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

Add Timestamp Zone offset ISO-8601 format for JSON EVF

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

Details

    • Improvement
    • Status: Reviewable
    • Major
    • Resolution: Unresolved
    • 1.20.0
    • None
    • Storage - JSON
    • None

    Description

      Add new format ifor mongo-styled dates intorduced in DRILL-8143 to EVF based JSON reader

      The following test cases failed:
      TestExtendedTypes, TestFrameworkTest, TestCsvWithoutHeadersWithSchema, TestNestedDateTimeTimestamp, TestJsonRecordReader

      java.lang.Exception: org.apache.drill.common.exceptions.UserRemoteException: DATA_READ ERROR: Type of JSON token is not compatible with its columnJSON token type: date
      JSON token: 2019-09-30T20:47:43.10+05
      Column: date
      Column type: TIMESTAMP
      Format plugin: json
      Format plugin: JSONFormatPlugin
      Plugin config name: json
      File name: classpath:/jsoninput/input2.json
      Line: 32
      Position: 42
      Near token: 2019-09-30T20:47:43.10+05
      Fragment: 0:0 

      Attachments

        Issue Links

        Activity

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

          People

            vitalii Vitalii Diravka
            vitalii Vitalii Diravka

            Dates

              Created:
              Updated:

              Slack

                Issue deployment