--! qt:dataset:src1
drop table over10k_n4;

create table over10k_n4(
           t tinyint,
           si smallint,
           i int,
           b bigint,
           f float,
           d double,
           bo boolean,
           s string,
	   ts timestamp, 
           `dec` decimal,  
           bin binary)
       row format delimited
       fields terminated by '|';

load data local inpath '../../data/files/over10k' into table over10k_n4;

select s, min(i) over (partition by s) m from over10k_n4 order by s, m limit 100;

select s, avg(f) over (partition by si order by s) a from over10k_n4 order by s, a limit 100;

select s, avg(i) over (partition by t, b order by s) a from over10k_n4 order by s, a limit 100;

select max(i) over w m from over10k_n4 window w as (partition by f) order by m limit 100;

select s, avg(d) over (partition by t order by f) a from over10k_n4 order by s, a limit 100;

select key, max(value) over
  (order by key rows between 10 preceding and 20 following) m
from src1 where length(key) > 10
order by key, m;