AWS DynamoDB Scan For Value in Array

Question

I am relatively new to AWS and DynamoDB. I have created a table with an array property. Is it possible for me to scan the array and return objects that contain a certain string?

rohan013 · Accepted Answer · 2016-04-05 06:19:04Z

0

Yes, you can do this. But keep in mind that a scan is an expensive operation which consumes a lot more read capacity units than a query operation. It would be better if you create a primary key on the column and do a query. You can find some examples here:

http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/QueryScanORMModelExample.html

answered Apr 5, 2016 at 6:19

rohan013

1991 gold badge1 silver badge14 bronze badges

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

2 Comments

mathlete Over a year ago

So I can query an array value? Lets say my Table named Photos has a list property users. Can I query all Objects that contain a certain user's id within the list?

Mike Dinescu Over a year ago

@csweeney285 - You could use a filter but it won't be efficient. How many users does a "photo" usually have?

Collectives™ on Stack Overflow

AWS DynamoDB Scan For Value in Array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related