4 ms·
Looks promising! Can materialized views be backfilled?
by gbrits 7y ago
Looks promising! Can materialized views be backfilled?
- deleted 7y ago[deleted]
- vhold 7y agoAccording to the documentation at https://materialize.io/docs/overview/architecture/ 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/ https://materialize.io/docs/sql/select/ Perhaps just an oversight in the documentation?
- benesch 7y agoGood catch, thanks! I've filed an issue about this: https://github.com/MaterializeInc/materialize/issues/2056 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 https://www.postgresql.org/docs/current/queries-union.html