By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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

Topics
AnalyticsDatabase
Tags
Amazon AthenaDatabase
Language
English
rePost-User-1127734
asked a year ago313 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
Debasis Mitra AWS
answered a year 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.

Guidelines for Answering Questions

Relevant content