[jira] [Commented] (HIVE-20622) Backwards Compat: Support non-zero padded date and timestamp entries

["Gopal V (JIRA)" <ji...@apache.org>]

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