You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "SHUBHAM KUMAR (Jira)" <ji...@apache.org> on 2022/09/12 16:30:00 UTC
[jira] [Updated] (DRILL-8306) UserRemoteException : DATA_READ ERROR: Error parsing JSON - Unexpected character ('-' (code 45)): was expecting comma to separate Object entries
[ https://issues.apache.org/jira/browse/DRILL-8306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
SHUBHAM KUMAR updated DRILL-8306:
---------------------------------
Description:
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
was:
I am trying to connect below mongo db instance using below URI in Apache Drill, but not able to fetch all databases its just showing only *mongo.admin* database but in actual it holds 4 databases.
URI: mongodb+srv://username:password@hostname/databasename
but same URI we are using in MongoDB compass and able to view all 4 databases.
> 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)