Re: No schema agreement from live replicas

2015-09-16 Thread Jonathan Haddad
With Rf=2, cl=quorum is effectively the same as ALL. Expect downtime anytime you restart a node. On Wed, Sep 16, 2015 at 3:39 PM Sebastian Estevez < sebastian.este...@datastax.com> wrote: > check nodetool describecluster to see the schema versions across your > nodes. >

Re: No schema agreement from live replicas

2015-09-16 Thread Sebastian Estevez
check nodetool describecluster to see the schema versions across your nodes. A rolling restart will help propagate schema if you have disagreement across your nodes. Just FYI: We do a lot of schema c

No schema agreement from live replicas

2015-09-16 Thread Saurabh Sethi
We have a 3 node Cassandra cluster (version 2.2.0). Two of the nodes are in one subnet and third one in different subnet. Replication factor is 2 and two of the nodes are seed nodes. Consistency level for everything is QUORUM. We are getting the following warning: WARN com.datastax.driver.core

Re: LTCS Strategy Resulting in multiple SSTables

2015-09-16 Thread Nate McCall
You could try altering the table to use STCS, then force a major compaction via 'nodetool compact', then alter the table back to LCS when it completes. You may very well hit the same issues in process of doing this, however, until you upgrade. On Wed, Sep 16, 2015 at 1:25 PM, Saladi Naidu wrote:

Re: LTCS Strategy Resulting in multiple SSTables

2015-09-16 Thread Saladi Naidu
Nate,Yes we are in process of upgrading to 2.1.9. Meanwhile I am looking for correcting the problem, do you know any recovery options to reduce the number of SS Tables. As SStbales are keep on increasing, the read performance is deteriorating  Naidu Saladi From: Nate McCall To: Cassand

Re: Upgrade Limitations Question

2015-09-16 Thread Victor Chen
Yes, you can examine the actual sstables in your cassandra data dir. That will tell you what version sstables you have on that node. You can refer to this link: http://www.bajb.net/2013/03/cassandra-sstable-format-version-numbers/ which I found via google search phrase "sstable versions" to see wh

Re: Upgrade Limitations Question

2015-09-16 Thread Vasileios Vlachos
Hello Rob and thanks for your reply, At the end we had to wait for the upgradesstables ti finish on every node. Just to eliminate the possibility of this being the reason of any weird behaviour after the upgrade. However, this process might take a long time in a cluster with a large number of node

RE: Cassandra Query using UDF

2015-09-16 Thread Leleu Eric
Hi, I'm not a Mongo user and I never used the Cassandra UDF feature but I found this (You may have already found it): https://issues.apache.org/jira/browse/CASSANDRA-8488 Eric -Message d'origine- De : Michael Scriney [mailto:mscri...@computing.dcu.ie] Envoyé : mercredi 16 septembre 20

Re: Should replica placement change after a topology change?

2015-09-16 Thread Richard Dawe
Hi Rob, On 11/09/2015 18:27, "Robert Coli" mailto:rc...@eventbrite.com>> wrote: On Fri, Sep 11, 2015 at 7:24 AM, Richard Dawe mailto:rich.d...@messagesystems.com>> wrote: Thanks, Nate and Rob. We are going to have to migrate some installations from SimpleSnitch to Ec2Snitch, others to Gossiping

Cassandra Query using UDF

2015-09-16 Thread Michael Scriney
Hello I am wondering is it possible to execute a search using a Cassandra UDF. Similarly to the way I can execute find queries in mongo using custom javascript. Thanks Michael.

Re: Tag filtering data model

2015-09-16 Thread Naresh Yadav
We also had similar usecase, after lot of trials with cassandra, we finally created solr schema doc_id(unique key), tags(indexed) in apache solr for answering search query "Get me matching docs by any given no of tags" and that solved our usecase. We had usecase of millions of docs and in tags we c

Re: Concurrency in Cassandra

2015-09-16 Thread Thouraya TH
Hello, Thank you so much for answer. Ok! i will see this video. I have tested two insert at the same time but i have errors. Thank you. Kind regards. 2015-09-15 22:14 GMT+01:00 Jonathan Haddad : > You may want to take an hour and watch a video on Cassandra fundamentals. > It'll answer a lot of