Is there anything else to pay attention to when using GetArrayElements() function？

Question

I create a UDF in Azure Stream Analysis,but there was an error when I called it, as follows:

//ExtractDynamicFields(inputData) is the UDF,and it return the array type
CROSS APPLY GetArrayElements(ExtractDynamicFields(event)) AS arrayElement
//error like follows:
Function 'GetArrayElements' requires a field of type 'array' as a parameter.

What should I do to solve this problem？

Answer 1

Hello

It's a bit hard to actually grasp what the function should do but I was able to do something similar.

I got the same error message until I split up the query:

First, make sure the output of the function is 'array':

My function is not that impressive:

Call the function as an UDF:

Finally, I did not call the function on the same line as the cross apply but added the function as extra columns to an tempory table:

I recommend using the VS Code extension for Stream Analytics so you can test your function and job locally.

---

If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.