Want to know what your options are for getting SQL to work on Hadoop? To help, we’ve been doing some tests, and using the TPC-DS query set have measured the performance of Hive LLAP, Impala, SparkSQL and Presto – and compared their results to Kognitio. What’s more, we haven’t just tested if the platforms can run the queries, but also whether they work under load and work with a mixed-concurrent workload – the latter to show whether they can handle interactive querying on Hadoop from BI tools.
SparkSQL compared with Kognitio 8.1.50
Impala compared with Kognitio 8.1.50
Hive LLAP compared with Kognitio 8.2.0
Presto compared with Kognitio 8.2.0