Re: COPY command to export a table to CSV file

Values in /etc/security/limits.d/cassandra.conf # Provided by the cassandra package cassandra - memlock unlimited cassandra - nofile 10 On Mon, Apr 20, 2015 at 12:21 PM, Kiran mk wrote: > Hi, > > Thanks for the info, > > Does the nproc,nofile,memlock settings in > /etc/security/limi

Re: COPY command to export a table to CSV file

Thanks Sebastian, I will try it out. But I am also curious why is the COPY command failing with Out of Memory Error. regards Neha On Tue, Apr 21, 2015 at 4:35 AM, Sebastian Estevez < sebastian.este...@datastax.com> wrote: > Blobs are ByteBuffer s it calls getBytes().toString: > > > https://gith

Re: COPY command to export a table to CSV file

Blobs are ByteBuffer s it calls getBytes().toString: https://github.com/brianmhess/cassandra-loader/blob/master/src/main/java/com/datastax/loader/parser/ByteBufferParser.java#L35 All the best, [image: datastax_logo.png] Sebastián Estévez Solutions Architect | 954 9

Re: COPY command to export a table to CSV file

hi, what happens if unloader meets blob field? 2015-04-20 23:43 GMT+02:00 Sebastian Estevez : > Try Brian's cassandra-unloader > > > All the best, > > > [image: datastax_logo.png] > > Sebastián Estévez

Re: COPY command to export a table to CSV file

Try Brian's cassandra-unloader All the best, [image: datastax_logo.png] Sebastián Estévez Solutions Architect | 954 905 8615 | sebastian.este...@datastax.com [image: linkedin.png]

Re: COPY command to export a table to CSV file

Does the nproc,nofile,memlock settings in /etc/security/limits.d/cassandra.conf are set to optimum value ? it's all default. What is the consistency level ? CL = Qurom Is there any other way to export a table to CSV? regards Neha On Mon, Apr 20, 2015 at 12:21 PM, Kiran mk wrote: > Hi, > > Tha

Re: COPY command to export a table to CSV file

Hi, Thanks for the info, Does the nproc,nofile,memlock settings in /etc/security/limits.d/cassandra.conf are set to optimum value ? What is the consistency level ? Best Regardds, Kiran.M.K. On Mon, Apr 20, 2015 at 11:55 AM, Neha Trivedi wrote: > hi, > > What is the count of records in the c

Re: COPY command to export a table to CSV file

hi, What is the count of records in the column-family ? We have about 38,000 Rows in the column-family for which we are trying to export What is the Cassandra Version ? We are using Cassandra 2.0.11 MAX_HEAP_SIZE and HEAP_NEWSIZE is the default . The Server is 8 GB. regards Neha On

Re: COPY command to export a table to CSV file

Hi, check the MAX_HEAP_SIZE configuration in cassandra-env.sh environment file Also HEAP_NEWSIZE ? What is the Consistency Level you are using ? Best REgards, Kiran.M.K. On Mon, Apr 20, 2015 at 11:13 AM, Kiran mk wrote: > Seems like the is related to JAVA HEAP Memory. > > What is the count

Re: COPY command to export a table to CSV file

Seems like the is related to JAVA HEAP Memory. What is the count of records in the column-family ? What is the Cassandra Version ? Best Regards, Kiran.M.K. On Mon, Apr 20, 2015 at 11:08 AM, Neha Trivedi wrote: > Hello all, > > We are getting the OutOfMemoryError on one of the Node and the No

COPY command to export a table to CSV file

Hello all, We are getting the OutOfMemoryError on one of the Node and the Node is down, when we run the export command to get all the data from a table. Regards Neha ERROR [ReadStage:532074] 2015-04-09 01:04:00,603 CassandraDaemon.java (line 199) Exception in thread Thread[ReadStage:532074,5