Hi All, I run following hive
create table2 as select id, ntile(6) over (partition by city order by price) as price_tile, ntile(3) over (partition by city order by discount) as discount_tile, ntile(6) over (partition by city order by number) as number_tile from table1; Table1 contains 8 million records with unique id, table2 contains the same number of records but with 15k missing ids and 15k duplicate ids. Is it because that we are not allowed to use multiple ntile's in one hive query?
