[IMPALA-9929] Unsupported subquery in select list throws IllegalStateException instead of AnalysisException

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 4.0.0
• Component/s: Frontend
• Epic Link: Subquery Support
• Epic Color: ghx-label-2
• Assignee: Shant Hovsepian
• Reporter: Tim Armstrong
• Created: 08/Jul/20 20:19
• Updated: 22/Aug/20 03:02
• Resolved: 22/Aug/20 03:02

Description

[localhost.EXAMPLE.COM:21000] default> explain select year, month, (year = 2010 and month > 11)  or min(id) in (select int_col from functional.alltypestiny) from functional.alltypes;
Query: explain select year, month, (year = 2010 and month > 11)  or min(id) in (select int_col from functional.alltypestiny) from functional.alltypes
ERROR: IllegalStateException: Invariant violated: Only subqueries that are guaranteed to return a single row are supported: (`year` = 2010 AND `month` > 11) OR min(id) IN (SELECT int_col FROM functional.alltypestiny)