4 ms·
According to the documentation at https://materialize.io/docs/overview/architecture/ https://materialize.io/docs/overview/architecture/ > Streaming sources mus
by vhold 7y ago
According 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