[jira] [Created] (DRILL-2975) Extended Json : Time type reporting data which is dependent on the system on which it ran

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

Rahul Challapalli created DRILL-2975:
----------------------------------------

             Summary: 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: Steven Phillips
            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.3.4#6332)