使用beeline 操作hive 添加分区
db=$1
if [ -z "$db" ];then
echo "请指定数据库名:"
exit 1
fi
rsync -aurvozR --progress --bwlimit=20480 --timeout=3600 119.96.199.96::do_sql/EMR/$db ./
for i in `ls EMR/$db/*.sql`;
do
echo $i `/usr/local/service/hive/bin/beeline -u 'jdbc:hive2://127.0.0.1/default;principal=hadoop/127.0.0.1@EMR-2D1YEE1M' --hiveconf hive.server2.logging.operation.level=NONE -f $i`;
done
for t in `impala-shell -i 127.0.0.1 -s hadoop -k -B -q "use $db;show tables;"|grep -v _view`;do
echo ${db}.${t}
impala-shell -i 127.0.0.1 -s hadoop -k -B -q "set request_pool=root.bi.da ; refresh ${db}.${t};"
done