You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@vxquery.apache.org by Till Westmann <we...@gmail.com> on 2013/11/27 22:13:07 UTC
Re: svn commit: r1546152 - in /incubator/vxquery/trunk/vxquery/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries:
q00.xq q01.xq q02.xq q03.xq q04.xq q05.xq q_test_00.xq q_test_01.xq q_test_02.xq
On Wed, Nov 27, 2013 at 10:23 AM, <pr...@apache.org> wrote:
> Modified:
> incubator/vxquery/trunk/vxquery/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q01.xq
> URL:
> http://svn.apache.org/viewvc/incubator/vxquery/trunk/vxquery/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q01.xq?rev=1546152&r1=1546151&r2=1546152&view=diff
>
> ==============================================================================
> ---
> incubator/vxquery/trunk/vxquery/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q01.xq
> (original)
> +++
> incubator/vxquery/trunk/vxquery/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q01.xq
> Wed Nov 27 18:23:52 2013
> @@ -1,6 +1,6 @@
> (: XQuery Filter Query :)
> -(: Select all the sensor readings for 1951 :)
> -let $collection := "/tmp/test/1.0_partition_ghcnd_gsn_xml_gz/sensors"
> +(: Find all reading for hurricane force wind warning or extreme wind
> warning. The warnings occur when the wind speed (AWND) exceeds 110 mph
> (49.1744 meters per second). :)
> +let $collection := "/tmp/test/1.0_partition_ghcnd_all_xml/sensors"
> for $r in collection($collection)/dataCollection/data
> -where fn:starts-with($r/date, "1951")
> +where $r/dataType eq "AWND" and $r/value > 491.744
> return $r
> \ No newline at end of file
>
I see that the comment says "49.1744 meters per second" while the query
uses "491.744".
Is that a typo of is the unit for the value dm/s?
Cheers,
Till
Re: svn commit: r1546152 - in /incubator/vxquery/trunk/vxquery/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries:
q00.xq q01.xq q02.xq q03.xq q04.xq q05.xq q_test_00.xq q_test_01.xq q_test_02.xq
Posted by Eldon Carman <ec...@ucr.edu>.
That was on purpose. Most of the weather measurements are in tenths of a
unit. We must convert the units to or from whole number when querying.
On Wed, Nov 27, 2013 at 1:13 PM, Till Westmann <we...@gmail.com> wrote:
> On Wed, Nov 27, 2013 at 10:23 AM, <pr...@apache.org> wrote:
>
> > Modified:
> >
> incubator/vxquery/trunk/vxquery/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q01.xq
> > URL:
> >
> http://svn.apache.org/viewvc/incubator/vxquery/trunk/vxquery/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q01.xq?rev=1546152&r1=1546151&r2=1546152&view=diff
> >
> >
> ==============================================================================
> > ---
> >
> incubator/vxquery/trunk/vxquery/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q01.xq
> > (original)
> > +++
> >
> incubator/vxquery/trunk/vxquery/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q01.xq
> > Wed Nov 27 18:23:52 2013
> > @@ -1,6 +1,6 @@
> > (: XQuery Filter Query :)
> > -(: Select all the sensor readings for 1951 :)
> > -let $collection := "/tmp/test/1.0_partition_ghcnd_gsn_xml_gz/sensors"
> > +(: Find all reading for hurricane force wind warning or extreme wind
> > warning. The warnings occur when the wind speed (AWND) exceeds 110 mph
> > (49.1744 meters per second). :)
> > +let $collection := "/tmp/test/1.0_partition_ghcnd_all_xml/sensors"
> > for $r in collection($collection)/dataCollection/data
> > -where fn:starts-with($r/date, "1951")
> > +where $r/dataType eq "AWND" and $r/value > 491.744
> > return $r
> > \ No newline at end of file
> >
>
> I see that the comment says "49.1744 meters per second" while the query
> uses "491.744".
> Is that a typo of is the unit for the value dm/s?
>
> Cheers,
> Till
>