I once dumped a cassandra cluster to json (10ish gb i if remember correctly) and used jq to do queries