Query Language Elements (Azure Stream Analytics)

 

Updated: April 22, 2016

Applies To: Azure

Azure Stream Analytics provides a variety of elements for building queries. They are summarized below.

ElementSummary
APPLYThe APPLY operator allows you to invoke a table-valued function for each row returned by an outer table expression of a query. There are two forms of APPLY:

CROSS APPLY returns only rows from the outer table that produce a result set from the table-valued function.

OUTER APPLY returns both rows that produce a result set, and rows that do not, with NULL values in the columns produced by the table-valued function.
CASECASE evaluates a list of conditions and returns one of multiple possible result expressions
CREATE TABLECREATE TABLE is used to define the schema of the payload of the events coming into Azure Stream Analytics.
FROMFROM specifies the input stream or a step name associated in a WITH clause. The FROM clause is always required for any SELECT statement.
GROUP BYGROUP BY groups a selected set of rows into a set of summary rows grouped by the values of one or more columns or expressions.
HAVINGHAVING specifies a search condition for a group or an aggregate. HAVING can be used only with the SELECT expression.
INTOINTO explicitly specifies an output stream, and is always associated with an SELECT expression. If not specified, the default output stream is “output”.
JOIN and

 Reference Data JOIN
JOIN is used to combine records from two or more input sources. JOIN is temporal in nature, meaning that each JOIN must define how far the matching rows can be separated in time.

JOIN is also used to correlate persisted historical data or a slow changing dataset (aka. reference data) with the real-time event stream to make smarter decisions about the system. For example, join an event stream to a static dataset which maps IP Addresses to locations. This is the only JOIN supported in Stream Analytics where a temporal bound is not necessary.
SELECTSELECT is used to retrieve rows from input streams and enables the selection of one or many columns from one or many input streams in Azure Stream Analytics.
UNIONUNION combines two or more queries into a single result set that includes all the rows that belong to all queries in the union.
WHEREWHERE specifies the search condition for the rows returned by the query.
WITHWITH specifies a temporary named result set which can be referenced by a FROM clause in the query. This is defined within the execution scope of a single SELECT statement.

Built-In Functions
Data Types
Time Management

Show: