!/bin/bash
hive -e “use ana_crmpicture;show tables;” > tables.txt
sleep 3
cat tables.txt |while read eachline
do
hive -e “show create table ana_crmpicture.$eachline” >>tablesDDL.txt
done
hive -e “use ana_crmpicture;show tables;” > tables.txt
sleep 3
cat tables.txt |while read eachline
do
hive -e “show create table ana_crmpicture.$eachline” >>tablesDDL.txt
done