Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Not A Bug
-
1.16.0
-
None
-
None
-
Windows 10 Pro
Mongodb db version v4.0.10
Apache Drill 1.16
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