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

bunniesfield 21 Reputation points
2020-06-12T05:28:04.683+00:00

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

Stream Analytics Query Language Reference
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)
arithmetic-operators-transact-sql

Thanks,

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
Accepted answer
  1. HimanshuSinha-msft 19,376 Reputation points Microsoft Employee
    2020-06-18T17:54:40.22+00:00

    Hello HIROYUKINAKAYAMA-3345,

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

    Thanks & stay safe

    Himanshu

    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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. bunniesfield 21 Reputation points
    2020-06-25T10:05:39.807+00:00

    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