1-844-696-6465 (US)        +91 77600 44484        help@dezyre.com

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

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password