En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

COLUMN_NOT_FOUND: line 37Column 'aggregation_type' cannot be resolved or requester is not authorized to access requested resources

1

The following query was run on athena. What is wrong?

query: SELECT * FROM number_of_works_per_search_conditions WHERE aggregation_type = 'n10';

error_message: COLUMN_NOT_FOUND: line 37Column 'aggregation_type' cannot be resolved or requester is not authorized to access requested resources

Sujets
Analytique
Balises
Amazon Athena
Langue
English
rePost-User-1172963
demandé il y a un an2551 vues
1 réponse
0

Hi there!

It means that the column aggregation_type doesn't exists in the table number_of_works_per_search_conditions. Please ensure the column exists and/or is spelled correctly in the query.

I hope this helps.

profile pictureAWS
EXPERT
Jose Guay
répondu il y a un an

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