Date: Mon, 4 Jul 2022 01:19:38 +0200 (CEST) Message-ID: <852871849.791.1656890378789@odysseus.offis.uni-oldenburg.de> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_790_913315197.1656890378788" ------=_Part_790_913315197.1656890378788 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html MEP: Functions and Operators

# MEP: Functions and Operators

=20
=20
=20
=20

Odysseus provides a wide range of functions and operators to be used for= data transformation and filtering in your query statements. In Odysseus-St= udio there is a view MEP Functions View, that lists all current available o= perators 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: !=3D, =3D or =3D=3D, <=3D, >=3D

## Functions a= nd operators in CQL

If you prefer CQL you can use these functions and operators in your Sele= ct clause for data transformation or in the Where clause for filtering:

Example
=20
```SELECT t=
an(x) FROM stream WHERE sqrt(y)>3```
=20

## Functions a= nd 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.

Example
=20
```output =
=3D MAP({expressions =3D ['tan(x)']}, SELECT({predicate =3D RelationalPredi=
cate('sqrt(y)>3')}, stream))```
=20

Some of the functions and operators are part of the Odysseus Core and so= me are available in additional features. On the following child pages you find all curre= ntly available functions and operators with their description and examples.=

=20
=20 =20
=20
------=_Part_790_913315197.1656890378788--