Subquery in having-clause (Spark 1.1.0)

[Daniel Klinger]

Hello,

 

I got the following query:

 

SELECT id, 
       Count(*) AS amount 
FROM   table1 
GROUP  BY id 
HAVING amount = (SELECT Max(mamount) 
                 FROM   (SELECT id, 
                                Count(*) AS mamount 
                         FROM   table1 
                         WHERE  date = 20140807 
                         GROUP  BY id) AS q)

 

If I try to run this query in the spark-sql-cli I’m getting the following
error:

 

14/10/27 22:36:44 ERROR CliDriver: java.lang.RuntimeException: [1.88]
failure: ``NOT´´ expected but `select´ found.

 

Isn’t it possible to run a subselect in the having-clause?

 

Greetz