unsort#

Type of operation: Metadata

Description#

Remove all column sort ordering metadata that may have been inserted by the sort verb.

This verb affects execution for the rest of the current OPAL pipeline.

unsort is a no-op if no previous sort verb was used.

unsort can be used for performance reasons, or to clear all previous sort ordering and see a random sample of rows from their dataset.

Usage#

unsort 

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

Removes all column ordering sort metadata that may have been inserted by the sort verb.