Clojurians Log v2
Clojure programming
Channels
Apps
xtdb 2024-08-01
markaddleman 2024-08-01T14:48:48.111679Z
Out of curiosity, the only issue for analytic (ie, window) functions is https://github.com/xtdb/xtdb/issues/3465 . Is there more planned around analytic functions?
refset 2024-08-01T16:30:54.589859Z
Hey @markaddleman we hope to support more than just ROW_NUMBER in the not too distant future - which things would you hypothetically suggest we prioritise? 🙂
markaddleman 2024-08-01T16:31:47.785449Z
Well, if I were king for a day 🙂 … My use case is primarily about navigation functions (eg, last_value, lag, etc)
refset 2024-08-01T16:33:25.972439Z
Interesting. "lag" doesn't show up on https://cloud.google.com/bigquery/docs/reference/standard-sql/window-function-calls - am I missing some equivalent?
markaddleman 2024-08-01T16:34:24.610739Z
It’s definitely supported. Probably that page is incomplete. Check out https://cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions
👍 1
markaddleman 2024-08-01T16:35:39.440569Z
We’re also increasingly using percentile_cont to compute medians and quartiles. For some reason, that function is not available as an aggregation function in BQ - I don’t know about other databases
📝 1