Hi Charles, This kind of data-specific setting really should be associated with a schema so that it is DB-specific, but consistent across queries. That is almost the definition of a schema...
In the future, once the recently-added schema system is more widely used, one might be able to set this as a property of a table with ALTER SCHEMA. However, the Mongo plugin does not yet support that functionality. Since we don't have a way to do that, there is an obscure hack that can be used. In the drill-override.conf file, one can change the default value for system/session variables. drill.exec.options: { store.mongo.read_numbers_as_double: true } This is not a documented feature, but it can be handy in unusual situations such as this. Caveat: I've not tried this, but it should work as we have done something similar in other obscure cases. Perhaps someone can try it. Thanks, - Paul On Thursday, September 26, 2019, 5:56:43 AM PDT, Charles Givre <cgi...@gmail.com> wrote: Hello all, Is it possible to set store.mongo.read_numbers_as_double in the storage plugin configuration, or someplace else so this is set permanently? Thanks, -- C