[
https://issues.apache.org/jira/browse/DRILL-2350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14341669#comment-14341669
]
Bhallamudi Venkata Siva Kamesh commented on DRILL-2350:
-------------------------------------------------------
snippet of json file
{noformat}
{ "_id" : "15687", "city" : "STAHLSTOWN", "loc" : [ -79.344473, 40.138593 ],
"pop" : 2555, "state" : "PA" }
{ "_id" : "15688", "city" : "TARRS", "loc" : [ -79.566101, 40.161915 ], "pop" :
385, "state" : "PA" }
{noformat}
{noformat}
0: jdbc:drill:zk=localhost:2181> select _id,loc[0] as latitude,loc[1] as
longitude from hdfs.drill.`zips.json` where _id = 15687;;
+------------+------------+------------+
| _id | latitude | longitude |
+------------+------------+------------+
| 15687 | -79.344473 | 40.138593 |
Query failed: Query stopped., Needed to be in state INIT or IN_BIGINT but in
mode IN_FLOAT8 [ 5a7906ca-2631-4867-a962-59d25c6a2978 on localhost:31010 ]
0: jdbc:drill:zk=localhost:2181> select _id,loc[0] as latitude,loc[1] as
longitude from hdfs.drill.`zips.json` where _id = 15688;
+------------+------------+------------+
| _id | latitude | longitude |
+------------+------------+------------+
Query failed: Query stopped., Needed to be in state INIT or IN_BIGINT but in
mode IN_FLOAT8 [ 087385f7-0a99-4cc9-80f4-e3700b237e45 on localhost:31010 ]
{noformat}
> Star query failed with exception on JSON data
> ---------------------------------------------
>
> Key: DRILL-2350
> URL: https://issues.apache.org/jira/browse/DRILL-2350
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - JSON, Storage - MongoDB
> Affects Versions: 0.7.0
> Reporter: Bhallamudi Venkata Siva Kamesh
> Assignee: Steven Phillips
> Fix For: 0.8.0
>
>
> Query failed while executing following query on JSON data with following
> exception
> {noformat}select * from hdfs.drill.`zips.json`;{noformat}
> {noformat}
> 2015-02-28 21:37:34,058 [2b0e183a-7597-0a1e-fd12-56d91173af70:frag:0:0] ERROR
> o.a.d.e.w.f.AbstractStatusReporter - Error
> 6b26e17b-f114-47a9-9cf7-1a77ba52a8e6: Failure while running fragment.
> java.lang.IllegalStateException: Needed to be in state INIT or IN_BIGINT but
> in mode IN_FLOAT8
> at
> org.apache.drill.exec.vector.complex.impl.SingleListWriter.bigInt(SingleListWriter.java:387)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at
> org.apache.drill.exec.vector.complex.fn.JsonReader.writeData(JsonReader.java:422)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at
> org.apache.drill.exec.vector.complex.fn.JsonReader.writeData(JsonReader.java:256)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at
> org.apache.drill.exec.vector.complex.fn.JsonReader.writeDataSwitch(JsonReader.java:208)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at
> org.apache.drill.exec.vector.complex.fn.JsonReader.writeToVector(JsonReader.java:182)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at
> org.apache.drill.exec.vector.complex.fn.JsonReader.write(JsonReader.java:156)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at
> org.apache.drill.exec.store.easy.json.JSONRecordReader.next(JSONRecordReader.java:125)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at
> org.apache.drill.exec.physical.impl.ScanBatch.next(ScanBatch.java:165)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at
> org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:118)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at
> org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:67)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at
> org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:97)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at
> org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:57)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at
> org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:121)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at
> org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:303)
> [drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> [na:1.7.0_51]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> [na:1.7.0_51]
> at java.lang.Thread.run(Thread.java:744) [na:1.7.0_51]
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
