drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2513) JsonWriter writes a timestamp values for 'time' datatype
Date Fri, 20 Mar 2015 21:55:39 GMT

    [ https://issues.apache.org/jira/browse/DRILL-2513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14372202#comment-14372202
] 

Rahul Challapalli commented on DRILL-2513:
------------------------------------------

Vicky...you are right. It is a duplicate

> JsonWriter writes a timestamp values for 'time' datatype
> --------------------------------------------------------
>
>                 Key: DRILL-2513
>                 URL: https://issues.apache.org/jira/browse/DRILL-2513
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - JSON
>            Reporter: Rahul Challapalli
>            Assignee: Steven Phillips
>             Fix For: 0.9.0
>
>         Attachments: fewtypes.tbl
>
>
> git.commit.id.abbrev=9c9ee8c
> Query :
> {code}
> create table temp_fromcsv as select cast(columns[3] as time) time_col from dfs.`cross-sources`.`fewtypes.tbl`;
> {code}
> The newly create json file has the below values
> {code}
> select * from dfs.`cross-sources`.`temp_fromcsv`;
> +------------+
> |  time_col  |
> +------------+
> | 1970-01-01T00:00:00.000Z |
> | 1970-01-01T01:00:00.000Z |
> | 1970-01-01T02:03:00.000Z |
> | 1970-01-01T11:59:00.000Z |
> | 1970-01-01T12:00:00.000Z |
> | 1970-01-01T12:01:00.000Z |
> | 1970-01-01T23:59:00.000Z |
> | 1970-01-01T23:59:59.990Z |
> | 1970-01-01T15:36:39.000Z |
> | 1970-01-01T15:36:39.000Z |
> | 1970-01-01T00:01:00.000Z |
> | 1970-01-01T02:33:00.000Z |
> | 1970-01-01T23:59:00.000Z |
> | 1970-01-01T12:03:00.000Z |
> | 1970-01-01T12:31:00.000Z |
> | 1970-01-01T19:59:00.000Z |
> | 1970-01-01T11:59:59.990Z |
> | 1970-01-01T15:37:39.000Z |
> | 1970-01-01T15:36:39.000Z |
> | 1970-01-01T11:59:59.990Z |
> | 1970-01-01T15:37:39.000Z |
> {code}
> This issue does not happen with ParquetWriter
> I attached the data file used.



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

Mime
View raw message