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
<[email protected]> 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
