[jira] [Commented] (DRILL-8377) While accessing a Uppercase databasename in Drill its getting converted to lower case and then throwing error cant access database
[
https://issues.apache.org/jira/browse/DRILL-8377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17652316#comment-17652316
]
SHUBHAM KUMAR commented on DRILL-8377:
--
Can you please help with any configuration which helps to retrive the database
name as it is. it should not convert it to lower case
> While accessing a Uppercase databasename in Drill its getting converted to
> lower case and then throwing error cant access database
> --
>
> Key: DRILL-8377
> URL: https://issues.apache.org/jira/browse/DRILL-8377
> Project: Apache Drill
> Issue Type: Bug
>Reporter: SHUBHAM KUMAR
>Priority: Major
>
> While accessing a Uppercase databasename in Drill its getting converted to
> lower case and then throwing error cant access database
>
> Command failed with error 13 (Unauthorized): 'not authorized on test-database
> to execute command.
> org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> MongoCommandException: Command failed with error 13 (Unauthorized): 'not
> authorized on test-database to execute command \{ count: "PaymentsDev",
> query: {}, $db: "test-database", $clusterTime:
>
> Actual Database Name: Test-Database
> Drill converting it as: test-database
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Updated] (DRILL-8377) While accessing a Uppercase databasename in Drill its getting converted to lower case and then throwing error cant access database
[
https://issues.apache.org/jira/browse/DRILL-8377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
SHUBHAM KUMAR updated DRILL-8377:
-
Description:
While accessing a Uppercase databasename in Drill its getting converted to
lower case and then throwing error cant access database
Command failed with error 13 (Unauthorized): 'not authorized on test-database
to execute command.
org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
MongoCommandException: Command failed with error 13 (Unauthorized): 'not
authorized on test-database to execute command \{ count: "PaymentsDev", query:
{}, $db: "test-database", $clusterTime:
Actual Database Name: Test-Database
Drill converting it as: test-database
was:
While accessing a Uppercase databasename in Drill its getting converted to
lower case and then throwing error cant access database
Command failed with error 13 (Unauthorized): 'not authorized on qa-omniprofile
to execute command.
org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
MongoCommandException: Command failed with error 13 (Unauthorized): 'not
authorized on qa-omniprofile to execute command \{ count: "PaymentsDev", query:
{}, $db: "qa-omniprofile", $clusterTime:
> While accessing a Uppercase databasename in Drill its getting converted to
> lower case and then throwing error cant access database
> --
>
> Key: DRILL-8377
> URL: https://issues.apache.org/jira/browse/DRILL-8377
> Project: Apache Drill
> Issue Type: Bug
>Reporter: SHUBHAM KUMAR
>Priority: Major
>
> While accessing a Uppercase databasename in Drill its getting converted to
> lower case and then throwing error cant access database
>
> Command failed with error 13 (Unauthorized): 'not authorized on test-database
> to execute command.
> org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> MongoCommandException: Command failed with error 13 (Unauthorized): 'not
> authorized on test-database to execute command \{ count: "PaymentsDev",
> query: {}, $db: "test-database", $clusterTime:
>
> Actual Database Name: Test-Database
> Drill converting it as: test-database
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Updated] (DRILL-8377) While accessing a Uppercase databasename in Drill its getting converted to lower case and then throwing error cant access database
[
https://issues.apache.org/jira/browse/DRILL-8377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
SHUBHAM KUMAR updated DRILL-8377:
-
Description:
While accessing a Uppercase databasename in Drill its getting converted to
lower case and then throwing error cant access database
Command failed with error 13 (Unauthorized): 'not authorized on qa-omniprofile
to execute command.
org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
MongoCommandException: Command failed with error 13 (Unauthorized): 'not
authorized on qa-omniprofile to execute command \{ count: "PaymentsDev", query:
{}, $db: "qa-omniprofile", $clusterTime:
was:
Command failed with error 13 (Unauthorized): 'not authorized on qa-omniprofile
to execute command.
org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
MongoCommandException: Command failed with error 13 (Unauthorized): 'not
authorized on qa-omniprofile to execute command \{ count: "PaymentsDev", query:
{}, $db: "qa-omniprofile", $clusterTime:
> While accessing a Uppercase databasename in Drill its getting converted to
> lower case and then throwing error cant access database
> --
>
> Key: DRILL-8377
> URL: https://issues.apache.org/jira/browse/DRILL-8377
> Project: Apache Drill
> Issue Type: Bug
>Reporter: SHUBHAM KUMAR
>Priority: Major
>
> While accessing a Uppercase databasename in Drill its getting converted to
> lower case and then throwing error cant access database
>
> Command failed with error 13 (Unauthorized): 'not authorized on
> qa-omniprofile to execute command.
> org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> MongoCommandException: Command failed with error 13 (Unauthorized): 'not
> authorized on qa-omniprofile to execute command \{ count: "PaymentsDev",
> query: {}, $db: "qa-omniprofile", $clusterTime:
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Updated] (DRILL-8377) While accessing a Uppercase databasename in Drill its getting converted to lower case and then throwing error cant access database
[
https://issues.apache.org/jira/browse/DRILL-8377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
SHUBHAM KUMAR updated DRILL-8377:
-
Description:
Command failed with error 13 (Unauthorized): 'not authorized on qa-omniprofile
to execute command.
org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
MongoCommandException: Command failed with error 13 (Unauthorized): 'not
authorized on qa-omniprofile to execute command \{ count: "PaymentsDev", query:
{}, $db: "qa-omniprofile", $clusterTime:
was:
Command failed with error 13 (Unauthorized): 'not authorized on qa-omniprofile
to execute command.
> While accessing a Uppercase databasename in Drill its getting converted to
> lower case and then throwing error cant access database
> --
>
> Key: DRILL-8377
> URL: https://issues.apache.org/jira/browse/DRILL-8377
> Project: Apache Drill
> Issue Type: Bug
>Reporter: SHUBHAM KUMAR
>Priority: Major
>
> Command failed with error 13 (Unauthorized): 'not authorized on
> qa-omniprofile to execute command.
> org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> MongoCommandException: Command failed with error 13 (Unauthorized): 'not
> authorized on qa-omniprofile to execute command \{ count: "PaymentsDev",
> query: {}, $db: "qa-omniprofile", $clusterTime:
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Updated] (DRILL-8377) While accessing a Uppercase databasename in Drill its getting converted to lower case and then throwing error cant access database
[ https://issues.apache.org/jira/browse/DRILL-8377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] SHUBHAM KUMAR updated DRILL-8377: - Summary: While accessing a Uppercase databasename in Drill its getting converted to lower case and then throwing error cant access database (was: Command failed with error 13 (Unauthorized): 'not authorized on qa-omniprofile to execute command) > While accessing a Uppercase databasename in Drill its getting converted to > lower case and then throwing error cant access database > -- > > Key: DRILL-8377 > URL: https://issues.apache.org/jira/browse/DRILL-8377 > Project: Apache Drill > Issue Type: Bug >Reporter: SHUBHAM KUMAR >Priority: Major > > Command failed with error 13 (Unauthorized): 'not authorized on > qa-omniprofile to execute command. > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (DRILL-8377) Command failed with error 13 (Unauthorized): 'not authorized on qa-omniprofile to execute command
[ https://issues.apache.org/jira/browse/DRILL-8377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] SHUBHAM KUMAR updated DRILL-8377: - Description: Command failed with error 13 (Unauthorized): 'not authorized on qa-omniprofile to execute command. > Command failed with error 13 (Unauthorized): 'not authorized on > qa-omniprofile to execute command > - > > Key: DRILL-8377 > URL: https://issues.apache.org/jira/browse/DRILL-8377 > Project: Apache Drill > Issue Type: Bug >Reporter: SHUBHAM KUMAR >Priority: Major > > Command failed with error 13 (Unauthorized): 'not authorized on > qa-omniprofile to execute command. > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Created] (DRILL-8377) Command failed with error 13 (Unauthorized): 'not authorized on qa-omniprofile to execute command
SHUBHAM KUMAR created DRILL-8377: Summary: Command failed with error 13 (Unauthorized): 'not authorized on qa-omniprofile to execute command Key: DRILL-8377 URL: https://issues.apache.org/jira/browse/DRILL-8377 Project: Apache Drill Issue Type: Bug Reporter: SHUBHAM KUMAR -- This message was sent by Atlassian Jira (v8.20.10#820010)
[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_numbers=1ZWW2398YW72540758=60540_number=K124155501=false_date=2019-11-29T16:40:02_date=2019-12-05T00:00:00-0600=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_numbers=1ZWW2398YW72540758=60540_number=K124155501=false_date=2019-11-29T16:40:02_date=2019-12-05T00:00:00-0600=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)
[jira] [Created] (DRILL-8306) UserRemoteException : DATA_READ ERROR: Error parsing JSON - Unexpected character ('-' (code 45)): was expecting comma to separate Object entries
SHUBHAM KUMAR created DRILL-8306:
Summary: 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
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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Updated] (DRILL-8285) Only able to view mongo.admin db in Apache Drill while making connection to mongo db Instance which has total 4 databases
[ https://issues.apache.org/jira/browse/DRILL-8285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] SHUBHAM KUMAR updated DRILL-8285: - Attachment: Apache drill db screenshot.PNG > Only able to view mongo.admin db in Apache Drill while making connection to > mongo db Instance which has total 4 databases > - > > Key: DRILL-8285 > URL: https://issues.apache.org/jira/browse/DRILL-8285 > Project: Apache Drill > Issue Type: Bug >Reporter: SHUBHAM KUMAR >Priority: Major > Attachments: Apache drill db screenshot.PNG, Mongo DB Compass.PNG > > > 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. > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (DRILL-8285) Only able to view mongo.admin db in Apache Drill while making connection to mongo db Instance which has total 4 databases
[ https://issues.apache.org/jira/browse/DRILL-8285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] SHUBHAM KUMAR updated DRILL-8285: - Attachment: Mongo DB Compass.PNG > Only able to view mongo.admin db in Apache Drill while making connection to > mongo db Instance which has total 4 databases > - > > Key: DRILL-8285 > URL: https://issues.apache.org/jira/browse/DRILL-8285 > Project: Apache Drill > Issue Type: Bug >Reporter: SHUBHAM KUMAR >Priority: Major > Attachments: Mongo DB Compass.PNG > > > 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. > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Created] (DRILL-8285) Only able to view mongo.admin db in Apache Drill while making connection to mongo db Instance which has total 4 databases
SHUBHAM KUMAR created DRILL-8285: Summary: Only able to view mongo.admin db in Apache Drill while making connection to mongo db Instance which has total 4 databases Key: DRILL-8285 URL: https://issues.apache.org/jira/browse/DRILL-8285 Project: Apache Drill Issue Type: Bug Reporter: SHUBHAM KUMAR Attachments: Mongo DB Compass.PNG 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. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (DRILL-8284) Apache SQL Query failing while accessing the Json with complex data model
[
https://issues.apache.org/jira/browse/DRILL-8284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17583896#comment-17583896
]
SHUBHAM KUMAR commented on DRILL-8284:
--
Json sample for case1:
{"attributes": [
{
"name": "webBrandName",
"value": {
"en-US": "Smashbox"
}
},
{
"name": "startDate",
"value": "2011-07-25T15:30:00.000Z"
}
]
}
Json sample for case2:
{"attributes": [
{
"name": "startDate",
"value": "2011-07-25T15:30:00.000Z"
},
{
"name": "hasCBD",
"value": false
}
]
}
> Apache SQL Query failing while accessing the Json with complex data model
> -
>
> Key: DRILL-8284
> URL: https://issues.apache.org/jira/browse/DRILL-8284
> Project: Apache Drill
> Issue Type: Bug
>Reporter: SHUBHAM KUMAR
>Priority: Major
>
> Apache SQL Query failing while accessing the Json with complex data model.
> Complex Json:
> Map object inside another map object then Array Object.
> Case1: When we have nested objects within array map, and map within map.
> {"attributes": [
> {
> "name": "webBrandName",
> "value": {
> "en-US": "Smashbox"
> }
> },
> {
> "name": "startDate",
> "value": "2011-07-25T15:30:00.000Z"
> }
> ]
> }
> Case2: Having array with multiple map items with diff data types. eg. String
> and Boolean both type.
> {"attributes": [
> {
> "name": "startDate",
> "value": "2011-07-25T15:30:00.000Z"
> },
> {
> "name": "hasCBD",
> "value": false
> }
> ]
> }
> Query:
> select flatten(attributes) as Var from dfs.`/filepath/filename.json`
>
> Error:
> org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> IndexOutOfBoundsException: readerIndex: 0, writerIndex: 1764642048 (expected:
> 0 <= readerIndex <= writerIndex <= capacity(0)) Fragment: 0:0 Please, refer
> to logs for more information. [Error Id: c5a3b8fa-cad1-4c9a-8673-de5745e9170b
> on GGNUWT461535L.ad.infosys.com:31010]
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Created] (DRILL-8284) Apache SQL Query failing while accessing the Json with complex data model
SHUBHAM KUMAR created DRILL-8284:
Summary: Apache SQL Query failing while accessing the Json with
complex data model
Key: DRILL-8284
URL: https://issues.apache.org/jira/browse/DRILL-8284
Project: Apache Drill
Issue Type: Bug
Reporter: SHUBHAM KUMAR
Apache SQL Query failing while accessing the Json with complex data model.
Complex Json:
Map object inside another map object then Array Object.
Case1: When we have nested objects within array map, and map within map.
{"attributes": [
{
"name": "webBrandName",
"value": {
"en-US": "Smashbox"
}
},
{
"name": "startDate",
"value": "2011-07-25T15:30:00.000Z"
}
]
}
Case2: Having array with multiple map items with diff data types. eg. String
and Boolean both type.
{"attributes": [
{
"name": "startDate",
"value": "2011-07-25T15:30:00.000Z"
},
{
"name": "hasCBD",
"value": false
}
]
}
Query:
select flatten(attributes) as Var from dfs.`/filepath/filename.json`
Error:
org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
IndexOutOfBoundsException: readerIndex: 0, writerIndex: 1764642048 (expected: 0
<= readerIndex <= writerIndex <= capacity(0)) Fragment: 0:0 Please, refer to
logs for more information. [Error Id: c5a3b8fa-cad1-4c9a-8673-de5745e9170b on
GGNUWT461535L.ad.infosys.com:31010]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
