Built-in Functions (Azure Stream Analytics)

Azure Stream Analytics provides some built-in functions. The categories of built-in functions are:

Types of Functions

Function Category Description
Aggregate Functions Operate on a collection of values but return a single, summarizing value.
Analytic Functions Return a value based on defined constraints.
Array Functions Returns information from an array.
GeoSpatial Functions Perform specialized GeoSpatial functions.
Input Metadata Functions Query the metadata of property in the data input.
Record Functions Returns record properties or values.
Windowing Functions Perform operations on events within a time window.
Scalar Functions Operate on a single value and then return a single value. Scalar functions can be used wherever an expression is valid.

Scalar Functions

A scalar function operates on a single value and then return a single value. Scalar functions can be used wherever an expression is valid.

The categories of scalar functions are:

Function Category Description
Conversion Functions These functions allow you to cast data into different formats.
Date and Time Functions These functions allow you to perform operations on DateTime formats.
Mathematical Functions Represent the scalar functions that perform a calculation, usually based on input values that are provided as arguments, and return a numeric value.
String Functions These functions allow you to convert strings to upper or lower case.

See Also

Data Types
Query Language Elements
Time Management