Support Questions
Find answers, ask questions, and share your expertise

Does LLAP support optimized non-equi joins ?

Rising Star

@James Dinkel, @Dennis Connolly,


Currently we are using presto for non equi joins, as we are looking replacement of presto.

please let me know if LLAP support optimized non-equi joins ?


Rising Star

I got answer

Yes, Hive LLAP does support optimized non-equi joins.
In more detail, Apache Hive 2.2 added support for non-equijoins (HIVE-15211) while Apache Tez recently added the ability to run non-equijoins (aka theta joins) in a parallel fashion (TEZ-2104). This is all enabled in Hive LLAP within HDP 2.6.