Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is It possible to change value of Range key in DynamoDB Table?

I know it may be a very silly question, but I am new to DynamoDB.

My doubt is is it possible to update the value of a Range Key in DynamoDB.

Suppose My Table is "TEST"

{ ID : PK/HK Date : RK Name : GSI  Add : LSI } 

I want to modify Date Attribute.

Initial Values in Table was:

{ ID = "344" Date = "5656" Name = "ABC" } 

Running this code below. I am able to change the Name Attribute which is GSI.

Map<String,AttributeValue> item = new HashMap<String,AttributeValue>(); item.put("ID", new AttributeValue("344")); item.put("Date", new AttributeValue("5656"));  Map<String,AttributeValueUpdate> item1 = new HashMap<String,AttributeValueUpdate>();  AttributeValueUpdate update = new AttributeValueUpdate().withValue(new AttributeValue("AMIT")).withAction("PUT"); item1.put("Name", update);   UpdateItemRequest updateItemreq = new UpdateItemRequest("Test",item,item1); UpdateItemResult updateItemres = dynamoDBUSEast.updateItem(updateItemreq); 

But When I change this line

item1.put("Name", update); 

with

 item1.put("Date", update); 

I am getting some error as

Exception in thread "main" com.amazonaws.AmazonServiceException: One or more parameter values were invalid: Cannot update attribute Date. This attribute is part of the key (Service: AmazonDynamoDBv2; Status Code: 400; Error Code: ValidationException; Request ID: HRRP24Q7C48AMD8ASAI992L6MBVV4KQNSO5AEMVJF66Q9ASUAAJG)     at com.amazonaws.http.AmazonHttpClient.handleErrorResponse(AmazonHttpClient.java:820)     at com.amazonaws.http.AmazonHttpClient.executeHelper(AmazonHttpClient.java:439)     at com.amazonaws.http.AmazonHttpClient.execute(AmazonHttpClient.java:245)     at com.amazonaws.services.dynamodbv2.AmazonDynamoDBClient.invoke(AmazonDynamoDBClient.java:2908)     at com.amazonaws.services.dynamodbv2.AmazonDynamoDBClient.updateItem(AmazonDynamoDBClient.java:1256) 

So Is it possible to change the range Key value?

like image 871
Geek_To_Learn Avatar asked May 18 '15 06:05

Geek_To_Learn


1 Answers

No, like the exception message states, you Cannot update attribute Date. This attribute is part of the key.

You can also see this under the AttributeUpdates documentation:

The names of attributes to be modified, the action to perform on each, and the new value for each. If you are updating an attribute that is an index key attribute for any indexes on that table, the attribute type must match the index key type defined in the AttributesDefinition of the table description. You can use UpdateItem to update any nonkey attributes.

The documentation states that you can update any attribute for "an attribute that is an index key attribute for any indexes on that table", which means that when you update an attribute that is projected onto an index, even it is is part of that indexes key, that index will also be updated to reflect the original item.

like image 68
mkobit Avatar answered Sep 21 '22 17:09

mkobit