Not able to view Mongo Collections in some databases

Database Support
, ,
#1

Hello Helical Insight,

I am using Helical Insight 4.0. I am connecting to my MongoDB using Apache Drill 1.17. I am able to view the collections in some of the databases. However, for some other databases, I am not able to view the collections. The database names for which I am not able to view the collections are:

testOvenData, view_RainConfig, long-data-Support

Is there any particular reason?

Thank You,
Jam.

#2

Hello Jam,

Apache Drill versions lesser than 1.19 do not support Mongo database names with upper case letters. This bug has been resolved in version 1.19 of Apache Drill.

Please install and start Apache Drill 1.19 or higher and then connect to your MongoDB instance. You will be able to view the collections inside databases with upper case letters as well.

image

image

Thank You,
Helical Insight.