[athena] split string into array

string to array

SELECT regexp_split('abcd', '')

array to string

SELECT array_join(regexp_split('abcd', ''), ' ')