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,930 points
171 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
2 answers

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

Thanks for the answer. This should be clear ...READ MORE

answered Aug 14 in AWS by athenauserz
1,437 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,900 points
1,025 views
0 votes
2 answers
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
6,914 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
50 views