Function drop_part { DB_NAME="$1"

Question

Function drop_part { DB_NAME="$1"

TBL_NAME="$2"
PART_NAME="$3"
ALL_CLUSTER="$4"

if [ "${ALL_CLUSTER}" = "1" ]; then
SERVER_LIST=`cat ${scriptroot}/lib/cluster_servers.lst`
else
SERVER_LIST="${DB_SERVER}"
fi

CODE="0"

for server in ${SERVER_LIST}
do
#echo " ${server} ${TBL_NAME} ${PART_NAME}"

to_log "$MSG - begin dropping partition ${PART_NAME} at server ${server}"
clickhouse-client -h ${server} --user "${DB_LOGIN}" --password "${DB_PASSWORD}" --query="ALTER TABLE ${DB_NAME}.${TBL_NAME} DROP PARTITION '${PART_NAME}'"
CODE=$?
if [ ! ${CODE} = 0 ]; then
to_log "$MSG - error dropping partition ${PART_NAME} at server ${server}" "" "red"
eval "$5='${CODE}'"
break
fi
to_log "$MSG - partition ${PART_NAME} at server ${server} dropped succesfully"
done

if [ ! "$5" = "" ] ; then
eval "$5='${CODE}'"
fi
}

#backend #clickhouse #database #devops #programming #russian

0

14.10.2019

1 ответов

7 просмотров

TRUMP - НЕ ОТВЕЧАЮ НЕ ЗВОНИ Ш · Accepted Answer

TRUMP - НЕ ОТВЕЧАЮ НЕ ЗВОНИ Ш

спасибо, думал мало ли есть какой нить drop on cluster :)

0

14.10.2019

184 похожих чатов

Function drop_part { DB_NAME="$1"

1 ответов

Похожие вопросы