[
https://issues.apache.org/jira/browse/PHOENIX-7380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17873121#comment-17873121
]
Istvan Toth commented on PHOENIX-7380:
--------------------------------------
Thinking about it some more, pushing down disjunctions (OR) only make sense if
they can be pushed down completely.
i.e.
(A op1 B OR B op2 C) AND (D op3 E) can be pushed down if both op1 and op2 can
be pushed down, but of only op1 or op2 can be pushed down, then it won't work.
This should be possible to add to the logic.
> Do not limit pushdown to conjunctions in Hive connector
> -------------------------------------------------------
>
> Key: PHOENIX-7380
> URL: https://issues.apache.org/jira/browse/PHOENIX-7380
> Project: Phoenix
> Issue Type: Improvement
> Components: connectors, hive-connector
> Reporter: Istvan Toth
> Priority: Major
>
> Working on the Hive connector code, I noticed that it only pushes down
> conjunctions.
> This may have been correct in the original (since removed) Hive indexing that
> the code is based on, but the restriction doesn't seem to be necessary in the
> Phoenix case.
> I see no reason not to push down disjunctions to Phoenix. In fact, AFAICT any
> expression that can be evaluated on single row (no aggregates) can be pushed
> down to Phoenix without any problems, and should benefit from the distributed
> Phoenix processing, indexes, etc.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
