RE: Does SparkSQL support ..... having count (fieldname) in SQL statement?

2015-03-04 Thread Cheng, Hao
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

Re: Does SparkSQL support ..... having count (fieldname) in SQL statement?

2015-03-04 Thread shahab
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

RE: Does SparkSQL support ..... having count (fieldname) in SQL statement?

2015-03-04 Thread yana
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. div Original message /divdivFrom: shahab