Re: Compound primary key: Insert after delete

code attached. Somehow it is not working with 1.1.5. -Vivek On Mon, Oct 22, 2012 at 5:20 AM, aaron morton wrote: > Yes AFAIK. > > Cheers > > - > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 20/10/2012, at 12:15 AM, Vivek Mishra wrote: >

Re: DELETE query failing in CQL 3.0

It is better to provide table definition. I guess the reason is below statement. " a table must define at least one column that is not part of the PRIMARY KEY as a row exists in Cassandra only if it contains at least one value for one such column " Please check this document here

find smallest counter

I have a set of categories. In these categories I want to add groups of users. If a user does not specify the group they want to join in a category, I want to add them to the least subscribed group. So the groups are a super column with CategoryId as key, GroupId as superColumnName and then column

Re: DELETE query failing in CQL 3.0

Can you paste the table definition ? Thanks - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/10/2012, at 5:53 AM, "Ryabin, Thomas" wrote: > I have a column family called “books”, and am trying to delete all rows where > the “title” column is

Re: Compound primary key: Insert after delete

Yes AFAIK. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/10/2012, at 12:15 AM, Vivek Mishra wrote: > Hi, > Is it possible to reuse same compound primary key after delete? I guess it > works fine for non composite keys. > > -Vivek

Re: Hinted Handoff runs every ten minutes

I *think* this may be ghost rows which have not being compacted. How many SSTables are on disk for the HintedHandoff CF ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/10/2012, at 7:16 AM, David Daeschler wrote: > Hi Steve, > > Also

Re: What does ReadRepair exactly do?

There are two processes in cassandra that trigger Read Repair like behaviour. During a DigestMismatchException is raised if the responses from the replicas do not match. In this case another read is run that involves reading all the data. This is the CL level agreement kicking in. The other "

Re: constant CMS GC using CPU time

Dne 18.10.2012 20:06, Bryan Talbot napsal(a): In a 4 node cluster running Cassandra 1.1.5 with sun jvm 1.6.0_29-b11 (64-bit), the nodes are often getting "stuck" in state where CMS collections of the old space are constantly running. you need more java heap memory