Created 01-22-2017 10:41 PM
Hi there,
I just like to know, what is equivalent of impala(from CDH) in Hortonworks. How to achieve better query performance in Hortonworks instead of using Hive. I would appreciate if anyone provide some information on this.
Thanks & Regards,
Jee
Created 01-22-2017 10:49 PM
HDP 2.5 has a technical preview for LLAP .LLAP is a caching layer on top of yarn, which allows improved hive query performance. You can enable LLAP from ambari hive config page.
Created 01-22-2017 11:07 PM
Hi Karthick Narayanan,
Thank you very much for your prompt reply and it will be really helpful. Once again, Thank you.
Created 01-23-2017 03:11 PM
Here is a very good blog showing a performance comparison of Hive LLAP to Impala. It uses 10TB of TPC-DS Data Warehouse data to get a solid apples-to-apple comparison of the two. http://hortonworks.com/blog/apache-hive-vs-apache-impala-query-performance-comparison/