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