Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Available Mapping Functions
Odysseus provides a wide range of functions and operators to be used for data transformation and filtering in a Map, Select, or Join operator.
Mathematic Function
Abs
Returns the absolute value of a value
Ceil
Returns the smallest value that is greater than or equal to the argument and is equal to a mathematical integer.
Floor
Returns the largest value that is less than or equal to the argument and is equal to a mathematical integer.
Round
Returns the closest number to the argument, with ties rounding up
ToRadian
Converts an angle measured in degrees to an equivalent angle measured in radians.
ToDegree
Converts an angle measured in radians to an equivalent angle measured in degrees.
Datatype Functions
DoubleToShort
Converts the given double value to a short value
DoubleToByte
Converts the given double value to a byte value
DoubleToFloat
Converts the given double value to a float value
DoubleToLong
Converts the given double value to a long value
ToShort
Converts the given value to a short value. This function converts any value to a short value, thus it is more time consuming than the DoubleToShort function for double values.
ToByte
Converts the given value to a byte value. This function converts any value to a byte value, thus it is more time consuming than the DoubleToByte function for double values.
ToFloat
Converts the given value to a float value. This function converts any value to a float value, thus it is more time consuming than the DoubleToFloat function for double values.
ToLong
Converts the given value to a long value. This function converts any value to a long value, thus it is more time consuming than the DoubleToLong function for double values.
Spatial Functions
Most function descriptions on this page are copied from the openjdk documentation.
your query statements. In Odysseus-Studio there is a view MEP Functions View, that lists all current available operators and functions.
Attentation: For most numeric operators the result is a floating value. This will be fixed in future versions.
Basic Operators
Mathematical Operators; +,-,/,*, % (modulo), ^ (power)
Logical Operators: && (and), || (or), !(not), xor
Compare Operators: !=, = or ==, <=, >=
Functions and operators in CQL
If you prefer CQL you can use these functions and operators in your Select clause for data transformation or in the Where clause for filtering:
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT tan(x) FROM stream WHERE sqrt(y)>3 |
Functions and operators in PQL
If you prefer PQL you can use these functions and operators in the MAP, JOIN, and SELECT operator. In addition, functions and operators can be used in other operators that are not part of the set of relational operators.
Code Block | ||||
---|---|---|---|---|
| ||||
output = MAP({expressions = ['tan(x)']}, SELECT({predicate = RelationalPredicate('sqrt(y)>3')}, stream)) |
Some of the functions and operators are part of the Odysseus Core and some are available in additional features. On the following child pages you find all currently available functions and operators with their description and examples.
Children Display | |
---|---|
Table of Contents | |
maxLevel | 3 | outline | true