Limit statement in PartiQL - Get Last row

Question

How do I use Limit in PartiQL? What I need is the last 3 rows from the table of Amazon QLDB which uses PartiQL Syntax for querying. Something like SELECT * FROM Accounts where AddedBy = 'admin@demo.com' LIMIT 3

score 2 · Accepted Answer · edited Mar 29 '21 at 16:59

2

LIMIT isn't currently supported by Amazon QLDB. Here's a more detailed answer to your question Pagination in QLDB.

edited Mar 29 '21 at 16:59

Dharman

30,962
25
85
135

answered Mar 29 '21 at 16:54

Jimmy

116
1
3

score 1 · Answer 2 · answered Aug 11 '22 at 10:57

1

Limit is now supported in the ExecuteStatement command. See the AWS documentation for sending it as part of the request.

Here is the announcement from March 8, 2022.

answered Aug 11 '22 at 10:57

What Would Be Cool

6,204
5
45
42

score 0 · Answer 3 · answered Nov 09 '22 at 08:19

0

This is the same issue I faced. So I write a project to extend PartiQL capbilities. Please refer here: https://github.com/passren/PyDynamoDB

answered Nov 09 '22 at 08:19

Peng Ren

1

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Nov 12 '22 at 21:32

score 0 · Answer 4 · answered Jul 13 '23 at 18:43

LIMIT works differently than I thought it would. LIMIT means you want to limit your search to that number of rows. So LIMIT=10 means you are only going to query a maximum of 10 rows.

And it does not go in the statement string, but instead in the method call. For example:

import boto3

stmt = "SELECT * FROM \"my-table\" WHERE my_key = \'some_key\'"
dynamodb = boto3.client('dynamodb', region_name='us-east-1')
resp = dynamodb.execute_statement(Statement=stmt, Limit=10)
print(resp['Items'])

Here is the documentation: https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_ExecuteStatement.html#API_ExecuteStatement_RequestSyntax

Limit statement in PartiQL - Get Last row

4 Answers4