Hi All, Is there any way to not index a String fie...
# general
a
Hi All, Is there any way to not index a String field when ingesting using MSQ? We have a few fields which have long string values but they will not be used for filtering. They are only needed in the query response. For such fields, is there a way to specify that they should only be stored but not indexed? Thanks, AR.
g
not currently, although my hope is that this and any other dimension / indexing parameters can be specified in the future using the catalog (a nascent feature)
the idea would be you would specify this at a table level rather than in each job
a
A setting at table level would be perfect. But since Druid doesn't have the concept of a CREATE TABLE, I am not sure how to specify this if it is not included in the ingestion spec. Thanks, AR.
g
there isn't a way to do it today, but as the catalog feature is developed, you'd be able to specify it at the catalog (which is table-level)
so, this is more of a stay-tuned thing
a
I was just wondering aloud how/when the catalog would be created for a table since there is no DDL to create a table. But I will watch out for this. Definitely something that will help with data size management. Thank you.