Comment on Materialize: A Streaming Data WarehouseComments−gbrits6yLooks promising! Can materialized views be backfilled?−vhold6yAccording to the documentation at https://materialize.io/docs/overview/architecture/Streaming sources must receive all of their data from the stream itself; there is no way to “seed” a streaming source with static data. However, you can union streaming and file sources in views, which accomplishes a similar outcome.What I find odd is that the documentation doesn't show UNION support in the SELECT documentation : https://materialize.io/docs/sql/select/Perhaps just an oversight in the documentation?−benesch6yGood catch, thanks! I've filed an issue about this: https://github.com/MaterializeInc/materialize/issues/2056Though it's not yet documented, we do support all of the SQL set operations [0]: UNION [ALL], INTERSECT [ALL], and EXCEPT [ALL].[0]: https://www.postgresql.org/docs/current/queries-union.html
Comments
Looks promising! Can materialized views be backfilled?
According to the documentation at https://materialize.io/docs/overview/architecture/
What I find odd is that the documentation doesn't show UNION support in the SELECT documentation : https://materialize.io/docs/sql/select/
Perhaps just an oversight in the documentation?
Good catch, thanks! I've filed an issue about this: https://github.com/MaterializeInc/materialize/issues/2056
Though it's not yet documented, we do support all of the SQL set operations [0]: UNION [ALL], INTERSECT [ALL], and EXCEPT [ALL].
[0]: https://www.postgresql.org/docs/current/queries-union.html