CODEWITHSUNDEEP
clickhouse
ogbofjnr
ogbofjnr

Reputation: 2028

REPLACE VIEW alternative in clickhouse?

Is there REPLACE VIEW alternative in clickhouse? If I drop view and create it again, could I get some queries failed due to downtime?

Upvotes: 0

Views: 1938

Answers (1)

Denny Crane
Denny Crane

Reputation: 13350

create or replace?

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)

Upvotes: 2

Related Questions