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
Read Count: 20
Read Latency: 0.35955000000000004 ms.
Write Count: 282
Write Latency: 12.891524822695036 ms.
Pending Flushes: 0
Table: business_feed
SSTable count: 2
Space used (live): 25745467
Space used (total): 25745467
Space used by snapshots (total): 0
SSTable Compression Ratio: 0.20019757349631778
Memtable cell count: 183396
Memtable data size: 10983652
Memtable switch count: 2
Local read count: 20
Local read latency: 0.360 ms
Local write count: 282
Local write latency: 12.892 ms
Pending flushes: 0
Bloom filter false positives: 0
Bloom filter false ratio: 0.00000
Bloom filter space used: 32
Compacted partition minimum bytes: 52066355
Compacted partition maximum bytes: 74975550
Compacted partition mean bytes: 68727587
Average live cells per slice (last five minutes): 1.25
Maximum live cells per slice (last five minutes): 2.0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0.0
Please help in finding the cause.
Regards:
Rahul Bhardwaj
On Mon, Jan 12, 2015 at 3:05 PM, Andreas Finke <andreas.fi...@solvians.com>
wrote:
> 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
>
> Hi All,
>
> I want to dump a query result into a csv file with custom column
> delimiter.
> Please help.
>
>
>
> Regards:
> Rahul Bhardwaj
>
>
> Follow IndiaMART.com <http://www.indiamart.com> for latest updates on
> this and more: <https://plus.google.com/+indiamart>
> <https://www.facebook.com/IndiaMART> <https://twitter.com/IndiaMART>
> Mobile Channel:
> <https://itunes.apple.com/WebObjects/MZStore.woa/wa/viewSoftware?id=668561641&mt=8>
> <https://play.google.com/store/apps/details?id=com.indiamart.m>
> <http://m.indiamart.com/>
>
> <https://www.youtube.com/watch?v=DzORNbeSXN8&list=PL2o4J51MqpL0mbue6kzDa6eymLVUXtlR1&index=2>
> Watch how Irrfan Khan gets his work done in no time on IndiaMART, kyunki Kaam
> Yahin Banta Hai <https://www.youtube.com/watch?v=hmS4Afl2bNU>!!!
>
--
Follow IndiaMART.com <http://www.indiamart.com> for latest updates on this
and more: <https://plus.google.com/+indiamart>
<https://www.facebook.com/IndiaMART> <https://twitter.com/IndiaMART> Mobile
Channel:
<https://itunes.apple.com/WebObjects/MZStore.woa/wa/viewSoftware?id=668561641&mt=8>
<https://play.google.com/store/apps/details?id=com.indiamart.m>
<http://m.indiamart.com/>
<https://www.youtube.com/watch?v=DzORNbeSXN8&list=PL2o4J51MqpL0mbue6kzDa6eymLVUXtlR1&index=2>
Watch how Irrfan Khan gets his work done in no time on IndiaMART, kyunki Kaam
Yahin Banta Hai <https://www.youtube.com/watch?v=hmS4Afl2bNU>!!!
