problem in exporting large table

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

problem in exporting large table

Rahul Bhardwaj
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!!!
Reply | Threaded
Open this post in threaded view
|

Re: problem in exporting large table

Rahul Neelakantan
Why can't you use sstable2json?


Rahul

On Jan 12, 2015, at 11:24 PM, Rahul Bhardwaj <[hidden email]> 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!!!