Stream ordering in Upsolver pipelines

Upsolver handles data streams ordering based on the following rules:

• the ordering within each partition or shard is preserved, as long as the number of output shards is equal or lower than the number of input shards

• data is read based on the Select statement

  • If a Union operator is used in the statement, the data sources will be processed based on the order in which they appear within the Union (standard ANSI SQL behavior)