[SPARK-2225] Turn HAVING without GROUP BY into WHERE

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 1.0.1, 1.1.0
• Component/s: SQL
• Assignee: Reynold Xin
• Reporter: Reynold Xin
• Created: 20/Jun/14 20:43
• Updated: 20/Jun/14 22:43
• Resolved: 20/Jun/14 22:43

Description

See http://msdn.microsoft.com/en-US/library/8hhs5f4e(v=vs.80).aspx

The HAVING clause specifies conditions that determines the groups included in the query. If the SQL SELECT statement does not contain aggregate functions, you can use a SQL SELECT statement that contains a HAVING clause without a GROUP BY clause.

Issue Links

• relates to: SPARK-2180 Basic HAVING clauses support for HiveQL