You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2015/05/06 00:27:59 UTC
[jira] [Updated] (DRILL-2964) Extended Json : Repeated date and
time columns reporting wrong values
[ https://issues.apache.org/jira/browse/DRILL-2964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau updated DRILL-2964:
----------------------------------
Priority: Major (was: Critical)
> 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: Client - CLI
> Reporter: Rahul Challapalli
> Assignee: Steven Phillips
> Fix For: 1.2.0
>
>
> 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)