You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "Reynold Xin (JIRA)" <ji...@apache.org> on 2014/06/21 00:44:26 UTC

[jira] [Resolved] (SPARK-2225) Turn HAVING without GROUP BY into WHERE

     [ https://issues.apache.org/jira/browse/SPARK-2225?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Reynold Xin resolved SPARK-2225.
--------------------------------

       Resolution: Fixed
    Fix Version/s: 1.1.0
                   1.0.1
         Assignee: Reynold Xin  (was: William Benton)

> 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
>            Assignee: Reynold Xin
>             Fix For: 1.0.1, 1.1.0
>
>
> 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)