Is this a bug of hive?
On Sun, Sep 25, 2016 at 11:29 PM, Rex X <dnsr...@gmail.com> wrote: > 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? > > > > >
