Skip to main content

​
VECTOR_SUBTRACT

Returns an array that is the difference of two input arrays.

​
Syntax

VECTOR_SUBTRACT(<array>, <array>)

​
Parameters

ParameterDescriptionSupported input types
<array>The first array in the difference calculation.Any array of numeric data types.
<array>The second array in the difference calculation.Any array of numeric data types.

​
Notes

Both input array arguments must have the same number of elements.

​
Return Type

VECTOR_SUBTRACT 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 example subtracts the vector [3, 4, -4] from [1, 5, 6] by computing 1-3, 5-4, and 6-(-2), which yields [-2, 1, 8]: 
select vector_subtract([1, 5, 6], [3, 4, -2]) as res
Returns
res (ARRAY(BIGINT))