Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of fsobral@igcorp.com.br
 designates 209.85.128.45 as permitted sender)
From: Francisco Nogueira Calmon Sobral <fsobral@igcorp.com.br>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Subject: sstableloader in Counter Columns
Message-Id: <EFD8DD54-7553-460B-A17A-ECB30D6A8718@igcorp.com.br>
Date: Thu, 7 Nov 2013 11:08:45 -0200
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Mime-Version: 1.0 (Mac OS X Mail 6.6 \(1510\))

Hi, all!

I've performed a test in my cluster, regarding the sstableloader =
behaviour on counter column families. The test cluster has 3 nodes =
running Cassandra 1.2.3 with RF=3D3. The machine that sstableloader run =
had Cassandra 1.2.11.

The counter column family had only one row, so I chose one node and =
performed nodetool snapshot. Then, I've truncated this CF.

Before truncating, this CF was:

RowKey: 0
=3D> (counter=3DEVENTS, value=3D4816777)
=3D> (counter=3DITEMS, value=3D395930)
=3D> (counter=3DUSERS, value=3D2574764)

After truncating and running sstableloader it was:

[default@Sessions] get Counters[0];
=3D> (counter=3DEVENTS, value=3D4809758)
=3D> (counter=3DITEMS, value=3D382473)
=3D> (counter=3DUSERS, value=3D2571674)

Then, I've performed another test. I've truncated the CF, then =
incremented the row 'ITEMS' by 1.000.000 and then run sstableloader. =
Unfortunately, the result was:

[default@Sessions] get Counters[0];
=3D> (counter=3DEVENTS, value=3D4809758)
=3D> (counter=3DITEMS, value=3D382473)
=3D> (counter=3DUSERS, value=3D2571674)


Is this the normal behaviour of sstableloader for counter column =
families? If that is the case, we cannot run sstableloader in a live =
cluster, can we?

Best regards!
Francisco