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?
질문됨 한 달 전122회 조회
1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
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
관련 콘텐츠
AWS 공식업데이트됨 일 년 전- AWS 공식업데이트됨 일 년 전
