drop database if exists test1;
create database if not exists test1; use test1;
create table c1 (a varchar(255), b int) engine = Columnstore;
insert into c1 values ('test1',2);
insert into c1 values ('test1',3);

drop database if exists test2;
create database if not exists test2; use test2;
create table c1 (a varchar(255), b int, c int) engine = Columnstore;
insert into c1 values ('test2',2,3);
insert into c1 values ('test2',3,4);

drop database if exists test3;
create database if not exists test3; use test3;
create table c1 (a varchar(255), b int, c int, d int) engine = Innodb;
insert into c1 values ('test3',2,3,4);
insert into c1 values ('test3',3,4,5);

create view v1 AS SELECT a ,b FROM test1.c1 where b=2 UNION ALL SELECT a ,b FROM test2.c1 where a='test2' UNION ALL SELECT a ,b FROM test3.c1;
select * from test3.v1;