Drop/Delete Queries

Delete All Table of a database in Hive

hive -e 'use db_name;show tables' | xargs -I '{}' hive -e 'use db_name;drop table {}'

Where db_name is name of database from tables have to deleted . This command is not be run from hive client . It should run from bin directory of hive installed.