[
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)
