[
https://issues.apache.org/jira/browse/CALCITE-1651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Remus Rusanu closed CALCITE-1651.
---------------------------------
Resolution: Duplicate
> 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)
