获取hive所有数据库的所有表的建表方式

 

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