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