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

1개 답변
0

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

profile pictureAWS
mercy
답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인