hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Minwoo Kim (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-4594) UDF should use setLenient(false) when using SimpleDateFormat for parsing given datestring
Date Thu, 23 May 2013 04:18:22 GMT

     [ https://issues.apache.org/jira/browse/HIVE-4594?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Minwoo Kim updated HIVE-4594:
-----------------------------

    Description: 
If UDF has a date format of "MM/DD/YYYY" and the function supply it the String "9/5/05" the
date should *not* be allowed.
In most cases, parsing must be non-lenient; the given string must strictly adhere to the parsing
format."

For example,
{code}
select hour('2013-05-111 10:10:1') from src limit 1;
{code}
it returns 10.
the result returned is not what is expected, it should be null;


SimpleDateFormat is lenient by default.
so, UDF should use setLenient(false) when using SimpleDateFormat for parsing given datestring
except for very specific or intended case




  was:
If UDF has a date format of "MM/DD/YYYY" and the function supply it the String "9/5/05" the
date should *not* be allowed.
In all cases, parsing must be non-lenient; the given string must strictly adhere to the parsing
format."

For example,
{code}
select hour('2013-05-111 10:10:1') from src limit 1;
{code}
it returns 10.
the result returned is not what is expected, it should be null;


SimpleDateFormat is lenient by default.
so, UDF should use setLenient(false) when using SimpleDateFormat for parsing given datestring
except for very specific or intended case




    
> UDF should use setLenient(false) when using SimpleDateFormat for parsing given datestring
> -----------------------------------------------------------------------------------------
>
>                 Key: HIVE-4594
>                 URL: https://issues.apache.org/jira/browse/HIVE-4594
>             Project: Hive
>          Issue Type: Bug
>          Components: UDF
>            Reporter: Minwoo Kim
>            Priority: Minor
>
> If UDF has a date format of "MM/DD/YYYY" and the function supply it the String "9/5/05"
the date should *not* be allowed.
> In most cases, parsing must be non-lenient; the given string must strictly adhere to
the parsing format."
> For example,
> {code}
> select hour('2013-05-111 10:10:1') from src limit 1;
> {code}
> it returns 10.
> the result returned is not what is expected, it should be null;
> SimpleDateFormat is lenient by default.
> so, UDF should use setLenient(false) when using SimpleDateFormat for parsing given datestring
except for very specific or intended case

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message