[jira] [Closed] (DRILL-1140) Casting of a timestamp to time fails

["Krystal (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-1140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Krystal closed DRILL-1140.
--------------------------

Verified that bug is fixed.  Automated test is at:
/private-sql-hadoop-test/framework/resources/Functional/Passing/datetime/datetime67.q

> 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
>            Assignee: DrillCommitter
>             Fix For: 0.4.0
>
>         Attachments: DRILL-1140.patch
>
>
> 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.3.4#6332)