Does Athena support SPLIT function?

Question

Hi all,
 Does anyone know if Athena supports a SPLIT function? Are the Athena functions available limited to only those on this page https://docs.aws.amazon.com/athena/latest/ug/functions.html or do they include the functions found in the Trino documentation?

If it is not available, is there any suggested workaround for split function replacements?

Accepted Answer

Athena does not have a built-in SPLIT function. 
For example, to split a string on commas you could use:
```
SELECT REGEXP_REPLACE('a,b,c', '[^,]*,([^,]*),?', '\1') 
FROM table;
```
Please find the list of all the functions Athena supports here: https://docs.aws.amazon.com/athena/latest/ug/functions.html

Does Athena support SPLIT function?

Contenuto pertinente