GetArrayElements (Azure Stream Analytics)

 

Published: April 12, 2016

Updated: April 22, 2016

Applies To: Azure

Returns a dataset with array values and indexes. The result of the GetArrayElements function must be used with CROSS APPLY operator only.

Syntax

GetArrayElements ( column_reference )  

column_reference

Is the column reference expression to be evaluated. Column must be of type Array.

Returns a dataset with ArrayIndex and ArrayValue columns.

SELECT   
    arrayElement.ArrayIndex,  
    arrayElement.ArrayValue  
FROM input as event  
CROSS APPLY GetArrayElements(event.arrayField) AS arrayElement  
  

Show: