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)
