FAILED: SemanticException Line 3:53 Unsupported SubQuery Expression 'p_name' in definition of SubQuery sq_1 [
x.p_name in (select y.p_name from part y where exists (select z.p_name from part z where y.p_name = z.p_name))
] used as sq_1 at Line 3:15: Nested SubQuery expressions are not supported.