RE: INSERT ... IF NOT EXISTS with some nodes unavailable

2014-06-03 Thread Ackerman, Mitchell
: user@cassandra.apache.org Subject: Re: INSERT ... IF NOT EXISTS with some nodes unavailable Hello Mitchell, I think it is due to your replication factor, which, I assume, is 2 since you have only 2 nodes in the cluster. If you are using even number of nodes, Cassandra is impossible to run

Re: INSERT ... IF NOT EXISTS with some nodes unavailable

2014-06-03 Thread Frederick Haebin Na
Hello Mitchell, I think it is due to your replication factor, which, I assume, is 2 since you have only 2 nodes in the cluster. If you are using even number of nodes, Cassandra is impossible to run queries require QUORUM participants. So, I think you have to expand your cluster to 3 nodes and mak

INSERT ... IF NOT EXISTS with some nodes unavailable

2014-06-02 Thread Ackerman, Mitchell
Hi, I'm trying to get a query using INSERT ... IF NOT EXISTS working when not all of the nodes are available. As a test case I have 2 nodes, one in AWS us-west-1, another in AWS eu-west-1. The keyspace settings are described below. When I only have one of the nodes available,