Re: Query on delete a column inside a super column

2010-07-08 Thread Moses Dinakaran
Moses. On Wed, Jul 7, 2010 at 7:41 PM, Jonathan Ellis wrote: > > the thrift api allows you to optionally specify column and subcolumn > as well.  no idea how or if phpCassa exposes this though. > > On Wed, Jul 7, 2010 at 1:51 AM, Moses Dinakaran > wrote: > > Hi, >

Re: Query on delete a column inside a super column

2010-07-06 Thread Moses Dinakaran
this case. Regards, Moses. On Wed, Jul 7, 2010 at 12:16 AM, Jonathan Ellis wrote: > insert is insert-or-update. leaving out a column from an update > doesn't delete it, you need to use the remove method for that. > > On Tue, Jul 6, 2010 at 7:41 AM, Moses Dinakaran > wrot

Query on delete a column inside a super column

2010-07-06 Thread Moses Dinakaran
Hi All, I have a query related to deleting a column inside a super column The following is my cassandra schema [cache_pages_key_hash] => Array ( [hash_1] => Array ( [1] => 4c330e95195f9 [2] => 4c330e951f18b

Re: Batch_Mutate throws Uncaught exception

2010-05-28 Thread Moses Dinakaran
Hi, > > Just to clarify. Are you trying to insert a couple of columns with key > "cache_pages" in the ColumnFamily "Page"? > > Moses Dinakaran wrote: > i, > > > > > > > > I am trying to use batch_mutate() with PHP Thrift. I was getting the > > following error. > > > >

Batch_Mutate throws Uncaught exception

2010-05-27 Thread Moses Dinakaran
Hi, I am trying to use batch_mutate() with PHP Thrift. I was getting the following error. *Fatal error*: Uncaught exception 'cassandra_InvalidRequestException' in CORE/php/phpcassa/thrift/packages/cassandra/Cassandra.php:4869 Stack trace: #0 CORE/php/phpcassa/thrift/packages/cassandra/Ca

Re: Is it possible to delete records based upon where condition

2010-05-13 Thread Moses Dinakaran
010 at 12:34 AM, Moses Dinakaran > wrote: >> I wanted to remove the records based upon the value of the column >> ses_tstamp >> ie (delete from sessions where ses_tstamp between XXX & YYY OR delete from >> session where ses_tstamp < XXX ) >> >> Is it po

Is it possible to delete records based upon where condition

2010-05-12 Thread Moses Dinakaran
Hi All, In Cassandra it possible to remove records based upon where condition. We are planning to move the session and cache table from MySql to Cassandra and where doing the fesability study. Everything seems to be Ok other than garbage collection of session table. Was not able to remove super