adding dev list for comments On Wed, Nov 23, 2016 at 7:04 PM, Nitin Pawar <nitinpawar...@gmail.com> wrote:
> 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 > -- Nitin Pawar