By using AWS re:Post, you agree to the AWS re:Post Terms of Use
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

Topics
Analytics
Tags
Amazon Athena
Language
English
rePost-User-1172963
asked a year ago2464 views
1 Answer
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
answered a year 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