For all big data’s promise, the problem has always been this: how do you turnRead More
Kognitio on Apache Hadoop, ultra-fast, high concurrency SQL engine
The Kognitio Analytical Platform is the world’s fastest in-memory data analysis engine and when deployed on Hadoop it allows organizations to connect interactive, self-service analytical tools to Hadoop-based data for thousands of end users even when the data volumes are very large.
Hadoop and its associated software projects have provided organizations with a cost-effective way of storing and processing vast amounts of diverse data and a range of tools that allow that data to be captured analyzed and to some degree, consumed.
However, mass consumption of Hadoop based datasets by large numbers of users in a business context, is still difficult, as the tools available do not possess the performance levels or enterprise capabilities needed to reliably support hundreds of concurrent users.
What’s required is a SQL engine that will allow a business to connect the tools that your wider business users prefer to use and which generate SQL, e.g. Tableau, to your Hadoop-based data and perform interactive train-of-thought querying for hundreds of concurrent users.
The engines that come as part of the main Hadoop distributions (e.g. Hive, Hive LLAP, Impala) are not as performant as more mature SQL engines like Kognitio when it comes interactive querying. To read more about benchmark tests of the various SQL engines, read our various blogs on the subject.
How does Kognitio work on Hadoop?
- The tried and tested Kognitio MPP SQL database has been enhanced to allow it to run as a YARN application on Hadoop.
Data is held in memory structures highly optimized for in-memory analysis – this is not a disk cache!
- The Kognitio architecture has been shared nothing for over 20 years and fits seamlessly into the Hadoop / YARN shared nothing paradigm to provide a platform that can be scaled across the largest of Hadoop clusters.
- Data can be explicitly pinned in memory – you know your expected usage patterns better than any optimizer.
- Kognitio’s Massively Parallel Processing technology is used to localize processing and data into logical units known as ramstores to maximize efficiency.
- Sophisticated query planning allows queries on large data sets to be distributed to use all available CPU resource to process the query with maximum performance.
- Processor efficiency is further maximized by the use of sophisticated techniques to maximize processor instruction cache usage. These techniques include machine code generation and advanced query plan optimization.
- Granular queries that access smaller subsets of data are optimized by the query planner to access only the ramstores containing the data required to fulfil the request providing extremely high concurrency for these queries.
- The Kognitio database is a mature SQL implementation running all TPC-DS benchmark queries as well as providing functions to allow non standard SQL from other vendors to run unchanged.
- The Kognitio SQL extensions such as embedded R, Python or any other Linux process allow the easy integration of sophisticated statistical processing or specialized processing for IOT, telecoms or other complex data types.
- The wide variety of standard connectors and the ease of construction of custom connectors make connecting to any data source simple and transparent to the end user who sees the data as a standard table irrespective of whether it’s in a Hadoop cluster, in an S3 bucket or retrieved by SSH from a remote file server.
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. For more information see our support options.