Re: Thoughts on adding complex queries to Cassandra

2010-05-28 Thread Jeremy Davis
I wonder if any of the main project committers would like to weigh in on what a desired API would look like, or perhaps we should start an unscheduled Jira ticket? On Thu, May 27, 2010 at 5:39 PM, Jake Luciani wrote: > I had this: > > > string slice_dice_reduce(1:required list key, >

Re: Thoughts on adding complex queries to Cassandra

2010-05-27 Thread Jake Luciani
I had this: string slice_dice_reduce(1:required list key, 2:required ColumnParent column_parent, 3:required SlicePredicate predicate, 4:required ConsistencyLevel consistency_level=ONE

Re: Thoughts on adding complex queries to Cassandra

2010-05-27 Thread Jeremy Davis
I agree, I had more than filter results in mind. Though I had envisioned the results to continue to use the List (and not JSON). You could still create new result columns that do not in any way exist in Cassandra, and you could still stuff JSON in to any of result columns. I had envisioned: list g

Re: Thoughts on adding complex queries to Cassandra

2010-05-27 Thread Jake Luciani
I've secretly started working on this but nothing to show yet :( I'm calling it SliceDiceReduce or SliceReduce. The plan is to use the js thrift bindings I've added for 0.3 release of thrift (out very soon?) This will allow the supplied js to access the results like any other thrift clie

Re: Thoughts on adding complex queries to Cassandra

2010-05-27 Thread Steve Lihn
Mongo has it too. It could save a lot of development time if one can figure out porting Mongo's query API and stored javascript to Cassandra. It would be great if scala's list comprehension can be facilitated to write query-like code against Cassandra schema. On Thu, May 27, 2010 at 11:05 AM, Vick

Re: Thoughts on adding complex queries to Cassandra

2010-05-27 Thread Vick Khera
On Thu, May 27, 2010 at 9:50 AM, Jonathan Ellis wrote: > There definitely seems to be demand for something like this.  Maybe for 0.8? > The Riak data store has something like this: you can submit queries (and map reduce jobs) written in javascript that run on the data nodes using data local to th

Re: Thoughts on adding complex queries to Cassandra

2010-05-27 Thread Jonathan Ellis
There definitely seems to be demand for something like this. Maybe for 0.8? On Wed, May 26, 2010 at 4:31 PM, Jeremy Davis wrote: > > Are there any thoughts on adding a more complex query to Cassandra? > > At a high level what I'm wondering is: Would it be possible/desirable/in > keeping with the

RE: Thoughts on adding complex queries to Cassandra

2010-05-26 Thread Nicholas Sun
I'm very curious on this topic as well. Mainly, I'd like to know is this functionality handled through Map/Reduce HADOOP operations? Nick From: Jeremy Davis [mailto:jerdavis.cassan...@gmail.com] Sent: Wednesday, May 26, 2010 3:31 PM To: user@cassandra.apache.org Subject: Thoughts on addi