Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
If there is a column reference within subquery which doesn't exist Hive throws misleading error message.
e.g.
select * from table1 where table1.col1 IN (select col2 from table2 where table2.col1=table1.non_existing_column) and table1.col1 IN (select 4);
The above query, assuming table1 doesn't have non_existing_column, will throw following misleading error:
FAILED: SemanticException Line 0:-1 Unsupported SubQuery Expression 'col1': Only 1 SubQuery expression is supported.
Attachments
Attachments
Issue Links
- relates to
-
HIVE-17119 Improve error message thrown by subqueries if there are no statistics
- Open
-
HIVE-18724 Improve error handling for subqueries referencing columns(correlated) of its grand-parent query
- Closed
- links to