cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rahul Bhardwaj <rahul.bhard...@indiamart.com>
Subject Re: how dump a query result into csv file
Date Mon, 12 Jan 2015 10:42:49 GMT
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_feed_new
                SSTable count: 15
                Space used (live): 446908108
                Space used (total): 446908108
                Space used by snapshots (total): 0
                SSTable Compression Ratio: 0.21311411274805014
                Memtable cell count: 249458
                Memtable data size: 14938837
                Memtable switch count: 37
                Local read count: 2108
                Local read latency: 8.149 ms
                Local write count: 923452
                Local write latency: 2.839 ms
                Pending flushes: 0
                Bloom filter false positives: 0
                Bloom filter false ratio: 0.00000
                Bloom filter space used: 560
                Compacted partition minimum bytes: 18
                Compacted partition maximum bytes: 557074610
                Compacted partition mean bytes: 102846983
                Average live cells per slice (last five minutes):
93.25047438330171
                Maximum live cells per slice (last five minutes): 102.0
                Average tombstones per slice (last five minutes): 0.0
                Maximum tombstones per slice (last five minutes): 0.0


On Mon, Jan 12, 2015 at 4:07 PM, Rahul Bhardwaj <
rahul.bhardwaj@indiamart.com> wrote:

> 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.Finke@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.bhardwaj@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>!!!

Mime
View raw message