I need to query something like in AWS Athena
SELECT * FROM "table"."demo1" where content = 'NaN' limit 10
How can I do that?
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.
You should make your backend functions to ...READ MORE
This is a known deficiency. The best ...READ MORE
You can use the following method :-
It ...READ MORE
This is not supported by Athena as Amazon ...READ MORE
Follow the guide given here in aws ...READ MORE
Check if the FTP ports are enabled ...READ MORE
To connect to EC2 instance using Filezilla, ...READ MORE
AWS ElastiCache APIs don't expose any abstraction ...READ MORE
Have you gone through the mapping template ...READ MORE
AWS Athena does not support creating any ...READ MORE