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.

See Also

• U-SQL Language Reference
• Built-in U-SQL UDOs