PHOENIX-1300 Allow sub-queries to choose different execution path other than hash-join