hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Namit Jain (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-400) bug in multi-join
Date Wed, 08 Apr 2009 22:54:13 GMT
bug in multi-join 
------------------

                 Key: HIVE-400
                 URL: https://issues.apache.org/jira/browse/HIVE-400
             Project: Hadoop Hive
          Issue Type: Bug
          Components: Query Processor
            Reporter: Namit Jain
            Assignee: Namit Jain


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)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message