• Home
• org.apache.vxquery
• apache-vxquery-benchmark
• 0.6
• source code
• q06.mrql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

noaa-ghcn-daily.other_systems.mrql.q06.mrql Maven / Gradle / Ivy

/*
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements. See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The ASF licenses this file to You under the Apache License, Version 2.0
 * (the "License"); you may not use this file except in compliance with
 * the License. You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
select (n, d, v)
from sensors in source(xml, args[0], {"data"}),
    d in sensors.date,
    v in sensors.value,
    stations in source(xml, args[1], {"station"}),
    n in stations.displayName
where text(stations.id) = text(sensors.station) 
    and toInt(substring(text(d), 0, 4)) = 2000
    and text(sensors.dataType) = "TMAX"
;