[jira] [Updated] (DRILL-3009) Reduce the IN list threshold to 10 to take advantage of Values operator

["Aman Sinha (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-3009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aman Sinha updated DRILL-3009:
------------------------------
    Attachment: 0001-DRILL-3009-Lower-IN-list-threshold-change-is-in-Calc.patch

Changed the threshold in Drill's Calcite branch.  Bumped up the version to 1.1.0-drill-r6.  [~jni] could you review the simple patch ? 

> Reduce the IN list threshold to 10 to take advantage of Values operator
> -----------------------------------------------------------------------
>
>                 Key: DRILL-3009
>                 URL: https://issues.apache.org/jira/browse/DRILL-3009
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>            Reporter: Aman Sinha
>            Assignee: Aman Sinha
>             Fix For: 1.0.0
>
>         Attachments: 0001-DRILL-3009-Lower-IN-list-threshold-change-is-in-Calc.patch
>
>
> The IN-list threshold is currently set to 200 (it was bumped up from 20 previously since Drill did not have the Values operator).   Now that Drill can support large IN lists through the Values operator, we should drop the threshold back and in fact lower it to 10.   
> For lists below this threshold, Calcite will build a binary tree of OR's.   Above this threshold, it will create a ValuesRel .



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)