[
https://issues.apache.org/jira/browse/DRILL-391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14245571#comment-14245571
]
Julian Hyde commented on DRILL-391:
-----------------------------------
Systems that generate large IN lists are not going to stop at 200. (Mondrian is
one such system.) Meanwhile, IN lists with 100 or so elements are going to
perform poorly. So, this is a poor compromise. I would not be inclined to
accept the Calcite patch.
> 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)
