Ibis: Current Window Function Support

Quansight / omnisci

Explorations on using MapD and Jupyter together.

4 stars 1 forks source link

Ibis: Current Window Function Support #33

Closed dharhas closed 4 years ago

dharhas commented 5 years ago

Land initial support for current window function impl in omnisci.

[x] rank (~2h)
[x] dense_rank (~2h)
[x] row_number (~2h)
[x] cume_dist (~2h)
[x] lag (~2h)
[x] first_value (~2h)
[x] lead (~2h)
[x] last_value (~2h)
[x] avg (~2h)
[x] min (~2h)
[x] max (~2h)
[x] count (~2h)
[x] sum (~2h)

total: ~30h

ref: https://github.com/omnisci/mapd-core/blob/master/Tests/ExecuteTest.cpp#L14107

xmnlab commented 5 years ago

First round of operations merged! https://github.com/ibis-project/ibis/pull/1771

xmnlab commented 5 years ago

Added size: 15 for the missing operations.

xmnlab commented 4 years ago

WIP PR: https://github.com/ibis-project/ibis/pull/1976

Currently there is an issue related to percent_rank and cume_dist operations: https://github.com/ibis-project/ibis/issues/1975

Currently, OmniSciDB stable version does support - 1 for window operations. This PR uses a development version of OmniSciDB (omnisci/core-os-cpu-dev:873026091ff8a12535b50ce27e08e2c95c5c01fe).

- 1 support for window operations should land on OmniSciDB on v5.0, planned for early November.

xmnlab commented 4 years ago

PS: I am moving percent_rank and ntile to new issues