[DRILL-1140] Casting of a timestamp to time fails

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Functions - Drill
• Assignee: DrillCommitter
• Reporter: Krystal
• Created: 14/Jul/14 20:30
• Updated: 21/Apr/15 21:44
• Resolved: 21/Jul/14 02:48

Description

git.commit.id.abbrev=699851b

0: jdbc:drill:schema=dfs> select cast(create_time as timestamp) from voter where voter_id=1;
------------

EXPR$0

------------

2014-05-25 03:41:54.0

------------

0: jdbc:drill:schema=dfs> select cast(create_time as time) from voter where voter_id=1;
message: "Failure while running fragment. < IllegalArgumentException:[ Invalid format: "2014-05-25 03:41:54" is malformed at "14-05-25 03:41:54" ]"

The same query from oracle and postgres return the time portion of the timestamp.