Stream Analytics and Power BI
rm -r dp-203 -f
git clone https://github.com/MicrosoftLearning/dp-203-azure-data-engineer dp-203
cd dp-203/Allfiles/labs/19
./setup.ps1
SELECT
DateAdd(second,-5,System.TimeStamp) AS StartTime,
System.TimeStamp AS EndTime,
ProductID,
SUM(Quantity) AS Orders
INTO
[powerbi-dataset]
FROM
[orders] TIMESTAMP BY EventEnqueuedUtcTime
GROUP BY ProductID, TumblingWindow(second, 5)
HAVING COUNT(*) > 1
node ~/dp-203/Allfiles/labs/19/orderclient
node ~/dp-203/Allfiles/labs/19/orderclient
原文地址:https://blog.csdn.net/weixin_44504151/article/details/140178147
免责声明:本站文章内容转载自网络资源,如本站内容侵犯了原著者的合法权益,可联系本站删除。更多内容请关注自学内容网(zxcms.com)!