No schema agreement from live replicas?

2015-02-03 Thread Clint Kelly
Hi all, I have an application that uses the Java driver to create a table and then immediately write to it. I see the following warning in my logs: [10.241.17.134] out: 15/02/03 09:32:24 WARN com.datastax.driver.core.Cluster: No schema agreement from live replicas after 10 s. The schema may not

Re: No schema agreement from live replicas?

2015-02-03 Thread Clint Kelly
FWIW increasing the threshold for withMaxSchemaAgreementWaitSeconds to 30sec was enough to fix my problem---I would like to understand whether the cluster has some kind of configuration problem that made doing so necessary, however. Thanks! On Tue, Feb 3, 2015 at 7:44 AM, Clint Kelly wrote: > Hi

Re: No schema agreement from live replicas?

2015-02-03 Thread graham sanderson
What version of C* are you using; you could be seeing https://issues.apache.org/jira/browse/CASSANDRA-7734 which I think affects 2.0.7 thru 2.0.10 > On Feb 3, 2015, at 9:47 AM, Clint Kelly wrote: > > FWIW increasing the threshold for with

Smart column searching for a particular rowKey

2015-02-03 Thread Ravi Agrawal
Hi Guys, Need help with this. My rowKey is stockName like GOOGLE, APPLE. Columns are sorted as per timestamp and they include some set of data fields like price and size. So, data would be like 1. 9:31:00, $520, 100 shares 2. 9:35:09, $530, 1000 shares 3. 9:45:39, $520, 500 shares I want to searc

Re: Smart column searching for a particular rowKey

2015-02-03 Thread Eric Stevens
WHERE < + ORDER DESC + LIMIT should be able to accomplish that. On Tue, Feb 3, 2015 at 11:28 AM, Ravi Agrawal wrote: > Hi Guys, > > Need help with this. > > My rowKey is stockName like GOOGLE, APPLE. > > Columns are sorted as per timestamp and they include some set of data > fields like price a

RE: Smart column searching for a particular rowKey

2015-02-03 Thread Ravi Agrawal
Thanks, it does. How about in astyanax? From: Eric Stevens [mailto:migh...@gmail.com] Sent: Tuesday, February 03, 2015 1:49 PM To: user@cassandra.apache.org Subject: Re: Smart column searching for a particular rowKey WHERE < + ORDER DESC + LIMIT should be able to accomplish that. On Tue, Feb 3,

RE: Smart column searching for a particular rowKey

2015-02-03 Thread Ravi Agrawal
Cannot find something corresponding to where clause there. From: Ravi Agrawal [mailto:ragra...@clearpoolgroup.com] Sent: Tuesday, February 03, 2015 2:44 PM To: user@cassandra.apache.org Subject: RE: Smart column searching for a particular rowKey Thanks, it does. How about in astyanax? From: Eric

Re: Tombstone gc after gc grace seconds

2015-02-03 Thread Alain RODRIGUEZ
Hi, thanks for sharing your tests ! Though, how did you inserted the data ? Did you try adding columns in an atomic and random order, with a small memtable size to achieve a big sharding (normal in time series use case) ? I think performing ./md_test against this set of data would be interesting,

RE: Smart column searching for a particular rowKey

2015-02-03 Thread Mohammed Guller
Astyanax allows you to execute CQL statements. I don’t remember the details, but it is there. One tip – when you create the column family, use CLUSTERING ORDER WITH (timestamp DESC). Then you query becomes straightforward and C* will do all the heavy lifting for you. Mohammed From: Ravi Agraw

Re: Unable to create a keyspace

2015-02-03 Thread Saurabh Sethi
Thanks Carlos for pointing that out. The clock on one of the nodes was not in sync and fixing that solved the issue. From: Jan mailto:cne...@yahoo.com>> Reply-To: "user@cassandra.apache.org" mailto:user@cassandra.apache.org>>, Jan mailto:cne...@yahoo.com>> Date

Suggestion Date as a Partition key

2015-02-03 Thread Asit KAUSHIK
HI All, Please excuse me if my queries of are of novice user . On continuation with my last table design issue i am thinking of creating a Partition key on date(only) as in our search criteria time frame would always be there. So my queries are 1) Is this a good idea as i don't have any other fie