Re: timezone time series data model

2012-05-02 Thread samal
this will work.I have tried both gave one day unique bucket. I just realized, If I sync all clients to one zone then date will remain same for all. One Zone date will give materialize view to row. On Mon, Apr 30, 2012 at 11:43 PM, samal samalgo...@gmail.com wrote: hhmm. I will try both.

timezone time series data model

2012-04-30 Thread samal
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

Re: timezone time series data model

2012-04-30 Thread Tyler Hobbs
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

Re: timezone time series data model

2012-04-30 Thread samal
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

Re: timezone time series data model

2012-04-30 Thread Tyler Hobbs
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

Re: timezone time series data model

2012-04-30 Thread samal
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);

Re: timezone time series data model

2012-04-30 Thread Tyler Hobbs
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 samalgo...@gmail.com wrote: I did it with node.js but it is

Re: timezone time series data model

2012-04-30 Thread samal
thanks I didn't noticed. run script for 5 minutes = divide seems to produce result ,modulo is still changing. If divide is ok will do the trick. I will run this script on Singapore, East coast server, and New delhi server whole night today. == unix =

Re: timezone time series data model

2012-04-30 Thread Tyler Hobbs
Err, sorry, I should have said ts - (ts % 86400). Integer division does something similar. On Mon, Apr 30, 2012 at 12:39 PM, samal samalgo...@gmail.com wrote: thanks I didn't noticed. run script for 5 minutes = divide seems to produce result ,modulo is still changing. If divide is ok will

Re: timezone time series data model

2012-04-30 Thread samal
hhmm. I will try both. thanks On Mon, Apr 30, 2012 at 11:29 PM, Tyler Hobbs ty...@datastax.com wrote: Err, sorry, I should have said ts - (ts % 86400). Integer division does something similar. On Mon, Apr 30, 2012 at 12:39 PM, samal samalgo...@gmail.com wrote: thanks I didn't noticed.