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 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则

相关内容