不同集群 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