hive 建表语句迁移

hive -e "use dbName;show tables;" > tablesName.txt

#!/bin/bash 
cat /home/xiaohe/xiaohe_ni/tablesName.txt | while read tableName
do
hive -e "use dbName; show create table $tableName" >> tablesDDL.sql
done

#!/bin/bash 
cat $1 | while read tableName
do
echo "drop table if exists $tableName;" >> $2
echo "create table if not exists $tableName (" >> $2
hive -e "set hive.cli.print.header=false;desc $tableName" |sed 's/$/,/' | grep -v 'WARN'|sed '$s/,//g'  >> $2
echo ") STORED AS orc;" >> $2
done

sh exporttableddl.sh dwctable.txt dwc_ddl.sql