To use these functions, the Probabilistic Feature is required.
The probabilistic feature provides arbitrary functions to work with discrete and continuous probabilistic values in a data stream and provides algebraic operator (+, *, -, /) to perform probabilistic addition, subtraction, multiplication, division, and exponentiation.
SELECT ToProbabilisticDouble([2.0,0.25;3.0,0.75]) + ToProbabilisticDouble([4.0,0.25;5.0,0.75]) FROM Stream => (6.0:0.0625;7.0:0.375;8.0:0.5625) SELECT ToProbabilisticDouble([2.0,0.25;3.0,0.75]) - ToProbabilisticDouble([4.0,0.25;5.0,0.75]) FROM Stream => (-3.0:0.1875;-2.0:0.625;-1.0:0.1875) SELECT ToProbabilisticDouble([2.0,0.25;3.0,0.75]) * ToProbabilisticDouble([4.0,0.25;5.0,0.75]) FROM Stream => (15.0:0.5625;12.0:0.1875;10.0:0.1875;8.0:0.0625) SELECT ToProbabilisticDouble([2.0,0.25;3.0,0.75]) / ToProbabilisticDouble([4.0,0.25;5.0,0.75]) FROM Stream => (0.75:0.1875;0.6:0.5625;0.5:0.0625;0.4:0.1875) SELECT ToProbabilisticDouble([2.0,0.25;3.0,0.75])^2 FROM Stream => (4.0:0.25;9.0:0.75) SELECT ToProbabilisticDouble([2.0,0.25;3.0,0.75]) + 2 FROM Stream => (4.0:0.25;5.0:0.75) SELECT ToProbabilisticDouble([2.0,0.25;3.0,0.75]) - 2 FROM Stream => (0.0:0.25;1.0:0.75) SELECT ToProbabilisticDouble([2.0,0.25;3.0,0.75]) * 2 FROM Stream => (6.0:0.75;4.0:0.25) SELECT ToProbabilisticDouble([2.0,0.25;3.0,0.75]) / 2 FROM Stream => (1.5:0.75;1.0:0.25) |
Computes the probabilistic square root of the given probabilistic value.
Computes the minimum of two probabilistic values.
Computes the maximum of two probabilistic values.
Constructs a discrete probabilistic value using the first column of the given matrix for the values and the second column of the matrix for the probabilities for each value.
SELECT ToProbabilisticDouble([2.0,0.25;3.0,0.75]) FROM Stream => (3.0:0.75;2.0:0.25) |
Converts the given probabilistic double value to a probabilistic byte value
Converts the given probabilistic double value to a probabilistic short value
Converts the given probabilistic double value to a probabilistic integer value
Converts the given probabilistic double value to a probabilistic long value
Converts the given probabilistic double value to a probabilistic float value
Estimates the multivariate normal distribution probability with lower and upper integration limit.
Converts the two object into a 2D vector.
Similar to the as2DVector function, this function creates a 3D vector with the given objects.
Calculates the Bhattacharyya distance between two distributions.
SELECT similarity(as2DVector(x1,y1), as2DVector(x2,y2)) FROM stream |
Calculates the Mahalanobis distance between the distribution and the value. The value can be a scalar value or a vector.
SELECT distance(as3DVector(x, y, z), [1.0;2.0;3.0]) FROM stream |