[
https://issues.apache.org/jira/browse/DRILL-1555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14177156#comment-14177156
]
Chun Chang commented on DRILL-1555:
-----------------------------------
Changed the array to:
"array_array":[[["hello"], ["yeah"]], [["a"], ["b"]], [["c", "d"], ["e", "f",
"g"]]]
now I get IllegalArgumentException:
0: jdbc:drill:schema=dfs> select array_array from `complex.json`;
Query failed: Screen received stop request sent. null
[d1b47cb0-1efb-4e4d-822c-87cbfdd34196]
Error: exception while executing query: Failure while trying to get next result
batch. (state=,code=0)
log.
10:27:34.862 [1c78547a-3961-466f-afcb-947805de164c:frag:0:0 - Producer Thread]
DEBUG o.a.d.exec.physical.impl.ScanBatch - Failed to read the batch. Stopping...
java.lang.IllegalArgumentException: null
at
org.apache.drill.common.expression.PathSegment$ArraySegment.<init>(PathSegment.java:54)
~[drill-common-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.common.expression.PathSegment$ArraySegment.cloneWithNewChild(PathSegment.java:111)
~[drill-common-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.common.expression.PathSegment$ArraySegment.cloneWithNewChild(PathSegment.java:30)
~[drill-common-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.common.expression.PathSegment$NameSegment.cloneWithNewChild(PathSegment.java:193)
~[drill-common-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.common.expression.SchemaPath.getUnindexedArrayChild(SchemaPath.java:169)
~[drill-common-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.vector.complex.RepeatedListVector.addOrGet(RepeatedListVector.java:428)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.vector.complex.impl.RepeatedListWriter.varChar(RepeatedListWriter.java:653)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.vector.complex.fn.JsonReader.handleString(JsonReader.java:305)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.vector.complex.fn.JsonReader.writeData(JsonReader.java:376)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.vector.complex.fn.JsonReader.writeData(JsonReader.java:319)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.vector.complex.fn.JsonReader.writeData(JsonReader.java:319)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.vector.complex.fn.JsonReader.writeData(JsonReader.java:216)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.vector.complex.fn.JsonReader.writeToVector(JsonReader.java:146)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.vector.complex.fn.JsonReader.write(JsonReader.java:130)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.vector.complex.fn.JsonReaderWithState.write(JsonReaderWithState.java:73)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.store.easy.json.JSONRecordReader2.next(JSONRecordReader2.java:111)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.ScanBatch.next(ScanBatch.java:158)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:117)
[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.producer.ProducerConsumerBatch$Producer.run(ProducerConsumerBatch.java:128)
[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]
10:27:34.863 [1c78547a-3961-466f-afcb-947805de164c:frag:0:0 - Producer Thread]
ERROR o.a.drill.exec.ops.FragmentContext - Fragment Context received failure.
> IllegalStateException in querying three dimensional json array
> --------------------------------------------------------------
>
> Key: DRILL-1555
> URL: https://issues.apache.org/jira/browse/DRILL-1555
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types
> Affects Versions: 0.7.0
> Reporter: Chun Chang
>
> code base:
> #Mon Oct 13 15:16:16 PDT 2014
> git.commit.id.abbrev=cd6dd9c
> I have a json array like this inside a json file
> "array_array":[["hello", "yeah"], ["a", "b"], [["c", "d"], ["e", "f", "g"]],
> Query this array gives me the following exception:
> 0: jdbc:drill:schema=dfs> select array_array from `complex.json`;
> Query failed: Screen received stop request sent. Needed to be in state INIT
> or IN_LIST but in mode IN_VARCHAR [2718c521-f05f-49bd-adbd-7834623d492e]
> Error: exception while executing query: Failure while trying to get next
> result batch. (state=,code=0)
> Here is the exception in drill bit.log:
> java.lang.IllegalStateException: Needed to be in state INIT or IN_LIST but in
> mode IN_VARCHAR
> at
> org.apache.drill.exec.vector.complex.impl.RepeatedListWriter.list(RepeatedListWriter.java:162)
>
> ~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.vector.complex.fn.JsonReader.writeData(JsonReader.java:319)
>
> ~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.vector.complex.fn.JsonReader.writeData(JsonReader.java:319)
>
> ~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.vector.complex.fn.JsonReader.writeData(JsonReader.java:216)
>
> ~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.vector.complex.fn.JsonReader.writeToVector(JsonReader.java:146)
>
> ~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.vector.complex.fn.JsonReader.write(JsonReader.java:130)
> ~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.vector.complex.fn.JsonReaderWithState.write(JsonReaderWithState.java:73)
>
> ~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.store.easy.json.JSONRecordReader2.next(JSONRecordReader2.java:111)
>
> ~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.physical.impl.ScanBatch.next(ScanBatch.java:158)
> ~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:117)
>
> ~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.physical.impl.producer.ProducerConsumerBatch$Producer.run(ProducerConsumerBatch.java:128)
>
> ~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
> at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]
> 09:47:34.824 [10acefc4-3012-4a7e-9f2d-5be7292663c7:frag:0:0] ERROR
> o.a.d.e.w.f.AbstractStatusReporter - Error
> dd2c9275-61d9-4604-9faf-c6977247cf4b: Failure while running fragment.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
