drop all tables
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