aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/column_group/hint_anon_groups.sql
blob: 384dbcfd3b1df60e5c7074c3ce4868e7659dfd8f (plain) (blame)
1
2
3
4
5
6
7
8
9
USE plato;

$i = select * from Input where a > "a";

select a,b,c,d from $i;
select c,d,e,f from $i;

-- Forces specific group for $i
insert into @tmp with column_groups="{grp=[b;c;d]}" select * from $i;