[HIVE-14194] Investigate optimizing the query compilation of long or-list in where statement

• Type: Improvement
• Status: Reopened
• Priority: Major
• Resolution: Unresolved
• Assignee: Aihua Xu
• Reporter: Aihua Xu
• Created: 08/Jul/16 14:43
• Updated: 02/May/18 17:16

Description

If a query has a long OR-list, when possible, the OR-list can be optimized with IN-list to have better performance during compilation (resolved by HIVE-11424).

select * from src 
where key = 1
or key =2
or ....

But for the cases which can't be converted e.g., if it contains key < 2, we will still have performance issue during compilation. Investigate if we can optimize it.

Issue Links

• relates to: HIVE-11424 Rule to transform OR clauses into IN clauses in CBO