How can we dynamically Sorting & Grouping data from DynamoDB

Question

I am new to DynamoDB and i see that data sorting done by the sort key value. Is there a way how we can sort data for any attribute with in an item irrespective of sortkey. And i am using nodejs with DynamoDB for my project.

May i know how can i achieve the same.

Thank you

Derrops · Accepted Answer · 2020-04-20 10:48:38Z

1

So long as you don't need to re-partition your data, the first way to do this is to create a LSI (local secondary index) with your new sort key.

But unlike SQL you can't do ad hoc queries, when you design how you are setting up your table you already have to know much about what queries and transactions you will have, in general you shouldn't need to make an LSI every time you want to search, I recommend watching this.

answered Apr 20, 2020 at 10:48

Derrops

8,2077 gold badges39 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can we dynamically Sorting & Grouping data from DynamoDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related