[SPARK-2226] HAVING should be able to contain aggregate expressions that don't appear in the aggregation list.

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 1.1.0
• Component/s: SQL
• Assignee: William Benton
• Reporter: Reynold Xin
• Created: 20/Jun/14 20:52
• Updated: 23/Jul/14 23:26
• Resolved: 23/Jul/14 23:26

Description

https://github.com/apache/hive/blob/trunk/ql/src/test/queries/clientpositive/having.q

This test file contains the following query:

SELECT key FROM src GROUP BY key HAVING max(value) > "val_255";

Once we fixed this issue, we should whitelist having.q.

Issue Links

• is duplicated by: SPARK-2589 Support HAVING clause generated by Tableau
• relates to: SPARK-2180 Basic HAVING clauses support for HiveQL
• links to: [Github] Pull Request #1497 (willb)