3个文件:

tablesDDL.sh
tablesName.txt
tablesName.txt
dim_pub_bigarea_df
dim_pub_bigarea_df_temp
dim_pub_bus_pline_df
dim_pub_business_industry_groups_classification_df
dim_pub_business_industry_groups_classification_df_temp
tablesDDL.sh
#!/bin/bash
cat /root/hivedata/tablesName.txt | while read tableName
do
hive -e "use ddi; show create table $tableName" >> /root/hivedata/tablesDDL.sql
done

然后,   

chmod  777  tablesDDL.txt
bash  tablesDDL.txt

生成整库ddi的建表语句文档

tablesDDL.sql