Zoltan Haindrich created HIVE-20296:
---------------------------------------
Summary: Improve HivePointLookupOptimizerRule to be able to
extract from more sophisticated contexts
Key: HIVE-20296
URL: https://issues.apache.org/jira/browse/HIVE-20296
Project: Hive
Issue Type: Improvement
Components: Logical Optimizer
Reporter: Zoltan Haindrich
Assignee: Zoltan Haindrich
Currently it could handle conditions in the form:
{code}
( ( a=1 && b=1 && ... ) || (a=2 && b=2 && ...) || ... )
{code}
If there is some noise somewhere in the or like:
{code}
( x=18 || ( a=1 && b=1 && ... ) || (a=2 && b=2 && ...) || ... )
{code}
it stops processing.
https://github.com/apache/hive/blob/2cabb8da150b8fb980223fbd6c2c93b842ca3ee5/ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HivePointLookupOptimizerRule.java#L238
HIVE-19097 right now unwinds some ors which can't be packed back; like query15
https://github.com/apache/hive/blob/2cabb8da150b8fb980223fbd6c2c93b842ca3ee5/ql/src/test/queries/clientpositive/perf/query15.q#L14
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
