[
https://issues.apache.org/jira/browse/SPARK-2225?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14039335#comment-14039335
]
William Benton commented on SPARK-2225:
---------------------------------------
So the Hive test suite treats HAVING without GROUP BY as an error (see
having1.q), although it is accepted by some dialects (like SQL Server). I'm
happy to take this, though, if this is what we want to do here.
> Turn HAVING without GROUP BY into WHERE
> ---------------------------------------
>
> Key: SPARK-2225
> URL: https://issues.apache.org/jira/browse/SPARK-2225
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 1.0.0
> Reporter: Reynold Xin
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
