VARP (Azure Stream Analytics)

 

Updated: April 22, 2016

Applies To: Azure

Returns the statistical variance for the population for all values in a group. Null values are ignored.

Syntax

VARP (expression )  

expression

Is an expression of the exact numeric or approximate numeric data type category. VARP can be used with bigint and float columns. Aggregate functions and sub queries are not permitted.

float

SELECT System.TimeStamp AS OutTime, TollId, VARP (Toll)   
FROM Input  
GROUP BY TollId, TumblingWindow(minute,3)  
  

Show: