[jira] [Commented] (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:comment-tabpanel&focusedCommentId=16937162#comment-16937162 ] 

Richard Powers commented on DRILL-7384:
---------------------------------------

Curious if any Drill folk have any tips for researching when tables do not appear in a show tables command. 

I have issues on another server as well, on an existing mongo database that is less than 10 characters in character length.  I believe the mongodb is sharded, with a primary and secondary on the same machine.  I'm still researching if my issue there is something to do with how drill interacts with a sharded db, but when i connect to either the primary or secondary, I see the same behavior.  I can see the databases, but I get nothing back from show tables command.  There definitely is data in the collections, and authentication does not appear to be an issue from what i'm seeing, as i'm able to connect as both the authenticated user and anonymous in mongo and query the collections without 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)