[jira] [Assigned] (DRILL-2513) JsonWriter writes a timestamp values for 'time' datatype

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

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

Jacques Nadeau reassigned DRILL-2513:
-------------------------------------

    Assignee: Jacques Nadeau  (was: Steven Phillips)

> 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: Jacques Nadeau
>             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)