[
https://issues.apache.org/jira/browse/IMPALA-2224?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jinchul Kim resolved IMPALA-2224.
---------------------------------
Resolution: Fixed
> Impala doesn't reject invalid timestamp format string
> -----------------------------------------------------
>
> Key: IMPALA-2224
> URL: https://issues.apache.org/jira/browse/IMPALA-2224
> Project: IMPALA
> Issue Type: Bug
> Components: Backend
> Affects Versions: Impala 2.1, Impala 2.2
> Reporter: Juan Yu
> Assignee: Jinchul Kim
> Priority: Minor
> Labels: newbie
>
> Impala only check if each character in the format string is valid or not,
> doesn't check if the whole string is invalid or not. for example, it will run
> the following query and produce result.
> {code}
> Query: select from_unixtime(unix_timestamp(), 'yyyyMMMdd HH:mm:ssmm')
> +---------------------------------------------------------+
> | from_unixtime(unix_timestamp(), 'yyyymmmdd hh:mm:ssmm') |
> +---------------------------------------------------------+
> | 2015Aug18 16:53:3353 |
> +---------------------------------------------------------+
> Fetched 1 row(s) in 0.02s
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
