By using AWS re:Post, you agree to the Terms of Use

sortkey in DynamoDB query with pagination limit

0

I have a doubt that when we use sortkey in DynamoDB query with pagination limit(example limit=10), whether it gives a sorted list of 10 items of an entire dynamoDB table or just gives the queried items sort list?

If it only gives sort list of queried items how to get the sort list of total dynamoDB table items? for example there is a post table & post has likes how to get the post with highest likes in the table with list of posts in descending order?

1 Answer
5
Accepted Answer

Its not possible to obtain order over all keys in a DynamoDB table. The only possible approach would be to Scan the entire table and implement your sorting on the client side.

You could of course use DynamoDB Streams and keep pointers to the top 10 liked posts, if that is something your application intends to show. Then you could simply call BatchGetItems with the 10 listed items.

Another option would be to create a GSI with a single attribute as the PK, for example POSTS and the number of likes as the SK.

PKSKOther
POSTS7Data
POSTS9Data
POSTS11Data

Then you could simply Query your GSI with the key POSTS and use ScanIndexForward=False, Limit=10.

Be warned that this is not a scalable solution as your GSI key is a single value. This will limit your tables writes to approximately 1000WCU per second. That's a decision you can make depending on your throughput needs.

profile picture
answered 25 days ago
EXPERT
reviewed 25 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions