英文:
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 = '[\"drop-by:test\"]')
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 <| .show table TestEvents extents where tags has "drop-by:e2e-backend-test"
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.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论