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
