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 17, 2019 in AWS by Anjali
• 2,950 points
1,419 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 17, 2019 by farhan

Related Questions In AWS

+2 votes
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, 2019 in AWS by athenauserz
9,200 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
• 58,100 points
5,650 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
41,633 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, 2019 in AWS by Zullu
723 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP