Convert Strings to Array


#1

Is there a way to convert Strings to Arrays in Athena? So that I can pass a List as String as a parameter and use the IN Operator to prove if a column is one of the list values.


#2

This worked for me:

SELECT “virtualdevice”
FROM (
SELECT split(’{{devices}}’, ‘,’) AS items
),
UNNEST (items) as t(virtualdevice)