unsort

Type of operation: Metadata

Description

Remove all column sort ordering metadata that may have been inserted by the sort verb for the rest of the current OPAL pipeline. It is a no-op if no previous sort verb was used. This verb can be used for performance reasons by removing sort column ordering from being applied further in the OPAL query pipeline. It can also be used to clear all previous sort ordering and see a random sample of rows from their dataset with no particular sort applied.

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.