[
https://issues.apache.org/jira/browse/HIVE-29612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated HIVE-29612:
----------------------------------
Labels: pull-request-available (was: )
> 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
> Priority: Major
> Labels: pull-request-available
>
> 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)
