Built-in Functions (U-SQL)
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
|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.|