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