This message was deleted.

Not sure, but maybe nested columns and unnest would help. There are also new SQL operators for json data. But I'm not sure how that all fits together.

if the data is already ingested using arrays, usually you just need to group by it this series is very good: https://blog.hellmar-becker.de/2021/10/03/multivalue-dimensions-in-apache-druid-part-4/ Be sure to check part 1..3

Use native json columns

@Bharat Thakur did you get any solution for this? Thinking of exploding array of json in multiple rows using UNNEST and then using SQL JSON Functions But not sure if this would work