By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Updating a existing Dynamodb Item to change single attribute of it with just partition and sort key inputs in query

0

Hi All,

is it possible to update a single attributes of a Dynamodb Item with out overriding the existing details of other attributes ??

Example : attributes in a dynamo item -> Employee_Id(partition key), Employee_Department(sort key), Employee_Address, Employee_experience

and want to update only employee_experience with only providing Employee_Department (sort key) in query

Currently I am using the following query to update the Employee_experience however Employedd_address is getting overriden to empty after executing this query

Query ::

QueryEnhancedRequest.builder() .queryConditional(QueryConditional.keyEqualTo(Key.builder().partitionValue(Employee_Department).build())) .exclusiveStartKey(startKey) .scanIndexForward(false) .build();

Please kindly let me know if you need any further details

Topics
Database
Tags
Amazon DynamoDB
Language
English
Sathwik
asked 7 months ago529 views
1 Answer
1
Accepted Answer

You cannot update values of an item using a read api such as Query. You must use UpdateItem:

https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_UpdateItem.html

profile pictureAWS
EXPERT
Leeroy Hannigan
answered 7 months ago
profile picture
EXPERT
Giovanni Lauria
reviewed a month ago
  • Sathwik
    7 months ago

    Hi @Leeroy Hannigan, Thanks for the suggestion I changed the logic to update a item in dynamoDB which helped me to solve the problem Initially I used : employeeTable.updateItem(Employeeitem) Note : *EmployeeItem = the modelled item to be inserted into or updated in the database table.

    Updated logic: I updated the logic to use updateItem(UpdateItemEnhancedRequest<T> request) with UpdateQuery

    UpdateItemEnhancedRequest<Employee> request = UpdateItemEnhancedRequest .builder(Employee.class) .item(employee) .ignoreNulls(true) -> this actually helped me avoid overriding the existing data with null values in update query .build();

    Thanks for you help and pointing to me correct documentation

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content