Currently I have a local image of amazon/dynamodb-local . Whenever I try to perform an update operation on the database, it creates a duplicate row instead of updating the existing record
My table definition is:
{
TableName: "commission",
KeySchema: [
{ AttributeName: "public_key", KeyType: "HASH" }, //Partition key
],
AttributeDefinitions: [{ AttributeName: "public_key", AttributeType: "S" }],
ProvisionedThroughput: {
ReadCapacityUnits: 5,
WriteCapacityUnits: 5,
},
}
Update query generated using NoSQL Workbench:
{
TableName: "commission",
Key: {
"public_key": publickey
},
UpdateExpression: "set commission = :commission , commisison_limit = :commissionlimit ",
ExpressionAttributeValues: {
":commission": commission,
":commissionlimit": commissionlimit
},
ReturnValues: "UPDATED_NEW"
}

