How to Drop Hive Database with Tables in it ?

[#1]

DROP DATABASE IF EXISTS userdb CASCADE;

By using CASCADE, tables in userdb will be deleted first and then the database will be dropped.

Is it safe to use cascade for Dropping the Hive database?

Is there any best practice?

[#2]

@Sridhar Reddy

[#3]

@Dhiraj

DROP DATABASE will fail if the database is not empty. To drop the tables in the database as well, use DROP DATABASE ... CASCADE

[#4]

@Sridhar Reddy I know, CASCADE will help in dropping the database with tables in it. Is this an only way or are there any best practices?

[#5]

@Dhiraj

Yes, this is the only way to drop the database along with tables inside it. I haven't faced any issues till now but I;m not sure of best practices

[#6]

@Dhiraj

Yes, this is the only way to drop the database along with tables inside it. I haven't faced any issues till now but I;m not sure of best practices

[#7]

@Sridhar Reddy Using cascade for dropping DB will delete the entire directory of DB in given HDFS location and also data of other DB which are in/under that location of dropped DB. So it is not recommended to use CASCADE for dropping DB.

[#8]

@Dhiraj

If the idea is to drop the database and all tables within, then the db directory from HDFS is sure to be removed. Is the use case to remove the tables within than to remove the database and it's directory structure?

[#9]

@Sindhu Yes, idea is to drop the database and all tables within and to remove the db directory from HDFS too.

[#10]

@Dhiraj

Then, you need to run 'Drop database cascade'.