ql/src/test/queries/clientpositive/windowing_ntile.q

drop table over10k_n13;

create table over10k_n13(
           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_n13;

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

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

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

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