problem with copy command and heap size

1) i am using below commands for coping data COPY events.standardevents (uuid, data, name, time, tracker, type, userid) TO 'temp.csv'; truncate standardevents; COPY event.standardeventstemp (uuid, data, name, time, tracker, type, userid) FROM 'temp.csv'; if table is not containi

Re: Help with batch renaming legacy sstable files

Todd, 'rename' is a (perl?) command line utility that comes with many Linux distributions. It's not part of Cassandra. It's highly useful for renaming many files. The utility can also be installed using Homebrew on MacOSX. Cheers, Jens — Sent from Mailbox On Thu, Jun 26, 2014 at 6:51 PM,

Re: Help with batch renaming legacy sstable files

On Thu, Jun 26, 2014 at 9:50 AM, Todd Nine wrote: > Robert. The data has been upgraded to 1.1, but it was created in a > 0.8 version. It's been steadily upgraded, so I believe sstable data > is in 1.1 format. However, they're still retaining the old naming > convention. > There's an automatic

Re: Help with batch renaming legacy sstable files

Jens, Where is the "rename" utility? I don't see it in the 1.2.16 distribution. Robert. The data has been upgraded to 1.1, but it was created in a 0.8 version. It's been steadily upgraded, so I believe sstable data is in 1.1 format. However, they're still retaining the old naming convention.

Re: Help with batch renaming legacy sstable files

On Wed, Jun 25, 2014 at 9:49 PM, Todd Nine wrote: > I'm working on migrating some data from 1.0.x clusters to a 1.2.16 > cluster. Part of my testing is (locally) loading the old 1.0 sstables > into my environment in 1.2.16. Since the 1.0 days, the file format > has changes from this format. >

Cassandra CLI showing inconsistent results during gets

I ran the following set of commands via CLI in our servers. There is a data-discrepancy that I encountered as below during gets... We are running 1.2.4 version with replication-factor=3 (DC1) & 2 (DC2). Reads and writes are at LOCAL_QUORUM create column family TestCF with key_validation_class=Asc

unsubscribe

On Mon, Jun 23, 2014 at 6:54 AM, Alain RODRIGUEZ wrote: > Anyone has any clue of what is happening in our cluster with the given > information? > > What other informations could help you to help me :-D ? > > > > > 2014-06-18 21:07 GMT+02:00 Robert Coli : > >> On Wed, Jun 18, 2014 at 5:36 AM, Alai

Re: restarting node makes cpu load of the entire cluster to raise

Hello Alain, I'm not sure of the root cause of this item. It may be helpful to use DEBUG and start the node to see what's happening as well as watch compaction stats or tpstats to understand what is taxing your system. The log file you provided shows a large ParNew while replaying commit log

[RELEASE CANDIDATE] Apache Cassandra 2.1.0-rc2 released

The Cassandra team is pleased to announce the release of the second release candidate for the future Apache Cassandra 2.1.0. Let first stress that this is not yet the final release of 2.1.0 and as such is *not* ready for production use. We however encourage as much testing as possible of this rele

Re: repair takes 10x more time in one DC compared to the other

On Thu, Jun 26, 2014 at 4:06 AM, Paulo Ricardo Motta Gomes < paulo.mo...@chaordicsystems.com> wrote: > > [...] since you may want to repair nodes sequentially in the local DC > (-local) without re-repairing ranges of neighbor nodes (-pr). > Nobody disagrees that this would nice to have, we're jus

Re: Does the default LIMIT applies to automatic paging?

On Wed, Jun 25, 2014 at 7:48 PM, ziju feng wrote: > > The reason I mentioned the 1 rows LIMIT is not only because it is the > default LIMIT in cqlsh, but also because I found it on the CQL document > , > specifical