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 <viktor.jevdoki...@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.jevdoki...@adform.com<javascript:_e(%7B%7D,'cvml','viktor.jevdoki...@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:pipeli...@gmail.com<javascript:_e(%7B%7D,'cvml','pipeli...@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 >
<<inline: signature-best-employer-logo4823.png>>
<<inline: signature-logo29.png>>