Property operators
Property operator is a syntax construct that describes an operator creating a property.
Property operators can be divided into context dependent and context independent.
Context dependent operators
Context dependent property operators can be part of expressions and use common parameters (context). These operators are:
- Arithmetic operators
[]
operatorACTIVE TAB
operatorAGGR
operatorCASE
operatorCONCAT
operatorEXCLUSIVE
operatorGROUP
operator (withoutBY
block)IF
operatorIF ... THEN
operatorISCLASS
operatorJOIN
operatorJSON
operatorLIKE
operatorMAX
operatorMIN
operatorMULTI
operatorOVERRIDE
operatorPARTITION
operatorPREV
operatorRECURSION
operatorROUND
operatorSTRUCT
operatorUNGROUP
operator- Type conversion operator
AND
,OR
,NOT
,XOR
operatorsIS
,AS
operators- Change operators
- Comparison operators
Context independent operators
Context independent property operators differ from the context dependent ones in that they do not just use the upper parameters but define the parameters themselves. As a result, they cannot be part of expressions and can only be used in the =
statement and the JOIN
operator: