SUM (Azure Stream Analytics)
Returns the sum of all the values in the expression. SUM can be used with numeric columns only. NULL values are ignored. For all NULL values the result is also NULL.
-- Aggregate Function Syntax SUM ( expression ) -- Analytic Function Syntax SUM ( expression ) OVER ([<PARTITION BY clause>] <LIMIT DURATION clause> [<WHEN clause>])
Is a constant, column, or function, and any combination of arithmetic operators. SUM can be used with bigint and float columns.
OVER ([<PARTITION BY clause> <LIMIT DURATION clause> [<WHEN clause>]]
Determines the group of rows over which SUM is applied. The PARTITION BY clause specifies that the rows with the same partition key will be grouped together. The LIMIT DURATION clause specifies how much history is included in the group. The WHEN clause specifies a boolean condition for the rows to be included in the group. See OVER clause for more details on the usage.
Returns the summation of all expression values in the most precise expression data type.
SELECT System.Timestamp() AS OutTime, TollId, SUM (Toll) FROM Input TIMESTAMP BY EntryTime GROUP BY TollId, TumblingWindow(minute,3)
Submit and view feedback for