Dynamodb update attribute based on another

Question

I want to update an item in Dynamodb such that I can set the value of one attribute based on the value of an existing attribute in that item. For example: I have table with the following item {"id": 1, "valueone": 30}.

I want to update this item such that I can add another attribute valuetwo whose value is twice that of valueone: {"id": 1, "valueone": 30, "valuetwo": 60}

Something like this, but not sure how to represent valueone in the ExpressionAttributeValues:

table.update_item(Key={'id': 1}, UpdateExpression="set vtwo = :two * :r", ExpressionAttributeValues={':r': valueone, ':two': 2},ReturnValues="ALL_NEW"))

I can control whether valuetwo is a new attribute in the item or already exists with a dummy value (say zero).

how u acheived it in aws cli?

sar
– sar

2021-11-14 19:35:58 +00:00
Commented Nov 14, 2021 at 19:35 — sar
– sar, Commented Nov 14, 2021 at 19:35

notionquest · Accepted Answer · 2017-02-07 11:34:07Z

6

Currently, DynamoDB doesn't support " * - Multiply (or) / - Division" arithmetic operators in UpdateExpression.

It supports only addition (+) and subtraction (-) operators.

Addition:-

UpdateExpression : "SET total_new_val = total_val + :value",

Subtraction:-

UpdateExpression : "SET total_new_val = total_val - :value",

Multiplication:-

UpdateExpression : "SET total_new_val = total_val * :value",

Multiplication throws the below error:-

Unable to update item. Error JSON: {
  "message": "Invalid UpdateExpression: Syntax error; token: \"*\", near: \"tota
l_val * :value\"",
  "code": "ValidationException",
  "time": "2017-02-07T11:32:41.478Z",
  "requestId": "64f36024-7251-40af-98ee-e9cef854e94b",
  "statusCode": 400,
  "retryable": false,
  "retryDelay": 0
}

answered Feb 7, 2017 at 11:34

notionquest

39.4k6 gold badges120 silver badges112 bronze badges

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

1 Comment

user2703829 Over a year ago

Is there a way to get around this constraint by doing something like this:

table.update_item(Key={'id': 1}, UpdateExpression="set vtwo = :r", ExpressionAttributeValues={':r': valueone *2},ReturnValues="ALL_NEW"))

Collectives™ on Stack Overflow

Dynamodb update attribute based on another

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related