Hi, It seems that there is a syntax error in your SQL. You should use `select ... from ... group by ... having sum(...)=0 and sum(...)>0` instead of `where sum(...)=0...`. I think aggregate functions are not allowed in WHERE.
-- Sent from: http://apache-spark-user-list.1001560.n3.nabble.com/ --------------------------------------------------------------------- To unsubscribe e-mail: [email protected]
