Thanks for ur reply. Exactly I have splitted that table into 47*20=940 parts, I have 47 partitions and each partition also has 20 buckets, so everytime I execute such cql: select * from table where partition_id=a and bucket_id=b, and the number of each select result maybe 40-80 million. What the " modern CQL client with paging support" mean? Is there opensource CQL client ? I does not use any opensource CQL client and exporting data with my java code.
在 2015-12-29 11:38:51,"Robert Coli" <rc...@eventbrite.com> 写道: On Mon, Dec 28, 2015 at 5:57 PM, xutom <xutom2...@126.com> wrote: I have 5 nodes in my C* cluster, and each node has the same configuration file(Cassandra-env.sh: MAX_HEAP_SIZE="32G" and HEAP_NEWSIZE="8G"), and My Cassandra version is 2.1.1. Now I want to export all data of one table, i am using select * from tablename, Probably lower your heap size. If you're using CMS GC with 32gb heap you will get long GC pauses. Also use a modern CQL client with paging support. In addition, upgrade to the head of 2.1.x, 2.1.1 is not a version anyone should be using in production at this time. =Rob