RE: Appending to fields

2011-06-01 Thread Jeremiah Jordan
, not just one column. -Jeremiah -Original Message- From: Marcus Bointon [mailto:mar...@synchromedia.co.uk] Sent: Tuesday, May 31, 2011 2:23 PM To: user@cassandra.apache.org Subject: Appending to fields I'm wondering how cassandra implements appending values to fields. Since (so the do

Re: Appending to fields

2011-06-01 Thread Nair, Rajesh
D - Original Message - From: Jonathan Ellis [mailto:jbel...@gmail.com] Sent: Tuesday, May 31, 2011 09:57 PM To: user@cassandra.apache.org Subject: Re: Appending to fields Sounds like Ed is right and you should be doing the append as add-a-new-column instead of overwrite-existing-column

Re: Appending to fields

2011-05-31 Thread Jonathan Ellis
Sounds like Ed is right and you should be doing the append as add-a-new-column instead of overwrite-existing-column. On Tue, May 31, 2011 at 8:36 PM, Marcus Bointon wrote: > On 31 May 2011, at 23:03, Dan Kuebrich wrote: > >> I think perhaps OP meant O(N * M), where N is number of rows and M is to

Re: Appending to fields

2011-05-31 Thread Marcus Bointon
On 31 May 2011, at 23:03, Dan Kuebrich wrote: > I think perhaps OP meant O(N * M), where N is number of rows and M is total > bytes. That's probably more accurate. This is what it was doing: Say I repeatedly append 100 bytes to the same 1000 records. First time around that's 100,000 bytes to

Re: Appending to fields

2011-05-31 Thread Edward Capriolo
On Tue, May 31, 2011 at 5:03 PM, Dan Kuebrich wrote: > > > On Tue, May 31, 2011 at 4:57 PM, Victor Kabdebon < > victor.kabde...@gmail.com> wrote: > >> As Jonathan stated I believe that the insert is in O(N + M), unless there >> are some operations that I don't know. >> >> There are other NoSQL dat

Re: Appending to fields

2011-05-31 Thread Dan Kuebrich
On Tue, May 31, 2011 at 4:57 PM, Victor Kabdebon wrote: > As Jonathan stated I believe that the insert is in O(N + M), unless there > are some operations that I don't know. > > There are other NoSQL database that can be used with Cassandra as > "buffers" for quick access and modification and then

Re: Appending to fields

2011-05-31 Thread Victor Kabdebon
As Jonathan stated I believe that the insert is in O(N + M), unless there are some operations that I don't know. There are other NoSQL database that can be used with Cassandra as "buffers" for quick access and modification and then after the content can be dumped into Cassandra for long term stor

Re: Appending to fields

2011-05-31 Thread Jonathan Ellis
On Tue, May 31, 2011 at 2:22 PM, Marcus Bointon wrote: > mysql reads the entire value of y, appends the data, then writes the whole > thing back, which unfortunately is an O(n^2) operation. Actually, this analysis is incorrect. Appending M bytes to N is O(N + M) which isn't the same as N^2 at al

Re: Appending to fields

2011-05-31 Thread Jonathan Ellis
On Tue, May 31, 2011 at 2:22 PM, Marcus Bointon wrote: > I'm wondering how cassandra implements appending values to fields. Since (so > the docs tell me) there's not really any such thing such thing as an update > in Cassandra You've answered your own question. -- Jonathan Ellis Project Chair

Appending to fields

2011-05-31 Thread Marcus Bointon
I'm wondering how cassandra implements appending values to fields. Since (so the docs tell me) there's not really any such thing such thing as an update in Cassandra, I wonder if it falls into the same trap as MySQL does. With a query like "update x set y = concat(y, 'a') where id = 1", mysql re