This message was deleted.

exploding a json array usually means creating a lot of columns (often empty as you have to create for the largest anticipated array size). Instead use the nested columns feature to store and query the array https://druid.apache.org/docs/latest/querying/nested-columns.html

We are also adding support for

UNNEST

that can be used to explode an array. https://github.com/apache/druid/pull/13268 - Right now, only available for native queries.