Data LakeData Lake User Guide

Table of Contents

Exabeam Data Lake Sort Logic

The following is the sorting order using in Data Lake. Note that leading spaces are given greater weight than all other character or number when records are sorted.

Ascending order is:

  1. Blank spaces (' ').

  2. Underscore ('_').

  3. Numeric characters.

  4. Lower case alphabetic character.

  5. Upper case alphabetic character.

  6. Field values longer than maximum char limit of 256).

Descending order is:

The reverse of the above.

The following is an example of ascending order:

david

David

_david

_David

1david

2david

3david

david

daVid

daVid

David