Hello Team,
I am trying to connect to Mongo using Apache drill option of Helical Insight. I have made the configurations, however we are getting the below error
“There was a problem in serving the request. The cause is EfwServiceException: Could not obtain cache.
com.helicalinsight.efw.exceptions.EfwServiceException: Could not obtain cache”
What could be the problem?
Thank You
Vetegoc
Hello Vetegoc,
This error might be happening because of Mongo settings at Apache Drill level. Wherever you have installed drill navigate to the options page: direct URL would be something like this
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
Once done refresh/restart and try once again by connecting from Helical Insight end.
Thank You
Team Helical.