Operators (U-SQL)
Summary
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:
| Operator | Description |
|---|---|
| Arithmetic Operators | Arithmetic operators perform mathematical operations on two expressions of one or more of the data types of the numeric data type category. |
| Comparison Operators | Comparison operators test whether two expressions are the same. |
| Logical Operators | Logical operators test for the truth of some condition. |
| Other Operators | Other 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.