Skip to content

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

asked 3 years ago750 views
1 Answer
0

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

SELECT * FROM "default"."table84" where table84.location = 'LHR3'
AWS
answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.