Thanks.
Basically there are two access patterns:
1) For last 1 hour (or more if last batch failed for some reason), get the
clicks data for all Ads. But it seems not possible as Ad Id is part of
Partition key.
2) For last 1 hour (or more if last batch failed for some reason), get the
clicks data
On Wed, Jan 7, 2015 at 10:18 AM, Ajay wrote:
> Hi,
>
> I have a column family as below:
>
> (Wide row design)
> CREATE TABLE clicks (hour text,adId int,itemId int,time timeuuid,PRIMARY
> KEY((adId, hour), time, itemId)) WITH CLUSTERING ORDER BY (time DESC);
>
> Now to query for a given Ad Id and
Hi,
I have a column family as below:
(Wide row design)
CREATE TABLE clicks (hour text,adId int,itemId int,time timeuuid,PRIMARY
KEY((adId, hour), time, itemId)) WITH CLUSTERING ORDER BY (time DESC);
Now to query for a given Ad Id and specific 3 hours say 2015-01-07 11 to
2015-01-07 14, how do I
