ibis-bigquery icon indicating copy to clipboard operation
ibis-bigquery copied to clipboard
verified publisher icon ibis-project

BQ: Rewrite lead/lag with negative offsets into lag/lead with positive offsets

Open tsdlovell opened this issue 8 years ago • 1 comments

expr.column.lag(-1) is invalid

BadRequest: 400 POST https://www.googleapis.com/bigquery/v2/projects/<project>/queries: Argument 2 to LAG must be at least LAG; got 0.

tsdlovell avatar Feb 12 '18 16:02 tsdlovell

I think we actually want to rewrite lead/lag with negative offsets into lag/lead with positive offsets.

Marking for 0.14

cpcloud avatar Feb 13 '18 16:02 cpcloud