[ https://issues.apache.org/jira/browse/HIVE-25306?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17386211#comment-17386211 ]
Stamatis Zampetakis commented on HIVE-25306: -------------------------------------------- [~ashish-kumar-sharma] If you can please go over the related issues and mark as resolved those fixed by this PR. > Change Date/Timestamp parser from LENIENT to STRICT > --------------------------------------------------- > > Key: HIVE-25306 > URL: https://issues.apache.org/jira/browse/HIVE-25306 > Project: Hive > Issue Type: Bug > Components: Query Planning, UDF > Reporter: Ashish Sharma > Assignee: Ashish Sharma > Priority: Major > Labels: backwards-compatibility, datetime, > pull-request-available, timestamp > Fix For: 4.0.0 > > Attachments: DB_compare.JPG > > Time Spent: 3h > Remaining Estimate: 0h > > Description - > Currently Date.java and Timestamp.java use DateTimeFormatter for parsing to > convert the date/timpstamp from int,string,char etc to Date or Timestamp. > Default DateTimeFormatter which use ResolverStyle.LENIENT which mean date > like "1992-13-12" is converted to "2000-01-12", > Moving DateTimeFormatter which use ResolverStyle.STRICT which mean date like > "1992-13-12" is not be converted instead NULL is return. > https://docs.google.com/document/d/1YTTPlNq3qyzlKfYVkSl3EFhVQ6-wa9WFRdkdIeCoc1Y/edit?usp=sharing > -- This message was sent by Atlassian Jira (v8.3.4#803005)