如何在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:

1. 无法知道MV何时不同步.
2. 一旦不同步，实际上就没有办法使其恢复同步.

所以听起来您已经超过了第一点.

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屋！