Operators (U-SQL)

 

Updated: March 10, 2017

In addition to the built in C# functions and operators, U-SQL has added some built in operators that are commonly used in SQL-based languages. The following is a list of the types of operators that U-SQL has added:

OperatorDescription
Arithmetic OperatorsArithmetic operators perform mathematical operations on two expressions of one or more of the data types of the numeric data type category.
Comparison OperatorsComparison operators test whether two expressions are the same.
Logical OperatorsLogical operators test for the truth of some condition.
Set OperatorsSet operators allow to intersect two rowsets, to union them or to subtract one from the other.
Other OperatorsOther additional operators.

These built-in scalar functions and operators can be used in the context of any U-SQL scalar expression intermingled with C# expressions. Some operators, like OVER however have restrictions where they are allowed to be used.

See Also

Community Additions

ADD
Show: