[HIVE-17783] Hybrid Grace Hash Join has performance degradation for N-way join using Hive on Tez

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.2.0

Environment

8*Intel(R) Xeon(R) CPU E5-2699 v4 @ 2.20GHz
1 master + 7 workers
TPC-DS at 3TB data scales
Hive version : 2.2.0

• Assignee: Unassigned
• Reporter: Ferdinand Xu
• Created: 12/Oct/17 03:06
• Updated: 31/Oct/17 08:53

Description

Most configurations are using default value. And the benchmark is to test enabling against disabling hybrid grace hash join using TPC-DS queries at 3TB data scales. Many queries related to N-way join has performance degradation over three times test. Detailed result is attached.

Issue Links

• is related to: HIVE-10403 Add n-way join support for Hybrid Grace Hash Join