Question

Drop command in Hive

Answer 1

1. DROP Database

drop database <database name>;

2. DROP Table

hive> DROP TABLE IF EXISTS <tablename>;

3. DROP View

DROP view <viewname>;

4. DROP Index

DROP INDEX <index_name> ON <table_name>;