groupArraySample

    Syntax

    Parameters

    • max_size — Maximum size of the resulting array. UInt64.
    • seed — Seed for the random number generator. Optional. . Default value: 123456.
    • x — Argument (column name or expression).

    Returned values

    • Array of randomly selected x arguments.

    Examples

    Consider table colors:

    2. │  1 │ red    │
    3. │  3 │ green  │
    4. │  4 │ white  │
    5. │  5 │ orange │
    6. └────┴────────┘

    Query with column name as argument:

    2. │ ['white','blue','green']   │

    Query with column name and different seed:

    Result:

    1. ┌─newcolors──────────────────┐
    2. │ ['red','orange','green']   │
    3. └────────────────────────────┘

    Query with expression as argument:

    1. ┌─newcolors───────────────────────────────────┐
    3. └─────────────────────────────────────────────┘