Help us improve the AWS re:Post Knowledge Center by sharing your feedback in a brief survey. Your input can influence how we create and update our content to better support your AWS journey.
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 Antwort
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
0
I am assuming location datatype is varchar, so use single quote instead of "".
SELECT * FROM "default"."table84" where table84.location = 'LHR3'
beantwortet vor 3 Jahren
