Aman Sinha created DRILL-3009:
---------------------------------
Summary: 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
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)
