Re: Server Side Logic/Script - Triggers / StoreProc

2012-05-01 Thread Praveen Baratam
lowing > you > >> to implement a java interface and plugin your own java class that will > get > >> called for every insert. > >> > >> Per the discussion on 1311, we intend to extend our proof of concept to > be > >> able to invoke scripts a

Consistency with Sequential Mutation/Access?

2012-04-24 Thread Praveen Baratam
I will start with a hypothetical scenario to make my question easy to comprehend. Time 1: Client A updates Row 1 in CF C. N=3, W=1 Time 2: Client A reads Row1 in CF C. N=3, R=1 Can we expect the update to be seen by all replicas and reply consistently in T2? I presume Cassandra queues job messa

Re: Help with Wide Rows with CounterColumns

2012-04-24 Thread Praveen Baratam
lumns. > 3) Depending on your requirements, consider a different server such as > Redis. > > Hope that helps. > - > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 21/04/2012, at 7:40 AM, Praveen Baratam wrote

Server Side Logic/Script - Triggers / StoreProc

2012-04-22 Thread Praveen Baratam
I found that Triggers are coming in Cassandra 1.2 ( https://issues.apache.org/jira/browse/CASSANDRA-1311) but no mention of any StoreProc like pattern. I know this has been discussed so many times but never met with any initiative. Even Groovy was staged out of the trunk. Cassandra is great for l

Help with Wide Rows with CounterColumns

2012-04-20 Thread Praveen Baratam
Hello All, I have a particular requirement where I need to update CounterColumns in a Row by a specific UID which is the key for the CounterColumn in that row and then query for those columns in that Row such that we get the top 5 UIDs with highest Counter Values. create column family Counters

Re: CQL Reversed and Comparator reversed=true

2012-03-26 Thread Praveen Baratam
7;UTF8Type'; > > Looks ok. > > SELECT FIRST 100 REVERSED 'z'..'0' from Comments where key = 'xyz'; > > try > SELECT FIRST 100 REVERSED * from Comments where key = 'xyz'; > > Cheers > > > ----- > Aaron

CQL Reversed and Comparator reversed=true

2012-03-23 Thread Praveen Baratam
Hello, I am a bit confused about how to store and retrieve columns in Reversed order. Currently I store comments for every blog post in a wide row per post. I want to store and retrieve comments for each blog post in reversed/descending order for efficiency as we display comments in descending o

Re: How to delete a range of columns using first N components of CompositeType Column?

2012-02-24 Thread Praveen Baratam
> You need to read and then delete by name. > > Cheers > > - > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 23/02/2012, at 8:08 PM, Praveen Baratam wrote: > > More precisely, > > Lets say we have a CF with the fol

Re: How to delete a range of columns using first N components of CompositeType Column?

2012-02-22 Thread Praveen Baratam
eType? Or should we read first and then delete? Thank You. On Thu, Feb 23, 2012 at 4:47 AM, Praveen Baratam wrote: > I am using CompositeType columns and its very convenient to query for a > range of columns using the *First N *components but how do I delete a > range of columns using th

Re: Row or Supercolumn with approximately n columns

2012-01-02 Thread Praveen Baratam
different >> rows, and Viva la Standard Column Families! >> >> Hope that helps. >> >> - >> Aaron Morton >> Freelance Developer >> @aaronmorton >> http://www.thelastpickle.com >> >> On 25/12/2011, at 7:48 PM, Pr