azure - 我可以在 Azure 流分析作业的同一输出中进行多个查询吗？

Question

我可以在 Azure 流分析作业的同一输出中进行多个查询吗？

例如

SELECT property1, property2 INTO Output1 WHERE Property3 ='Answer'
SELECT property4, property5 INTO Output1 WHERE Property3 ='Question'

Answer 1

首先合并结果并使用WITH为组合别名，然后从该表中选择到输出中。

https://msdn.microsoft.com/en-us/azure/stream-analytics/reference/union-azure-stream-analytics

没有测试这个，但应该给出想法:

WITH Combined AS (
SELECT property1, property2 
FROM [input-hub] 
WHERE Property3 ='Answer'
UNION
SELECT property4, property5 
FROM [input-hub] 
WHERE Property3 ='Question'
)

SELECT * 
INTO [output-cosmos]
FROM Combined