hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vineet Garg (JIRA)" <>
Subject [jira] [Created] (HIVE-15812) Scalar subquery with having throws exception
Date Sat, 04 Feb 2017 04:31:51 GMT
Vineet Garg created HIVE-15812:

             Summary: Scalar subquery with having throws exception
                 Key: HIVE-15812
             Project: Hive
          Issue Type: Bug
          Components: Query Planning
            Reporter: Vineet Garg
            Assignee: Vineet Garg

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,

This message was sent by Atlassian JIRA

View raw message