Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.6.0
    • Component/s: stream
    • Labels:
      None

      Description

      Stream joins are used to relate information from different streams or stream and relation combinations. Calcite lacks (proper) support for stream-to-relation joins and stream-to-stream joins.

      stream-to-relation join like below fails at the SQL validation stage.

      select stream orders.orderId, orders.productId, products.name from orders join products on orders.productId = products.id

      But if 'products' is a stream, the query is valid according to Calcite, even though the stream-to-stream join in above query is not valid due to unbounded nature of streams.

        Attachments

        1. CALCITE-968-0.patch
          13 kB
          Milinda Lakmal Pathirage

          Issue Links

            Activity

              People

              • Assignee:
                julianhyde Julian Hyde
                Reporter:
                milinda Milinda Lakmal Pathirage
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: