[DRILL-1165] Cast a varchar timestamp into date fails

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Fix Version/s: 0.4.0
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: Krystal
• Created: 21/Jul/14 23:01
• Updated: 21/Apr/15 21:12
• Resolved: 25/Jul/14 17:19

Description

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.