AThena single vs. double quotes
0
Why does this query fail in Athena:
`SELECT COUNT (title) FROM "s3_library_data" WHERE s3_library_data.genre = "Science Fiction"`
but this one works?
`SELECT COUNT (title) FROM "s3_library_data" WHERE s3_library_data.genre = 'Science Fiction'`
demandé il y a 2 mois278 vues
1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
The single and double quote are used for different things.
-
Single quotes are used to denote string literals. For example, if you want to search for a specific string value in a column, you would enclose the string in single quotes, like 'search string'.
-
Double quotes are used to escape reserved keywords that are being used as column or table names.
In your first query you are looking for a literal value - Science Fiction. So you should use single quotes, not double quotes.
répondu il y a 2 mois
Contenus pertinents
- demandé il y a un an
- demandé il y a 2 mois
- demandé il y a un an
- demandé il y a 2 mois
AWS OFFICIELA mis à jour il y a un an- AWS OFFICIELA mis à jour il y a 3 ans
Thank you! My issue is the query is being generated by an LLM and I have been trying to "prompt it to use single quotes.