[IMPALA-1478] Improve error message when subquery is used in the ON clause

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 2.0, Impala 2.2, Impala 2.3.0, Impala 2.5.0
• Fix Version/s: Impala 2.10.0
• Component/s: Frontend
• Labels: newbie planner supportability usability
• Target Version: Product Backlog
• Assignee: Pranay Singh
• Reporter: Dimitris Tsirogiannis
• Created: 18/Nov/14 19:24
• Updated: 15/Aug/17 21:05
• Resolved: 15/Aug/17 21:05

Description

Improve the error message when a subquery is used in an ON clause.
Example:

[localhost:21000] > select * from alltypes a inner join alltypes b on a.id = b.id and a.int_col < (select min(id) from alltypes c);
Query: select * from alltypes a inner join alltypes b on a.id = b.id and a.int_col < (select min(id) from alltypes c)
ERROR: AnalysisException: null
CAUSED BY: IllegalStateException: null

Issue Links

• is duplicated by: IMPALA-5645 AnalysisException when join on clause contains subquery