[
https://issues.apache.org/jira/browse/IMPALA-13439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steve Carlin resolved IMPALA-13439.
-----------------------------------
Resolution: Fixed
IN is now converted to the internal Sarg and is handled more efficiently.
Before it was being converted to a bunch of OR clauses.
> Make IN clause more efficient in Calcite Planner
> ------------------------------------------------
>
> Key: IMPALA-13439
> URL: https://issues.apache.org/jira/browse/IMPALA-13439
> Project: IMPALA
> Issue Type: Sub-task
> Reporter: Steve Carlin
> Assignee: Steve Carlin
> Priority: Major
>
> Comment from code review for
> https://gerrit.cloudera.org/#/c/21911/3//COMMIT_MSG@13
> For large IN-lists, Calcite supports the LogicalValues relnode (derived from
> Values) and converts it to a join [see comments in [1]). This would be the
> most efficient representation but we would need a physical representation of
> this as well, so something to consider for future work.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
