S3 select aws console

Asked May 12 '23 at 16:41

Active May 12 '23 at 17:58

Viewed 22 times

I have the following data in a file:

{"new_date":"2022-06-09","code":34,"value":33,"id":18}
{"new_date":"2022-06-09","code":34,"value":36,"id":19}
{"new_date":"2022-06-09","code":34,"value":35,"id":15}

In AWS console im trying to execute the following code, is it possible to do between date comparison in s3 select?

SELECT s.* FROM s3object s WHERE CAST(new_date, 'yyyy-mm-dd') >= '2022-06-09' limit 5

but i cant seem to get this work, from the docs i have found that there is a BETWEEN available, but how does that work?

edited May 12 '23 at 17:58

asked May 12 '23 at 16:41

user1555190

2,803
8
47
80

You can try this way: SELECT s.* FROM s3object s WHERE s.new_date >= '2022-06-09' LIMIT 5 – Josue Vargas May 12 '23 at 17:54

S3 select aws console

0 Answers0