// corelated sub query.
// Push Down Semi Joins
basePlan = hepPlan(basePlan, true, mdProvider,
PushSemiJoinPastJoinRule.INSTANCE,
new PushSemiJoinPastFilterRule(HiveFilterRel.DEFAULT_FILTER_FACTORY),
new PushSemiJoinPastProjectRule(HiveProjectRel.DEFAULT_PROJECT_FACTORY));
basePlan = hepPlan(basePlan, true, mdProvider,
new PushFilterPastProjectRule(
FilterRelBase.class, HiveFilterRel.DEFAULT_FILTER_FACTORY, HiveProjectRel.class,