VECTOR_ ELEMENTS_ SUM
On this page
Returns the sum of all elements of a vector expression.
It is a scalar function.
Syntax
VECTOR_ELEMENTS_SUM(vector_expression)
Arguments
-
vector_
: An expression that evaluates to a vector.expression The vector must be encoded as a blob containing packed single-precision or double-precision floating-point numbers in little-endian byte order.
Return Type
An element sum (64-bit signed integer for integer versions and 64-bit floating-point number for float versions).
Remarks
A vector can be of any length, but the input blob length must be divisible by the packed vector element size (1, 2, 4 or 8 bytes, depending on the vector element).
You can specify the datatype of the vector elements in which this operation is performed on the vector by adding a suffix to the function._
.
Suffix |
Datatype |
---|---|
|
8-bit signed integer |
|
16-bit signed integer |
|
32-bit signed integer |
|
64-bit signed integer |
|
32-bit floating-point number (IEEE standard format) |
|
64-bit floating-point number (IEEE standard format) |
Examples
CREATE TABLE ves_t (x BLOB);INSERT INTO ves_t VALUES (JSON_ARRAY_PACK('[4,3,1,5,2]'));
SELECT VECTOR_ELEMENTS_SUM(x) AS x from ves_t;
+------+
| x |
+------+
| 15 |
+------+
Last modified: February 28, 2023