Handle Negative Values In Where Condition

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

Handle Negative Values In Where Condition #452

Closed DarshanSP19 closed 8 months ago

DarshanSP19 commented 8 months ago

Support query like below which contains negative values in conditions.

SELECT AVG(temperature) FROM 'gs://darshan-store/ar/2013-2022-full_37-1h-0p25deg-chunk-1.zarr-v3' WHERE time >= '2015-01-01' AND time < '2015-02-01' AND latitude > 40 AND latitude < 41 AND longitude > -86 AND longitude < -90 GROUP BY time_date