Re: Problem with the windowing function ntile (Exceptions)

2013-07-25 Thread Lars Francke
Hi Navis, that's awesome! Thank you for the quick response and the patch. I just tested it against my query which used to fail and it just worked. So you have at least my thumbs-up. Thanks again for your help. Cheers, Lars On Thu, Jul 25, 2013 at 10:01 AM, Navis류승우 wrote: > I've booked this an

Re: Problem with the windowing function ntile (Exceptions)

2013-07-25 Thread Navis류승우
I've booked this and attached patch for it. https://issues.apache.org/jira/browse/HIVE-4932 Could you test with that? thanks. 2013/7/25 Lars Francke : > We're still being bitten by this problem without a workaround. Does > anyone have an idea? > > Thanks, > Lars > > On Wed, Jul 17, 2013 at 11:24

Re: Problem with the windowing function ntile (Exceptions)

2013-07-24 Thread Lars Francke
We're still being bitten by this problem without a workaround. Does anyone have an idea? Thanks, Lars On Wed, Jul 17, 2013 at 11:24 PM, Lars Francke wrote: > Hi, > > I'm running a query like this: > > CREATE TABLE foo > STORED AS ORC > AS > SELECT > id, > season, > amount, > ntile(10)

Problem with the windowing function ntile (Exceptions)

2013-07-17 Thread Lars Francke
Hi, I'm running a query like this: CREATE TABLE foo STORED AS ORC AS SELECT id, season, amount, ntile(10) OVER ( PARTITION BY season ORDER BY amount DESC ) FROM bar; On a small enough dataset that works fine but when switching to a larger sample we're seeing exceptions like this: