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.
SELECT country_id, ARRAY_CONCAT(cities, ARRAY("my", "kind", "of", "town")) FROM city_array
|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|