Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1204

Problem selecting the following json format (a mongodb export)

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • Future
    • None
    • None

    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 }

      ]}

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            wingchen Winston Chen

            Dates

              Created:
              Updated:

              Issue deployment