You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Chun Chang (JIRA)" <ji...@apache.org> on 2017/03/10 01:25:38 UTC
[jira] [Closed] (DRILL-599) can't convert timestamptz to time
[ https://issues.apache.org/jira/browse/DRILL-599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chun Chang closed DRILL-599.
----------------------------
> 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.15#6346)