How do I query DynamoDB without specifying a partition key value?

Question

I have a simple table consisting of orderID as PK and userID as SK, I found out that in dynamoDB you need to specify both PK and SK to use query. so in this case, how is it possible for me to get all the orders for userID x since I can't ignore orderID since they're the partition key of this table? another way to solve this which works but not recomended is using a scan filter, which scans the whole table then filters the result. it will eventually slow down as the table grow. I wonder how do you guys do it with this scenario?

hephalump · Accepted Answer · 2019-10-15 01:44:29Z

1

You can create a Global Secondary Index (GSI) based on userId and query based on that index.

You can read more about indexes and GSI’s in the AWS docs here.

answered Oct 15, 2019 at 1:44

hephalump

6,1741 gold badge25 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

How do I query DynamoDB without specifying a partition key value?

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