drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2964) Extended Json : Repeated date and time columns reporting wrong values
Date Tue, 05 May 2015 20:51:00 GMT
Rahul Challapalli created DRILL-2964:
----------------------------------------

             Summary: Extended Json : Repeated date and time columns reporting wrong values
                 Key: DRILL-2964
                 URL: https://issues.apache.org/jira/browse/DRILL-2964
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - JSON
            Reporter: Rahul Challapalli
            Assignee: Steven Phillips
            Priority: Critical


git.commit.id.abbrev=f240ac2

Data :
{code}
{
  "int_col" : {"$numberLong": 1},
  "date_col" : {"$dateDay": "2012-05-22"},
  "time_col"  : {"$time": "19:20:30.45Z"},
  "date_array" : [{"$dateDay" : "2012-08-01"}, {"$dateDay" : "2033-11-28"}],
  "time_array" : [{"$time": "19:20:30.45Z"}, {"$time": "11:25:01.45Z"}],
  "int_array" : [{"$numberLong": 1}, {"$numberLong": 2}, {"$numberLong": 3}]
}
{code}

Query :
{code}
0: jdbc:drill:schema=dfs_eea> select time_array, date_array from `data1.json`;
+------------+------------+
| time_array | date_array |
+------------+------------+
| [{"dayOfMonth":1,"dayOfWeek":4,"era":1,"year":1970,"dayOfYear":1,"centuryOfEra":19,"millisOfSecond":450,"millisOfDay":69630450,"secondOfMinute":30,"secondOfDay":69630,"minuteOfHour":20,"minuteOfDay":1160,"hourOfDay":19,"weekOfWeekyear":1,"weekyear":1970,"monthOfYear":1,"yearOfEra":1970,"yearOfCentury":70,"zone":{"fixed":true,"id":"UTC"},"millis":69630450,"chronology":{"zone":{"fixed":true,"id":"UTC"}},"afterNow":false,"equalNow":false,"beforeNow":true},{"dayOfMonth":1,"dayOfWeek":4,"era":1,"year":1970,"dayOfYear":1,"centuryOfEra":19,"millisOfSecond":450,"millisOfDay":41101450,"secondOfMinute":1,"secondOfDay":41101,"minuteOfHour":25,"minuteOfDay":685,"hourOfDay":11,"weekOfWeekyear":1,"weekyear":1970,"monthOfYear":1,"yearOfEra":1970,"yearOfCentury":70,"zone":{"fixed":true,"id":"UTC"},"millis":41101450,"chronology":{"zone":{"fixed":true,"id":"UTC"}},"afterNow":false,"equalNow":false,"beforeNow":true}]
| [{"dayOfMonth":1,"dayOfWeek":3,"era":1,"year":2012,"dayOfYear":214,"centuryOfEra":20,"millisOfSecond":0,"millisOfDay":0,"secondOfMinute":0,"secondOfDay":0,"minuteOfHour":0,"minuteOfDay":0,"hourOfDay":0,"weekOfWeekyear":31,"weekyear":2012,"monthOfYear":8,"yearOfEra":2012,"yearOfCentury":12,"zone":{"fixed":true,"id":"UTC"},"millis":1343779200000,"chronology":{"zone":{"fixed":true,"id":"UTC"}},"afterNow":false,"equalNow":false,"beforeNow":true},{"dayOfMonth":28,"dayOfWeek":1,"era":1,"year":2033,"dayOfYear":332,"centuryOfEra":20,"millisOfSecond":0,"millisOfDay":0,"secondOfMinute":0,"secondOfDay":0,"minuteOfHour":0,"minuteOfDay":0,"hourOfDay":0,"weekOfWeekyear":48,"weekyear":2033,"monthOfYear":11,"yearOfEra":2033,"yearOfCentury":33,"zone":{"fixed":true,"id":"UTC"},"millis":2016748800000,"chronology":{"zone":{"fixed":true,"id":"UTC"}},"afterNow":true,"equalNow":false,"beforeNow":false}]
|
{code}

Drill could be serializing the whole date object here. Marked it as critical since we are
reporting wrong data. Let me know if you have any questions.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message