[jira] [Created] (HIVE-13012) NPE from simple nested ANSI Join

[Dave Nicodemus (JIRA)]

Dave Nicodemus created HIVE-13012:
-------------------------------------

             Summary: NPE from simple nested ANSI Join
                 Key: HIVE-13012
                 URL: https://issues.apache.org/jira/browse/HIVE-13012
             Project: Hive
          Issue Type: Bug
          Components: Parser
    Affects Versions: 1.2.1
            Reporter: Dave Nicodemus
            Assignee: Pengcheng Xiong


Using hive 1.2.1.2.3  Connecting using JDBC, issuing the following query : 

SELECT COUNT(*) 
FROM nation n 
    INNER JOIN (customer c
                         INNER JOIN orders o ON c.c_custkey = o.o_custkey)
     ON n.n_nationkey = c.c_nationkey;

Generates the NPE and stack below. Fields are integer data type.
NOTE: Similar stack as https://issues.apache.org/jira/browse/HIVE-11433 

Stack
--------
Caused by: java.lang.NullPointerExcEeption: Remote 
java.lang.NullPointerException: null
        at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.isPresent(SemanticAnalyzer.java:2046)
        at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.parseJoinCondPopulateAlias(SemanticAnalyzer.java:2109)
        at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.parseJoinCondPopulateAlias(SemanticAnalyzer.java:2185)
        at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.parseJoinCondition(SemanticAnalyzer.java:2445)
        at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.parseJoinCondition(SemanticAnalyzer.java:2386)
        at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genJoinTree(SemanticAnalyzer.java:8192)
        at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genJoinTree(SemanticAnalyzer.java:8131)
        at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9709)
        at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9636)
        at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genOPTree(SemanticAnalyzer.java:10109)
        at 
org.apache.hadoop.hive.ql.parse.CalcitePlanner.genOPTree(CalcitePlanner.java:329)
        at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:10120)
        at 
org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:211)
        at 
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:227)
        at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:454)
        at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:314)
        at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1164)
        at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1158)
        at 
org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:110)





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)