1 Answer
- Newest
- Most votes
- Most comments
-1
The literal in the where clause is the problem. The query can't be parsed because there isn't a column named "nan".
Are you trying to check for null with "nan"?
Relevant content
- asked 2 years ago
- asked a year ago
- asked 3 months ago
- Accepted Answerasked 3 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 years ago
- What happens to Amazon RDS and Amazon Redshift queries that are running during a maintenance window?AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated 2 years ago
Sorry, not sure I understand your question. Here's a query that gives the output that I expect. The WHERE clause has nothing to do with the rest of the query in the OP or in this example.