Deleting multiple records in dynamo db

Question

can we delete multiple records in dynamo db only through range key?

I'm trying to do like this sql statement

delete from employee where employee_name='gopal';

so here the records with employee name gopal should get deleted

can we achieve same like this sql query in dynamo db?

Answer 1

You would have to do a BatchWriteItem to delete your items. From the documentation:

BatchWriteItem performs put and delete

Answer 2

Please Check This query it's working with multiple data

const params = {TableName: "test"};

docClient.scan(params, (error, result) => {
        if (error) { console.log(error,"error scan"); }

        result.Items.forEach(function(item) {          
            docClient.delete({Key:{mainID: item.id},TableName:"test"}, (error) => {
                if (error) {
                    console.log("Delete fail");
                }
                console.log("Delete  Success");
            });
        });

});