BlazingDB / blazingsql

BlazingSQL is a lightweight, GPU accelerated, SQL engine for Python. Built on RAPIDS cuDF.
https://blazingsql.com
Apache License 2.0
1.92k stars 181 forks source link

[BUG] Window function throws stoi for ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING #1510

Closed drabastomek closed 3 years ago

drabastomek commented 3 years ago

Describe the bug At the moment cannot use this window as it throws stoi

Steps/Code to reproduce bug

import cudf
import blazingsql as bsql

bc = bsql.BlazingContext()

aaa = cudf.DataFrame({
'A': [1,1,1,2,2,3,4,5,5]
, 'B': [1,7,9,4,5,6,1,3,3]
, 'C': [3,4,10,3,4,12,3,4,11]
})
bc.create_table('aaa', aaa)

bc.sql('''
SELECT A
, B
, C
, AVG(C) OVER (PARTITION BY A ORDER BY B ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING)
FROM aaa
''')

Expected behavior An moving average is calculated

Environment overview (please complete the following information)

wmalpica commented 3 years ago

this has been resolved