drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Window function
Date Wed, 23 Nov 2016 13:34:07 GMT
Hi,

according to DRILL-3596 <https://issues.apache.org/jira/browse/DRILL-3596>,
lead or lag function are limited to use offset as 1.

according to documentation on postgres
lag(value any [, offset integer [, default any ]]) same type as value
returns value evaluated at the row that is offset rows before the current
row within the partition; if there is no such row, instead return default.
Both offset and default are evaluated with respect to the current row. If
omitted, offset defaults to 1 and default to null


is there any plan to allow offset according to needs but not restrict equal
to 1

usecase :

I have daily data for a month.
every day I want to do a delta with last week same day like compare monday
with monday and tuesday with tuesday so basically do a lag(col, 7)

-- 
Nitin Pawar

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message