[
https://issues.apache.org/jira/browse/CALCITE-1651?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15876341#comment-15876341
]
Julian Hyde commented on CALCITE-1651:
--------------------------------------
We need to discuss what Calcite's behavior should be. What does the SQL
standard say?
> 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)
