You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Subhasis Gorai (JIRA)" <ji...@apache.org> on 2018/02/20 04:05:00 UTC

[jira] [Created] (HIVE-18746) add_months should validate the date first

Subhasis Gorai created HIVE-18746:
-------------------------------------

             Summary: 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


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)