Comparing Cassandra and DynamoDB: A Side-By-Side Guide

StringBuilder sb = new StringBuilder("INSERT INTO ")
 .append(TABLE_NAME).append("(key, value) ")
 .append("VALUES (").append(keyVal)
 .append(", '").append(valueVal).append("');");
	String query = sb.toString();
 session.execute(query);

Region region = Region.US_EAST_1;
DynamoDbClient ddb = DynamoDbClient.builder().region(region).build();
HashMap<String, AttributeValue> itemValues = new HashMap<>();
itemValues.put(key, AttributeValue.builder().s(keyVal).build());
itemValues.put(value, AttributeValue.builder().s(valueVal).build());
PutItemRequest request = PutItemRequest.builder().tableName(tableName).item(itemValues).build();
PutItemResponse response = ddb.putItem(request);

UPDATE keyspace.tablename 
SET column1 = 'col1Val',column1 = 'col2Val' 
 WHERE id = 'id123';

HashMap<String, AttributeValue> itemKey = new HashMap<>();
itemKey.put(key, AttributeValue.builder().s(keyVal).build());
HashMap<String, AttributeValueUpdate> updatedValues = new HashMap<>();
updatedValues.put(name, AttributeValueUpdate.builder().value(AttributeValue.builder().s(updateVal).build())
 .action(AttributeAction.PUT)
 .build());
UpdateItemRequest request = UpdateItemRequest.builder().tableName(tableName).key(itemKey)
 .attributeUpdates(updatedValues)
 .build();
ddb.updateItem(request);

//Delete data from specific columns in a row
DELETE col1, col2 FROM keyspace.table WHERE id = 'id123';
//Delete a row
DELETE FROM keyspace.table WHERE id = 'id123';

HashMap<String, AttributeValue> keyToDelete = new HashMap<>();
keyToDelete.put(key, AttributeValue.builder().s(keyVal).build());
DeleteItemRequest deleteReq = DeleteItemRequest.builder().tableName(tableName).key(keyToDelete).build();
ddb.deleteItem(deleteReq);

//Select specific columns in a row
SELECT col1, col2 FROM keyspace.table WHERE id = 'id123';
//Select all columns in a row
SELECT *  FROM keyspace.table WHERE id = 'id123';

// Set up an alias for the partition key name 
HashMap<String, String> attrNameAlias = new HashMap<String, String>();
attrNameAlias.put(partitionAlias, partitionKeyName);
 // Set up mapping of the partition name with the value.
HashMap<String, AttributeValue> attrValues = new HashMap<>();
attrValues.put(":" + partitionKeyName, AttributeValue.builder().s(partitionKeyVal).build());
QueryRequest queryReq = QueryRequest.builder()
 .tableName(tableName)
 .keyConditionExpression(partitionAlias + " = :" + partitionKeyName)
 .expressionAttributeNames(attrNameAlias)
 .expressionAttributeValues(attrValues)
 .build();
QueryResponse response = ddb.query(queryReq);