drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-599) can't convert timestamptz to time
Date Sun, 04 Jan 2015 21:28:48 GMT

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

Jacques Nadeau resolved DRILL-599.
----------------------------------
    Resolution: Fixed

> can't convert timestamptz to time
> ---------------------------------
>
>                 Key: DRILL-599
>                 URL: https://issues.apache.org/jira/browse/DRILL-599
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Chun Chang
>             Fix For: Future
>
>
> postgres:
> foodmart=# select c_row, c_timestamptz, cast(c_timestamptz as time) from data;
>  c_row |         c_timestamptz         |  c_timestamptz
> -------+-------------------------------+-----------------
>      1 | 1997-02-10 17:32:01-08        | 17:32:01
>      2 | 1997-02-10 17:32:01.000001-08 | 17:32:01.000001
>      3 | 1997-02-10 17:32:01.999999-08 | 17:32:01.999999
>      4 | 1997-02-10 17:32:01.4-08      | 17:32:01.4
>      5 | 1997-02-10 17:32:01.5-08      | 17:32:01.5
>      6 | 1997-02-10 17:32:01.6-08      | 17:32:01.6
>      7 | 1997-02-10 17:32:01-08        | 17:32:01
>      8 | 1997-06-10 17:32:01-07        | 17:32:01
>      9 | 2000-03-15 08:14:01-08        | 08:14:01
>     10 | 2000-03-15 04:14:02-08        | 04:14:02
>     11 | 2000-03-15 02:14:03-08        | 02:14:03
>     12 | 2000-03-15 03:14:04-08        | 03:14:04
>     13 | 2000-03-15 01:14:05-08        | 01:14:05
>     14 | 1997-02-10 17:32:01-08        | 17:32:01
>     15 | 1997-02-10 17:32:01-08        | 17:32:01
>     16 | 1997-02-10 17:32:00-08        | 17:32:00
>     17 | 1997-06-10 18:32:01-07        | 18:32:01
>     18 | 1997-01-02 00:00:00-08        | 00:00:00
>     19 | 1997-01-02 03:04:05-08        | 03:04:05
>     20 | 1997-02-10 17:32:01-08        | 17:32:01
>     21 | 1997-02-10 17:32:01-08        | 17:32:01
>     22 | 1997-02-10 17:32:01-08        | 17:32:01
>     23 | 1997-02-10 17:32:00-08        | 17:32:00
> (23 rows)
> drill:
> 0: jdbc:drill:schema=dfs> select cast(c_timestamptz as time) from data;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id:
"63c1ad1b-6986-4bee-94ad-5de1b4cb9ac8"
> endpoint {
>   address: "qa-node119.qa.lab"
>   user_port: 31010
>   control_port: 31011
>   data_port: 31012
> }
> error_type: 0
> message: "Failure while running fragment. < IllegalArgumentException:[ Invalid format:
\"1997-02-10 17:32:01-08\" is malformed at \"97-02-10 17:32:01-08\" ]"
> ]
> Error: exception while executing query (state=,code=0)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message