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.