在ADX群集中执行创建 - 材料视图查询时，获得与缓存策略相关的错误

发布于 2025-02-13 21:32:59 字数 817 浏览 0 评论 0原文

我正在尝试使用回填属性集执行以下ADX群集的命令，然后返回操作ID：

   .create async ifnotexists materialized-view with (backfill=true, docString="Asset Trends") AssetTrend on table Variables
{
Variables 
| where variable == 'severity' and model=='conditionMonitor' and 
  timestamp between (datetime(2022-06-29) .. 1d) 
| summarize Normal = countif(value<=1), CheckSUM = countif(value>1 and 
  value<=250), OutofSpecification = countif(value>250 and value<=500),
   MaintenanceRequired = countif(value>500 and value<=750), 
   Failure = countif(value>750 and value<=1000) 
   by bin(timestamp,1s)
}

我收到以下错误：请让我知道我该如何解决。

原文

I am trying to execute the following command of ADX cluster with backfill property set, then operation id is getting returned :

   .create async ifnotexists materialized-view with (backfill=true, docString="Asset Trends") AssetTrend on table Variables
{
Variables 
| where variable == 'severity' and model=='conditionMonitor' and 
  timestamp between (datetime(2022-06-29) .. 1d) 
| summarize Normal = countif(value<=1), CheckSUM = countif(value>1 and 
  value<=250), OutofSpecification = countif(value>250 and value<=500),
   MaintenanceRequired = countif(value>500 and value<=750), 
   Failure = countif(value>750 and value<=1000) 
   by bin(timestamp,1s)
}

I am getting the following error :

Please let me know how can I fix this.