Query NaN double values in Athena

Question

I need to query something like in AWS Athena

SELECT * FROM "table"."demo1" where content = 'NaN' limit 10

How can I do that?

Answer 1

Try using the following command to query NaN.

SELECT * FROM "table"."demo1" where cast(content as VARCHAR(4)) = 'NaN' limit 10

This will help you get the query done.