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 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.orgmailto: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

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

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

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 
shahab.mok...@gmail.com /divdivDate:03/04/2015  7:22 AM  (GMT-05:00) 
/divdivTo: user@spark.apache.org /divdivSubject: Does SparkSQL support 
. having count (fieldname) in SQL statement? /divdiv
/divHi,

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