title: Export large amount of data from Cassandra to CSV
body: <p>I'm using Cassandra 2.0.9 for store quite big amounts of data, let's say 100Gb, in one column family. I would like to export this data to CSV in fast way. I tried:</p>
  
  <ul>
  <li><strong>sstable2json</strong> - it produces quite big json files which are hard to parse - because tool puts data in one row and uses complicated schema (ex. 300Mb Data file = ~2Gb json), it takes a lot of time to dump and Cassandra likes to change source file names according its internal mechanism</li>
  <li><strong>COPY</strong> - causes timeouts on quite fast EC2 instances for big number of records</li>
  <li><strong>CAPTURE</strong> - like above, causes timeouts</li>
  <li><strong>reads with pagination</strong> - I used timeuuid for it, but it returns about 1,5k records per second</li>
  </ul>
  
  <p>I use Amazon Ec2 instance with fast storage, 15 Gb of RAM and 4 cores</p>
  
  <p>Is there any better option for export gigabytes of data from Cassandra to CSV?</p>