unsort 

Clears all column sort ordering metadata that may have been recorded by a prior sort verb.

The verb takes no arguments; supplying any is a compile error. The effect applies to the rest of the current OPAL pipeline: downstream stages no longer see an explicit sort order from earlier sort steps. If no sort metadata was present, unsort is effectively a no-op on that metadata.

unsort only removes sort metadata; it does not select a random sample of rows. After unsort, row order is engine-defined unless another verb establishes ordering (for example sort again).

Clearing sort metadata can reduce work when subsequent stages do not need a preserved ordering.

Categories

• Metadata

Accelerable

unsort is always accelerable if the input is accelerable. A dataset that only uses accelerable verbs can be accelerated, making queries on the dataset respond faster.

Examples

unsort

Clears any sort-column ordering metadata carried from an earlier sort so later pipeline stages do not inherit that ordering.