[HIVE-15812] Scalar subquery with having throws exception

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.2.0
• Component/s: Query Planning
• Labels: sub-query
• Assignee: Vineet Garg
• Reporter: Vineet Garg
• Created: 04/Feb/17 04:31
• Updated: 25/Jul/17 20:05
• Resolved: 05/Feb/17 18:58

Description

Following query throws an exception

select sum(p_retailprice) from part group by p_type having sum(p_retailprice) > (select max(pp.p_retailprice) from part pp);

SemanticException [Error 10004]: Line 3:40 Invalid table alias or column reference 'pp': (possible column names are: p_partkey, p_name, p_mfgr, p_brand, p_type, p_size, p_container, p_retailprice, p_comment)