You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Zoltan Haindrich (JIRA)" <ji...@apache.org> on 2018/11/09 13:01:00 UTC
[jira] [Commented] (HIVE-20898) For time related functions
arguments may not be casted to a non nullable type
[ https://issues.apache.org/jira/browse/HIVE-20898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16681404#comment-16681404 ]
Zoltan Haindrich commented on HIVE-20898:
-----------------------------------------
checked with a locally built Calcite 1.18.0-SNAPSHOT
[~jcamachorodriguez] Could you please take a look?
> 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
> Attachments: HIVE-20898.01.patch
>
>
> {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)