Hi All, Do you know how can I ingest a column of array of JSON in Druid (i.e. as ARRAY<COMPLEX<json>>) ?

I was able to do it by adding curly braces around the array element, e.g.:

{
  "cars": [
    {
      "Name": "Ford",
      "Country": "US"
    },
    {
      "Name": "BMW",
      "Country": "Germany"
    },
    {
      "Name": "Fiat",
      "Country": "Italy"
    }
  ]
}

Yes, we did that too, but it is not ingested as a ARRAY<COMPLEX<json>> but as a COMPLEX<<json>>

There is a doc page (albeir somewhat hard to find) that clarifies which datatypes can be held in an array currently ... unfortunately the others must be ingested within a nested column: https://druid.apache.org/docs/latest/querying/arrays