By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

FUNCTION_NOT_FOUND: line 1:8: Function 'dateadd' not registered

0

I am trying to use the DATEADD function, but I encountered an issue. I am querying an S3 database using Athena. Do I need to store the data in Redshift to use the DATEADD function? Any guidance would be greatly appreciated. Thank you.

Topics
AnalyticsStorage
Tags
Amazon AthenaAmazon RedshiftS3 Select
Language
English
Kaitlyn
asked 6 months ago543 views
1 Answer
0

If you're using the latest version of the Athena query engine, it uses Trino underneath, and the function is date_add (with an underscore): https://trino.io/docs/current/functions/datetime.html#date_add

You'll find links to all the functions supported by Athena's different versions in documentation: https://docs.aws.amazon.com/athena/latest/ug/functions.html

EXPERT
Leo K
answered 6 months ago
profile picture
EXPERT
Osvaldo Marte
reviewed 6 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content