Odysseus provides a wide range of functions to be used in a Map, Select, or Join operator.
Returns the trigonometric cosine of an angle
Returns the arc cosine of a value
Returns the hyperbolic cosine of a double value
Returns the trigonometric sine of an angle
Returns the arc sine of a value
Returns the hyperbolic sine of a double value
Returns the trigonometric tangent of an angle
Returns the arc tangent of a value
Returns the angle theta from the conversion of rectangular coordinates (x, y) to polar coordinates (r, theta)
Returns the hyperbolic tangent of a double value
Returns the absolute value of a value
Returns the signum function of the argument
Returns the square root of a value
Returns the smallest value that is greater than or equal to the argument and is equal to a mathematical integer.
Returns the largest value that is less than or equal to the argument and is equal to a mathematical integer.
Returns the closest number to the argument, with ties rounding up
Returns the natural logarithm (base e) of a double value
Returns Euler's number e raised to the power of a double value
Returns the double value that is closer than any other to pi.
Returns the double value that is closer than any other to e
Converts an angle measured in degrees to an equivalent angle measured in radians.
Converts an angle measured in radians to an equivalent angle measured in degrees.
The following MEP functions are not part of the Odysseus Core and may be restricted.
The probabilistic feature provides arbitrary functions to work with discrete and continuous probabilistic values in a data stream. Further this feature 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 short value
Converts the given probabilistic double value to a probabilistic byte value
Converts the given probabilistic double value to a probabilistic integer value
Converts the given probabilistic double value to a probabilistic float value
Converts the given probabilistic double value to a probabilistic long 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 |
The spatial functions are based upon the JTS Topology Suite (http://www.vividsolutions.com/jts/JTSHome.htm).
Notice, that JTS only considers x and y coordinate and ignores the z coordinate (although z can be definied)!
Transform the list of spatial polar coordinates into a list of Cartesian coordinates
Returns the centroid of the given geometry
Creates a buffer of the given size around the given geometry
Checks whether the first geometry contains the second geometry.
Computes the smallest convex spatial polygon
that contains all the points in the geometry
Transforms the given spatial polar coordinate into a spatial Cartesian coordinate.
Transforms the given spatial Cartesian coordinate into a polar coordinate
Most function descriptions on this page are copied from the openjdk documentation.