Query by string array in AWS DynamoDB

Question

Using Node.js, I'm querying DynamoDB for objects using a secondary index:

TableName: "Products",
IndexName: 'MerchantAndDateIndex',
KeyConditionExpression: "#creator = :creatorId",
ExpressionAttributeNames:{
    "#creator": "createdBy"
},
ExpressionAttributeValues: {
    ":creatorId": uuid
}

What I want to do is query the "Products" table with the "createdBy" hash key accepting several different possible strings, something like this:

ExpressionAttributeValues: {
    ":creatorId": ["multiple","valid","uuids","here"]
}

Where every element in my dynamic array is checked against the ID in the table when running a query.

Of course, this specific implementation returns a type mismatch, but I'm not sure how to do this correctly

Mike Dinescu · Accepted Answer · 2016-04-05 22:13:56Z

4

This is not supported by the DynamoDB API, and it would still count as multiple read requests from DynamoDB's throughput perspective.

If you need to query for multiple values you would need to implement that logic yourself in your application. Basically write a loop over the values to query and issue a query for each. That's what Dynamo would do server-side anyway.

answered Apr 5, 2016 at 22:13

Mike Dinescu

56k17 gold badges124 silver badges153 bronze badges

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

Collectives™ on Stack Overflow

Query by string array in AWS 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