It’s relatively easy to get up and running with Kognitio. In case you need extra help, here are lots of tips and hints for getting the most from the software.
Previously we’ve gone over ways to push data to S3 and connect to it via Kognitio external tables. See how we use that method on some bus data provided by Transport for London (TFL) and accelerating a simple (for now) Tableau dashboard propped up by Kognitio.
BI tools are great for inspecting your data from a viewpoint that databases can’t provide. Some are able to perform complex calculations and even modelling such as clustering and regression. With big data over a live connection this can be a challenge considering the amount of data that the BI tool must work through. Find out how Kognitio helps.
Read our tips to get the most out of Tableau driven by a system using Kognitio. These don’t apply exclusively to Kognitio and Tableau, however, the concepts should be applicable to most in-memory databases and BI tools that connect to them.
In this video we explain how to connect Microsoft PowerBI to Kognitio via a custom connector tool.
AVRO support was introduced in Kognitio 8.2 and in this post I’ll be briefly going through what it is and how to load it from HDFS.
Watch this short demo of Kognitio using 24 billion rows of retail transaction data to show how quickly Kognitio can run SQL on Hadoop. Using AmazonEMR as the platform and Kognitio’s console as the interface, we run a selection of typical queries against this big data set.
KogScript is a general purpose programming language based on Lua. It may be run within Console, which acts as an integrated development environment for it, or run from the command line tool kogscript.exe. The KogScript running within Console and via kogscript.exe are compiled from the same source files and are identical, with some exceptions; read them here.
Occasionally we would like the value of the primary key field to be created automatically every time a new record is inserted. That is we would like an auto-incrementable field in a table. Find out how.
In this article we will install and configure a Kognitio cluster on to a running HDP Hadoop cluster.
If you’ve just downloaded Kognitio on Hadoop, you’re probably wondering how the software will complement your existing BI tools, and support your fellow business users.
The MapR Hadoop distribution has unique benefits and extra capabilities that make it a desirable choice for many companies. Our new version of Kognitio, specifically for MapR, takes full advantage of MapR’s improved file system technology.
If you’ve already installed Kognitio on your Hadoop distribution of choice, or are about to, then you should be aware that Kognitio includes full YARN integration allowing Kognitio to share the Hadoop hardware infrastructure and resources with other Hadoop applications and services. Read more here.
Kognitio has a lot of experience commissioning clusters of new hardware for our MPP software product. As part of that process, we’ve developed a number of steps for validating the performance of new clusters. Read them here.