Re: Correct model

2012-09-25 Thread Hiller, Dean
sandra.apache.org<mailto:user@cassandra.apache.org>" >mailto:user@cassandra.apache.org>> >Date: Monday, September 24, 2012 1:54 PM >To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" >mailto:user@cassandra.apache.org>> >Subject: Re

Re: Correct model

2012-09-25 Thread Hiller, Dean
e.org<mailto:user@cassandra.apache.org><mailto:user@cassandra.apache.org<mailto:user@cassandra.apache.org>>" mailto:user@cassandra.apache.org><mailto:user@cassandra.apache.org<mailto:user@cassandra.apache.org>>> Subject: Re: Correct model Dean, this sounds l

Re: Correct model

2012-09-25 Thread Marcelo Elias Del Valle
assandra.apache.org>> > Date: Monday, September 24, 2012 1:54 PM > To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" < > user@cassandra.apache.org<mailto:user@cassandra.apache.org>> > Subject: Re: Correct model > > Dean, this soun

Re: Correct model

2012-09-25 Thread Hiller, Dean
;user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Re: Correct model Dean, this sounds like magic :D I don't know details about the performance on the index implementations you chose, but it would pay the way to use it in my case, as I don

Re: Correct model

2012-09-24 Thread Marcelo Elias Del Valle
Marcelo Elias Del Valle mvall...@gmail.com>> > Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" < > user@cassandra.apache.org<mailto:user@cassandra.apache.org>> > Date: Monday, September 24, 2012 12:09 PM > To: "user@cassandra.apac

Re: Correct model

2012-09-24 Thread Hiller, Dean
" mailto:user@cassandra.apache.org>> Subject: Re: Correct model Dean, There is one last thing I would like to ask about playOrm by this list, the next questiosn will come by stackOverflow. Just because of the context, I prefer asking this here: When you say playOrm indexes a tabl

Re: Correct model

2012-09-24 Thread Marcelo Elias Del Valle
so it creates less noise on this > list too. > > Later, > Dean > > > From: Marcelo Elias Del Valle mvall...@gmail.com>> > Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" < > user@cassandra.apache.org<mailto:user@cassandra.

Re: Correct model

2012-09-24 Thread Hiller, Dean
Elias Del Valle mailto:mvall...@gmail.com>> Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Date: Monday, September 24, 2012 11:07 AM To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>"

Re: Correct model

2012-09-24 Thread Marcelo Elias Del Valle
2012/9/24 Hiller, Dean > I am confused. In this email you say you want "get all requests for a > user" and in a previous one you said "Select all the users which has new > requests, since date D" so let me answer both… > I have both needs. These are the two queries I need to perform on the mode

Re: Correct model

2012-09-24 Thread Hiller, Dean
your data all on one node of course. Later, Dean From: Marcelo Elias Del Valle mailto:mvall...@gmail.com>> Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Date: Monday, September 24, 2012 7:45 AM To: "user@

Re: Correct model

2012-09-24 Thread Marcelo Elias Del Valle
r, > Dean > > From: Marcelo Elias Del Valle mvall...@gmail.com>> > Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" < > user@cassandra.apache.org<mailto:user@cassandra.apache.org>> > Date: Sunday, September 23, 2012 10:23 AM >

Re: Correct model

2012-09-23 Thread aaron morton
vall...@gmail.com>> > Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" > mailto:user@cassandra.apache.org>> > Date: Sunday, September 23, 2012 10:23 AM > To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" > mai

Re: Correct model

2012-09-23 Thread Hiller, Dean
quot;user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Re: Correct model 2012/9/20 aaron morton mailto:aa...@thelastpickle.com>> I would consider: # User CF * row_key: user_id * columns: user properties, key=value # Us

Re: Correct model

2012-09-23 Thread Marcelo Elias Del Valle
2012/9/20 aaron morton > I would consider: > > # User CF > * row_key: user_id > * columns: user properties, key=value > > # UserRequests CF > * row_key: where partition_start is the start > of a time partition that makes sense in your domain. e.g. partition > monthly. Generally want to avoid row

Re: Correct model

2012-09-20 Thread aaron morton
> I created the following model: an UserCF, whose key is a userID generated by > TimeUUID, and a RequestCF, whose key is composite: UserUUID + timestamp. For > each user, I will store basic data and, for each request, I will insert a lot > of columns. I would consider: # User CF * row_key: use

Re: Correct model

2012-09-19 Thread Marcelo Elias Del Valle
> > In your first email, you get a request and seem to shove it and a user in > generating the ids which means that user never generates a request ever > again??? If a user sends multiple requests in, how are you looking up his > TimeUUID row key from your first email(I would do the same in my > i

Re: Correct model

2012-09-19 Thread Hiller, Dean
r, >Dean > >From: Marcelo Elias Del Valle >mailto:mvall...@gmail.com>> >Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" >mailto:user@cassandra.apache.org>> >Date: Wednesday, September 19, 2012 1:47 PM >To: "user@cassandra.apache.

Re: Correct model

2012-09-19 Thread Hiller, Dean
to:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Re: Correct model 2012/9/19 Hiller, Dean mailto:dean.hil...@nrel.gov>> Thinking out loud and I think a bit towards playOrm's model though you don’t' need to use playroom for this. 1. I would p

Re: Correct model

2012-09-19 Thread Marcelo Elias Del Valle
ra.apache.org>" < > user@cassandra.apache.org<mailto:user@cassandra.apache.org>> > Date: Wednesday, September 19, 2012 1:02 PM > To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" < > user@cassandra.apache.org<mailto:user@cassandra.

Re: Correct model

2012-09-19 Thread Hiller, Dean
uot;user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Date: Wednesday, September 19, 2012 1:02 PM To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Correct model

Correct model

2012-09-19 Thread Marcelo Elias Del Valle
I am new to Cassandra and NoSQL at all. I built my first model and any comments would be of great help. I am describing my thoughts bellow. It's a very simple model. I will need to store several users and, for each user, I will need to store several requests. It request has it's insertion time. As