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:29:59 UTC
[jira] [Commented] (DRILL-2964) toString of JDBC object return type
should do smarter JSON encoding
[ https://issues.apache.org/jira/browse/DRILL-2964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14529425#comment-14529425 ]
Jacques Nadeau commented on DRILL-2964:
---------------------------------------
The problem here is actually SQLLine not knowing how to decode complex values. We can improve by changing toString but the real problem is we need to customize SQLline to have more data return modes.
> toString of JDBC object return type should do smarter JSON encoding
> -------------------------------------------------------------------
>
> 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)