Apply Aggregation Without Group By

google / weather-tools

Tools to make weather data accessible and useful.

https://weather-tools.readthedocs.io/

Apache License 2.0

216 stars 40 forks source link

Apply Aggregation Without Group By #429

Closed DarshanSP19 closed 10 months ago

DarshanSP19 commented 10 months ago

Now the aggregation works without a group by clause. Queries like below are now supported.

SELECT
  MIN(temperature)
FROM 'gs://gcp-public-data-arco-era5/ar/full_37-1h-0p25deg-chunk-1.zarr-v3'
WHERE
  time >= '2023-01-01' AND
  time < '2023-02-01'