;
>> and
>> select count(*)
>> where token(customer_id,event_time) >= token('289','2016-03-01
>> 18:45:00+')
>> and token(customer_id,event_time) <= token('289','2016-03-12
>> 19:05:00+0000') ;
>>
>
thanks. that explains it.
-Original Message-
From: Jack Krupansky
To: user
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 ha
27;,'2016-03-12
> 19:05:00+') ;
>
> 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
> To: use
question is more of academic exercise for me.
-Original Message-
From: Jack Krupansky
To: user
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 or
t; 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 loaded 1.03 million rows from a csv file.
>
> Business case: Show me all events for
typo: the primary key was (customer_id + event_time )
-Original Message-
From: Rakesh Kumar
To: user
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 loaded
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 >= '2016
