We disabled ppd_join4 in HIVE-8970, after seeing an issue when running it with map join. However, since this test uses reduce-side join, we should have no problem enabling it. The issue with map join is tracked by HIVE-9007, and we will create separate test for the map join case in that JIRA.