ADD_MONTHS date validation

A change, which is not likely to cause any migration problems, was made to the ADD_MONTHS function.

Before Upgrade to CDP

The ADD_MONTHS function would execute on invalid dates, such as 2017-02-29.

After Upgrade to CDP

Hive-18746 performs validation of the date before executing the ADD_MONTHS function. The output indicates an invalid date as shown below:

select add_months('2017-02-29', 1);
'2017-02-29' is an invalid date.