En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
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?

Sujets
Analytique
Balises
Amazon Athena
Langue
English
rePost-User-2540619
demandé il y a 2 mois312 vues
2 réponses
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
répondu il y a 2 mois
0

You can also refer this re:post answer:

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

profile pictureAWS
INGÉNIEUR EN ASSISTANCE TECHNIQUE
Shahrukh_K
répondu il y a 2 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents