Re: nested join issue

2015-06-13 Thread Gautam
Found that turning off hive.optimize.remove.identity.project ( ref: HIVE-8435 https://issues.apache.org/jira/browse/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

Re: nested join issue

2015-06-12 Thread Gopal Vijayaraghavan
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

2015-06-12 Thread Gautam
Done. https://issues.apache.org/jira/browse/HIVE-10996 On Fri, Jun 12, 2015 at 1:47 PM, Gopal Vijayaraghavan gop...@apache.org 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

Re: nested join issue

2015-06-11 Thread Gautam
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 gop...@apache.org wrote: Hi,

nested join issue

2015-06-11 Thread Slava Markeyev
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,

Re: nested join issue

2015-06-11 Thread Gopal Vijayaraghavan
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, which