[IMPALA-648] Timestamp Parser Does Not like "T"

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 1.1.1
• Fix Version/s: Impala 2.0
• Labels: imapala
• Assignee: Chris Channing
• Reporter: David E. Wheeler
• Created: 29/Oct/13 21:25
• Updated: 20/Dec/15 00:05
• Resolved: 18/Dec/13 13:18

Description

The ISO-8601 format allows an optional "T" between the date and time in its format. Looks like the Impala date parser doesn't like it:

[example.com:21000] > select cast('2012-01-06T20:59:58.117' as timestamp);
Query: select cast('2012-01-06T20:59:58.117' as timestamp)
Query finished, fetching results ...
+----------------------------------------------+
| cast('2012-01-06t20:59:58.117' as timestamp) |
+----------------------------------------------+
|                                              |
+----------------------------------------------+
Returned 1 row(s) in 0.15s

Works if I remove the "T", though:

[example.com:21000] > select cast('2012-01-06 20:59:58.117' as timestamp);
Query: select cast('2012-01-06 20:59:58.117' as timestamp)
Query finished, fetching results ...
+----------------------------------------------+
| cast('2012-01-06 20:59:58.117' as timestamp) |
+----------------------------------------------+
| 2012-01-06 20:59:58.117000000                |
+----------------------------------------------+
Returned 1 row(s) in 0.09s