By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre: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
rePost-User-3077382
asked 2 years ago480 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
SaiIndira_Ch
answered 2 years ago
AWS
EXPERT
Fabrizio@AWS
reviewed 2 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.

Guidelines for Answering Questions

Relevant content