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-5b4fe81f3de6
1回答
- 新しい順
- 投票が多い順
- コメントが多い順
0
I am assuming location datatype is varchar, so use single quote instead of "".
SELECT * FROM "default"."table84" where table84.location = 'LHR3'
回答済み 1年前
