[jira] [Updated] (HIVE-20898) For time related functions arguments may not be casted to a non nullable type

["Zoltan Haindrich (JIRA)" <ji...@apache.org>]

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

Zoltan Haindrich updated HIVE-20898:
------------------------------------
    Description: 
{code}
create table t (a string); insert into t values (null),('1988-11-11');
set hive.cbo.enable=true;
select 'expected 1 (second)', count(1) from t where second(a) is null;
{code}

this may only cause trouble if Calcite is exploiting the datatype nullability; it will be need after CALCITE-2469 (1.18.0)



  was:
{code}
create table t (a string); insert into t values (null),('1988-11-11');
set hive.cbo.enable=true;
select 'expected 1 (second)', count(1) from t where second(a) is null;
{code}

this may only cause trouble if Calcite is exploiting the datatype nullability.



> For time related functions arguments may not be casted to a non nullable type
> -----------------------------------------------------------------------------
>
>                 Key: HIVE-20898
>                 URL: https://issues.apache.org/jira/browse/HIVE-20898
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Zoltan Haindrich
>            Assignee: Zoltan Haindrich
>            Priority: Major
>
> {code}
> create table t (a string); insert into t values (null),('1988-11-11');
> set hive.cbo.enable=true;
> select 'expected 1 (second)', count(1) from t where second(a) is null;
> {code}
> this may only cause trouble if Calcite is exploiting the datatype nullability; it will be need after CALCITE-2469 (1.18.0)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)