Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7384

Mongodb database name character length limit in order for Drill to see tables in it?

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

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

      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

       

        Attachments

        1. sqlline from 9-24 length check.log
          301 kB
          Richard Powers
        2. sqlline_queries.log
          106 kB
          Richard Powers
        3. show tables.JPG
          95 kB
          Richard Powers
        4. show databases output.JPG
          90 kB
          Richard Powers

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              rpow Richard Powers

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment