[jira] [Created] (SPARK-20827) cannot express HAVING without a GROUP BY clause

[N Campbell (JIRA)]

N Campbell created SPARK-20827:
----------------------------------

             Summary: cannot express HAVING without a GROUP BY clause
                 Key: SPARK-20827
                 URL: https://issues.apache.org/jira/browse/SPARK-20827
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 2.1.0
            Reporter: N Campbell


SPARK SQL does not support a HAVING clause without a GROUP BY which is valid 
SQL and supported by other engines (ORACLE, DB2, ....)

    SELECT
        'AAAA' AS `C1`
    FROM
        `cert`.`tparts`
     HAVING 
        COUNT(`pno`) > 0

SQL state: java.lang.UnsupportedOperationException: Cannot evaluate expression: 
count(input[0, string, true]), Query: SELECT
        'AAAA' AS `C1`
    FROM
        `cert`.`tparts`
     HAVING 
        COUNT(`pno`) > 0.
SQLState:  HY000
ErrorCode: 500051



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org