[
https://issues.apache.org/jira/browse/DRILL-8306?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17608680#comment-17608680
]
James Turton commented on DRILL-8306:
-------------------------------------
SQL timestamp strings are not in ISO-8601 format like yours are here. You can
run
{code:java}
select current_timestamp;{code}
to see the SQL format. You'll need to treat these timestamps as VARCHAR and
then feed them into a parsing function like TO_TIMSTAMP.
> UserRemoteException : DATA_READ ERROR: Error parsing JSON -
> Unexpected character ('-' (code 45)): was expecting comma to separate Object
> entries
> -------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DRILL-8306
> URL: https://issues.apache.org/jira/browse/DRILL-8306
> Project: Apache Drill
> Issue Type: Bug
> Reporter: SHUBHAM KUMAR
> Priority: Major
>
> While querying below Json we are getting the DATA_READ ERROR: Error parsing
> JSON - Unexpected character ('-' (code 45)): was expecting comma to separate
> Object entries.
> json payload:
> {
> "_id": "US26781824744023100811",
> "state": "SAP_PROCESSING",
> "createdAt": 2022-08-27T15:07:42.162Z,
> "customerId": "c5acee7c-35db-4741-a09f-20f8f76cc0bd",
> "orderTotal": 50,
> "shipmentInfo": [
> {
> "trackingNumber":"1ZWW2398YW72540758",
>
> "URL":"https://ulta.narvar.com/tracking/ulta/UPS?service=SP&tracking_numbers=1ZWW2398YW72540758&dzip=60540&order_number=K124155501&type=false&order_date=2019-11-29T16:40:02&promise_date=2019-12-05T00:00:00-0600&oZip=46143";
> }
> ],
> "updatedAt": 2022-08-28T15:07:42.162Z
> }
>
>
> Note: this issue coming mainly for createdAt and updatedAt field. if i make
> value of these fields as "createdAt": "2022-08-27T15:07:42.162Z" kind of
> string then able to query it successfully. Please suggest some solution
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
