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 14 days ago93 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 month ago- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 3 months ago
