Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Please add Split method

    Please Add Split methods to the Azure stream analytics Query language

    34 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Query Language  ·  Flag idea as inappropriate…  ·  Admin →

    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

  2. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Query Language  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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 MATCH
    RECOGNIZE at https://www.oracle.com/technetwork/database/bi-datawarehousing/mr-deep-dive-3769287.pdf

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Query Language  ·  Flag idea as inappropriate…  ·  Admin →
  4. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Query Language  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Stream Analytics

Categories

Feedback and Knowledge Base