REFERENCE SYSTEM ASSEMBLY (U-SQL)

 

Updated: April 26, 2017

U-SQL provides a small set of preloaded system assemblies for the C# core and the most commonly used C# functions. The set is being kept small to reduce the amount of assemblies that the query processor will have to load and process at runtime.

In order to load additional system assemblies, U-SQL provides the REFERENCE SYSTEM ASSEMBLY statement that allows to load additional system assemblies for the script.

Syntax
Reference_System_Assembly_Statement :=                                                                   
    'REFERENCE' 'SYSTEM' 'ASSEMBLY' Assembly_Name.

Assembly_Name := Quoted_or_Unquoted_Identifier.

Semantics of Syntax Elements

  • Assembly_Name
    Specifies the C# name of the system assembly as a quoted or unquoted identifier of the assembly to be loaded. Note: This name is not resolved against the U-SQL meta data catalog.

Preloaded System Assemblies

The following system assemblies and namespaces are preloaded and thus their public objects can be used directly in any U-SQL expression:

  • Assemblies:
    • mscorlib.dll
    • System.dll
    • System.Core.dll
    • System.Data.dll
  • Namespaces:
    • System
    • System.Data
    • System.Text
    • System.Text.RegularExpressions
    • System.Linq

In addition, the U-SQL’s own system assemblies and namespaces for its types and associated functions, constructors and methods are also preloaded.

  • Assemblies:
    • Microsoft.Analytics.Interfaces.dll
    • Microsoft.Analytics.Types.dll
  • Namespaces:
    • Microsoft.Analytics.Types
    • Microsoft.Analytics.Types.Sql
    • Microsoft.Analytics.Interfaces

Even though one can use short-form references to the preloaded objects, it is recommended to always fully qualify the objects to avoid conflicts with user objects.

Examples

The following statement references the system assembly System.XML, so its objects can be used in the script:

REFERENCE SYSTEM ASSEMBLY [System.XML];  

See Also

Community Additions

ADD
Show: