drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aman Sinha (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-3009) Reduce the IN list threshold to take advantage of Values operator
Date Wed, 13 May 2015 07:24:59 GMT

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

Aman Sinha resolved DRILL-3009.
-------------------------------
    Resolution: Fixed

Fixed in ce3343f676d556be283dfcc129db1d9b9e99f6fd.  Lowered threshold to 20 rather than 10
for now. 

> Reduce the IN list threshold 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)

Mime
View raw message