Limit on amount of CFs

2011-02-10 Thread Nick Santini
Hi, Reading in the documentation (specially on the tuning section) is clear the the number of Column Families affects the performance, in particular the amount of memory assigned to the heap. My question is: What's the hard limit on the number of CFs? Does anybody implemented an application with l

Re: performance degradation in cluster

2011-02-03 Thread Nick Santini
Are you using Virtual Machines to run Cassandra? Ive found that performance in VMs is crap Nicolas Santini On Thu, Feb 3, 2011 at 11:17 PM, aaron morton wrote: > This page has a guide to setting the initial tokens for the nodes > http://wiki.apache.org/cassandra/Operations#Ring_management > > <

Re: Schema Design

2011-01-26 Thread Nick Santini
One thing you can do is create one CF, then as the row key use the application name + timestamp, with that you can do your range query using OOP. then store whatever you want in the row problem would be if one app generates far more logs than the others Nicolas Santini On Thu, Jan 27, 2011 at 1

Re: get_range_slices getting deleted rows

2011-01-25 Thread Nick Santini
Jan 25, 2011 at 2:59 PM, Nick Santini wrote: > >> Hi, >> I'm trying a test scenario where I create 100 rows in a CF, then >> use get_range_slices to get all the rows, and I get 100 rows, so far so good >> then after the test I delete the rows using "remove&quo

get_range_slices getting deleted rows

2011-01-25 Thread Nick Santini
Hi, I'm trying a test scenario where I create 100 rows in a CF, then use get_range_slices to get all the rows, and I get 100 rows, so far so good then after the test I delete the rows using "remove" but without a column or super column, this deletes the row, I can confirm that cos if I try to get i

Re: Installing Cassandra on windows

2010-12-19 Thread Nick Santini
now :) > > Can you also tell me where to keep the cassandra folder with phpcassa to > use it with wamp server.. Thanks for your great help!! > > Regards > Rajkumar > > > On Fri, Dec 17, 2010 at 2:31 AM, Nick Santini wrote: > >> just tried my self >> seems

Re: Installing Cassandra on windows

2010-12-16 Thread Nick Santini
just tried my self seems to be that you are not starting the cassandra process first the cli is only to access it, not to start it execute cassandra first Nicolas Santini On Fri, Dec 17, 2010 at 9:55 AM, Rajkumar Gupta wrote: > yes I tried to connect through: > > *cassandra-cli -host localhost

Re: batch mutate with only deletions on 0.7beta2

2010-12-15 Thread Nick Santini
found the issue, was on the logic of the test sorry about crying wolf :-p thanks for reading and all your help guys Nicolas Santini On Thu, Dec 16, 2010 at 3:55 PM, Nick Santini wrote: > btw, inside the test the data row gets deleted, but not the secondary index > row/columns > &g

Re: batch mutate with only deletions on 0.7beta2

2010-12-15 Thread Nick Santini
btw, inside the test the data row gets deleted, but not the secondary index row/columns Nicolas Santini On Thu, Dec 16, 2010 at 3:53 PM, Nick Santini wrote: > ok, after a few tests and debugs ive found that is actually deleting those > columns, so great > > but the problem is di

Re: batch mutate with only deletions on 0.7beta2

2010-12-15 Thread Nick Santini
de where I inserted the references is exactly the same, but > without the deletion part in the mutations > > > Nicolas Santini > > > On Thu, Dec 16, 2010 at 12:55 PM, Tyler Hobbs wrote: > >> What client are you using? If you're not using a client, what does your

Re: batch mutate with only deletions on 0.7beta2

2010-12-15 Thread Nick Santini
#x27;re not using a client, what does your > deletion code look like? > > - Tyler > > > On Wed, Dec 15, 2010 at 4:58 PM, Nick Santini wrote: > >> thats not exactly what im seeing, is not a row, but columns on a row that >> i was deleting >> >> ie: >>

Re: 0.7beta2 supported index not updated on delete

2010-12-15 Thread Nick Santini
thanks Nicolas Santini On Thu, Dec 16, 2010 at 12:08 PM, Jonathan Ellis wrote: > Known bug. Upgrade. > > > On Wed, Dec 15, 2010 at 4:19 PM, Nick Santini wrote: > >> Hi, >> im working with the 0.7beta2 version and using the supported secondary >> indexes for S

Re: batch mutate with only deletions on 0.7beta2

2010-12-15 Thread Nick Santini
utate, but you are probably > seeing this: > > http://wiki.apache.org/cassandra/FAQ#range_ghosts > > - Tyler > > > On Wed, Dec 15, 2010 at 4:26 PM, Nick Santini wrote: > >> since the 0.7beta2 version doesnt support indexes for Super CF or for >> columns that you m

batch mutate with only deletions on 0.7beta2

2010-12-15 Thread Nick Santini
since the 0.7beta2 version doesnt support indexes for Super CF or for columns that you might not now the name yet, im supporting them manually by adding a row on the same CF where the key is the name of the column plus the value, and in the columns hold the key to the referenced rows this works as

0.7beta2 supported index not updated on delete

2010-12-15 Thread Nick Santini
Hi, im working with the 0.7beta2 version and using the supported secondary indexes for Standard CF they work, as in I can find rows by searching on those indexes. what ive just found is that when I delete the row, using "remove", the indexes dont get updated, so im still able to find the referenc

Re: Secondary index on SuperColumn Family , Casandra 0.7beta2

2010-12-05 Thread Nick Santini
Thanks Jonathan Nicolas Santini

Re: Fetch a SuperColumn based on value of column

2010-12-02 Thread Nick Santini
actually, the solution would be something like my last mail, but pointing to the name of the super column and the row key Nicolas Santini Director of Cloud Computing Auckland - New Zealand (64) 09 914 9426 ext 2629 (64) 021 201 3672 On Fri, Dec 3, 2010 at 1:08 PM, Nick Santini wrote: >

Re: Fetch a SuperColumn based on value of column

2010-12-02 Thread Nick Santini
Hi, as I got answered on my mail, secondary indexes for super column families is not supported yet, so you have to implement your own easy way: keep another column family where the row key is the value of your field and the columns are the row keys of your super column family (inverted index) N

Re: Secondary index on SuperColumn Family , Casandra 0.7beta2

2010-12-02 Thread Nick Santini
you will find secondary indexes are not supported for super columns > > Sent from my iPhone > > On Dec 3, 2010, at 10:22, Nick Santini wrote: > > > Hi, > > Im creating a column family and adding some secondary indexes on the > column definition for some columns inside

Secondary index on SuperColumn Family , Casandra 0.7beta2

2010-12-02 Thread Nick Santini
Hi, Im creating a column family and adding some secondary indexes on the column definition for some columns inside my super columns I save a row, but then when I try to get the indexed slice with an expression that would match that row I got nothing back Is there anything special about secondary

cassandra version update and my cluster

2010-12-01 Thread Nick Santini
Hi, this is an hypothetical situation highly likely to happen: I have a cassandra 0.7 cluster, filled with production data, and I want to upgrade cassandra to the 0.8 version (and so on as new versions get released) what happen with my data and keyspace / column families definitions? whats the pr