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?
질문됨 2달 전157회 조회
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 공식업데이트됨 2년 전
- AWS 공식업데이트됨 일 년 전
