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

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

     [ https://issues.apache.org/jira/browse/DRILL-7384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Richard Powers closed DRILL-7384.
---------------------------------
    Resolution: Not A Bug

We were able to determine this was an issue where the mongodb database names need to be all lowercase for the tables to appear in Drill.  Length not the issue.  

> 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)