ARRAY

The ARRAY command allows you to create an array from a group of values. The values can be field values, calculated values, literals, or a combination thereof. The only requirement is that all the values are of the same data type.

Parameter	Type
`args`	any

Returns: array

Example

Arrays are currently only supported on tables from a live connection to an Athena database. You cannot use them with other databases or with tables derived from an Athena database.

query:

SELECT ARRAY(country_id, "kind", "of", "town")
  FROM city_array

results:

array
UK, kind, of, town
SG, kind, of, town
US, kind, of, town
CN, kind, of, town
CH, kind, of, town
BR, kind, of, town