use toscalar() to make code more concise in Kusto

肯德基套餐

于 2019-04-20 12:27:12 发布

阅读量261

点赞数

分类专栏： Kusto 文章标签： Kusto

本文链接：https://blog.csdn.net/dpengwang/article/details/89415696

版权

Kusto 专栏收录该内容

4 篇文章

订阅专栏

redundant code

let endTime = datetime(2019-04-10);
let startTime = endTime - 10d;
let targetNode =datatable(NodeId:string, EventTime:datetime)
[
  .........
]
| project NodeId
;
cluster('xxx').database('xxx').xx
| where NodeId  in ( targetNode )

compact code

let endTime = datetime(2019-04-10);
let startTime = endTime - 10d;
let targetNode =datatable(NodeId:string, EventTime:datetime)
[
......
]
;
cluster('xx').database('xx').xx
| where NodeId  in (toscalar(targetNode | project NodeId| summarize make_set(NodeId)))

If we don’t use toscalar function or we don’t use “make_set” function in

 where NodeId  in (toscalar(targetNode | project NodeId| summarize make_set(NodeId)))

then the result will be wrong or even can’t execute at all.