大数据平台设置表数据量的监控任务（阈值）

大数据平台设置表数据量的监控任务

#------------
#本脚本为通用脚本
#编写目的：监控玄武平台部分表的数据量，设置阈值，超过设置阈值会报错，发送短信提醒
#-----------
DB_NAME=${dbname} #DB_NAME：库名
TABLE_NAME=${tablename} #TABLE_NAME：表名
NORMAL_COUNT=${normalcount} #NORMAL_COUNT：最小阈值
MAX_COUNT=${maxcount} #MAX_COUNT：最大阈值
P_DATE=${pdate}	#P_DATE：日期
TABLE_ERR_FLAG=${DB_NAME}.${TABLE_NAME}.err

table_counts=$(hive -e "analyze table ${DB_NAME}.${TABLE_NAME} partition(pt='${P_DATE}') compute statistics;
desc formatted ${DB_NAME}.${TABLE_NAME} partition(pt='${P_DATE}')" | grep numRows | awk '{print $2}') #table_counts 查询出传入日期的表的数据量

if [ ! ${table_counts} ]; then
    table_counts=0
fi

echo "table_counts: $table_counts"
echo "normal_counts: ${NORMAL_COUNT}"
echo "maxcount: ${MAX_COUNT}"
echo  "${P_DATE} ${TABLE_NAME}'s count is ${table_counts} , normal_count:${NORMAL_COUNT} , maxcount: ${MAX_COUNT}"  

	
# 正常情况
if [ ${table_counts} -gt ${NORMAL_COUNT} ] && [ ${table_counts} -lt ${MAX_COUNT} ] ; then
	echo "check success"
else
	echo "check error"	
	exit -1
fi