Cassandra: Export all tables from keyspaces on server

export-cassandra-keyspaces.sh

#!/bin/bash

function join
{
	local IFS="$1"; shift; echo "$*";
}

function cqlsh_on
{
	server=$1
	cmd="${@:2}"
	ssh -T $server << EOSSH
cqlsh -e "$cmd"
EOSSH
}

function export_cassandra_keyspaces
{
	server=$1
	keyspaces="${@:2}"
	out_dir=export-keyspaces-$(join - $keyspaces)
	for namespace in ${keyspaces}; do
		tables=$(cqlsh_on $server "USE ${namespace}; DESCRIBE tables;")
		mkdir -p ${out_dir}/${namespace}
		for table in ${tables}; do
			cmd="COPY ${namespace}.${table} TO STDOUT WITH HEADER=true;"
			cqlsh_on $server $cmd | tee ${out_dir}/${namespace}/${table}.csv
		done;
	done;
}

export_cassandra_keyspaces "$@"

Usage is: ./export-cassandra-keyspaces.sh HOSTNAME KEYSPACE1 KEYSPACE2
It will generate and export-KEYSPACE1-KEYSPACE2 directory with a directory for each keyspace inside.