[
https://issues.apache.org/jira/browse/HIVE-13012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15134657#comment-15134657
]
Sergey Shelukhin commented on HIVE-13012:
-----------------------------------------
HIVE-11960 added the parser support; that usually works, but apparently not in
all cases.
> 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)