Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
✅ Azure Stream Analytics ✅ Fabric Eventstream
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.
| 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. |
Operators
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. |