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.