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

SYNTAX_ERROR while running query in athena editor after triggering crawler

0

Hi folks , got the below error while running query in athena editor after triggering crawler

SYNTAX_ERROR: line 1:8: SELECT * not allowed from relation that has no columns This query ran against the "demodb" database, unless qualified by the query

Note : the table got populated in the workgroup but when I try to preview table it should run the query but got the syntax error ,

Any help would be great ,

Thanks

Topics
AnalyticsDatabase
Tags
AnalyticsExtract Transform & Load DataAmazon RedshiftAmazon AthenaDatabase
Language
English
asked 3 years ago385 views
1 Answer
0

Add permissions to describe and select the table and Database in AWS Lake Formation

AWS
answered 3 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