Migrating from Mysql to Cassandra

2010-09-28 Thread sekhar kosuru
Hi I am involving in migrating our database Mysql to Cassandra. After Google about Cassandra database i feel following are some issues we need to find the solutions. Suggest me if my analysis is wrong or for my doubts. *1) Projecting all the rows* - If we fixed KeyRange count to N records and i

Re: How to Retrieve all the rows from a ColumnFamily

2010-09-27 Thread sekhar kosuru
arent > cp = new ColumnParent() { Column_family = "MetaAssets" }; > > results = _client.get_slice(_utf8.GetBytes(guid.ToString("N")), cp, > predicate, ConsistencyLevel.QUORUM); > > > On Mon, Sep 27, 2010 at 2:44 AM, Benjamin Black wrote: > >> http://wiki.apache.o

How to Load Records From ColumnFamily by Condition Based on a Column Values.

2010-09-27 Thread sekhar kosuru
Hi I have a ColumnFamily with 50k rows, how can i load only say some 2k or so, Which are satisfied some Criteria on a Single Column Values. For Example, In the ColumnFamily normal column named CreatedDate, i need to load the satisfied criteria like this. 1-sep-2009 to 3-july-2010. /Regards Sek

How to Retrieve all the rows from a ColumnFamily

2010-09-26 Thread sekhar kosuru
Hi I am new to Cassandra Database. I want to know how to Retrieve all the records from a column family, is this is different in the clustered servers vs single servers. Please suggest me with piece of code if possible. /Regards Sekhar.