search

confluentinc / ksql

The database purpose-built for stream processing applications.
https://ksqldb.io
Other
76 stars 1.04k forks source link

KSQL Incremental Materialized Views Outer Join Support #10064

Open koureasstavros opened 1 year ago

koureasstavros commented 1 year ago

When I first heard about KSQL (a streaming database for real time analytics) I though this is it, maybe it could work for small datawarehouses in real time. So I started reading about Materialized Views and I though that the most common RDBMs limitations will not be present into incremental materialized views like outer joins and many aggregate functions in combination.

From documentation, I managed to spot that only inner joins are supported, right?

TheDarkFlame commented 12 months ago

materialized views are tables derived from other ksqldb collections (streams/tables) https://docs.ksqldb.io/en/latest/concepts/materialized-views/ Materialized views are a type of table

https://docs.ksqldb.io/en/latest/developer-guide/joins/join-streams-and-tables/#table-table-joins

For primary-key joins INNER, LEFT OUTER, and FULL OUTER joins are supported. For foreign-key joins INNER and LEFT OUTER joins are supported.

What exactly are you trying to do that you're not sure about?