You already know Kognitio gives you super-fast analytics insights. But did you know that you also get a stack of additional tools as part of your free download? Find out why they are useful for your data analysis.
All businesses need accurate data insights, but BI tools can be frustratingly slow to run accurate, concurrent queries.
So, we built Kognitio specifically for massively parallel analytical query processing directly on your data, whatever the format, structure or source.
Whether you are a simply connecting to Kognitio, doing some data wrangling or system administration, our various client tools will often come in handy.
Kognitio can be accessed from any BI tool that operates via an ODBC or JDBC connections but can also use Kognitio Console — our main client tool for SQL submission and basic system administration. If you prefer command-line access there are number of options available to you:
our basic SQL submission command line utility
a set of bash functions design for easy SQL submission and results handling in a bash scripts
a lua based scripting utility that is designed for easy lua scripting around SQL statements submitted to Kognitio
For users wanting to prepare data for analysis, Kognitio provides a number of profiling utilities enabling you to effortlessly build Kognitio tables.
Kognitio is an MPP system and you can take advantage of this for fast loading and unloading of data directly to and from Kognitio tables including directly into memory. These flexible utilities have a vast number of options to allow you to work with data of any format within flat files and json files.
There are a number of command line utilities that can be used for Kognitio administration. As well as the main server command utilities these include:
Kognitio offers different levels of support from free Community support to Enterprise Premium support.
Our community forum is open to anyone using Kognitio.Go to Forum
For support via email or our customer portal.Read More
For customers that want to include phone support.Read More
Yes, if you deploy Kognitio on Hadoop, it’s completely free to use with no restrictions on time, scale or functionality. We offer Kognitio on Hadoop completely free to use and offer paid support contracts to customers who wish to take out support for production environments.
If you deploy Kognitio on standalone servers or on MapR, it’s free up to 512GB RAM. But should you need more RAM to evaluate Kognitio properly, just get in touch.
No, we have one version of Kognitio which comes with full functionality and various deployment options.
Kognitio on Hadoop is free and revenue for that comes from customers who wish to take out paid support.
If you deploy Kognitio on standalone servers or on MapR, you will require a software license for use above 512GB RAM.
We offer a range of support options for Kognitio, from web only to full enterprise support. For more information visit our support page.
There are large variations in the performance, flexibility and maturity of available SQL engines.
Hive, Impala and SparkSQL, for example, are new SQL implementations that were developed from scratch for Hadoop. Yet SQL is a very large, complex standard which is difficult enough to implement on a serial platform, but to implement it in parallel is incredibly difficult and time consuming.
For 25 years, Kognitio has been developing parallel SQL. So our SQL engine is much more mature and proven to scale-out for the high concurrency required by business users. Kognitio is also a true in-memory engine.
If you intend to use Kognitio on a Hadoop cluster under YARN, you should install the “on Hadoop” version.
If you intend to use Kognitio on MapR, download the MapR version.
If you are not running Hadoop or MapR, then you should install the standalone version of Kognitio.
Read our blog.
So you have Hadoop up and running and data loaded. Your data scientists and software developers are happily writing programs to analyze the data, but you now want to provide access to a much wider audience so that people across your business can ask ad-hoc questions of the data, whenever they need to. These people…Read more
In this article I’m going to explain the workings of Kognitio’s query streaming feature. This is a core part of the Kognitio server’s architecture which we use to run a wide range of queries regardless of available workspace, adapting its behaviour based on system load and resource availability. Query streaming takes query plans we get…Read more
Over the past year, the Kognitio Analytics Team has been testing different open source SQL on Hadoop solutions against our own free-to-use software. Due to increasing demands for performance comparisons of different SQL on Hadoop solutions, the TPC-DS query set has become the de-facto industry standard benchmark for Big Data systems. We have used these…Read more