querying data from aws athena using where clause

0

Column 'lhr3' cannot be resolved This query ran against the "default" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: 868f19df-351c-4c03-9c67-5b4fe81f3de6Enter image description here
Enter image description here

已提問 1 年前檢視次數 337 次
1 個回答
0

I am assuming location datatype is varchar, so use single quote instead of "".

SELECT * FROM "default"."table84" where table84.location = 'LHR3'
AWS
已回答 1 年前

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

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

回答問題指南