Hello, I too would be in favor of this. It drastically cuts down on the test matrix for Hive if we can clamp down on timestamp formats. With that being said, I've tried this and it's a big effort. I put it down without getting consensus or buy-in or engagement on the effort. Please check out my work here:
https://issues.apache.org/jira/plugins/servlet/mobile#issue/HIVE-24814 On Fri, Jul 9, 2021, 9:49 PM Ashish Sharma <[email protected]> wrote: > 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 >
