GBase 8a行列混存表使用

1、行列混存表
drop table if exists test.t_grouped;
CREATE TABLE test.t_grouped(a int,b int,c int,d int,GROUPED a(b,c) COMPRESS(5));

insert into test.t_grouped values(1,1,1,1);
insert into test.t_grouped values(1,1,1,2);
insert into test.t_grouped values(1,1,1,3);
select * from test.t_grouped;
update test.t_grouped set a=3 where d=3;
select * from test.t_grouped;
delete from test.t_grouped  where d=2;
select * from test.t_grouped;