azure - 语义错误: Unsupported calculated column name GET/dbs/*/colls/*/pkranges Kusto

Question

我的 kusto 查询中有计算列。现在列名之一是“GET/dbs//colls//pkranges”。运行查询时我遇到此错误

 Semantic error: Unsupported calculated column name GET /dbs/*/colls/*/pkranges Kusto

有人可以帮助动态替换列名或在计算本身时替换列名吗？我的查询如下

dependencies
| where operation_Id in (operation_ids)
| where timestamp > ago(7d)
| summarize duration_list=make_list_with_nulls(duration) by tostring(name), operation_Id
| extend p = pack(tostring(name), duration_list)
| summarize bag = make_bag(p) by operation_Id
| evaluate bag_unpack(bag);

提前致谢!!

Answer 1

您可以使用 replace_string() 将键中的无效字符(在本例中为 *)替换为其他内容，如下所示:

dependencies
| where operation_Id in (operation_ids)
| where timestamp > ago(7d)
| summarize duration_list=make_list_with_nulls(duration) by tostring(name), operation_Id
| extend p = pack(replace_string(name, '*', '_'), duration_list)
| summarize bag = make_bag(p) by operation_Id
| evaluate bag_unpack(bag);