Date and timestamp parser changes from LENIENT to STRICT

Learn about the changes introduced in DateTimeFormatter class, which is used to parse string, int, and char into Date or Timestamp.

Before Upgrade to CDP 7.1.7 SP1

Before the upgrade, the DateTimeFormatter class was set to ResolverStyle.LENIENT, which results in converting an incorrect date or timestamp instead of NULL. For example, "1992-13-12" was converted to "2000-01-12".

After Upgrade to CDP 7.1.7 SP2

The DateTimeFormatter class was enhanced to use the ResolverStyle.STRICT, which returns NULL when an incorrect date or timestamp is casted.

For more information, see HIVE-25306.