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: [email protected]
For additional commands, e-mail: [email protected]
