VECTOR_ADD
Returns an array that is the sum of two input arrays.
Syntax
VECTOR_ADD(<array>, <array>)
Parameters
| Parameter | Description | Supported input types |
|---|
<array> | The first array in the addition calculation. | Any array of numeric data types. |
<array> | The second array in the addition calculation. | Any array of numeric data types. |
Notes
Both input ARRAY arguments must have the same number of elements.
Return Type
VECTOR_ADD returns a result of type ARRAY(BIGINT) if the elements of <array> are of type INT, and returns a result of type ARRAY(DOUBLE PRECISION) if the elements are of type REAL. For other element types, VECTOR_ADD returns a result that matches the original element type, or follows Firebolt’s type conversion rules to convert them to compatible data types.
Examples
Example
The following code example adds the two vectors, [1, 2, 5] and [3, 4, -2], by computing 1+3, 2+4, and 5+(-2), which yields [4, 6, 3]:
SELECT VECTOR_ADD([1, 2, 5], [3, 4, -2]) AS res;
| res array(long) |
|---|
| [‘4’, ‘6’, ‘3’] |
Rows: 1Execution time: 6.25ms
