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
Thanks for the answer.
This should be clear ...READ MORE
You can use the following method :-
It ...READ MORE
You can use CTAS - as Amazon ...READ MORE
Here for the above mentioned IAM user ...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
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.