1.第一种保留所有表到各自文件
#!/bin/bash
hive -e "show databases ;" > databases.txt
i=1
cat databases.txt |while read db
do
hive -e "use $db;show tables;" > $i.txt
sleep 3
cat $i.txt |while read eachline
do
hive -e "use $db;show create table $eachline" >>tablesDDL.txt
done
i=$(($i+1))
done
2.不保留表名
#!/bin/bash
hive -e "show databases ;" > databases.txt
cat databases.txt |while read db
do
hive -e "use $db;show tables;" > tables.txt
sleep 3
cat tables.txt |while read eachline
do
hive -e "use $db;show create table $eachline" >>tablesDDL.txt
done
done