Insertion Delay Cassandra 2.1.9

Cassandra users, I have a 4 node Cassandra cluster set up. All nodes are in a single rack and distribution center. I have a loader program which loads 40 million rows into a table in a keyspace with a replication factor of 3. Immediately after inserting the rows (after the loader program

Re: Insertion Delay Cassandra 2.1.9

Vidur, Forgive me if I'm getting this wrong as I'm exceptionally new to Cassandra. By consistency, if you mean the USING CONSISTENCY clause, then I'm not specifying it which, per the CQL documentation, means a default of ONE. On Fri, Nov 6, 2015 at 1:49 PM, Vidur Malik

Re: Insertion Delay Cassandra 2.1.9

Ah, I thought you may have been using a higher consistency, which would explain your error since the data may not have been replicated across all 3 nodes when you made the query. Anyway, it seems to be happening because of replication. What version of Cassandra are you using? There may be a issue

Re: Insertion Delay Cassandra 2.1.9

What is your query consistency? On Fri, Nov 6, 2015 at 1:47 PM, Greg Traub wrote: > Cassandra users, > > I have a 4 node Cassandra cluster set up. All nodes are in a single rack > and distribution center. I have a loader program which loads 40 million > rows into a

Re: Insertion Delay Cassandra 2.1.9

Your experience, then, is expected (although 20m delay seems excessive, and is a sign you may be overloading your cluster, which may be expected with an unthrottled bulk load like that). When you insert with consistency ONE on RF > 1, that means your query returns after one node confirms the