Does Athena support SPLIT function?

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?

主题

分析

标签

Amazon Athena

语言

English

rePost-User-6555134

已提问 1 个月前144 查看次数

1 回答

最新
投票最多
评论最多

已接受的回答

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

专家

Giovanni Lauria

已回答 1 个月前

专家

Oleksii Bebych

已审核 1 个月前

专家

iBehr

已审核 1 个月前

Does Athena support SPLIT function?

相关内容