Re: how dump a query result into csv file

2015-01-12 Thread Rahul Bhardwaj
sry consider these stats: nodetool cfstats clickstream.business_feed_new Keyspace: clickstream Read Count: 2108 Read Latency: 8.148092030360532 ms. Write Count: 923452 Write Latency: 2.8382575358545976 ms. Pending Flushes: 0 Table: business_f

Re: how dump a query result into csv file

2015-01-12 Thread Rahul Bhardwaj
Hi, Thanks for your quick reply. But I know this command , but for one table which has around 10lacs rows, this command (Copy table_name to 'table_name.csv' ) get stuck for long time also slows down my cluster. pfb table stats: nodetool cfstats clickstream.business_feed Keyspace: clickstream

RE: how dump a query result into csv file

2015-01-12 Thread Andreas Finke
I think this might be what you are looking for http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/copy_r.html Andi From: Rahul Bhardwaj [rahul.bhard...@indiamart.com] Sent: 12 January 2015 09:22 To: user Subject: how dump a query result into csv file