Designing date range table where I track the userId, the activity and the day activity was performed.
Key format is <userId activityId YYDDMM> (using space as separator) to avoid hot-spots by having the date as last part of the key. Now I can easily find the activities done by user 'X' using PrefixFilter. But how do I go about finding user activities between date ranges? thanks
