any help on this ? from class NoFrameSupportTemplate, I see that inIndex is hard coded to point to previous row in case of lag and next row in case of lead. Is there a way I can modify this and pass it as parameter to pic appropriate row? On Fri, Nov 25, 2016 at 2:57 PM, Nitin Pawar wrote: > adding dev list for comments > > On Wed, Nov 23, 2016 at 7:04 PM, Nitin Pawar > wrote: > >> Hi, >> >> according to 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 > -- Nitin Pawar