yt/yql/tests/sql/suites/column_group/insert_diff_groups1_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 @a
select * from $s1;

commit;

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