Apache Druid

As per Documentation: Apache Druid supports “multi-value” *string dimensions*. Multi-value *string dimensions* result from input fields that contain an array of values instead of a single value.

i’ve updated the documentation recently to better distinguish multi-value dimensions from actual array types <https://github.com/apache/druid/pull/15245>, it should be available on the docs website once druid 28 is released (actual array columns were introduced in druid 27 as part of the type-aware schema discovery stuff)

array columns do not have a `multiValueHandling` and always just store the array as it is

another thing to watch out for with `multiValueHandling` on multi-value dimensions, i believe using auto compaction will wipe out the original setting and end up using the `SORTED_ARRAY` default because the setting isn’t stored anywhere in the segment