Add guards for unsupported subqueries join plan, optimize the possible subqueriese

Line # 300. 

If it is single partitioned, it never go to this line because it does not need two fragments.