CQL 3.x Update ...USING TIMESTAMP...

I am planning to use the Update...USING TIMESTAMP... statement to make sure that I do not overwrite fresh data with stale data while having to avoid doing at least LOCAL_QUORUM writes. Here is my table structure. Table=DocumentStore DocumentID (primaryKey, bigint) Document(text) Version(int) If

Re: C* 2.0.9 Compaction Error

Have someone see this before ? How to deal with this error?remove this node first ,then add this node to cluster? -- Ranger Tsao 2015-03-10 10:57 GMT+08:00 曹志富 : > Hi,every one: > > I have a 12 nodes C* 2.0.9 cluster for titan.I found some error when doing > c

Re: how to clear data from disk

Or just manually delete the files. The directories are broken down by keyspace and table. Patrick On Mon, Mar 9, 2015 at 7:50 PM, 曹志富 wrote: > nodetool clearsnapshot > > -- > Ranger Tsao > > 2015-03-10 10:47 GMT+08:00 鄢来琼 : > >> Hi ALL, >> >> >> >> After dro

Re: timeout when using secondary index

Jimmy, The secondary index is getting scanned since you put the column in your query. The behavior you are looking for is a coming feature called Global Indexes slated for 3.0. https://issues.apache.org/jira/browse/CASSANDRA-6477 In the meantime, you could build your own lookup table even with th

Re: Inconsistent count(*) and distinct results from Cassandra

Thanks for the suggestion DuyHai. I assume you mean CL=QUORUM (as in consistency level, not replication factor). As expected, setting the consistency level to quorum or all yields equally inconsistent results for the select count and select distinct queries. Which is good in a way, because if RF=1

Re: cassandra node jvm stall intermittently

heh on the midst of upgrading , Rob ;-) Jason On Tue, Mar 10, 2015 at 2:04 AM, Robert Coli wrote: > On Sat, Mar 7, 2015 at 1:44 AM, Jason Wee wrote: >> >> hey Ali, 1.0.8 >> >> On Sat, Mar 7, 2015 at 5:20 PM, Ali Akhtar wrote: >>> >>> What version are you running? > > > Upgrade your very old ve