how to delete database from hive?is that possible?
1 Answer(s)
Abhijit-Dezyre Support
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
Nov 07 2015 12:04 AM
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