[
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)
