By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

COLUMN NOT FOUND, Athena Query

0

COLUMN_NOT_FOUND: line 1:40: Column 'e' cannot be resolved or requester is not authorized to access requested resources This query ran against the "logs" database, unless qualified by the query, the query i'm writing is , select * from logs where type="E"; There is a column named type , in the table

Topics
AnalyticsDatabaseManagement & Governance
Tags
Amazon AthenaDatabaseAmazon CloudWatch Logs
Language
English
AWS
Krritesh
asked 10 months ago3127 views
3 Answers
1
Accepted Answer

Try putting single quotes around the E - so

select * from logs where type='E';

HTH

Nick

AWS
Nick
answered 10 months ago
1

select * from logs where "type"='E'

profile pictureAWS
AWS_TAM
answered 10 months ago
0

Thanks a lot, I've been running in circles trying to troubleshoot this issue! Any idea about the underlying cause?

Amr Ayad
answered 8 months 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