给定一个表的列表tables.list,输出删除原数据脚本location_rm.sh,和重新拉数的脚本location_distcp.sh
tables.list
cat tables.list |awk ‘{print "impala-shell -B -q “show create table “$0"”|grep nameservice1 >> location_pre.txt”}’|bash
cat location_pre.txt |awk -F’nameservice1’ ‘{print $2}’>location.txt
sed -i “s#’##g” location.txt
cat location.txt |awk ‘{print "hadoop fs -rm -r "$0}’> location_rm.sh
cat location.txt | awk -F ‘/|=’ ‘{print “sudo -u hdfs hadoop distcp -p -i webhdfs://hadoop1:14000”$0}’|awk -F’/’ ‘{print $0 " /"$4"/"$5"/"}’ > location_distcp.sh