Stream Analytics
Azure Stream Analytics is a fully managed real-time stream computation service hosted in Microsoft Azure, which provides highly resilient, low latency, and scalable complex event processing of streaming data. Azure Stream Analytics enables developers to easily combine streams of data with historic records or reference data to derive business insights easily and quickly.
-
Please add Split method
Please Add Split methods to the Azure stream analytics Query language
34 votesunplanned ·
AdminAzure Stream Analytics Team on UserVoice
(Product Manager, Microsoft Azure)
responded
The scenario can be addressed via a User Defined Function that will convert the string into an array. Followed by CROSS APPLY GetArrayElements() that will split the array into multiple rows.
Javascript UDF: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-javascript-user-defined-functions
With the JS function:
function main(arg1) {
return arg1.split(“,”);
}Convert array elements into separate events: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-parsing-json#convert-array-elements-into-separate-events
With the query:
WITH CTE AS (
SELECT
UDF.myFunction(I.myString) AS myNewArray
FROM Input I
)
SELECT
A.ArrayValue AS myValue
FROM CTE
CROSS APPLY GetArrayElements(myNewArray) AS A -
Add KQL support
KQL is such a powerfull language for working with time series data. In my opinion it is a very clean and transparent language for defining queries. It would be great to have KQL-like support for Stream Analytics on the edge and in the cloud.
9 votes -
Add ALWAYS TRUE pattern to MATCH_RECOGNIZE
using matchrecognize to detect "V" shape data change is very convenient, however it will miss the first value as "delta" calculation starts only when data is changed.
you can find a good explanation of ALWAYS TRUE in MATCHRECOGNIZE at https://www.oracle.com/technetwork/database/bi-datawarehousing/mr-deep-dive-3769287.pdf1 vote -
1 vote
- Don't see your idea?