如何在Cassandra实现视图中删除行? [英] How to delete a row in cassandra materialiezed view?
问题描述
我有一个带有表的cassadra命名空间和一个来自它的实例化视图.基本表中的行已删除,但更改未传播到实例化视图.我不知道发生这种情况的确切原因.
I have a cassadra namespace with a table and a materialized view from it. A row got deleted in the base table but the change was not propagated to the materialized view. I don't know the exact reason why this happend.
因此,现在我在MV中停留在该行上,因此无法删除它.有什么想法吗?
So now I am stuck with that row in the MV and I am not able to delete it. Any ideas?
推荐答案
是的,物化视图仍然非常混乱.两个主要问题是:
Yeah, materialized views are still very much broken. The two main problems are:
- 无法知道MV何时不同步.
- 一旦不同步,实际上就没有办法使其恢复同步.
所以听起来您已经超过了第一点.
So it sounds like you're past point #1.
有 个 nodetool rebuild_view
命令,但是它不会清除您需要的现有数据.
There is a nodetool rebuild_view
command, but it does not clear-out existing data, which is what you would need.
不幸的是,我认为前进的唯一途径是对视图进行 DROP
并重新创建它.
Unfortunately, I think the only path forward is to DROP
the view and re-create it.
这篇关于如何在Cassandra实现视图中删除行?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!