[DRILL-8195] Add Timestamp Zone offset ISO-8601 format for JSON EVF

• Type: Improvement
• Status: Reviewable
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.20.0
• Component/s: Storage - JSON
• Assignee: Vitalii Diravka
• Reporter: Vitalii Diravka
• Created: 22/Apr/22 22:07
• Updated: 15/Feb/23 06:35

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 

Issue Links

• is part of: DRILL-8037 Add V2 JSON Format Plugin based on EVF