[jira] [Created] (HIVE-22788) Query cause NPE due to implicit cast on ROW__ID

[Vineet Garg (Jira)]

Vineet Garg created HIVE-22788:
----------------------------------

             Summary: Query cause NPE due to implicit cast on ROW__ID
                 Key: HIVE-22788
                 URL: https://issues.apache.org/jira/browse/HIVE-22788
             Project: Hive
          Issue Type: Bug
          Components: Query Planning
            Reporter: Vineet Garg
            Assignee: Vineet Garg


*Repro*
{code:sql}
CREATE TABLE table_16 (
timestamp_col_19    timestamp,
timestamp_col_29    timestamp,
int_col_27          int,
int_col_39          int,
boolean_col_18      boolean,
varchar0045_col_23  varchar(45)
);


CREATE TABLE table_7 (
int_col_10      int,
bigint_col_3    bigint
);

CREATE TABLE table_10 (
boolean_col_8       boolean,
boolean_col_16      boolean,
timestamp_col_5     timestamp,
timestamp_col_15    timestamp,
timestamp_col_30    timestamp,
decimal3825_col_26  decimal(38, 25),
smallint_col_9      smallint,
int_col_18          int
);

explain cbo 
SELECT
    DISTINCT COALESCE(a4.timestamp_col_15, IF(a4.boolean_col_16, 
a4.timestamp_col_30, a4.timestamp_col_5)) AS timestamp_col
FROM table_7 a3
RIGHT JOIN table_10 a4 
WHERE (a3.bigint_col_3) >= (a4.int_col_18)
INTERSECT ALL
SELECT
    COALESCE(LEAST(
        COALESCE(a1.timestamp_col_19, CAST('2010-03-29 00:00:00' AS TIMESTAMP)),
        COALESCE(a1.timestamp_col_29, CAST('2014-08-16 00:00:00' AS TIMESTAMP))
        ),
        GREATEST(COALESCE(a1.timestamp_col_19, CAST('2013-07-01 00:00:00' AS 
TIMESTAMP)),
        COALESCE(a1.timestamp_col_29, CAST('2028-06-18 00:00:00' AS TIMESTAMP)))
    ) AS timestamp_col
FROM table_16 a1
    GROUP BY COALESCE(LEAST(
        COALESCE(a1.timestamp_col_19, CAST('2010-03-29 00:00:00' AS TIMESTAMP)),
        COALESCE(a1.timestamp_col_29, CAST('2014-08-16 00:00:00' AS TIMESTAMP))
    ),
    GREATEST(
        COALESCE(a1.timestamp_col_19, CAST('2013-07-01 00:00:00' AS TIMESTAMP)),
        COALESCE(a1.timestamp_col_29, CAST('2028-06-18 00:00:00' AS TIMESTAMP)))
    );
{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)