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
2,818 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

How to Use Amazon AWS Credentials to Access/Query Tables in AWS RDS Instance through Mobile App

You should make your backend functions to ...READ MORE

answered Aug 28, 2018 in AWS by Priyaj
• 58,020 points
1,324 views
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
11,874 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,020 points
8,275 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
51,093 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
1,463 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