how to delete database from hive?is that possible?



0
i created a database but its messed up now i want to delete that and again create the database of same name.is that possible?please help me .

1 Answer(s)


0

Hi Hemanthi,
Use the below command to delete the empty database.
hive> DROP DATABASE IF EXISTS
Use this command to delete database if not empty.
hive> DROP DATABASE IF EXISTS financials CASCADE;

Follow below for more help:
https://www.safaribooksonline.com/library/view/programming-hive/9781449326944/ch04.html