query with multiple values for same attribute in dynamodb nodejs

Question

Is there any way to query a dynamodb table with multiple values for a single attribute?

      TableName: "sdfdsgfdg"
      IndexName: 'username-category-index',
      KeyConditions: {
        "username": {
          "AttributeValueList": { "S": "[email protected]" }
          ,
          "ComparisonOperator": "EQ"
        },
        "username": {
          "AttributeValueList": { "S": "[email protected]" }
          ,
          "ComparisonOperator": "EQ"
        },
        "category": {
          "AttributeValueList": { "S": "Coupon" }
          ,
          "ComparisonOperator": "EQ"
        }
      }

notionquest · Accepted Answer · 2017-10-10 11:54:39Z

2

BachGetItem API can be used to get multiple items from DynamoDB table. However, it can't be used in your use case as you are getting the data from index.

The BatchGetItem operation returns the attributes of one or more items from one or more tables. You identify requested items by primary key.

In API perspective, there is no other solution. You may need to look at data modelling perspective and design the table/index to satisfy your Query Access Pattern (QAP).

Also, please note that querying the index multiple times with partition key values (i.e. some small number) wouldn't impact the performance as long as it is handful of items.

answered Oct 10, 2017 at 11:54

notionquest

39.4k6 gold badges120 silver badges111 bronze badges

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

Collectives™ on Stack Overflow

query with multiple values for same attribute in dynamodb nodejs

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