[
https://issues.apache.org/jira/browse/SPARK-2589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Reynold Xin resolved SPARK-2589.
--------------------------------
Resolution: Duplicate
> Support HAVING clause generated by Tableau
> ------------------------------------------
>
> Key: SPARK-2589
> URL: https://issues.apache.org/jira/browse/SPARK-2589
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.0.1, 1.0.2
> Reporter: Cheng Lian
>
> The query on how Tableau generates # of records:
> {code}
> SELECT SUM(1) AS `sum_number_of_records_ok` FROM `some_db`.`some_table`
> `some_table` GROUP BY 1 HAVING (COUNT(1) > 0)
> {code}
> The following query can be used to reproduce this issue under {{sbt
> hive/console}}
> {code}
> select sum(1) from src group by 1 having (count(1) > 0);
> {code}
> Exception stacktrace:
> {code}
> org.apache.spark.sql.catalyst.errors.package$TreeNodeException (No function
> to evaluate expression. type: Count, tree: COUNT(1))
>
> org.apache.spark.sql.catalyst.expressions.AggregateExpression.eval(aggregates.scala:40)
>
> org.apache.spark.sql.catalyst.expressions.Expression.c2(Expression.scala:207)
>
> org.apache.spark.sql.catalyst.expressions.GreaterThan.eval(predicates.scala:168)
>
> org.apache.spark.sql.execution.Filter$$anonfun$2$$anonfun$apply$1.apply(basicOperators.scala:54)
>
> org.apache.spark.sql.execution.Filter$$anonfun$2$$anonfun$apply$1.apply(basicOperators.scala:54)
> scala.collection.Iterator$$anon$14.hasNext(Iterator.scala:390)
> scala.collection.Iterator$$anon$11.hasNext(Iterator.scala:327)
> scala.collection.Iterator$class.foreach(Iterator.scala:727)
> scala.collection.AbstractIterator.foreach(Iterator.scala:1157)
>
> scala.collection.generic.Growable$class.$plus$plus$eq(Growable.scala:48)
>
> scala.collection.mutable.ArrayBuffer.$plus$plus$eq(ArrayBuffer.scala:103)
>
> scala.collection.mutable.ArrayBuffer.$plus$plus$eq(ArrayBuffer.scala:47)
> scala.collection.TraversableOnce$class.to(TraversableOnce.scala:273)
> scala.collection.AbstractIterator.to(Iterator.scala:1157)
>
> scala.collection.TraversableOnce$class.toBuffer(TraversableOnce.scala:265)
> scala.collection.AbstractIterator.toBuffer(Iterator.scala:1157)
>
> scala.collection.TraversableOnce$class.toArray(TraversableOnce.scala:252)
> scala.collection.AbstractIterator.toArray(Iterator.scala:1157)
>
> org.apache.spark.rdd.RDD$$anonfun$org$apache$spark$rdd$RDD$$collectPartition$1$1.apply(RDD.scala:773)
>
> org.apache.spark.rdd.RDD$$anonfun$org$apache$spark$rdd$RDD$$collectPartition$1$1.apply(RDD.scala:773)
>
> org.apache.spark.SparkContext$$anonfun$runJob$4.apply(SparkContext.scala:1096)
>
> org.apache.spark.SparkContext$$anonfun$runJob$4.apply(SparkContext.scala:1096)
> org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:112)
> org.apache.spark.scheduler.Task.run(Task.scala:51)
> org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:189)
>
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> java.lang.Thread.run(Thread.java:745)
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
