hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krisztian Kasa (Jira)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-22788) Query cause NPE due to implicit cast on ROW__ID
Date Wed, 29 Jan 2020 12:53:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-22788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Krisztian Kasa updated HIVE-22788:
----------------------------------
    Status: Patch Available  (was: Open)

> 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: Krisztian Kasa
>            Priority: Major
>         Attachments: HIVE-22788.1.patch, HIVE-22788.2.patch, HIVE-22788.3.patch
>
>
> *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)

Mime
View raw message