Richard Powers created DRILL-7384:
-------------------------------------
Summary: 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
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 "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
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
