Query NaN double values in Athena?

0 votes

I need to query something like in AWS Athena

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

How can I do that?

Jan 16 in AWS by Anjali
• 2,900 points
93 views

1 answer to this question.

0 votes

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.

answered Jan 16 by farhan

Related Questions In AWS

+1 vote
1 answer
0 votes
1 answer

How to skip headers when reading a CSV file in S3 and creating a table in AWS Athena?

This is a known deficiency. The best ...READ MORE

answered Sep 4, 2018 in AWS by Archana
• 4,090 points
746 views
0 votes
1 answer

Pivot rows into columns in AWS Athena?

You can use the following method :- It ...READ MORE

answered Oct 29, 2018 in AWS by Priyaj
• 56,160 points
591 views
0 votes
1 answer

How to store Amazon Athena Query Results into new Table?

This is not supported by Athena as Amazon ...READ MORE

answered Jan 16 in AWS by heena
277 views
0 votes
1 answer
+1 vote
2 answers
+1 vote
1 answer

Accessing query parameter in Lambda with Python

Have you gone through the mapping template ...READ MORE

answered Dec 5, 2018 in AWS by bugseeker
2,841 views
0 votes
1 answer

Is it possible to create view in Athena?

AWS Athena does not support creating any ...READ MORE

answered Jan 16 in AWS by Zullu
39 views