yql/essentials/tests/sql/suites/column_group/many_inserts.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

USE plato;

pragma yt.ColumnGroupMode="perusage";

$s1 = select * from Input where a != "";
$s2 = select * from Input where a > "a1";

insert into @a with column_groups="{a=#}"
select * from $s1;

insert into @b
select * from $s1;

insert into @c
select * from $s1;

insert into Output with column_groups="{a=#}"
select * from $s1;

commit;

insert into @a with column_groups="{a=#}"
select * from $s2;

insert into @b
select * from $s2;

insert into @c with column_groups="{default=#}"
select * from $s2;

insert into Output with column_groups="{a=#}"
select * from $s2;