[ 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)