By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre: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
rePost-User-2540619
asked 2 months ago261 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.

profile picture
Ananth Tirumanur
answered 2 months ago
0

You can also refer this re:post answer:

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

profile pictureAWS
SUPPORT ENGINEER
Shahrukh_K
answered 2 months 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