Support for # PRECEDING?

[Jiang Wu <ji...@numerxdata.com>]

I am looking at the Drill documentation and saw that it supports this:

{ RANGE | ROWS } frame_start
{ RANGE | ROWS } BETWEEN frame_start AND frame_end

where frame_start is

UNBOUNDED PRECEDING
CURRENT ROW

The above is good for us to do cumulative sums over a data frame. Now related to this, is there support for frame_start and frame_end to support:

unsigned-integer PRECEDING
unsigned-integer FOLLOWING

The above would allow us to compute aggregate over a moving data frame.  If there is no support for PRECEDING/FOLLOWING, is there another way to create a moving window?

Thanks.

-- Jiang