Stream Analytics

原创已于 2024-07-05 10:44:51 修改

· 339 阅读

0 ·

版权

文章标签：

#azure

于 2024-07-04 11:14:17 首次发布

Data Engineer 专栏收录该内容

16 篇文章

订阅专栏

rm -r dp-203 -f

git clone https://github.com/MicrosoftLearning/dp-203-azure-data-engineer dp-203

cd dp-203/Allfiles/labs/17

./setup.ps1

node ~/dp-203/Allfiles/labs/17/orderclient

SELECT
    DateAdd(second,-10,System.TimeStamp) AS StartTime,
    System.TimeStamp AS EndTime,
    ProductID,
    SUM(Quantity) AS Orders
INTO
    [blobstore]
FROM
    [orders] TIMESTAMP BY EventProcessedUtcTime
GROUP BY ProductID, TumblingWindow(second, 10)
HAVING COUNT(*) > 1