[
https://issues.apache.org/jira/browse/DRILL-7384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Richard Powers updated DRILL-7384:
----------------------------------
Description:
Hello. I'm having issues with multiple machine installs having Apache Drill
show using the show databases command or be able to query data from databases
created in mongodb. I think the length of the database name is the issue, but
I'm surprised a db name of 20 characters is too much, wonder if this is
expected? It seems like about 18 characters is the limit.
*Tests Performed:*
*1.* Ran these 5 mongoimport commands on the same review.json file (in test
data supplied with Drill install). Each one loads the same file into a new
database, into a collection called "rvw1". When I issue a show database
command, drill sees all the databases. But issuing a 'show tables' only
returns data in the "commandlinedbfrom" and ""commandlinedbfram" databases,
while doing so in the rest show 0 rows. I confirmed the data did load ok to
each database in mongo, with no authentication in play.
mongoimport -v --host localhost:27017 -d "commandlinedbfromMonkoImp" -c "rvw1"
--file "review.json" --type json
mongoimport -v --host localhost:27017 -d "commandlinedbfromMonkoIm" -c "rvw1"
--file "review.json" --type json
mongoimport -v --host localhost:27017 -d "commandlinedbfromMonkoI" -c "rvw1"
--file "review.json" --type json
mongoimport -v --host localhost:27017 -d "commandlinedbfromMonk" -c "rvw1"
--file "review.json" --type json
mongoimport -v --host localhost:27017 -d "commandlinedbfromMon" -c "rvw1"
--file "review.json" --type json
mongoimport -v --host localhost:27017 -d "commandlinedbfromM" -c "rvw1" --file
"review.json" --type json
These are the ones that did work with Drill, 1 char less for db name:
mongoimport -v --host localhost:27017 -d "commandlinedbfrom" -c "rvw1" --file
"review.json" --type json
mongoimport -v --host localhost:27017 -d "commandlinedbfram" -c "rvw1" --file
"review.json" --type json
was:
Hello. I'm having issues with multiple machine installs having Apache Drill
show using the show databases command or be able to query data from databases
created in mongodb. I think the length of the database name is the issue, but
I'm surprised a db name of 20 characters is too much, wonder if this is
expected? It seems like about 18 characters is the limit.
*Tests Performed:*
*1.* Ran these 5 mongoimport commands on the same review.json file (in test
data supplied with Drill install). Each one loads the same file into a new
database, into a collection called "rvw1". When I issue a show database
command, drill sees all the databases. But issuing a 'show tables' only
returns data in the "commandlinedbfromM" database, while doing so in the rest
show 0 rows. I confirmed the data did load ok to each database in mongo, with
no authentication in play.
mongoimport -v --host localhost:27017 -d "commandlinedbfromMonkoImp" -c "rvw1"
--file "review.json" --type json
mongoimport -v --host localhost:27017 -d "commandlinedbfromMonkoIm" -c "rvw1"
--file "review.json" --type json
mongoimport -v --host localhost:27017 -d "commandlinedbfromMonkoI" -c "rvw1"
--file "review.json" --type json
mongoimport -v --host localhost:27017 -d "commandlinedbfromMonk" -c "rvw1"
--file "review.json" --type json
mongoimport -v --host localhost:27017 -d "commandlinedbfromMon" -c "rvw1"
--file "review.json" --type json
mongoimport -v --host localhost:27017 -d "commandlinedbfromM" -c "rvw1" --file
"review.json" --type json
> Mongodb database name character length limit in order for Drill to see tables
> in it?
> ------------------------------------------------------------------------------------
>
> Key: DRILL-7384
> URL: https://issues.apache.org/jira/browse/DRILL-7384
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - MongoDB
> Affects Versions: 1.16.0
> Environment: Windows 10 Pro
> Mongodb db version v4.0.10
> Apache Drill 1.16
> Reporter: Richard Powers
> Priority: Major
> Attachments: show databases output.JPG, show tables.JPG, sqlline from
> 9-24 length check.log, sqlline_queries.log
>
>
> Hello. I'm having issues with multiple machine installs having Apache Drill
> show using the show databases command or be able to query data from databases
> created in mongodb. I think the length of the database name is the issue,
> but I'm surprised a db name of 20 characters is too much, wonder if this is
> expected? It seems like about 18 characters is the limit.
>
> *Tests Performed:*
> *1.* Ran these 5 mongoimport commands on the same review.json file (in test
> data supplied with Drill install). Each one loads the same file into a new
> database, into a collection called "rvw1". When I issue a show database
> command, drill sees all the databases. But issuing a 'show tables' only
> returns data in the "commandlinedbfrom" and ""commandlinedbfram" databases,
> while doing so in the rest show 0 rows. I confirmed the data did load ok to
> each database in mongo, with no authentication in play.
> mongoimport -v --host localhost:27017 -d "commandlinedbfromMonkoImp" -c
> "rvw1" --file "review.json" --type json
> mongoimport -v --host localhost:27017 -d "commandlinedbfromMonkoIm" -c
> "rvw1" --file "review.json" --type json
> mongoimport -v --host localhost:27017 -d "commandlinedbfromMonkoI" -c "rvw1"
> --file "review.json" --type json
> mongoimport -v --host localhost:27017 -d "commandlinedbfromMonk" -c "rvw1"
> --file "review.json" --type json
> mongoimport -v --host localhost:27017 -d "commandlinedbfromMon" -c "rvw1"
> --file "review.json" --type json
> mongoimport -v --host localhost:27017 -d "commandlinedbfromM" -c "rvw1"
> --file "review.json" --type json
>
> These are the ones that did work with Drill, 1 char less for db name:
> mongoimport -v --host localhost:27017 -d "commandlinedbfrom" -c "rvw1" --file
> "review.json" --type json
> mongoimport -v --host localhost:27017 -d "commandlinedbfram" -c "rvw1"
> --file "review.json" --type json
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
