更新Azure ADX的物化视图?

huangapple go评论59阅读模式
英文:

Update materialized view azure adx?

问题

我正在将某些数据注入到名为 "TestEvents" 的表中,使用范围标记。

.ingest inline into table TestEvents with (tags = '[\"drop-by:test\"]')

与此表关联的物化视图 "TestEventsMV" 也会随着新数据的更新而更新。

然后,我想根据我上面设置的范围标记从源表中删除数据。

.drop extents <| .show table TestEvents extents where tags has "drop-by:e2e-backend-test"

数据从源表中删除了,但由于物化视图有自己的保留策略,所以注入的数据仍然存在于视图中。

有一个名为 "autoUpdateSchema" 的功能,当设置为 true 时,视图的架构会根据源表自动更新,但我找不到任何选项来更新视图内的内容。是否有可能实现这样的功能?

英文:

I am ingesting certain data into a table "TestEvents" with extent tagging

.ingest inline into table TestEvents with (tags = &#39;[\&quot;drop-by:test\&quot;]&#39;)

The materialized "TestEventsMV "view associated with this table also gets updated with the new data.

Then, I want to drop the data in the source table based on the extent tag that I had set above.

.drop extents &lt;| .show table TestEvents extents where tags has &quot;drop-by:e2e-backend-test&quot;

The data gets dropped from source table but since materialized view has its own retention policy, the ingested data still persists in the view.

There is a feature "autoUpdateSchema", which when set to true, the schema of the view is automatically updated based on the source table, but I could not find any option to update the content inside the view. Is it possible to achieve something like this?

答案1

得分: 1

不,这是不可能的。物化视图不受其源表中删除的记录的影响,如此处所记录 - 记录被摄取到或从源表中删除的影响

英文:

No, this is not possible. A materialized view is not impacted by records dropped from its source table, as documented here - Impact of records ingested to or dropped from the source table.

huangapple
  • 本文由 发表于 2023年3月31日 21:13:56
  • 转载请务必保留本文链接:https://go.coder-hub.com/75898965.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定