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:
|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.