[
https://issues.apache.org/jira/browse/HIVE-7326?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14052253#comment-14052253
]
Hive QA commented on HIVE-7326:
-------------------------------
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12654033/HIVE-7326.1.patch.txt
{color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 5692 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_subquery_in_having
org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_root_dir_external_table
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-Build/678/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-Build/678/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-Build-678/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 2 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12654033
> 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)
