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
http://10.10.10.10:8047/options
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