Late Rows

A late row is a row that arrives out of time sequence. SQLstream enforces the rule that ROWTIME must be monontonically increasing.

In a streaming view we can promote any TIMESTAMP column (eg event_timestamp) to be ROWTIME - see Promoting event time as ROWTIME; however any rows where event_timestamp is less than the highest value of that column seen so far will be discarded.

We can reduce (or eliminate) the number of rows being discarded by using a T-Sort in the same view that promotes event_time to ROWTIME. For more information see Managing Late Rows in the Concepts Guide.