Data Deletion in HBase Table

In this video we are going to discuss data deletion in edge base table

How to delete enter row, how to delete a certain cell, we'll be discussing them

So how to delete data from a table in edge base? Using the delete command you can delete a specific cell in a table

So syntax will be delete table name, comma, row name, comma column family, column name

So here we are mentioning the column family. column the column name and co comma the timestamp so the timestamp field is optional

you can delete data without using timestamp also so this is a syntax to

delete a certain cell that is a certain column under one column family so to delete

the enter row the syntax will be like this there is a delete all table name

comma row num in that case the enter row will get deleted for the better understanding

let us go for one practical demonstration where we'll be showing that how this delete command

or delete all command will be working there. In this demonstration we shall discuss how we can delete data from the table

So before going for the deletion at first we should see what is the current content of our table So we are issuing the command scan student So I shall write this one as scan student

So you see this is the current content. So now I shall go for the deletion

So how to do the deletion? So let us suppose delete the data of city cell from the row number two

So row number two, we can have that for this row number two. we're having this city the value for this row number two we're having the city value is

Kolkata okay so I want I want to delete that one so how to write this one so I

shall go for this delete and then student obviously within single quotes then

student then comma then two must be also in single quotes then comma then personal

data and what is the data city so this is a respective so I should

be sticking with the single course only and then we shall press enter so delete

student that is a table name comma 2 that is a row number 2 there is a second

record we are having this one as personal underscore data colon city so now the

respective record has got deleted so let us go for a cross check we shall go for this one as scan student you can find that the Kolkata is missing so for the for the second row we are having only three rows are there so the city is missing here so it has got deleted so after doing the

scan student I've got the idea that that row has got deleted now so now if I

want to delete the enter row whose row number is to I want to delete the

enter row whose row number is two so how to do that one so

in that case we shall go for say delete all student within single code comma 2 only and 2

should be also in single code so here you see i'm not mentioning after this two i'm not going

to mention that is a personal underscore data colon city within the single code i'm not mentioning

that one so as i'm not mentioning anything so it will delete the enter row number 2

as a whole so let us go for enter and you can go for the scan student you can go

for the scan student you can find that we're having this row number one but

having this row number two so we're having a column families like your college

data and personal data so accordingly they are surviving but only all the details against the road number 2 it has got deleted and that that is the purpose here so how to

drop the table now you see how to drop the table so we shall go for this one as a drop

student so if you go for the drop student you see the table student is

enabled disable at first then go for the dropping so disable student

disabled student so is disabled student

so is disabled that means I should have to check whether the table has got disabled or not

so I think it should be disabled so let me go for the cross check yes it is not

now so it is true so then if I go for the drop student now you think you see

the table has been dropped so now if I go for the scan student I cannot access

the content I cannot access the content so in this way I've shown you that

how to perform the deletion from the age-based tables thanks for watching this demonstration