Skip to content

DynamoDb enhanced client: support UpdateExpressions in single-request update #5554

Open

Description

@IDUN-BogdanPi

Describe the feature

Enhance the UpdateItemEnhancedRequest to support update expressions.
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Expressions.UpdateExpressions.html

I see this feature is partially implemented: https://aws.amazon.com/blogs/developer/using-atomic-counters-in-the-enhanced-dynamodb-aws-sdk-for-java-2-x-client/

but as it is also stated in the article:

Update expressions in the extensions are applicable for use cases where you want to do the same thing with an attribute every time that you call the database, such as atomic counters. However, if you need a one-time effect for a single request, then leveraging the extension framework isn’t useful.

Use Case

I need to atomically increment a numeric value in a table column by different amounts on demand, without first reading the current value.

Consider this table:

@Getter
@Setter
@DynamoDbBean
public class Recording {

    private String id;
    private Long totalRecordingSeconds;

I need to be able to update and increment the value of totalRecordingSeconds with different durations: +30, + 20 ... etc, without reading the current value.

It would be helpful to be able to perform something like:

        String updateExpression = "SET totalRecordingSeconds = if_not_exists(totalRecordingSeconds, :zero) + :increment";
        
        Map<String, AttributeValue> expressionValues = new HashMap<>();
        expressionValues.put(":increment", AttributeValue.builder().n(Long.toString(incrementBy)).build());
        expressionValues.put(":zero", AttributeValue.builder().n("0").build());

        Expression expression = Expression.builder()
                .expression(updateExpression)
                .expressionValues(expressionValues)
                .build();


        UpdateItemEnhancedRequest<Recording> request = UpdateItemEnhancedRequest.builder(Recording.class)
                .key(k -> k.partitionValue(id))  
                .updateExpression(expression)   
                .build();


        table.updateItem(request);

Proposed Solution

No response

Other Information

No response

Acknowledgements

  • I may be able to implement this feature request
  • This feature might incur a breaking change

AWS Java SDK version used

2.21.37

JDK version used

22.0.2

Operating System and version

MacOS Sonoma 14.5

Activity

  1. debora-ito commented on Sep 4, 2024

    @debora-ito
    Member

    PR #3836 started working on this but it lost traction. I'll see if I can get it moving again.

  2. added
    p2This is a standard priority issue
    and removed
    needs-triageThis issue or PR still needs to be triaged.
    on Sep 4, 2024
  3. IDUN-BogdanPi commented on Sep 6, 2024

    @IDUN-BogdanPi
    Author

    Much appreciated!

  4. evg-tso commented on Jan 1, 2025

    @evg-tso

    Hi @debora-ito, my team would also like to utilize the features in this PR.
    Did you get the chance to review #3836?
    I see the PR hasn't been reviewed by the team, I'm not sure if this means it's abandoned or it should be refactored.

  5. Ayush-10 commented on Aug 18, 2025

    @Ayush-10

    Hi @debora-ito, can you please help here with the current status of the above PR (#3836) ?
    My team would really appreciate the above feature being implemented as currently we are utilizing one of the available methods to do the same which is not quite efficient & scalable & would hence want to move away from it as soon as possible.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    dynamodb-enhancedfeature-requestA feature should be added or improved.p2This is a standard priority issue

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions