Tag: amazon-s3-select

I’m trying to figure out how to use AWS S3 Select, everything seems pretty straight forward, but the following query just doesn’t want to work: select r.value from S3Object[*].outputs.private_subnets …

With mysql the following code: would pull the 5th through 10th rows of the table. What is the equivalent for doing this through the SQL engine in S3 select (PrestoDB I believe)? Is there a rownumber constructor or operator that works with S3 select? Answer The S3 Select documentation is at: SQL Reference for Amazon S3 Select and Amazon Glacier