Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Implemented
    • Affects Version/s: None
    • Fix Version/s: 1.2.0, 1.3.0
    • Component/s: Table API & SQL
    • Labels:
      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)
      

      What do you think? Fabian Hueske Timo Walther

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sunjincheng121 sunjincheng
                Reporter:
                sunjincheng121 sunjincheng
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: