[ https://issues.apache.org/jira/browse/HIVE-1642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12931705#action_12931705 ]
Liyin Tang commented on HIVE-1642: ---------------------------------- In the case: A left outer join B right outer join C, A must be small table. I have a test case: auto_join25.q to test the backup test. There are several query in this test case. The idea is just set the hive.hashtable.max.memory.usage = 0.00001. It means if the local task uses more than 0.00001% of memory, it will abort. Obviously, all local tasks will always fail in this task case. So the back up will run after the local task failed. > Convert join queries to map-join based on size of table/row > ----------------------------------------------------------- > > Key: HIVE-1642 > URL: https://issues.apache.org/jira/browse/HIVE-1642 > Project: Hive > Issue Type: Improvement > Components: Query Processor > Reporter: Namit Jain > Assignee: Liyin Tang > Fix For: 0.7.0 > > Attachments: hive_1642_1.patch > > > Based on the number of rows and size of each table, Hive should automatically > be able to convert a join into map-join. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.