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 Im getting the following error: 14/10/27 22:36:44 ERROR CliDriver: java.lang.RuntimeException: [1.88] failure: ``NOT´´ expected but `select´ found. Isnt it possible to run a subselect in the having-clause? Greetz