Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Won't Fix
-
Impala 2.1, Impala 2.2
-
None
Description
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.
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