[
https://issues.apache.org/jira/browse/DRILL-282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13817461#comment-13817461
]
Jacques Nadeau commented on DRILL-282:
--------------------------------------
We don't actually support the repeated map type yet in Milestone one. We're
missing that datatype. I think Tim already created the functionality on the
reader side but since we don't support in general execution layer, it doesn't
work. Repeated map is used when you have an array of sub maps within a top
level map. I think this is the problem you are encountering given the data
described. I think this should be targeted for milestone 3.
> Support 'repeated' type in Json reader
> --------------------------------------
>
> Key: DRILL-282
> URL: https://issues.apache.org/jira/browse/DRILL-282
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Mehant Baid
> Assignee: Timothy Chen
>
> Trying to scan the following json file
> {
> "Bigname": [ {"name": "hello", "id": "1"}, {"name": "world", "id": "2"}]
> }
> using a simple query (via sqlline): select * from "filename.json"; results in
> the following error
> java.lang.IndexOutOfBoundsException
> at io.netty.buffer.EmptyByteBuf.checkIndex(EmptyByteBuf.java:857)
> at io.netty.buffer.EmptyByteBuf.getBytes(EmptyByteBuf.java:321)
> at
> org.apache.drill.exec.vector.VarCharVector$Accessor.get(VarCharVector.java:241)
> at
> org.apache.drill.exec.vector.VarCharVector$Accessor.getObject(VarCharVector.java:258)
> at
> org.apache.drill.exec.vector.NullableVarCharVector$Accessor.getObject(NullableVarCharVector.java:245)
> at org.apache.drill.sql.client.full.JsonHelper.get(JsonHelper.java:41)
> at
> org.apache.drill.sql.client.full.BatchLoaderMap.getCurrentObject(BatchLoaderMap.java:112)
> at
> org.apache.drill.sql.client.full.ResultEnumerator.moveNext(ResultEnumerator.java:51)
> at
> net.hydromatic.optiq.runtime.ObjectEnumeratorCursor.next(ObjectEnumeratorCursor.java:44)
> at
> net.hydromatic.optiq.jdbc.OptiqResultSet.next(OptiqResultSet.java:162)
> at sqlline.SqlLine$BufferedRows.<init>(SqlLine.java:2499)
> at sqlline.SqlLine.print(SqlLine.java:1886)
> at sqlline.SqlLine$Commands.execute(SqlLine.java:3835)
> at sqlline.SqlLine$Commands.sql(SqlLine.java:3738)
> at sqlline.SqlLine.dispatch(SqlLine.java:882)
> at sqlline.SqlLine.begin(SqlLine.java:717)
> at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:460)
> at sqlline.SqlLine.main(SqlLine.java:443)
> The same query works if the above json file is modified to be the following:
> {
> "Bigname": [ {"name": "hello", "id": "1"} ]
> }
--
This message was sent by Atlassian JIRA
(v6.1#6144)
