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?
demandé il y a un mois121 vues
1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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
Contenus pertinents
- demandé il y a 5 mois
- demandé il y a 2 mois
- demandé il y a 2 mois
- demandé il y a 6 mois
AWS OFFICIELA mis à jour il y a un an- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 3 ans