Details
-
Sub-task
-
Status: Closed
-
Major
-
Resolution: Implemented
-
None
-
None
Description
Similar to the SQL, window clause is defined "as" a symbol which is explicitly used in groupby/over. We are proposing to refactor the way to write groupby+window tableAPI as follows:
tab //Table('a,'b,'c) .window( Slide over 10.milli every 5.milli as 'w1as 'w1) // WindowedTable .groupBy('w1,'a,'b) // WindowGroupedTable .select('a,'b,c.count as 'mycount) // Table .window(Tumble over 5.milli on 'b as 'w2) .groupBy('w2) .select('a.count, 'w2.start, 'w2.end)
In this way, for row-window, we anyway need to define window clause as a symbol. This change will make the API of window and row-window consistent, example for row-window:
.window(RowXXXWindow as ‘x, RowYYYWindow as ‘y) // WindowedTable
.select(‘a, ‘b.count over ‘x as ‘xcnt, ‘c.count over ‘y as ‘ycnt, ‘x.start, ‘x.end)
Attachments
Issue Links
- links to
