This message was deleted.
# generals
Slackbot
12/19/2023, 9:45 AMThis message was deleted.
s
Sergio Ferragut
12/19/2023, 4:41 PMWhat does the JSON array look like? What are the elements? JSON arrays of primitives are supported at this point (Druid 28.0) as ARRAYs. You can use UNNEST at query time (and I think also at SQL ingestion time) to expand it into rows. There is work underway to also be able to use UNNEST on ARRAYs of JSON objects.
Sergio Ferragut
12/19/2023, 5:22 PMAlso, auto discovery of nested columns will convert individual JSON object fields into columns automatically.
v
Vinicius Rodrigues
12/21/2023, 2:15 PMThanks, Sergio!!