1 Answer
- Newest
- Most votes
- Most comments
0
【以下的回答经过翻译处理】 我在Athena V2中成功复现了这个问题。regexp_count是在V3中添加支持的函数之一。请根据以下说明将您的Athena版本更改为V3 - https://docs.aws.amazon.com/athena/latest/ug/engine-versions-changing.html
当我改回V3后,我能够执行下面的查询。
SELECT regexp_count('1a 2b 14m', '\s*[a-z]+\s*');
Relevant content
- Accepted Answerasked 6 months ago
- asked a year ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 months ago