#!/bin/sh
hive -e "use csxuy;show tables;"|grep product_tour2 | while read line
do
echo -n "drop table $line;">>temptables.txt
done
tables=`cat temptables.txt`
echo $tables
hive -e "use csxuy;$tables"
rm temptables.txt