[
https://issues.apache.org/jira/browse/HIVE-4371?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13634800#comment-13634800
]
Navis commented on HIVE-4371:
-----------------------------
[~namit] I've not been following SMB/BMJoins for months and afraid I could be
on the road.
I've attached a small patch excluding aliases belonging to other join, which
makes the test case run. (but not verified the result)
And in the test query,
select count(*) FROM bucket_small a JOIN bucket_medium b ON a.key = b.key JOIN
bucket_big c ON c.key = b.key JOIN bucket_medium d ON c.key = b.key;
the last "JOIN bucket_medium d ON c.key = b.key" means cross join?
> some issue with merging join trees
> ----------------------------------
>
> Key: HIVE-4371
> URL: https://issues.apache.org/jira/browse/HIVE-4371
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.11.0
> Reporter: Namit Jain
> Assignee: Navis
> Attachments: HIVE-4371.D10323.1.patch
>
>
> [~navis], I would really appreciate if you can take a look.
> I am attaching a testcase, for which in the optimizer the join context left
> aliases and right aliases do not look correct.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
