Riju Trivedi created HIVE-29729:
-----------------------------------
Summary: AIBOE in HiveFilterProjectTransposeRule during CBO
planning for filters over windowing Projects
Key: HIVE-29729
URL: https://issues.apache.org/jira/browse/HIVE-29729
Project: Hive
Issue Type: Bug
Components: CBO, Hive
Affects Versions: 4.2.0
Reporter: Riju Trivedi
Assignee: Riju Trivedi
When CBO plans a query where an {{IS NOT NULL}} predicate sits above a sub-plan
that contains a windowing ({{{}OVER(...){}}}) {{{}Project{}}}, planning fails
with an {{ArrayIndexOutOfBoundsException}} thrown from inside
{{{}HiveFilterProjectTransposeRule{}}}'s redundant-{{{}IS NOT NULL{}}} check
(the {{RedundancyChecker}} {{{}RelVisitor{}}}).
{code:java}
java.lang.ArrayIndexOutOfBoundsException:
at org.apache.calcite.plan.RelOptUtil.pushPastProjectUnlessBloat(...) at
org.apache.hadoop.hive.ql.optimizer.calcite.HiveRelOptUtil.pushPastProjectUnlessBloat(HiveRelOptUtil.java:730)
at
org.apache.hadoop.hive.ql.optimizer.calcite.rules.HiveFilterProjectTransposeRule$RedundancyChecker.visit(HiveFilterProjectTransposeRule.java:341)
... {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
