Delete Data & Drop Hive Tables

In this video we are discussing delete data and drop tables

So, the basic difference between delete data and drop tables will be that, in case of delete

data, the data will get deleted, but the table structure will be there. But in case of drop table, along with the data, the table structure will be deleted here

So now let us go for some more in detailing about this topic

So how to delete data from Hype Table? To delete all of the stored data from the table, we need to

use the truncate table command. So, command is truncate table command. So, the truncate

command will not delete the whole table schema, and it will delete only the data. So

that means only the data will get deleted, not the table schema, not the table structure

So, command is truncate table. So, the syntax will be truncate table name. So data will get

deleted and the table schema and structure will survive. The drop command is used to delete the whole schema of the table so syntax will be dropped table

table name semicolon so there is a syntax with the help of which you can drop the table schema

there so for both cases the main data will also be removed from the sdfs so for the both

cases the main data file will also be removed from the sdfs so in the both cases the data

will be removed from the file so now let us go for one practical demonstration

to discuss and to issue such commands practically so that you can get the topic in a better way

In this demonstration we shall show you that how to delete data from the Hibb table So in this case what we are doing we are going for truncate table name So the command will be truncate table table name

So before going for any deletion, so let me show you that what is the current content

So select star from stood. So you can find that we're having six rows there

So truncate table stood. in case of truncate table stood the table structure will survive it will persist

but the content will get deleted so if you go on this select start from stood

here then you can find that there is no content but the table structure is

existing so how to delete the table itself then you shall go for drop table

you should go for drop table stood so that table has got deleted

ultimately the table has got deleted so now if you go for say select star from stood so

you see error is being shown so in this way I've shown you that how to delete all

the records from the table and how to drop the table itself then you can go for

drop a database so name of my database was my database so drop database so drop database

my database I think the my was M was capital so let me make it M capital you see the

database has also also been dropped so in this way in this particular demonstration

I've shown you that how to delete and the records from the table how to drop the

table and how to drop the database also thanks for watching this