Not able to view Mongo DB collections in Metadata

Hello Helical Team,

I am using Helical Insight 4.0. I have connected to MongoDB via Apache Drill. I am not able to see the collections in the metadata. Do I need to make some changes in settings?

image

Thank You,
Jam.

Hello Jam,

You need to make certain changes in the Drill options.
Go to “Options” on the Apache Drill homepage. Set the following options:

exec.enable_union_type : TRUE

store.mongo.all_text_mode : TRUE

store.mongo.bson.record.reader : FALSE

store.mongo.read_numbers_as_double : FALSE

On the metadata page, click on Refresh icon next to the datasource connection.

image

Thank You,
Helical Insight.