Aswathy Chellammal Sreekumar created HIVE-15904:
---------------------------------------------------
Summary: select query throwing Null Pointer Exception from
org.apache.hadoop.hive.ql.optimizer.DynamicPartitionPruningOptimization.generateSemiJoinOperatorPlan
Key: HIVE-15904
URL: https://issues.apache.org/jira/browse/HIVE-15904
Project: Hive
Issue Type: Bug
Components: HiveServer2
Reporter: Aswathy Chellammal Sreekumar
Assignee: Jason Dere
Following query failing with Null Pointer Exception from
org.apache.hadoop.hive.ql.optimizer.DynamicPartitionPruningOptimization.generateSemiJoinOperatorPlan
Attaching create table statements for table_1 and table_18
Query:
SELECT
COALESCE(498, LEAD(COALESCE(-973, -684, 515)) OVER (PARTITION BY (t2.int_col_10
+ t1.smallint_col_50) ORDER BY (t2.int_col_10 + t1.smallint_col_50),
FLOOR(t1.double_col_16) DESC), 524) AS int_col,
(t2.int_col_10) + (t1.smallint_col_50) AS int_col_1,
FLOOR(t1.double_col_16) AS float_col,
COALESCE(SUM(COALESCE(62, -380, -435)) OVER (PARTITION BY (t2.int_col_10 +
t1.smallint_col_50) ORDER BY (t2.int_col_10 + t1.smallint_col_50) DESC,
FLOOR(t1.double_col_16) DESC ROWS BETWEEN UNBOUNDED PRECEDING AND 48
FOLLOWING), 704) AS int_col_2
FROM table_1 t1
INNER JOIN table_18 t2 ON (((t2.tinyint_col_15) = (t1.bigint_col_7)) AND
((t2.decimal2709_col_9) = (t1.decimal2016_col_26))) AND
((t2.tinyint_col_20) = (t1.tinyint_col_3))
WHERE (t2.smallint_col_19) IN (SELECT
COALESCE(-92, -994) AS int_col
FROM table_1 tt1
INNER JOIN table_18 tt2 ON (tt2.decimal1911_col_16) = (tt1.decimal2612_col_77)
WHERE (t1.timestamp_col_9) = (tt2.timestamp_col_18));
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
