hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Putting the big table rightmost in the join
Date Thu, 18 Feb 2010 23:21:17 GMT
I have worked through this issue.

* When doing Join, please put the table with big number of rows
containing the same join key to
the rightmost in the JOIN clause. Otherwise we may see OutOfMemory errors.

This advice does work, but should we open up a jira to create a simple
optimizer that does this?

Edward

Mime
View raw message