wrapper for sstableloader to load one file at a time, rename and moved completed to directory

sstable_load.sh

#!/bin/bash

#This is the directory that teh sstables will be palce into load - the table name is also going to be changed from v2 to v4
WORKING_DIR=/somecompany/cassandra/data/sstable_loading_dir/someks/sometable_v4
COMPLETED_DIR=/somecompany/cassandra/data/sstable_completed_dir

mkdir -p $COMPLETED_DIR
mkdir -p $WORKING_DIR

rm -rf $WORKING_DIR/*

SSTABLE_SNAPHOST_NAME="snapshotName"

#Map it somehow to the destination host to load the data in
DEST_HOST=`hostname | sed 's/host36/host26/g'`

THROTTLE=$THROTTLE_MEGABITS_PER_SEC

for i in $(find /somecompany/cassandra/data  -type d | grep ${SSTABLE_SNAPHOST_NAME} ); do 
    for x in $(ls ${i}/*Data* | cut -d'-' -f4 | uniq ); do
        mv ${i}/*${x}* ${WORKING_DIR}
        cd ${WORKING_DIR}
        rename 's/v2/v4/' *
        sstableloader --throttle ${THROTTLE} -d ${DEST_HOST} ${WORKING_DIR}/ || { echo 'sstableloader for ${x} failed' ; exit 1; }
        mv ${WORKING_DIR}/* ${COMPLETED_DIR}/
    done
done

exit 0