Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of seenutn@gmail.com designates
 209.85.192.50 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAFruNdcoVEnpdN7jXhNYVotjG-LYvhadjptmzbvnHA-3-Ufw0w@mail.gmail.com>
References: 
 <CAFruNdcoVEnpdN7jXhNYVotjG-LYvhadjptmzbvnHA-3-Ufw0w@mail.gmail.com>
Date: Fri, 23 Jan 2015 15:44:31 +0530
Message-ID: 
 <CAFruNdeFB1wnkKcJU=Raqvc04yeBQ5R9TT=Gzo8GXoZv_B7HFg@mail.gmail.com>
Subject: Re: How to store weather station Details along with monitoring data
 efficiently?
From: Srinivasa T N <seenutn@gmail.com>
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary=001a11c16782fe4cf9050d4f0d6e

--001a11c16782fe4cf9050d4f0d6e
Content-Type: text/plain; charset=UTF-8

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.

Regards,
Seenu.

On Fri, Jan 23, 2015 at 2:14 PM, Srinivasa T N <seenutn@gmail.com> 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.
>

--001a11c16782fe4cf9050d4f0d6e
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div>I forgot, my task at hand is to generate a repor=
t of all the weather station&#39;s along with the sum of temperatures measu=
red each day.<br><br></div>Regards,<br></div>Seenu.<br></div><div class=3D"=
gmail_extra"><br><div class=3D"gmail_quote">On Fri, Jan 23, 2015 at 2:14 PM=
, Srinivasa T N <span dir=3D"ltr">&lt;<a href=3D"mailto:seenutn@gmail.com" =
target=3D"_blank">seenutn@gmail.com</a>&gt;</span> wrote:<br><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;p=
adding-left:1ex"><div dir=3D"ltr"><div><div><div><div><div>Hi All,<br></div=
>=C2=A0=C2=A0 I was following the TimeSeries data modelling in PlanetCassan=
dra by Patrick McFadin.=C2=A0 Regarding that, I had one query:<br><br></div=
>If I need to store the weather station name also, should it be in the same=
 table, say:<br><br></div>create table test (wea_id int, wea_name text, wea=
_add text, eventday timeuuid, eventtime timeuuid, temp int, PRIMARY KEY ((w=
ea_id, eventday), eventtime) );<br><br></div>This forces me to enter the we=
a_name and wea_add for each new row, so how to identify a new row has been =
created?=C2=A0 Or is there any better mechanism for modeling the above data=
?<br><br></div>Regards,<br>Seenu.<br></div>
</blockquote></div><br></div>

--001a11c16782fe4cf9050d4f0d6e--