[
https://issues.apache.org/jira/browse/CALCITE-1655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15887314#comment-15887314
]
Ashutosh Chauhan commented on CALCITE-1655:
-------------------------------------------
I dont think its a good idea to force runtime to execute OR expressions even
when user has specified IN or BETWEEN. Simply because in most runtimes (Hive &
Druid) in/between executes way faster than OR tree. By insisting on translating
IN/BETWEEN into ORs you are forcing perf penalty unnecessarily.
> Add In filter to druid adapter.
> -------------------------------
>
> Key: CALCITE-1655
> URL: https://issues.apache.org/jira/browse/CALCITE-1655
> Project: Calcite
> Issue Type: Bug
> Components: druid
> Reporter: slim bouguerra
> Assignee: Julian Hyde
>
> The druid calcite adapter throw an exception when an IN filter is used.
> This happens only in hive because in calcite project the IN filter is
> transformed to OR automatically.
> Since this rule does not kick in HIVE and it is better to use the native IN
> filter from druid instead having huge number of OR clauses i will send a
> patch that adds the IN filter.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
