如何使点击室实现的视图在带有6个节点的群集上正确工作
我的Clickhouse群集中有6个节点。我在集群上创建本地表（使用ReplicatedReplacingMergetree引擎）和分布式表。创建了对节点“ CDH03”的实现视图，以从表加入数据并将结果写入分布式表。然后，我在节点“ CDH06”上创建一个实现的视图，该视图从分布式表中选择数据，然后使用MySQL引擎将其推到MySQL。
但是，由于数据正确地写入了分布式表，并且可以在其他节点上看到，因此对节点“ CDH06”的实现视图对MySQL没有写入。
我尝试在其他节点上使用相同的查询来创建实现的视图，但是只有在节点“ CDH03”上才能正常工作。这怎么了？我该怎么做才能使它起作用？
There is 6 nodes in my clickhouse cluster. I create local tables(with ReplicatedReplacingMergeTree engine) and distributed tables on the cluster. A Materialized View on node 'cdh03' is created to join data from tables and write the result to the distributed table. I then create a Materialized View on node 'cdh06', which select data from the distributed table and push them to mysql, with a mysql engine.
However, since data is correctly writen to the distributed table, and could be seen on other nodes, the Materialized View on node 'cdh06' writes nothing to mysql.
I tried to create the Materialized View with the same query on other nodes, but only on the node 'cdh03' it works correctly. What's wrong with this? And what can I do to make it work?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论