#!/bin/bash
#批量指定impalad的执行主机
DIR="/home/chenzl/data/BI"
LOG="/home/chenzl/tmp/log.log"
rm -f $LOG
`touch $LOG`
find $DIR -name "*.sh" | while read f; do
# 有HIVE_DB字符串
grep "HIVE_DB" $f > /dev/null;
if [ $? -eq 0 ]; then
# 有HIVE_TABLE字符串
grep "HIVE_TABLE" $f > /dev/null;
if [ $? -eq 0 ]; then
# 没有impalad字符串
grep "impalad" $f > /dev/null;
if [ $? -ne 0 ]; then
echo $f
echo $f >> $LOG
#sed -i '$a\sudo -u hdfs impala-shell -q "REFRESH ${HIVE_DB}.${HIVE_TABLE};"' $f
sed -i '/CDM_IMPALA=/i\arr=($(seq 158 162))' $f
sed -i '/CDM_IMPALA=/i\num=${#arr[*]}' $f
sed -i '/CDM_IMPALA=/i\res=${arr[$(($RANDOM%num))]}' $f
sed -i 's/ impala-shell / impala-shell --impalad=192.168.1.$res:21000 /g' $f
fi
fi
fi
done