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