是否替换clickhouse中的视图替代项?

eagi6jfj  于 2021-07-15  发布在  ClickHouse
关注(0)|答案(1)|浏览(460)

REPLACE VIEW clickhouse的替代品?如果我删除视图并再次创建它,是否会导致一些查询因停机而失败?

xmakbtuz

xmakbtuz1#

创建还是替换?

create or replace view testv as select 1;
create or replace view testv as select 2;
select * from testv
┌─2─┐
│ 2 │
└───┘

https://github.com/clickhouse/clickhouse/blob/master/docs/en/whats-new/changelog/2019.md

ClickHouse Release 19.5.2.6, 2019-04-15
   Support for CREATE OR REPLACE VIEW. 
   Allow to create a view or set a new definition in a 
   single statement. #4654 (Boris Granveaud)

相关问题