You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Kryvenko Igor (JIRA)" <ji...@apache.org> on 2018/03/01 23:03:00 UTC
[jira] [Updated] (HIVE-18746) add_months should validate the date
first
[ https://issues.apache.org/jira/browse/HIVE-18746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kryvenko Igor updated HIVE-18746:
---------------------------------
Attachment: HIVE-18746.7.patch
> add_months should validate the date first
> -----------------------------------------
>
> Key: HIVE-18746
> URL: https://issues.apache.org/jira/browse/HIVE-18746
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Reporter: Subhasis Gorai
> Assignee: Kryvenko Igor
> Priority: Minor
> Attachments: HIVE-18746.1.patch, HIVE-18746.3.patch, HIVE-18746.4.patch, HIVE-18746.5.patch, HIVE-18746.6.patch, HIVE-18746.7.patch, HIVE-18746.patch
>
>
> hive (sbg_hvc_ods)> select add_months('2017-02-28', 1);
> OK
> _c0
> 2017-03-31
> Time taken: 0.107 seconds, Fetched: 1 row(s)
> hive (sbg_hvc_ods)> select add_months('2017-02-29', 1);
> OK
> _c0
> 2017-04-01
> Time taken: 0.084 seconds, Fetched: 1 row(s)
> hive (sbg_hvc_ods)>
>
> '2017-02-29' is an invalid date.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)