cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tyler Hobbs <ty...@datastax.com>
Subject Re: timezone time series data model
Date Mon, 30 Apr 2012 17:14:47 GMT
getTime() returns the number of milliseconds since the epoch, not the
number of seconds: http://www.w3schools.com/jsref/jsref_gettime.asp

If you divide that number by 1000, it should work.

On Mon, Apr 30, 2012 at 11:28 AM, samal <samalgorai@gmail.com> wrote:

> I did it with node.js but it is changing after some interval.
>
> <code>
> setInterval(function(){
>   var d =new Date().getTime();
>   console.log("====================== ");
>   console.log("unix         =>  ",d);
>   i=parseInt(d)
>   console.log("Divid i/86400=>  ",i/86400);
>   console.log("Modulo i%86400=> ",i%86400);
>   console.log("====================== ");
> },2000);
>
> </code>
> Am I doing wrong?
>
>
> On Mon, Apr 30, 2012 at 9:54 PM, Tyler Hobbs <tyler@datastax.com> wrote:
>
>> Correct, that's exactly what I'm saying.
>>
>>
>> On Mon, Apr 30, 2012 at 10:37 AM, samal <samalgorai@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 <tyler@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 <samalgorai@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/>
>>
>>
>


-- 
Tyler Hobbs
DataStax <http://datastax.com/>

Mime
View raw message