cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rahul Neelakantan <ra...@rahul.be>
Subject Re: problem in exporting large table
Date Tue, 13 Jan 2015 11:50:44 GMT
Why can't you use sstable2json?


Rahul

> On Jan 12, 2015, at 11:24 PM, Rahul Bhardwaj <rahul.bhardwaj@indiamart.com> wrote:
> 
> Hi All,
> 
> We are using C* 2.1. we need to export data of one table (consist 10 lacs records) using
COPY command. After executing copy command cqlsh hangs and get stuck . Please help in resolving
the same or provide any alternative for the same. pfb table stats:
> 
> Keyspace: clickstream
>         Read Count: 3567
>         Read Latency: 8.109851135407906 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: 3567
>                 Local read latency: 8.110 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): 96.81356882534342
>                 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
> 
> 
> 
> regards
> 
> Rahul Bhardwaj
> 
> 
> 
> 
> Follow IndiaMART.com for latest updates on this and more:    Mobile Channel:   
> 
> Watch how Irrfan Khan gets his work done in no time on IndiaMART, kyunki Kaam Yahin Banta
Hai!!!

Mime
View raw message