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

Error: COLUMN_NOT_FOUND: line 1:8: SELECT * not allowed from relation that has no columns

0

Hello, I have an Excel file stored in S3 bucket. After running a crawler and creating a table I'm trying to see the table in Athena and getting this error: COLUMN_NOT_FOUND: line 1:8: SELECT * not allowed from relation that has no columns.

How can I solve it?

Topics
Analytics
Tags
Amazon Athena
Language
English
asked 2 years ago3.9K views
2 Answers
1

It seems like the user does not have sufficient permissions.

Are you using Lake Formation? If so, please check if SELECT access has been granted on the table level and 'Describe' has been granted at the database level.

answered 2 years ago
0

You can also refer this re:post answer:

https://repost.aws/questions/QUQ712jy2XTX247bNBBU6WDg/athena-query-does-not-see-any-columns

AWS
SUPPORT ENGINEER
answered 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.

Relevant content