Table of contents

Built-in Functions (Azure Stream Analytics)

Mary McCready|Last Updated: 8/14/2018
|
3 Contributors

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

Types of Functions

Function CategoryDescription
Aggregate FunctionsOperate on a collection of values but return a single, summarizing value.
Analytic FunctionsReturn a value based on defined constraints.
GeoSpatial FunctionsPerform specialized GeoSpatial functions.
Record FunctionsReturns record properties or values.
Scalar FunctionsOperate 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 CategoryDescription
Conversion FunctionsThese functions allow you to cast data into different formats.
Date and Time FunctionsThese functions allow you to perform operations on DateTime formats.
Mathematical FunctionsRepresent the scalar functions that perform a calculation, usually based on input values that are provided as arguments, and return a numeric value.
String FunctionsThese functions allow you to convert strings to upper or lower case.

See Also

Data Types
Query Language Elements
Time Management

© 2018 Microsoft