#Author: DZH
#Date: 2023
#Desc: 测试(CSV 数据load StarRocks 集群)
##############################################
export LANG=zh_CN.UTF-8
# 按行读取配置文件内容
FILE=/data/strks_pro_ps/conf/strks.conf
DBlink=""
# 获取配置文件进行FE集群状态判断
while read line
do
State_Fe=`echo $line|awk -F "|" '{print $1}'`
# 判断FE是否正常(返回OK 正常其他都是异常)
Fe=`echo ${State_Fe} |awk '{run=$0;system(run)}' |grep -Po '"status":(.+?),' |grep -Po '(OK)'`
# echo ${Fe}
# Fe状态正常,获取正常链接
if [ "${Fe}" == "OK" ];then
DBlink=`echo $line|awk -F "|" '{print $2}'`
break
fi
done < $FILE
#DBlink=$(cat /data/strks_pro_ps/conf/strks.conf)
#EXE_STSQL="${DBlink} "
echo "${DBlink} "
#获取当前路径
#path=$(cd $(dirname $0);pwd)
#SQL1=" -- 测试select now();";
#
LAB_TIME=`date +%Y%m%d%H%M%S`
#echo ${LAB_TIME}
curl --location-trusted -u devuser:devuser -H "label:beacon_request_meta_data_parse_result_${LAB_TIME}" \
-H "max_filter_ratio:0.2" \
-H "column_separator:|" \
-H "format: CSV" \
-T /home/dzh/data_test01.csv -XPUT \
http://IP:8039/api/temp/beacon_request_meta_data_parse_result/_stream_load