[HIVE-12296] ClassCastException when selecting constant in inner select

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Component/s: Query Planning
• Assignee: Unassigned
• Reporter: Szehon Ho
• Created: 29/Oct/15 20:52
• Updated: 04/Dec/15 16:34
• Resolved: 04/Dec/15 16:34

Description

Following query:

SELECT
t1.bigint_col_3
FROM table_3 t1
WHERE
(t1.bigint_col_3) IN (SELECT
0.0 as decimal_col
FROM table_3)

produces an exception:

java.lang.ClassCastException: org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc cannot be cast to org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.insertSelectForSemijoin(SemanticAnalyzer.java:7581)
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genJoinOperator(SemanticAnalyzer.java:7524)
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genFilterPlan(SemanticAnalyzer.java:2782)
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genBodyPlan(SemanticAnalyzer.java:8771)
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9672)
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9565)
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genOPTree(SemanticAnalyzer.java:10057)
	at org.apache.hadoop.hive.ql.parse.CalcitePlanner.genOPTree(CalcitePlanner.java:336)
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:10068)
	at org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:215)
	at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:237)
	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:440)
	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:312)
	at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1199)
	at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1252)
	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1124)
	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1112)
	at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:225)
	at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:177)
	at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:387)
	at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:758)
	at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:703)
	at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:632)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
	at org.apache.hadoop.util.RunJar.main(RunJar.java:136)

Issue Links

• is superceded by: HIVE-12578 Hive query failing with error ClassCastException org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc cannot be cast to org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc