Handling return type for old date functions
Learn about the changes related to the return type for some of the originally introduced date functions. The return type is changed from string to date.
Before upgrade to CDP
Some of the original date functions, such as TO_DATE, DATE_ADD, and DATE_SUB returned string values instead of date values. This was because the date return type was not available in Hive when these functions were introduced.
After upgrade to CDP
HIVE-13248 changes the return type of
date_sub functions from string to date.