Is it possible to join more than two data streams or tables in KSQL?

Is it possible to join more than two data streams or tables in KSQL?
Thanks in advance.

Tagged:

Comments

  • No, you can only join two per query in KSQL up to v5.0. You'd need to daisy-chain your queries, something like this:

    Intermediate Stream:

    CREATE STREAM ABStream AS \
    SELECT * \
    FROM StreamA a \
    JOIN StreamB b \
    ON b.aid = a.id;
    Multi- join stream

    CREATE STREAM ABCStream AS \
    SELECT * \
    FROM ABStream AB \
    JOIN StreamC c \
    WITHIN 1 HOURS \
    ON c.bid = AB.b_id;

Sign In or Register to comment.