SORT - Amazon Glue DataBrew
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

SORT

Sorts the data in one or more columns of a dataset in ascending, descending, or custom order.

Parameters
  • expressions – A string that contains one or more JSON-encoded strings representing sorting expressions.

    • sourceColumn – A string that contains the name of an existing column.

    • ordering – Ordering can be either ASCENDING or DESCENDING.

    • nullsOrdering – Nulls ordering can be either NULLS_TOP or NULLS_BOTTOM to place null or missing values at the beginning or at the bottom of the column.

    • customOrder – A list of strings that defines a custom order for the string sorting. By default, strings are sorted alphabetically.

    • isCustomOrderCaseSensitive – Boolean. The default value is false.

Example

{ "RecipeAction": { "Operation": "SORT", "Parameters": { "expressions": "[{\"sourceColumn\": \"A\", \"ordering\": \"ASCENDING\", \"nullsOrdering\": \"NULLS_TOP\"}]", } } }

Example of custom sort order

In the following example, the customOrder expression string has the format of a list of objects. Each object describes a sorting expression for one column.

[ { "sourceColumn": "A", "ordering": "ASCENDING", "nullsOrdering": "NULLS_TOP", }, { "sourceColumn": "B", "ordering": "DESCENDING", "nullsOrdering": "NULLS_BOTTOM", "customOrder": ["Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun"], "isCustomOrderCaseSensitive": false, } ]