RE: RE: Storing user activity logs

2021-07-20 Thread MyWorld
Thanks Elliott, Sean, Manish for the quick response. On 2021/07/20 13:31:17 "Durity, Sean R" wrote: > Yes, use the time-bucketing approach and choose a bucket-size (included in the partition key) that is granular enough to keep partitions to about 100 MB in size. (Unbounded partitions WILL destroy

RE: Re: Storing user activity logs

2021-07-19 Thread MyWorld
Hi Elliott, We thought of adding month and mapping key to partition key to make it bimonthly. So our new partition key would be userid + date (mm) + mapping key (01 for date 01-15 and 02 for date 16-30). However, there could be a user who has done only 10 activities in past 6 months. So I need