[ https://issues.apache.org/jira/browse/DRILL-3710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15394980#comment-15394980 ]
Gautam Kumar Parai commented on DRILL-3710: ------------------------------------------- [~amansinha100]] I have updated the pull request (https://github.com/apache/drill/pull/552) to account for latest Calcite changes. Can you please take a look? Thanks! > Make the 20 in-list optimization configurable > --------------------------------------------- > > Key: DRILL-3710 > URL: https://issues.apache.org/jira/browse/DRILL-3710 > Project: Apache Drill > Issue Type: Improvement > Components: Query Planning & Optimization > Affects Versions: 1.1.0 > Reporter: Hao Zhu > Assignee: Gautam Kumar Parai > Fix For: Future > > > 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); -- This message was sent by Atlassian JIRA (v6.3.4#6332)