Re: nested join issue

To clarify, HIVE-8435 introduced the regression. Turning that feature off fixes the issue. So we still need to fix that optimization to not produce this incorrect result. On Fri, Jun 12, 2015 at 11:31 PM, Gautam wrote: > Found that turning off hive.optimize.remove.identity.project ( ref: > HIVE-

Re: nested join issue

Found that turning off hive.optimize.remove.identity.project ( ref: HIVE-8435 ) fixes the issue. This gives us a workaround, but dunno the performance degradation this impacts yet. Thanks! -Gautam. On Fri, Jun 12, 2015 at 6:02 PM, Gautam wrote:

Re: nested join issue

Done. https://issues.apache.org/jira/browse/HIVE-10996 On Fri, Jun 12, 2015 at 1:47 PM, Gopal Vijayaraghavan wrote: > Hi > > > Thanks for investigating.. Trying to locate the patch that fixes this > >between 1.1 and 2.0.0-SNAPSHOT. Any leads on what Jira this fix was part > >of? Or what part of

Re: nested join issue

Hi > Thanks for investigating.. Trying to locate the patch that fixes this >between 1.1 and 2.0.0-SNAPSHOT. Any leads on what Jira this fix was part >of? Or what part of the code the patch is likely to be on? git bisect is the only way usually to identify these things. But before you hunt into

Re: nested join issue

Thanks for investigating.. Trying to locate the patch that fixes this between 1.1 and 2.0.0-SNAPSHOT. Any leads on what Jira this fix was part of? Or what part of the code the patch is likely to be on? -Gautam. On Thu, Jun 11, 2015 at 8:35 PM, Gopal Vijayaraghavan wrote: > Hi, > > > I'm runnin

Re: nested join issue

Hi, > I'm running into a peculiar issue with nested joins and outer select. I >see this error on 1.1.0 and 1.2.0 but not 0.13 which seems like a >regression. ... > create table events (s string, st2 string, n int, timestamp int); The issue does not seem to be happening in hive-2.0.0-SNAPSHOT, wh

nested join issue

I'm running into a peculiar issue with nested joins and outer select. I see this error on 1.1.0 and 1.2.0 but not 0.13 which seems like a regression. The following query produces no results: select sfrom ( select last.*, action.st2, action.n from ( select purchase.s, purchase.timestamp, m