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'
답변함 일 년 전
