Details
-
Bug
-
Status: Closed
-
Blocker
-
Resolution: Fixed
-
None
-
None
-
Reviewed
-
HIVE-400. Fix bug in genColList. (Namit Jain via zshao)
Description
explain
SELECT src5.src1_value
FROM
(SELECT src3.*,
src4.value as src4_value,
src4.key as src4_key
FROM src src4
JOIN
(SELECT src2.*,
src1.key as src1_key,
src1.value as src1_value
FROM src src1
JOIN src src2
ON src1.key = src2.key) src3
ON src3.src1_key = src4.key) src5;
The above query fails:
2009-04-08 15:50:30,087 ERROR ql.Driver (SessionState.java:printError(279)) - FAILED: Error in semantic analysis: line 2:12 Invalid Column Reference src1_value
org.apache.hadoop.hive.ql.parse.SemanticException: line 2:12 Invalid Column Reference src1_value
at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genExprNodeDesc(SemanticAnalyzer.java:3616)
at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genSelectPlan(SemanticAnalyzer.java:1228)
at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genBodyPlan(SemanticAnalyzer.java:2963)
at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:3334)
at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:3533)
at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:80)
at org.apache.hadoop.hive.ql.parse.ExplainSemanticAnalyzer.analyzeInternal(ExplainSemanticAnalyzer.java:43)
at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:80)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:199)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:174)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:207)
at org.apache.hadoop.hive.ql.QTestUtil.executeClient(QTestUtil.java:410)