[
https://issues.apache.org/jira/browse/HIVE-20622?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16624773#comment-16624773
]
Gopal V commented on HIVE-20622:
--------------------------------
Example query case -
https://github.com/hortonworks/hive-testbench/blob/hdp26/sample-queries-tpcds/query94.sql#L12
> Backwards Compat: Support non-zero padded date and timestamp entries
> --------------------------------------------------------------------
>
> Key: HIVE-20622
> URL: https://issues.apache.org/jira/browse/HIVE-20622
> Project: Hive
> Issue Type: Bug
> Reporter: Gopal V
> Priority: Major
>
> The Date spec in Hive says
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-date
> {noformat}
> DATE values describe a particular year/month/day, in the form YYYY-MM-DD.
> For example, DATE '2013-01-01'
> {noformat}
> Even though the Hive date & timestamp spec are strict on their format
> specification, Hive has previously supported " yyyy-[m]m-[d]d" formatted
> dates and it is better to expand the spec rather than drop this compatibility.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)