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
