Correct, that's exactly what I'm saying.
On Mon, Apr 30, 2012 at 10:37 AM, samal <samalgo...@gmail.com> wrote:
> thanks tyler for reply.
>
> are you saying user1uuid_*{ts%86400}* would lead to unique day bucket
> which will be timezone {NZ to US} independent? I will try.
>
>
> On Mon, Apr 30, 2012 at 8:25 PM, Tyler Hobbs <ty...@datastax.com> wrote:
>
>> Don't use dates or datestamps as the buckets for your row keys, use a
>> unix timestamp modulo whatever size you want your bucket to be instead.
>> Timestamps don't involve time zones or any of that nonsense.
>>
>> So, instead of having keys like "user1uuid_30042012", the second half
>> would be replaced the current unix timestamp mod 86400 (the number of
>> seconds in a day).
>>
>>
>> On Mon, Apr 30, 2012 at 1:46 AM, samal <samalgo...@gmail.com> wrote:
>>
>>> Hello List,
>>>
>>> I need suggestion/ recommendation on time series data.
>>>
>>> I have requirement where users belongs to different timezone and they
>>> can subscribe to global group.
>>> When users at specific timezone send update to group it is available to
>>> every user in different timezone.
>>>
>>> I am using GroupSubscribedUsers CF where all update to group are push to
>>> "Each User" time line, and key is timelined by useruuid_date(one day update
>>> of all groups) and columns are group updates.
>>>
>>> GroupSubscribedUsers ={
>>> user1uuid_30042012:{//this user belongs to same timezone
>>> timeuuid1:JSON[group1update1]
>>> timeuuid2:JSON[group2update2]
>>> timeuuid3:JSON[group1update2]
>>> timeuuid4:JSON[group4update1]
>>> },
>>> user2uuid_30042012:{//this user belongs to different timezone where
>>> date has changed already to 1may but 30 april is getting update
>>> timeuuid1:JSON[group1update1]
>>> timeuuid2:JSON[group2update2]
>>> timeuuid3:JSON[group1update2]
>>> timeuuid4:JSON[group4update1]
>>> timeuuid5:JSON[groupNupdate1]
>>> },
>>>
>>> }
>>>
>>> I have noticed this approach is good for single time zone when
>>> different timezone come into picture it breaks.
>>>
>>> I am thinking of like when user pushed update to group ->get user who is
>>> subscribed to group->check user timezone->push time series in user time
>>> zone. So for one user update will be on 30april where as other may have on
>>> 29april and 1may, using timestamps i can find out hours ago update came.
>>>
>>> Is there any better approach?
>>>
>>>
>>> Thanks,
>>>
>>> >>>Samal
>>>
>>>
>>>
>>
>>
>> --
>> Tyler Hobbs
>> DataStax <http://datastax.com/>
>>
>>
>
--
Tyler Hobbs
DataStax <http://datastax.com/>
