You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Hari Sankar Sivarama Subramaniyan (JIRA)" <ji...@apache.org> on 2014/07/02 00:43:24 UTC
[jira] [Created] (HIVE-7326) Hive complains invalid column
reference with group by having aggregate predicates
Hari Sankar Sivarama Subramaniyan created HIVE-7326:
-------------------------------------------------------
Summary: Hive complains invalid column reference with group by 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
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)