Built-in Functions (U-SQL)
Summary
While U-SQL is using C# as its expression language and thus has a large set of the Common Language Runtime (CLR) libraries and all of C#’s operators at the user’s disposal, it also adds a couple of common Built-in U-SQL Functions.
Types of Functions
| Function | Description |
|---|---|
| Aggregate Functions | An aggregator will compute a single result value over a group of values and will have an identity value for the case that the group is empty. |
| Analytic Functions | Analytic functions compute an aggregate value based on a group of rows. However, unlike aggregate functions, they can return multiple rows for each group. |
| Metadata Functions | Returns information about the database and database objects. |
| Ranking Functions | Returns a ranking value for each row in a partition. |
| Built-in U-SQL UDOs | Provides extraction from and outputting to some common data formats. |