Cacher is the code snippet organizer for pro developers

hive -e  $(hive -e 'show tables;' | sed 's/^\(.*\)$/drop table `\1`;/g')

for t in `hive -e 'show tables;'`;do hive -e "drop table $t;";done