Query using only partition key in DynamoDB

Question

I am trying to query on my table using only the partition key and ignoring the sort key but I get no items.

My global secondary index looks like this:

And my table looks like this:

And this is my query:

const params = {
  ExpressionAttributeValues: {
    ':app': 'app',
  },
  IndexName: 'glc-development-gsi1',
  KeyConditionExpression: 'sk = :app',
  TableName: this.tableName,
};
return new Promise((resolve, reject) => {
  this.client.query(params, (err, data) => {
    console.log(data);
    if (err) {
      reject(err);
    } else {
      resolve(data);
    }
  });
});

According to all the documentation I've read and the other questions on here, this should work and I can't understand why it doesn't. The scan from my index is also empty.

Shouldn't params be like this: ``` const params = { ExpressionAttributeValues: { ":app": { S: "app" } }, IndexName: 'glc-development-gsi1', KeyConditionExpression: 'sk = :app', TableName: this.tableName, }; ``` — dDarkLORD
– dDarkLORD, Commented May 28, 2019 at 2:47

Raphael Valois · Accepted Answer · 2019-05-29 19:41:04Z

2

Finally found my solution. DynamoDB stores data in indexes only when both the partition key and the sort key are defined, so my index was empty all the time. The query was fine.

answered May 29, 2019 at 19:41

Raphael Valois

1754 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Query using only partition key 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