Soumyakanti Das created HIVE-29612:
--------------------------------------
Summary: LATERAL VIEW OUTER doesn't work with CBO enabled
Key: HIVE-29612
URL: https://issues.apache.org/jira/browse/HIVE-29612
Project: Hive
Issue Type: Bug
Components: CBO
Affects Versions: 4.3.0
Reporter: Soumyakanti Das
Assignee: Soumyakanti Das
Running
{noformat}
CREATE TABLE test (id string, items array<string>);
INSERT INTO test VALUES ('a', array('a', 'b')), ('b', array('c')), ('d',
array());
CREATE VIEW v AS
SELECT test.id AS id, item
FROM test
LATERAL VIEW OUTER explode(test.items) lv AS item;
SELECT id, item FROM v ORDER BY id, item;{noformat}
fails with:
{noformat}
org.apache.hadoop.hive.ql.optimizer.calcite.CalciteSubquerySemanticException:
CBO can not handle Sub Query
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner<span>CalcitePlannerAction.genSubQueryRelNode(CalcitePlanner.java:3448)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner</span>CalcitePlannerAction.genFilterRelNode(CalcitePlanner.java:3461)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner<span>CalcitePlannerAction.genFilterLogicalPlan(CalcitePlanner.java:3489)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner</span>CalcitePlannerAction.genLogicalPlan(CalcitePlanner.java:4953)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner<span>CalcitePlannerAction.apply(CalcitePlanner.java:1611)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner</span>CalcitePlannerAction.apply(CalcitePlanner.java:1553)
at
org.apache.calcite.tools.Frameworks.lambda<span>withPlanner</span>0(Frameworks.java:140)
at
org.apache.calcite.prepare.CalcitePrepareImpl.perform(CalcitePrepareImpl.java:936)
at org.apache.calcite.tools.Frameworks.withPrepare(Frameworks.java:191)
at org.apache.calcite.tools.Frameworks.withPlanner(Frameworks.java:135)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner.logicalPlan(CalcitePlanner.java:1331)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner.genOPTree(CalcitePlanner.java:588)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:13224)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:481)
at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:358)
at org.apache.hadoop.hive.ql.Compiler.analyze(Compiler.java:224)
at org.apache.hadoop.hive.ql.Compiler.compile(Compiler.java:109){noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
