USE tpch1;
create table if not exists mkr (c1 int, select_b int) engine=columnstore;
insert into mkr (c1, select_b) (select n_nationkey, n_regionkey from nation);
select * from mkr;
c1	select_b
0	0
1	1
2	1
3	1
4	4
5	0
6	3
7	3
8	2
9	2
10	4
11	4
12	2
13	4
14	0
15	0
16	0
17	1
18	2
19	3
20	4
21	2
22	3
23	3
24	1
drop table mkr;