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.

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

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.

An operator is a symbol specifying an action that is performed on one or more expressions.

Function Category	Description
Bitwise Operators	Bitwise operators perform bit manipulations between two expressions of types bit or bigint.