Hi, When casting incorrect date or timestamp literals to DATE or TIMESTAMP data type hive returns wrong values
hive> select cast('2020-20-20' as date);
OK
2021-08-20
Time taken: 4.436 seconds, Fetched: 1 row(s)
I have created a solution draft. Please review the draft and provide your
valuable feedback on the same.
https://docs.google.com/document/d/1YTTPlNq3qyzlKfYVkSl3EFhVQ6-wa9WFRdkdIeCoc1Y/edit?usp=sharing
https://issues.apache.org/jira/browse/HIVE-25306
Thank you
Ashish Sharma
