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

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

主題

分析

標籤

Amazon Athena

語言

English

rePost-User-1172963

已提問 1 年前檢視次數 2546 次

1 個回答

最新
最多得票
最多評論

這些答案是否有幫助？支持正確答案，以幫助社區從您的知識中受益。

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.

專家

Jose Guay

已回答 1 年前

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

相關內容