[
https://issues.apache.org/jira/browse/DRILL-391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14245835#comment-14245835
]
Aman Sinha commented on DRILL-391:
----------------------------------
Agree that raising the threshold is not the right solution for reasons you
mention; that's why I am only proposing this as a temporary measure for the
Drill version of Calcite, NOT the master branch. There is an immediate need to
support IN lists of sizes in the range of 30 to 50; hence the urgency until
Drill implements the Values operator. We will revert to the old behavior once
that is implemented.
> IN-list predicate with 20 or more elements gives UnsupportedOperationException
> ------------------------------------------------------------------------------
>
> Key: DRILL-391
> URL: https://issues.apache.org/jira/browse/DRILL-391
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Aman Sinha
> Assignee: Aman Sinha
> Fix For: 0.7.0
>
> Attachments:
> 0001-DRILL-391-Test-case-for-large-IN-list-actual-fix-wor.patch,
> 0001-Increase-IN-list-threshold-from-20-to-200-for-system.patch
>
>
> select _MAP['N_REGIONKEY'], _MAP['N_NATIONKEY'] FROM
> "/tmp/parquet/nation.parquet" where cast(_MAP['N_NATIONKEY'] as int) in (1,
> 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20);
> java.lang.UnsupportedOperationException
> at
> org.apache.drill.optiq.DrillValuesRel.implement(DrillValuesRel.java:51)
> at
> org.apache.drill.optiq.DrillImplementor.visitChild(DrillImplementor.java:143)
> at
> org.apache.drill.optiq.DrillAggregateRel.implement(DrillAggregateRel.java:62)
> at
> org.apache.drill.optiq.DrillImplementor.visitChild(DrillImplementor.java:143)
> at
> org.apache.drill.optiq.DrillJoinRel.implementInput(DrillJoinRel.java:98)
> at org.apache.drill.optiq.DrillJoinRel.implement(DrillJoinRel.java:75)
> at
> org.apache.drill.optiq.DrillImplementor.visitChild(DrillImplementor.java:143)
> at
> org.apache.drill.optiq.DrillProjectRel.implement(DrillProjectRel.java:63)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
