Thanks Cheng, my problem was some misspelling problem which I just fixed, unfortunately the exception message sometimes does not pin point to exact reason. Sorry my bad.
On Wed, Mar 4, 2015 at 5:02 PM, Cheng, Hao <hao.ch...@intel.com> wrote: > I’ve tried with latest code, seems it works, which version are you using > Shahab? > > > > *From:* yana [mailto:yana.kadiy...@gmail.com] > *Sent:* Wednesday, March 4, 2015 8:47 PM > *To:* shahab; user@spark.apache.org > *Subject:* RE: Does SparkSQL support "..... having count (fieldname)" in > SQL statement? > > > > I think the problem is that you are using an alias in the having clause. I > am not able to try just now but see if HAVING count (*)> 2 works ( ie dont > use cnt) > > > > > > Sent on the new Sprint Network from my Samsung Galaxy S®4. > > > > -------- Original message -------- > > From: shahab > > Date:03/04/2015 7:22 AM (GMT-05:00) > > To: user@spark.apache.org > > Subject: Does SparkSQL support "..... having count (fieldname)" in SQL > statement? > > > > Hi, > > > > It seems that SparkSQL, even the HiveContext, does not support SQL > statements like : SELECT category, count(1) AS cnt FROM products GROUP BY > category HAVING cnt > 10; > > > > I get this exception: > > > > Error: org.apache.spark.sql.catalyst.errors.package$TreeNodeException: > Unresolved attributes: CAST(('cnt < 2), BooleanType), tree: > > > > > > I couldn't find anywhere is documentation whether "having" keyword is not > supported ? > > If this is the case, what would be the work around? using two nested > select statements? > > > > best, > > /Shahab >