不同集群 hive 表结构 重新创建

导出表结构
#/bin/bash
#hive -e"
#show databases;
#">databases.txt
#sed -i '1d' databases.txt

for database in `cat databases.txt`
do
echo database-------------- ${database}
# hive -e "use ${database};"
# hive -e"
#  use ${database};
#  show tables;
# ">tables.txt
#  sed -i '1d' tables.txt
  for table in `cat tables.txt`
   do
    echo table--${table}
    mkdir -p hive_table_0413/${database}
    hive -e"
       use ${database};
       show create table ${table};">hive_table_0413/${database}/${table}.txt
   done
done

sed -i "s/hdfs:\/\/getui-bi-calc//g" *.txt

sed -i "/2018-04-17/d" *.txt

sed -i  '$r 1' *.txt