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.