如何在ClickHouse中重命名物化视图

Question

如何在ClickHouse中重命名数学视图？

:) ALTER MATERIALIZED VIEW db.table_1 RENAME TO db.table_2;
Syntax error: failed at position 7


:) RENAME MATERIALIZED VIEW db.table_1 TO db.table_2;
Syntax error: failed at position 8

:) RENAME TABLE db.table_1 TO db.table_2;

RENAME TABLE table_1 TO table_2
Received exception from server (version 19.4.4):
Code: 48. DB::Exception: Received from 127.0.0.1:9000. DB::Exception: Method rename is not supported by storage MaterializedView

请救救我！

Answer 1

在下面的版本中添加了对重命名MaterializedView的支持。

ClickHouse发布版19.8.3.8,2019-06-11

请求：https://github.com/ClickHouse/ClickHouse/pull/5209

Answer 2

如何将未复制的MV转换为复制的https://gist.github.com/den-crane/80cb95e74f046be2d8ffae58d9b04e8f

如何修改MV https://gist.github.com/den-crane/431010ca08b9e51b960e55344b1dbbe3

MV_poplulating_with_freeze https://gist.github.com/den-crane/64c05be67ef8a926242011188ce96f44

Several_MV_one_internal_store https://gist.github.com/den-crane/005633470c70877dd28c00211cd9fcfb

通过空表AggregatingMergeTree填充https://gist.github.com/den-crane/f7382cd4f1f859ff6ac46afe7dc9925a

alter_MV_with_SummingMergeTree https://gist.github.com/den-crane/3a8d57253711e277b2a60a75b5dfeef6

在19.8.3.8 https://gist.github.com/den-crane/d9a0bceb58a7d5314ea66e8edbebc9f7之前在CH中重命名MV

Answer 3

ClickHouse发布后19.8.3.8 (参考文献)

RENAME TABLE materialized_view_table TO materialized_view_table_migrate;

在ClickHouse发布之前19.8.3.8 (要旨)

DETACH TABLE materialized_view_table;
RENAME TABLE `.inner.materialized_view_table` TO `.inner.materialized_view_table_migrate`;

重命名.sql文件并编辑(使用vi) /var/lib/clickhouse/metadata/default/materialized_view_table.sql

ATTACH TABLE materialized_view_table_migrate