-- vector_avg
SELECT vector_avg(col) FROM VALUES (array(1.0F, 2.0F)), (array(3.0F, 4.0F)) AS tab(col);
+---------------+
|vector_avg(col)|
+---------------+
|     [2.0, 3.0]|
+---------------+

-- vector_cosine_similarity
SELECT vector_cosine_similarity(array(1.0F, 2.0F, 3.0F), array(4.0F, 5.0F, 6.0F));
+--------------------------------------------------------------------+
|vector_cosine_similarity(array(1.0, 2.0, 3.0), array(4.0, 5.0, 6.0))|
+--------------------------------------------------------------------+
|                                                          0.97463185|
+--------------------------------------------------------------------+

-- vector_inner_product
SELECT vector_inner_product(array(1.0F, 2.0F, 3.0F), array(4.0F, 5.0F, 6.0F));
+----------------------------------------------------------------+
|vector_inner_product(array(1.0, 2.0, 3.0), array(4.0, 5.0, 6.0))|
+----------------------------------------------------------------+
|                                                            32.0|
+----------------------------------------------------------------+

-- vector_l2_distance
SELECT vector_l2_distance(array(1.0F, 2.0F, 3.0F), array(4.0F, 5.0F, 6.0F));
+--------------------------------------------------------------+
|vector_l2_distance(array(1.0, 2.0, 3.0), array(4.0, 5.0, 6.0))|
+--------------------------------------------------------------+
|                                                      5.196152|
+--------------------------------------------------------------+

-- vector_norm
SELECT vector_norm(array(3.0F, 4.0F), 2.0F);
+---------------------------------+
|vector_norm(array(3.0, 4.0), 2.0)|
+---------------------------------+
|                              5.0|
+---------------------------------+

SELECT vector_norm(array(3.0F, 4.0F), 1.0F);
+---------------------------------+
|vector_norm(array(3.0, 4.0), 1.0)|
+---------------------------------+
|                              7.0|
+---------------------------------+

SELECT vector_norm(array(3.0F, 4.0F), float('inf'));
+---------------------------------+
|vector_norm(array(3.0, 4.0), inf)|
+---------------------------------+
|                              4.0|
+---------------------------------+

-- vector_normalize
SELECT vector_normalize(array(3.0F, 4.0F), 2.0F);
+--------------------------------------+
|vector_normalize(array(3.0, 4.0), 2.0)|
+--------------------------------------+
|                            [0.6, 0.8]|
+--------------------------------------+

SELECT vector_normalize(array(3.0F, 4.0F), 1.0F);
+--------------------------------------+
|vector_normalize(array(3.0, 4.0), 1.0)|
+--------------------------------------+
|                  [0.42857143, 0.57...|
+--------------------------------------+

SELECT vector_normalize(array(3.0F, 4.0F), float('inf'));
+--------------------------------------+
|vector_normalize(array(3.0, 4.0), inf)|
+--------------------------------------+
|                           [0.75, 1.0]|
+--------------------------------------+

-- vector_sum
SELECT vector_sum(col) FROM VALUES (array(1.0F, 2.0F)), (array(3.0F, 4.0F)) AS tab(col);
+---------------+
|vector_sum(col)|
+---------------+
|     [4.0, 6.0]|
+---------------+