Details

    • Type: Task
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.7.0
    • Component/s: stream
    • Labels:
      None

      Description

      The goal of the "Streaming" page (1) on the Calcite website is to define a SQL syntax for queries that can be applied on continuous data streams as well as static tables.
      However, it does not reflect the current state of discussion and should be updated.

      • Update the syntax to define tumbling and hopping windows as proposed on the dev mailing list (2).
      • Relax the requirement of for a monotonic expression / attribute and allow for expressions which are slightly out-of-order but guarded by punctuations (or watermarks, ) as discussed on the dev mailing list (3).

      (1) http://calcite.apache.org/docs/stream.html
      (2) http://mail-archives.apache.org/mod_mbox/calcite-dev/201506.mbox/%3CCAPSgeETbowxM2TRX0RFxQ_tEAPk2uM=hE0aryWinBtovGwbddQ@mail.gmail.com%3E
      (3) https://mail-archives.apache.org/mod_mbox/calcite-dev/201602.mbox/%3CCAPSgeETRKJb1D9oV3YMjLsyxXFkvUhHivZOHzZDOZSAmWOSg4Q%40mail.gmail.com%3E

        Issue Links

          Activity

          Hide
          julianhyde Julian Hyde added a comment -

          Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/884f0106. Added the new TUMBLE and HOP, sections on stream-to-table and stream-to-stream JOIN, GROUPING SETS, DML, the "pie chart" problem, the new "quasi-monotonic" concept, a section discussing punctuation, watermarks & latency, and a diagram of window types.

          Also added a schema called ORINOCO so that we can write Quidem tests against the Products/Orders/Shipments schema (though not streaming queries, yet).

          Show
          julianhyde Julian Hyde added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/884f0106 . Added the new TUMBLE and HOP, sections on stream-to-table and stream-to-stream JOIN, GROUPING SETS, DML, the "pie chart" problem, the new "quasi-monotonic" concept, a section discussing punctuation, watermarks & latency, and a diagram of window types. Also added a schema called ORINOCO so that we can write Quidem tests against the Products/Orders/Shipments schema (though not streaming queries, yet).
          Hide
          julianhyde Julian Hyde added a comment -

          Resolved in release 1.7.0 (2016-03-22).

          Show
          julianhyde Julian Hyde added a comment - Resolved in release 1.7.0 (2016-03-22).

            People

            • Assignee:
              julianhyde Julian Hyde
              Reporter:
              fhueske Fabian Hueske
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development