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 Resposta
- Mais recentes
- Mais votos
- Mais comentários
0
I am assuming location datatype is varchar, so use single quote instead of "".
SELECT * FROM "default"."table84" where table84.location = 'LHR3'
respondido há 3 anos
Conteúdo relevante
- feita há 8 meses
- feita há 3 meses
- feita há 10 meses
