truncate.sh

TSDB="/root/opentsdb/build/tsdb"

ZK="zk0,zk1,zk2"
IN="truncate.txt"
FN="sum"

START=`date -d '2 years ago' '+%Y/%m/%d-%H:%M'`
STOP=`date -d '4 hours ago' '+%Y/%m/%d-%H:%M'`

echo $START
echo $STOP

cat $IN | while read metric; do
    if [ -z $metric ]; then
        continue
    fi

    echo "Truncate: $metric"
    $TSDB scan --delete --zkquorum=$ZK $START $STOP $FN $metric > /dev/null
done

truncate.txt

metric0
metric1
metric2
metric3
metric4