使用beeline 操作hive 添加分区

使用beeline 操作hive 添加分区

#!/bin/sh

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