How to query NaN double values in Athena

Question

I need to query something like in AWS Athena

SELECT * FROM "hl"."may" where fqk = 'NaN' limit 10

Answer 1

Use is_nan:

select is_nan(nan());

 _col0
-------
 true