ARRAY doesn't sound right:
> Arrays can be compared for exact match with = or <>:
> No other inequality operator is supported, and usage of arrays in just
about any other context (including GROUP BY) is illegal.
That doesn't line up well with how multi-value columns behave in Druid.
Multiset
Hey Calcites,
I'm hoping for some feedback on how to best handle Druid multi-value
columns in SQL.
Background: Druid has a "multi-value column" feature that lets you have
string columns with more than one value per row. Details and examples of
how this works are here: