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

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?

主題

分析

標籤

Amazon Athena

語言

English

rePost-User-2540619

已提問 2 個月前檢視次數 309 次

2 個答案

最新
最多得票
最多評論

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.

Ananth Tirumanur

已回答 2 個月前

You can also refer this re:post answer:

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

支援工程師

Shahrukh_K

已回答 2 個月前

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

相關內容