[DRILL-7384] Mongodb database name character length limit in order for Drill to see tables in it?

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Bug
• Affects Version/s: 1.16.0
• Component/s: Storage - MongoDB

Environment

Windows 10 Pro

Mongodb db version v4.0.10

Apache Drill 1.16

• Assignee: Unassigned
• Reporter: Richard Powers
• Created: 24/Sep/19 19:54
• Updated: 02/Oct/19 17:16
• Resolved: 02/Oct/19 17: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