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

preguntada hace un año2551 visualizaciones
1 Respuesta
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
EXPERTO
respondido hace un año

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas