[ 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