Scan through all the sort keys of a particular hash in DynamoDB

Question

For example, I have a table with userID as hash key. The same table contains commentID as range key. I want to find all entries related to a specific userID. Using java SDK, what is the most efficient way to retrieve all items that has a particular hash key.

SOLUTION
Here's how I did it:

QuerySpec spec = new QuerySpec()
                .withKeyConditionExpression("userID = :v_id")
                .withValueMap(new ValueMap()
                    .withString(":v_id", user.getId()));

ItemCollection<QueryOutcome> items = table.query(spec);

Iterator<Item> iterator = items.iterator();
Item item = null;
while (iterator.hasNext()) {
      item = iterator.next();
      System.out.println(item.toJSONPretty());
}

Just use query or getItem to get all the values of your hash key..! — Harshal Bulsara
– Harshal Bulsara, Commented Mar 30, 2016 at 12:49

Chen Harel · Accepted Answer · 2016-03-30 15:28:26Z

1

The way to "scan" a hash key in DynamoDB is called Query. Use this API either with the DynamoDBMapper or Document API to fetch all items for a specific hash.

answered Mar 30, 2016 at 15:28

Chen Harel

10.1k5 gold badges48 silver badges60 bronze badges

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

Collectives™ on Stack Overflow

Scan through all the sort keys of a particular hash in 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