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

AWS
已提問 1 年前檢視次數 3349 次
3 個答案
1
已接受的答案

Try putting single quotes around the E - so

select * from logs where type='E';

HTH

Nick

AWS
Nick
已回答 1 年前
1

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

profile pictureAWS
AWS_TAM
已回答 1 年前
0

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

已回答 9 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南