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 年前
