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,
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.
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/