Cannot delete item from DynamoDB table (java)

Question

I've been attempting to delete an item from a table in DynamoDB through java code, but every attempt I've made results in the same error:

com.amazonaws.AmazonServiceException: The provided key element does not match the schema (Service: AmazonDynamoDBv2; Status Code: 400; Error Code: ValidationException;

My current attempt is very simple and looks like this:

final DynamoDB dynamoDB = new DynamoDB(new  AmazonDynamoDBClient(credentials));  

Table table =dynamoDB.getTable(tableName);    

DeleteItemSpec itemSpec = new  DeleteItemSpec().withPrimaryKey("cognitoId", cognitoId);  
table.deleteItem(itemSpec);

tablename is simply the table name, the credentials have been verified to be correct, and cognitoId is the actual ID of the item I'm trying to delete. The table in question has cognitoId as the primary key and I don't understand why the deletion isn't matching the schema. The table also has a sort key, or range key (I'm not sure what it is because the documentation is quite vague). I've been referring to the documentation here: http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/WorkingWithTables.html#WorkingWithTables.primary.key

Try using deleteItem(String hashKeyName, Object hashKeyValue) — Chris Franklin
– Chris Franklin, Commented Jan 15, 2016 at 21:24

Pratik Varma · Accepted Answer · 2016-01-15 22:08:59Z

4

Did you have a sort key while creating a table? If so, then you have to specify the sort key too as you have a composite key on the table. Having a sort key means that you could have multiple records with the same primary key, however the sort key must be unique

http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/WorkingWithTables.html#WorkingWithTables.primary.key

The sort key may also be referred to as range or range key in the AWS Dynamo DB documentation and the console.

So your delete item would be like

DeleteItemSpec itemSpec = new DeleteItemSpec().withPrimaryKey("cognitoId", "my_id", "sortKeyField", "sort_key_id");
DeleteItemOutcome outcome = table.deleteItem(itemSpec);

answered Jan 15, 2016 at 22:08

Pratik Varma

3681 gold badge2 silver badges10 bronze badges

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

2 Comments

zackygaurav Over a year ago

What do you mean by "composite key"?

Pratik Varma Over a year ago

In DynamoDB, a primary key can either be a single-attribute partition key or a composite partition-sort key

Dexter Legaspi · Accepted Answer · 2019-06-12 12:25:43Z

1

FYI this also happens if you provide the wrong key name, e.g.:

DeleteItemSpec itemSpec = new DeleteItemSpec().withPrimaryKey("#NOPENOTMYKEYLOL", "my_id", "sortKeyField", "sort_key_id");
DeleteItemOutcome outcome = table.deleteItem(itemSpec);

answered Jun 12, 2019 at 12:25

Dexter Legaspi

3,3321 gold badge37 silver badges29 bronze badges

Collectives™ on Stack Overflow

Cannot delete item from DynamoDB table (java)

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related