Re: What is wrong in this token function

2016-03-11 Thread Matt Kennedy
m> > To: user <user@cassandra.apache.org> > Sent: Thu, Mar 10, 2016 5:28 pm > Subject: Re: What is wrong in this token function > > From the doc: "When using the RandomPartitioner or Murmur3Partitioner, > Cassandra rows are ordered by the hash of their value and hence

Re: What is wrong in this token function

2016-03-10 Thread Rakesh Kumar
thanks. that explains it. -Original Message- From: Jack Krupansky <jack.krupan...@gmail.com> To: user <user@cassandra.apache.org> Sent: Thu, Mar 10, 2016 5:28 pm Subject: Re: What is wrong in this token function >From the doc: "When using the RandomPartitioner o

Re: What is wrong in this token function

2016-03-10 Thread Jack Krupansky
0+') ; > > are not same ? > > And yes I am aware of how to change the clustering_key to get the first > query. This question is more of academic exercise for me. > > > -Original Message- > From: Jack Krupansky <jack.krupan...@gmail.com> > To: user <use

Re: What is wrong in this token function

2016-03-10 Thread Rakesh Kumar
ge- From: Jack Krupansky <jack.krupan...@gmail.com> To: user <user@cassandra.apache.org> Sent: Thu, Mar 10, 2016 4:55 pm Subject: Re: What is wrong in this token function What partitioner are you using? The default partitioner is not "ordered", so it will randomly order

Re: What is wrong in this token function

2016-03-10 Thread Jack Krupansky
: Rakesh Kumar <dcrunch...@aim.com> > To: user <user@cassandra.apache.org> > Sent: Thu, Mar 10, 2016 4:44 pm > Subject: What is wrong in this token function > > C* 3.0.3 > > I have a table table1 which has the primary key on > ((customer_id,event_id)). > > I loa

Re: What is wrong in this token function

2016-03-10 Thread Rakesh Kumar
typo: the primary key was (customer_id + event_time ) -Original Message- From: Rakesh Kumar <dcrunch...@aim.com> To: user <user@cassandra.apache.org> Sent: Thu, Mar 10, 2016 4:44 pm Subject: What is wrong in this token function C* 3.0.3 I have a table table1 which has

What is wrong in this token function

2016-03-10 Thread Rakesh Kumar
C* 3.0.3 I have a table table1 which has the primary key on ((customer_id,event_id)). I loaded 1.03 million rows from a csv file. Business case: Show me all events for a given customer in a given time frame In RDBMS it will be (Query1) where customer_id = '289' and event_time >=