Skip directly to the demo: 0:26
For more details see the Knowledge Center article with this video: https://aws.amazon.com/premiumsupport/knowledge-center/athena-syntax-function-not-registered/
Harsh shows you how to handle the error “SYNTAX_ERROR: line 1:8:Function -function_name- not registered”.
Publisher: Amazon Web Services
You can watch this video also at the source.