[jira] [Commented] (HIVE-7326) Hive complains invalid column reference with 'having' aggregate predicates

["Navis (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-7326?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14052146#comment-14052146 ] 

Navis commented on HIVE-7326:
-----------------------------

[~hsubramaniyan] Sorry. I didn't noticed that this is assigned already.

> Hive complains invalid column reference with 'having' aggregate predicates
> --------------------------------------------------------------------------
>
>                 Key: HIVE-7326
>                 URL: https://issues.apache.org/jira/browse/HIVE-7326
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Hari Sankar Sivarama Subramaniyan
>            Assignee: Hari Sankar Sivarama Subramaniyan
>         Attachments: HIVE-7326.1.patch.txt
>
>
> CREATE TABLE TestV1_Staples (
>       Item_Count INT,
>       Ship_Priority STRING,
>       Order_Priority STRING,
>       Order_Status STRING,
>       Order_Quantity DOUBLE,
>       Sales_Total DOUBLE,
>       Discount DOUBLE,
>       Tax_Rate DOUBLE,
>       Ship_Mode STRING,
>       Fill_Time DOUBLE,
>       Gross_Profit DOUBLE,
>       Price DOUBLE,
>       Ship_Handle_Cost DOUBLE,
>       Employee_Name STRING,
>       Employee_Dept STRING,
>       Manager_Name STRING,
>       Employee_Yrs_Exp DOUBLE,
>       Employee_Salary DOUBLE,
>       Customer_Name STRING,
>       Customer_State STRING,
>       Call_Center_Region STRING,
>       Customer_Balance DOUBLE,
>       Customer_Segment STRING,
>       Prod_Type1 STRING,
>       Prod_Type2 STRING,
>       Prod_Type3 STRING,
>       Prod_Type4 STRING,
>       Product_Name STRING,
>       Product_Container STRING,
>       Ship_Promo STRING,
>       Supplier_Name STRING,
>       Supplier_Balance DOUBLE,
>       Supplier_Region STRING,
>       Supplier_State STRING,
>       Order_ID STRING,
>       Order_Year INT,
>       Order_Month INT,
>       Order_Day INT,
>       Order_Date_ STRING,
>       Order_Quarter STRING,
>       Product_Base_Margin DOUBLE,
>       Product_ID STRING,
>       Receive_Time DOUBLE,
>       Received_Date_ STRING,
>       Ship_Date_ STRING,
>       Ship_Charge DOUBLE,
>       Total_Cycle_Time DOUBLE,
>       Product_In_Stock STRING,
>       PID INT,
>       Market_Segment STRING
>       );
> Query that works:
> SELECT customer_name, SUM(customer_balance), SUM(order_quantity) FROM default.testv1_staples s1 GROUP BY customer_name HAVING (
> (COUNT(s1.discount) <= 822) AND
> (SUM(customer_balance) <= 4074689.000000041)
> );
> Query that fails:
> SELECT customer_name, SUM(customer_balance), SUM(order_quantity) FROM default.testv1_staples s1 GROUP BY customer_name HAVING (
> (SUM(customer_balance) <= 4074689.000000041)
> AND (COUNT(s1.discount) <= 822)
> );



--
This message was sent by Atlassian JIRA
(v6.2#6252)