Apache Druid

Could you provide examples of your queries? If you are doing count distinct, data sketches on `s_id` may be useful

is s_id always a string? can you re-import as string using the index enable and make sure the query planner knows about it eg:
`cast (s_id as varchar) IN (?, ...`) ` for example

<@U04CGQ1P68Z> nothing fancy, simple selects and aggregations

<@U038XPQFJHM> That’s not done automatically? Yes s_id is always a string!

<@U032H7AUY74> what you are referencing to? if you don't defined any column on the ingestion, yes, it's the default for dimensions be imported as string with the bitmap index created `createBitmapIndex` default is true for string, long, float, json and double it's false bc id do not support any indexing aside the segment/time

but what I discovery is that is best to help calcite when writing the queries to cast the dimension to string, just to not depend on the heuristics of planning.