Soumyakanti Das created HIVE-29629:
--------------------------------------
Summary: Support LATERAL VIEW with CBO return path
Key: HIVE-29629
URL: https://issues.apache.org/jira/browse/HIVE-29629
Project: Hive
Issue Type: Sub-task
Affects Versions: 4.3.0
Reporter: Soumyakanti Das
Currently `LATERAL VIEW` is not supported in CBO return path.
{noformat}
set hive.cbo.returnpath.hiveop=true;
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 explode(test.items) lv AS item
fname=test.q
See ./ql/target/tmp/log/hive.log or ./itests/qtest/target/tmp/log/hive.log, or
check ./ql/target/surefire-reports or ./itests/qtest/target/surefire-reports/
for specific test cases logs.
java.lang.RuntimeException: Cannot find UDF for RecordType(VARCHAR(2147483647)
col) explode[OTHER_FUNCTION]/1
at
org.apache.hadoop.hive.ql.optimizer.calcite.translator.ExprNodeConverter.visitCall(ExprNodeConverter.java:222)
at
org.apache.hadoop.hive.ql.optimizer.calcite.translator.ExprNodeConverter.visitCall(ExprNodeConverter.java:103)
at org.apache.calcite.rex.RexCall.accept(RexCall.java:189)
at
org.apache.hadoop.hive.ql.optimizer.calcite.translator.opconventer.HiveTableFunctionScanVisitor.visit(HiveTableFunctionScanVisitor.java:77)
at
org.apache.hadoop.hive.ql.optimizer.calcite.translator.opconventer.HiveOpConverter.dispatch(HiveOpConverter.java:117)
at
org.apache.hadoop.hive.ql.optimizer.calcite.translator.opconventer.HiveProjectVisitor.visit(HiveProjectVisitor.java:62)
at
org.apache.hadoop.hive.ql.optimizer.calcite.translator.opconventer.HiveOpConverter.dispatch(HiveOpConverter.java:97)
at
org.apache.hadoop.hive.ql.optimizer.calcite.translator.opconventer.HiveOpConverter.convert(HiveOpConverter.java:87)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner.getOptimizedHiveOPDag(CalcitePlanner.java:1397)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner.genOPTree(CalcitePlanner.java:601)
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.ddl.view.create.AbstractCreateViewAnalyzer.analyzeQuery(AbstractCreateViewAnalyzer.java:70)
at
org.apache.hadoop.hive.ql.ddl.view.create.CreateViewAnalyzer.analyzeInternal(CreateViewAnalyzer.java:86)
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)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:499)
at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:451)
at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:415)
at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:409)
at
org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126)
at org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:234)
at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
at org.apache.hadoop.hive.cli.CliDriver.processCmd1(CliDriver.java:203)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:129)
at
org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:430){noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
