Clickhouse 物化视图-optimize无效
select a, b from test_all;
优点
空间换时间:查询速度快
CREATE MATERIALIZED VIEW test_mv ON CLUSTER ENGINE=ReplicatedReplacingMergeTree partition by toYYYYMM(b) ORDER BY (b)
AS
select a, b from test_all where a != 1;
select a, b from test_mv 会看到没有数据
optimize table test_mv 也没有用
原文地址:https://blog.csdn.net/m0_37962554/article/details/140541885
免责声明:本站文章内容转载自网络资源,如本站内容侵犯了原著者的合法权益,可联系本站删除。更多内容请关注自学内容网(zxcms.com)!