Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-400

bug in multi-join

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • None
    • 0.3.0
    • Query Processor
    • 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)

      Attachments

        1. hive.400.1.patch
          7 kB
          Namit Jain

        Activity

          People

            namit Namit Jain
            namit Namit Jain
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: