sqlamazon-web-servicesamazon-s3amazon-s3-select

Querying rows by index in S3 Select

With mysql the following code:

SELECT * from TABLE limit 5, 10

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?

Solution

  • The S3 Select documentation is at: SQL Reference for Amazon S3 Select and Amazon Glacier Select - Amazon Glacier

    The LIMIT clause is documented as:

    LIMIT number

    The LIMIT clause limits the number of records that you want the query to return based on number.

    So, not available.