| Parameter | Type |
|---|---|
arrays | array |
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 country_id,
ARRAY_CONCAT(cities, ARRAY("my", "kind", "of", "town"))
FROM city_arrayresults:
| country_id | array_concat |
|---|---|
| UK | London, Stretford, my, kind, of, town |
| SG | Singapore, my, kind, of, town |
| US | Southlake, South San Francisco, South Brunswick, Seattle, my, kind, of, town |
| CN | Beijing, my, kind, of, town |