azure - 在 ADX Cluster 中执行 create-materialized-view 查询时，出现与缓存策略相关的错误

Question

我尝试在设置了回填属性的情况下执行 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)
}

我收到以下错误: 请让我知道如何解决这个问题。

Answer 1

• 错误消息中已为您提供了解决方案:

An admin command cannot be executed due to an invalid state:State='Materialized view creation with backfill option is notsupported for tables with extents in cold cache. Please increase thehot cache policy to cover all extents in table or create the view withno backfill'

• documentation陈述相同，加上一个额外的提示:

Using the backfill option is not supported for data in cold cache.
Increase the hot cache period, if necessary, for the duration of theview creation. This may require scale-out.

Cache policy (hot and cold cache)