drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vitalii Diravka (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (DRILL-2975) Extended Json : Time type reporting data which is dependent on the system on which it ran
Date Wed, 21 Jun 2017 14:28:00 GMT

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

Vitalii Diravka closed DRILL-2975.
----------------------------------
       Resolution: Not A Bug
    Fix Version/s:     (was: Future)

According to the conversation in [DRILL-4116|https://issues.apache.org/jira/browse/DRILL-4116]
it seems that drillbits on these two machines work with different timezones. 
Therefore Drill behaviour described in the jira is expected and jira can be closed.

[~rkins] If something is missed, please reopen the jira.


> Extended Json : Time type reporting data which is dependent on the system on which it
ran
> -----------------------------------------------------------------------------------------
>
>                 Key: DRILL-2975
>                 URL: https://issues.apache.org/jira/browse/DRILL-2975
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - JSON
>    Affects Versions: 1.2.0
>            Reporter: Rahul Challapalli
>            Assignee: Vitalii Diravka
>            Priority: Critical
>
> git.commit.id.abbrev=3b19076
> Data :
> {code}
> {
>   "int_col" : {"$numberLong": 1},
>   "date_col" : {"$dateDay": "2012-05-22"},
>   "time_col"  : {"$time": "19:20:30.45Z"}
> }
> {code}
> System 1 :
> {code}
> 0: jdbc:drill:schema=dfs_eea> select time_col from `extended_json/data1.json` d;
> +------------+
> |  time_col  |
> +------------+
> | 19:20:30.450 |
> +------------+
> {code}
> System 2 :
> {code}
> 0: jdbc:drill:schema=dfs.drillTestDirComplexP> select time_col from `temp.json`;
> +------------+
> |  time_col  |
> +------------+
> | 11:20:30.450 |
> +------------+
> {code}
> The above results are inconsistent.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message