title: Cassandra selective copy
body: <p>I want to copy selected rows from a columnfamily to a .csv file. The copy command is available just to dump a column or entire table to a file without where clause. Is there a way to use where clause in copy command?</p>
  
  <p>Another way I thought of was,</p>
  
  <p>Do "Insert into table2 () values ( <code>select * from table1 where &lt;where_clause&gt;</code>);" and then dump the table2 to .csv , which is also not possible. </p>
  
  <p>Any help would be much appreciated.</p>