[ https://issues.apache.org/jira/browse/DRILL-3540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau updated DRILL-3540: ---------------------------------- Summary: SQLline calls toString to convert complex columns into JSON. This translation doesn't work for some types (was: Joda module not added to jackson for default serialization of DateTime objects (enhanced json)) > SQLline calls toString to convert complex columns into JSON. This > translation doesn't work for some types > ---------------------------------------------------------------------------------------------------------- > > Key: DRILL-3540 > URL: https://issues.apache.org/jira/browse/DRILL-3540 > Project: Apache Drill > Issue Type: Bug > Components: Storage - JSON > Affects Versions: 1.1.0 > Reporter: Stefán Baxter > Assignee: Steven Phillips > > test-datetime.json > { > "occurred_at" : { > "$date" : "2015-04-01T00:14:02.309Z" > }, > "sub":{ > "occurred_at":{"$date":"2015-04-01T00:14:02.309Z"} > } > } > correctly results in this (without timezone though): > select t.occurred_at, t.sub.occurred_at from dfs.tmp.`/test-datetime.json` > as t; > +--------------------------+--------------------------+ > | occurred_at | EXPR$1 | > +--------------------------+--------------------------+ > | 2015-04-01 00:14:02.309 | 2015-04-01 00:14:02.309 | > +--------------------------+--------------------------+ > 1 row selected (0.067 seconds) > here we select the substructure, not the field > select t.occurred_at, t.sub from dfs.tmp.`/test-datetime.json` as t; > incorrectly results in this: > +-------------+-----+ > | occurred_at | sub | > +-------------+-----+ > | 2015-04-01 00:14:02.309 | > {"occurred_at":{"year":2015,"dayOfMonth":1,"dayOfWeek":3,"era":1,"dayOfYear":91,"weekyear":2015,"weekOfWeekyear":14,"monthOfYear":4,"yearOfEra":2015,"yearOfCentury":15,"centuryOfEra":20,"millisOfSecond":309,"millisOfDay":842309,"secondOfMinute":2,"secondOfDay":842,"minuteOfHour":14,"minuteOfDay":14,"hourOfDay":0,"millis":1427847242309,"zone":{"fixed":false,"uncachedZone":{"cachable":true,"fixed":false,"id":"Atlantic/Reykjavik"},"id":"Atlantic/Reykjavik"},"chronology":{"zone":{"fixed":false,"uncachedZone":{"cachable":true,"fixed":false,"id":"Atlantic/Reykjavik"},"id":"Atlantic/Reykjavik"}},"afterNow":false,"beforeNow":true,"equalNow":false}} > | > +-------------+-----+ > 1 row selected (0.066 seconds) -- This message was sent by Atlassian JIRA (v6.3.4#6332)