Does Athena support SPLIT function?
0
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?
asked 2 months ago158 views
1 Answer
- Newest
- Most votes
- Most comments
2
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
Relevant content
- asked 7 years ago
- asked 6 years ago
- Accepted Answerasked a year ago
- asked a year ago
AWS OFFICIALUpdated a year ago- AWS OFFICIALUpdated 4 months ago
- AWS OFFICIALUpdated 2 months ago
