Hi Edward, You can do it with streamtable hint. Hive will put the table in that hint in the rightmost. -yongqiang On 2/18/10 3:21 PM, "Edward Capriolo" <[email protected]> wrote:
> 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 > >
