You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by ng <pi...@gmail.com> on 2014/04/02 17:03:44 UTC
Exporting column family data to csv
I want to export all the data of particular column family to the text file
from Cassandra cluster.
I tried
copy keyspace.mycolumnfamily to '/root/ddd/xx.csv';
It gave me timeout error
I tried below in Cassandra.yaml
request_timeout_in_ms: 10000000
read_request_timeout_in_ms: 10000000
range_request_timeout_in_ms: 10000000
truncate_request_timeout_in_ms: 10000000
I still have no luck. Any advise how to achieve this? I am NOT limited to
copy command. What is the best way to achieve this? Thanks in advance for
the help.
ng
Re: Exporting column family data to csv
Posted by ng <pi...@gmail.com>.
Thanks for the reply. Most of the solutions provided over web involves
some kind of 'where' clause in data extract and then export the next set
until done. I have column family with no time stamp and no other column I
can use to filter the data. One other solution provided was to use
pagination, but I could not find any example any where over web that
achieves this. This can not be that hard! I must be missing something.
Please advise.
On Wednesday, April 2, 2014, Viktor Jevdokimov <Vi...@adform.com>
wrote:
>
> http://mail-archives.apache.org/mod_mbox/cassandra-user/201309.mbox/%3C9AF3ADEDDFED4DDEA840B8F5C6286BBA@vig.local%3E
>
>
>
>
> http://stackoverflow.com/questions/18872422/rpc-timeout-error-while-exporting-data-from-cql
>
>
>
> Google for more.
>
>
>
>
> Best regards / Pagarbiai
> *Viktor Jevdokimov*
> Senior Developer
>
> Email: Viktor.Jevdokimov@adform.com<javascript:_e(%7B%7D,'cvml','Viktor.Jevdokimov@adform.com');>
> Phone: +370 5 212 3063, Fax +370 5 261 0453
> J. Jasinskio 16C, LT-03163 Vilnius, Lithuania
> Follow us on Twitter: @adforminsider <http://twitter.com/#!/adforminsider>
> Experience Adform DNA <http://vimeo.com/76421547>
> [image: Adform News] <http://www.adform.com>
> [image: Adform awarded the Best Employer 2012]
> <http://www.adform.com/site/blog/adform/adform-takes-top-spot-in-best-employer-survey/>
>
> Disclaimer: The information contained in this message and attachments is
> intended solely for the attention and use of the named addressee and may be
> confidential. If you are not the intended recipient, you are reminded that
> the information remains the property of the sender. You must not use,
> disclose, distribute, copy, print or rely on this e-mail. If you have
> received this message in error, please contact the sender immediately and
> irrevocably delete this message and any copies.
>
> *From:* ng [mailto:pipelines@gmail.com<javascript:_e(%7B%7D,'cvml','pipelines@gmail.com');>]
>
> *Sent:* Wednesday, April 2, 2014 6:04 PM
> *To:* user@cassandra.apache.org<javascript:_e(%7B%7D,'cvml','user@cassandra.apache.org');>
> *Subject:* Exporting column family data to csv
>
>
>
>
> I want to export all the data of particular column family to the text file
> from Cassandra cluster.
>
> I tried
>
> copy keyspace.mycolumnfamily to '/root/ddd/xx.csv';
>
> It gave me timeout error
>
> I tried below in Cassandra.yaml
>
> request_timeout_in_ms: 10000000
> read_request_timeout_in_ms: 10000000
> range_request_timeout_in_ms: 10000000
> truncate_request_timeout_in_ms: 10000000
>
> I still have no luck. Any advise how to achieve this? I am NOT limited to
> copy command. What is the best way to achieve this? Thanks in advance for
> the help.
>
> ng
>
RE: Exporting column family data to csv
Posted by Viktor Jevdokimov <Vi...@adform.com>.
http://mail-archives.apache.org/mod_mbox/cassandra-user/201309.mbox/%3C9AF3ADEDDFED4DDEA840B8F5C6286BBA@vig.local%3E
http://stackoverflow.com/questions/18872422/rpc-timeout-error-while-exporting-data-from-cql
Google for more.
Best regards / Pagarbiai
Viktor Jevdokimov
Senior Developer
Email: Viktor.Jevdokimov@adform.com<ma...@adform.com>
Phone: +370 5 212 3063, Fax +370 5 261 0453
J. Jasinskio 16C, LT-03163 Vilnius, Lithuania
Follow us on Twitter: @adforminsider<http://twitter.com/#!/adforminsider>
Experience Adform DNA<http://vimeo.com/76421547>
[Adform News] <http://www.adform.com>
[Adform awarded the Best Employer 2012] <http://www.adform.com/site/blog/adform/adform-takes-top-spot-in-best-employer-survey/>
Disclaimer: The information contained in this message and attachments is intended solely for the attention and use of the named addressee and may be confidential. If you are not the intended recipient, you are reminded that the information remains the property of the sender. You must not use, disclose, distribute, copy, print or rely on this e-mail. If you have received this message in error, please contact the sender immediately and irrevocably delete this message and any copies.
From: ng [mailto:pipelines@gmail.com]
Sent: Wednesday, April 2, 2014 6:04 PM
To: user@cassandra.apache.org
Subject: Exporting column family data to csv
I want to export all the data of particular column family to the text file from Cassandra cluster.
I tried
copy keyspace.mycolumnfamily to '/root/ddd/xx.csv';
It gave me timeout error
I tried below in Cassandra.yaml
request_timeout_in_ms: 10000000
read_request_timeout_in_ms: 10000000
range_request_timeout_in_ms: 10000000
truncate_request_timeout_in_ms: 10000000
I still have no luck. Any advise how to achieve this? I am NOT limited to copy command. What is the best way to achieve this? Thanks in advance for the help.
ng