Does Stream Analytics query support simple binary operators (like + - etc)?

bunniesfield 21 Reputation points

Azure Stream Analytics supports subset of Transaction-SQL and is explained by below document.

Stream Analytics Query Language Reference

But I cannot find the simple binary operators (such as +, - etc) in this document.
Does Stream Analytics query really support this kind of simple operators appears in T-SQL specification?

Arithmetic Operators (Transact-SQL)


Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
248 questions
{count} votes

Accepted answer
  1. HimanshuSinha-msft 19,196 Reputation points Microsoft Employee


    We can use the binary operator for BIT/DOUBLE/BIGINT datatypes.

    Thanks & stay safe


    Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. bunniesfield 21 Reputation points

    Thanks, HimanshuSinha-5732!

    Now I found the Steam Analytics one sample SQL doing below calculations in SELECT.

    (bidPrice + askPrice)/2 AS midPrice,

    (midPrice1 + midPrice2 + midPrice3 + midPrice4 + midPrice5 + midPrice6 + midPrice7 + midPrice8 + midPrice9 + midPrice10)/10.0 - midPrice AS y,

    a + b1 * x1 + b2 * x2 AS efpc

    from stream-analytics-high-frequency-trading

    Then I can imagine what kind of calculations are accepted by Stream Analytics T-SQL, yet I cannot find one definitive document on this topic.

    0 comments No comments