drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1165) Cast a varchar timestamp into date fails
Date Mon, 21 Jul 2014 23:02:38 GMT
Krystal created DRILL-1165:
------------------------------

             Summary: Cast a varchar timestamp into date fails 
                 Key: DRILL-1165
                 URL: https://issues.apache.org/jira/browse/DRILL-1165
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
            Reporter: Krystal


git.commit.id.abbrev=e5c2da0

I have the following varchar data casted as timestamp:
0: jdbc:drill:schema=dfs> select cast(create_time as timestamp) from student where student_id=15;
+------------+
|   EXPR$0   |
+------------+
| 2014-11-12 12:38:15.0 |

I can cast the varchar data to a date:
0: jdbc:drill:schema=dfs> select cast(create_time as date) from student where student_id=15;
+------------+
|   EXPR$0   |
+------------+
| 2014-11-12 |
+------------+

However, it fails when I tried to cast it to a time:
0: jdbc:drill:schema=dfs> select cast(create_time as time) from student where student_id=15;
message: "Failure while running fragment. < IllegalArgumentException:[ Invalid format:
"2014-11-12 12:38:15" is malformed at "14-11-12 12:38:15" ]"

If it works for date, it should work for time.  This query returned the time portion of the
string when executed from postgres.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message