hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashish Sharma (Jira)" <j...@apache.org>
Subject [jira] [Comment Edited] (HIVE-25306) Change Date/Timestamp parser from LENIENT to STRICT
Date Mon, 26 Jul 2021 05:09:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-25306?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17387038#comment-17387038
] 

Ashish Sharma edited comment on HIVE-25306 at 7/26/21, 5:08 AM:
----------------------------------------------------------------

[~zabetak] Updated the linked items. Thank you for the review and merging the code !


was (Author: ashish-kumar-sharma):
[~zabetak] Thank you for the review!

> 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)

Mime
View raw message