[DRILL-1204] Problem selecting the following json format (a mongodb export)

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Assignee: Unassigned
• Reporter: Winston Chen
• Created: 28/Jul/14 07:30
• Updated: 01/Oct/15 16:37

Description

The following exception occurs:
Producer Thread" java.lang.IllegalArgumentException: You tried to write a BigInt type when you are using a ValueWriter of type NullableFloat8WriterImpl.
at org.apache.drill.exec.vector.complex.impl.AbstractFieldWriter.fail(AbstractFieldWriter.java:509)
at org.apache.drill.exec.vector.complex.impl.AbstractFieldWriter.write(AbstractFieldWriter.java:141)
at org.apache.drill.exec.vector.complex.impl.NullableFloat8WriterImpl.write(NullableFloat8WriterImpl.java:83)
at org.apache.drill.exec.vector.complex.fn.JsonReader.writeData(JsonReader.java:129)
at org.apache.drill.exec.vector.complex.fn.JsonReader.writeData(JsonReader.java:162)
at org.apache.drill.exec.vector.complex.fn.JsonReader.writeData(JsonReader.java:97)
at org.apache.drill.exec.vector.complex.fn.JsonReader.write(JsonReader.java:65)
at org.apache.drill.exec.vector.complex.fn.JsonReaderWithState.write(JsonReaderWithState.java:52)
at org.apache.drill.exec.store.easy.json.JSONRecordReader2.next(JSONRecordReader2.java:82)
at org.apache.drill.exec.physical.impl.ScanBatch.next(ScanBatch.java:138)
at org.apache.drill.exec.physical.impl.producer.ProducerConsumerBatch$Producer.run(ProducerConsumerBatch.java:122)

when selecting the follow row of json file:
{"ssv2" : [

{ "rsco" : 0.583885768553 }

,

{ "rsco" : 0 }

]}

However, this works fine:
{"ssv2" : [

{ "rsco" : 0.583885768553 }

]}

Issue Links

• is superceded by: DRILL-1255 Allow change from integer to double type and vice versa in JSON reader