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: