Cache error while connecting MongoDB using Apache Drill

Hello Team Helical,

I am using Apache Drill to connect to MongoDB but it keeps on giving “EFWService Exception” / Cache error.
Can someone help with it. Using Helical Insight 3.1 enterprise version?

Thank You.

Hi Marc,

Wherever you have installed drill navigate to the options page: direct URL would be like

When this page is opened please make sure that the below settings are applied

exec.enable_union_type : TRUE

store.mongo.all_text_mode : TRUE

store.mongo.bson.record.reader : FALSE

store.mongo.read_numbers_as_double : FALSE

In most the cases, the above settings will work.

Thank You
From Team Helical