[HIVE-15763] Subquery in both LHS and RHS of IN/NOT IN throws misleading error

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.3.0
• Component/s: Query Planning
• Labels: sub-query
• Assignee: Vineet Garg
• Reporter: Vineet Garg
• Created: 31/Jan/17 03:56
• Updated: 21/Jul/17 18:36
• Resolved: 02/Feb/17 01:54

Description

Following query throws an error

select * from part where (select max(p_size) from part) IN (select p_size from part);

Error

SemanticException [Error 10249]: Line 1:79 Unsupported SubQuery Expression 'p_size': Only 1 SubQuery expression is supported.

Such queries should either be supported or should be detected and an appropriate error message should be thrown.