drop table over10k;

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

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

select i, ntile(10) over (partition by s order by i) from over10k limit 100;

select s, ntile(100) over (partition by i order by s) from over10k limit 100;

select f, ntile(4) over (partition by d order by f) from over10k limit 100;

select d, ntile(1000) over (partition by dec order by d) from over10k limit 100;