[
https://issues.apache.org/jira/browse/DRILL-1140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14061241#comment-14061241
]
Krystal commented on DRILL-1140:
--------------------------------
For the query in the description, the underlying type is drill string.
However, I ran the same query against a hive table and a view that has the
column as timestamp and the query also failed with the same error.
> Casting of a timestamp to time fails
> ------------------------------------
>
> Key: DRILL-1140
> URL: https://issues.apache.org/jira/browse/DRILL-1140
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Reporter: Krystal
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
