groupArrayInsertAt

Inserts a value into the array at the specified position.

groupArrayInsertAt

Introduced in: v1.1.0

Inserts a value into the array at the specified position.

If in one query several values are inserted into the same position, the function behaves in the following ways:

• If a query is executed in a single thread, the first one of the inserted values is used.
• If a query is executed in multiple threads, the resulting value is an undetermined one of the inserted values.

Syntax

groupArrayInsertAt(default_x, size)([x, pos])

Parameters

• default_x — Optional. Default value for substituting in empty positions. Any
• size — Optional. Length of the resulting array. When using this parameter, the default value default_x must be specified. UInt32

Arguments

• x — Value to be inserted. Any
• pos — Position at which the specified element x is to be inserted. Index numbering in the array starts from zero. UInt32

Returned value

Returns an array with inserted values. Array

Examples

Basic usage without parameters

Query

SELECT groupArrayInsertAt(toString(number), number * 2) FROM numbers(5);

Response

┌─groupArrayInsertAt(toString(number), multiply(number, 2))─┐
│ ['0','','1','','2','','3','','4']                         │
└───────────────────────────────────────────────────────────┘

Usage with default value parameter

Query

SELECT groupArrayInsertAt('-')(toString(number), number * 2) FROM numbers(5);

Response

┌─groupArrayInsertAt('-')(toString(number), multiply(number, 2))─┐
│ ['0','-','1','-','2','-','3','-','4']                          │
└────────────────────────────────────────────────────────────────┘

Usage with default value and size parameters

Query

SELECT groupArrayInsertAt('-', 5)(toString(number), number * 2) FROM numbers(5);

Response

┌─groupArrayInsertAt('-', 5)(toString(number), multiply(number, 2))─┐
│ ['0','-','1','-','2']                                             │
└───────────────────────────────────────────────────────────────────┘

Multi-threaded insertion into same position

Query

SELECT groupArrayInsertAt(number, 0) FROM numbers_mt(10) SETTINGS max_block_size = 1;

Response

┌─groupArrayInsertAt(number, 0)─┐
│ [7]                           │
└───────────────────────────────┘