Table of contents
Collapse the table of content
Expand the table of content

Built-in Functions (U-SQL)

Michael Rys|Last Updated: 5/15/2018
4 Contributors

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 FunctionsAn 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 FunctionsAnalytic functions compute an aggregate value based on a group of rows. However, unlike aggregate functions, they can return multiple rows for each group.
Metadata FunctionsReturns information about the database and database objects.
Ranking FunctionsReturns a ranking value for each row in a partition.
Built-in U-SQL UDOsProvides extraction from and outputting to some common data formats.

See Also

© 2018 Microsoft