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

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.

See Also