cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Srinivasa T N <>
Subject Re: How to store weather station Details along with monitoring data efficiently?
Date Fri, 23 Jan 2015 10:14:31 GMT
I forgot, my task at hand is to generate a report of all the weather
station's along with the sum of temperatures measured each day.


On Fri, Jan 23, 2015 at 2:14 PM, Srinivasa T N <> wrote:

> Hi All,
>    I was following the TimeSeries data modelling in PlanetCassandra by
> Patrick McFadin.  Regarding that, I had one query:
> If I need to store the weather station name also, should it be in the same
> table, say:
> create table test (wea_id int, wea_name text, wea_add text, eventday
> timeuuid, eventtime timeuuid, temp int, PRIMARY KEY ((wea_id, eventday),
> eventtime) );
> This forces me to enter the wea_name and wea_add for each new row, so how
> to identify a new row has been created?  Or is there any better mechanism
> for modeling the above data?
> Regards,
> Seenu.

View raw message