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

ATHENA ERROR QUERY

0

Hi ,

I ran a query using athena and this was the error. "SYNTAX_ERROR: line 2:6: Table awsdatacatalog.crawler_waf.waf_v2_logs does not exist". Has anyone seen this before

Regards

Topics
Analytics
Tags
Amazon Athena
Language
English

asked 4 years ago758 views

1 Answer
0

Hi,

As mentioned in the error, this error generally occurs when the table that is being queried is not present in the database. Please recheck if the table : waf_v2_logs is present in the database : crawler_waf . Also since the table names are case sensitive, please check for the same and if any spelling mistakes, extra spaces etc.,

Thank you.

AWS
SUPPORT ENGINEER

answered 4 years ago

AWS
EXPERT

reviewed 4 years 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.

Relevant content