[DRILL-3710] Make the 20 in-list optimization configurable

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.0
• Fix Version/s: 1.8.0
• Component/s: Query Planning & Optimization
• Assignee: Gautam Parai
• Reporter: Hao Zhu
• Reviewer: Chun Chang
• Created: 25/Aug/15 23:34
• Updated: 25/Aug/16 21:14
• Resolved: 29/Jul/16 14:41

Description

If Drill has more than 20 in-lists , Drill can do an optimization to convert that in-lists into a small hash table in memory, and then do a table join instead.
This can improve the performance of the query which has many in-lists.
Could we make "20" configurable? So that we do not need to add duplicate/junk in-list to make it more than 20.

Sample query is :
select count from table where col in (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1);

Issue Links

• is cloned by: DRILL-4789 In-list to join optimization should have configurable in-list size
• relates to: CALCITE-1321 In-list to join optimization should have configurable in-list size
• links to: GitHub Pull Request #552