bigfunctions > median_value

median_value

Signature

median_value(arr)

Description

Return median value of array (inspired from sql-snippets repo)

Examples

1. When array length is odd

EUUSeurope-west1

select bigfunctions.eu.median_value([1, 4, 3])

select bigfunctions.us.median_value([1, 4, 3])

select bigfunctions.europe_west1.median_value([1, 4, 3])

+-------+
| value |
+-------+
| 3     |
+-------+

2. When array length is even

EUUSeurope-west1

select bigfunctions.eu.median_value([1, 4, 3, 2])

select bigfunctions.us.median_value([1, 4, 3, 2])

select bigfunctions.europe_west1.median_value([1, 4, 3, 2])

+-------+
| value |
+-------+
| 2.5   |
+-------+