[DRILL-1555] IllegalStateException in querying three dimensional json array

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.7.0
• Fix Version/s: 0.8.0
• Component/s: Execution - Data Types
• Assignee: Hanifi Gunes
• Reporter: Chun Chang
• Created: 20/Oct/14 16:57
• Updated: 17/Jan/15 01:50
• Resolved: 17/Jan/15 01:50

Description

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.