Re: Problem while migrating a single node cluster from 2.1 to 3.2

2016-01-30 Thread Ajaya Agrawal
de first to C* 2.2 before migrating to C* 3.x >> >> For each version, read the NEWS.txt file and follow the procedure: >> >> From 2.1.x to 2.2.x : >> https://github.com/apache/cassandra/blob/cassandra-2.2/NEWS.txt >> >> From 2.2.x to 3.x: >> htt

Problem while migrating a single node cluster from 2.1 to 3.2

2016-01-29 Thread Ajaya Agrawal
Hi, I am a newbie when it comes to Cassandra administration and operation. We have a single node cluster running 2.1 in EC2 and we are planning to move it to better single machine instance and want to run 3.2 on that. I installed 3.2 on the new machine and created a snapshot of the old cluster an

Re: Start with single node, move to 3-node cluster

2015-05-28 Thread Ajaya Agrawal
If it is necessary to start the cluster now then create 3 vms in one machine and start up the cluster. The performance would not be as good as 3 individual nodes, but it will do the job for time being. Later when more nodes arrive start decommissioning vms one by one and add the physical nodes. Dec

Re: how to make unique coloumns in cassandra

2015-03-02 Thread Ajaya Agrawal
Mar 2, 2015 at 12:53 PM, Rahul Srivastava < srivastava.robi...@gmail.com> wrote: > but what if i want to fetch the value using on table then this idea might > fail > > On Mon, Mar 2, 2015 at 12:46 PM, Ajaya Agrawal wrote: > >> Make a table for each of the unique keys. F

Re: how to make unique coloumns in cassandra

2015-03-01 Thread Ajaya Agrawal
Make a table for each of the unique keys. For e.g. If primary key for user table is user_id and you want the phone number column to be unique then create another table wherein the primary key is (phone_number, user_id). Before inserting to main table try to insert to this table first with "if not

Re: road map for Cassandra 3.0

2015-02-17 Thread Ajaya Agrawal
It would be around April of this year. I asked the same thing in cassaandra-dev irc channel sometime back. This is by no means an official release date or month, just a guesstimate. Cheers, Ajaya On Wed, Feb 11, 2015 at 6:49 PM, Ernesto Reinaldo Barreiro < reier...@gmail.com> wrote: > Thanks for

Re: Mutable primary key in a table

2015-02-07 Thread Ajaya Agrawal
On Sun, Feb 8, 2015 at 5:03 AM, Eric Stevens wrote: > I'm struggling to think of a model where it makes sense to update a > primary key as a typical operation. It suggests, as Adil said, that you > may be reasoning wrong about your data model. Maybe you can explain your > problem in more detail

Re: Mutable primary key in a table

2015-02-06 Thread Ajaya Agrawal
On Fri, Feb 6, 2015 at 7:43 PM, Adil wrote: > Hi, > it seems you are doing some thing wrong in your model, why can you go with > updating columns of key1 instead of deleting/inserting row key? > You can't update a primary key column with update statements.

Mutable primary key in a table

2015-02-06 Thread Ajaya Agrawal
Hi guys, I want to take a row with primary key K1, rewrite it with primary key K2, and delete the original data with key K1, atomically. It seems like the only solution which won't have race conditions is to use batch statement to delete the old row and insert the new one. But the documentation o