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

["Richard Powers (Jira)" <ji...@apache.org>]

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)