[
https://issues.apache.org/jira/browse/CALCITE-1651?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15878799#comment-15878799
]
Remus Rusanu commented on CALCITE-1651:
---------------------------------------
CALCITE-1653 makes this problem irrelevant as using the Hive executor for
constant simplification yields the expected result (expected by Hive, that is).
> Difference in DATE cast between Hive and Calcite
> ------------------------------------------------
>
> Key: CALCITE-1651
> URL: https://issues.apache.org/jira/browse/CALCITE-1651
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: Remus Rusanu
> Assignee: Julian Hyde
>
> Hive {{CAST('<literal>' as DATE)}} is handled by Java's {{Date.valueOf}} and
> thus expects {{yyyy-mm-dd}}. In Hive {{SELECT CAST('1' as DATE);}} yields
> {{NULL}} but in Calcite is {{0001-12-31}}.
> I'm opening this as Calcite issue to track HIVE-15708 (migrate to Calcite
> 1.12) blockers, not sure if solution will require Calcite changes.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
