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.