yt/yql/tests/sql/suites/column_group/insert_diff_groups2_fail.yql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

/* custom error:Insert with different "column_groups" to existing table is not allowed*/
USE plato;

pragma yt.ColumnGroupMode="perusage";

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

insert into Output
select * from $s1;

commit;

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