You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Steven Phillips (JIRA)" <ji...@apache.org> on 2015/10/01 22:17:27 UTC
[jira] [Updated] (DRILL-2975) Extended Json : Time type reporting
data which is dependent on the system on which it ran
[ https://issues.apache.org/jira/browse/DRILL-2975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Phillips updated DRILL-2975:
-----------------------------------
Assignee: (was: Steven Phillips)
> 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
> Priority: Critical
> Fix For: 1.3.0
>
>
> 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.3.4#6332)