Querying DynamoDB with node.js between values

Question

Querying dynamoDB table with node.js. The DynamoDB table has key of Timestamp, represented by an integer. In this case, I left :timestampStart as 1 and timestampEnd as 10 as an example.

    var params = {
        TableName: "Table2",
        KeyConditionExpression:"Timestamp = :ts BETWEEN :timestampStart AND :timestampEnd",
        ExpressionAttributeValues: {
            ":ts":"Timestamp",
            ":timestampStart": 1,
            ":timestampEnd": 10
        }
    };

The :ts is not correct, I can see this. I want to return any rows found with a Timestamp value between timestampStart and timestampEnd.

Error message:

"errorMessage": "Invalid KeyConditionExpression: Syntax error; token: \"BETWEEN\", near: \":ts BETWEEN :timestampStart\"",

Vikas Sardana · Accepted Answer · 2021-05-21 12:40:54Z

13

If Timestamp is the partition key and not the sort key. Then, you have two problems:

In a Query operation, you cannot perform a comparison test (<, >, BETWEEN, ...) on the partition key. The condition must perform an equality test (=) on a single partition key value and, optionally, one of several comparison tests on a single sort key value. For example:

KeyConditionExpression: 'HashKey = :hkey and RangeKey > :rkey'
You have a syntax error in your KeyConditionExpression, obviously. Keep in mind that Timestamp is a reserved word in DynamoDB. So, you'll have to use ExpressionAttributeNames for that:

(Assuming you have an Id partition key and Timestamp sort key)

var params = {
   TableName: "Table2",
   KeyConditionExpression: "Id = :id AND #DocTimestamp BETWEEN :start AND :end",
   ExpressionAttributeNames: {
     '#DocTimestamp': 'Timestamp'
   },
   ExpressionAttributeValues: {
     ":id": "SOME VALUE",
     ":start": 1,
     ":end": 10
   }
 };

edited May 21, 2021 at 12:40

Vikas Sardana

1,6432 gold badges22 silver badges39 bronze badges

answered Feb 20, 2017 at 23:51

Khalid T.

10.6k5 gold badges51 silver badges58 bronze badges

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

2 Comments

Iorek Over a year ago

If I have Timestamp as the partition key, would creating a secondary global index with the Timestamp as the sort key overcome the problems here? I could then create an equality statement

Iorek Over a year ago

Solved with the addition of a secondary index

Collectives™ on Stack Overflow

Querying DynamoDB with node.js between values

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