blob: 532c2a6e3c9a822f112d87c264b6816f981dda4c [file] [log] [blame]
--! qt:dataset:srcpart
-- Cannot add or drop partition columns with CREATE OR REPLACE VIEW if partitions currently exist
drop view v;
create view v partitioned on (ds, hr) as select * from srcpart;
alter view v add partition (ds='1',hr='2');
create or replace view v partitioned on (hr) as select * from srcpart;