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
Language
English
asked 2 years ago5.7K views
3 Answers
- Newest
- Most votes
- Most comments
1
Try putting single quotes around the E - so
select * from logs where type='E';
HTH
Nick
answered 2 years ago
0
Thanks a lot, I've been running in circles trying to troubleshoot this issue! Any idea about the underlying cause?
answered 2 years ago
Relevant content
AWS OFFICIALUpdated a year ago- AWS OFFICIALUpdated a year ago
