1 Antwort
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
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.
beantwortet vor 2 Monaten
Relevanter Inhalt
- Wie erstelle ich automatisch Tabellen in Amazon Athena, um AWS-CloudTrail-Protokolle zu durchsuchen?AWS OFFICIALAktualisiert vor 3 Jahren
- AWS OFFICIALAktualisiert vor einem Jahr
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 5 Jahren
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.