Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
To use these functions, the Matrix Feature is required.
The matrix feature provides arbitrary functions to work with matrices in a data stream and provides algebraic operator (+, *, -, ^) to perform matrix addition, subtraction, multiplication, and exponentiation.
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT [1.0,2.0,3.0;4.0,5.0,6.0]+[1.0,2.0,3.0;4.0,5.0,6.0] FROM stream SELECT [1.0,2.0,3.0;4.0,5.0,6.0]-[1.0,2.0,3.0;4.0,5.0,6.0] FROM stream SELECT [1.0,2.0,3.0;4.0,5.0,6.0]*[1.0,2.0,3.0;4.0,5.0,6.0] FROM stream SELECT [1.0,2.0,3.0;4.0,5.0,6.0]^3 FROM stream |
Tr(Matrix)
Computes the trace of the matrix
Det(Matrix)
Computes the determinant of the given matrix
Inv(Matrix)
Computes the inverse of the given matrix
Trans(Matrix)
Computes the transpose of the given matrix
Identity(Number)
Creates a N x N identity matrix
sMin(Matrix|Vector)
Return the minimum element in the given matrix.
sMax(Matrix|Vector)
Returns the maximum element in the given matrix.
sCount(Matrix|Vector)
Counts all elements in the given matrix.
sSum(Matrix|Vector)
Computes the sum of all elements of the given matrix.
sAVG(Matrix|Vector)
Compute the average of all elements of the given matrix.
sMedian(Matrix|Vector)
Compute the median of all elements of the given matrix.
Table of Contents |
---|