ARR_AVG

Syntax

ARR_AVG( array )

Description

Returns the average of elements in the array.

Argument types:

  • arrayArray of fractional numbers | Array of integers

Return type: Fractional number

Note

This function cannot work with arrays with Nullable items. To remove NULL items from the array, use REPLACE.

Example

[int_array] [float_array] ARR_AVG([int_array]) ARR_AVG([float_array])
'[21,12,0]' '[14.3,0.42,15]' 11.00 9.91
'[-4,12,0]' '[0,-3,12]' 2.67 3.00
'[5,7,9]' '[3.2,2.3,3.2]' 7.00 2.90

Data source support

ClickHouse 21.8.

Previous