You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Javier Pérez (JIRA)" <ji...@apache.org> on 2016/03/17 13:37:33 UTC
[jira] [Created] (SPARK-13971) Implicit group by with distinct
modifier on having raises an unexpected error
Javier Pérez created SPARK-13971:
------------------------------------
Summary: Implicit group by with distinct modifier on having raises an unexpected error
Key: SPARK-13971
URL: https://issues.apache.org/jira/browse/SPARK-13971
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 1.6.0
Environment: spark standalone mode installed on Centos7
Reporter: Javier Pérez
1. Start-thriftserver
2. connect with beeline
3 perform the following query over a simple talbe:
SELECT COUNT(DISTINCT field1) FROM test_table HAVING COUNT(DISTINCT field1) = 3
TRACE:
ERROR SparkExecuteStatementOperation: Error running hive query:
org.apache.hive.service.cli.HiveSQLException: org.apache.spark.sql.AnalysisException: resolved attribute(s) gid#13616,field1#13617 missing from field1#13612,field2#13611,field2#13608,field3#13610,field4#13613,field5#13609 in operator !Expand [List(null, 0, if ((gid#13616 = 1)) field1#13617 else null),List(field2#13608, 1, null)], [field2#13619,gid#13618,if ((gid = 1)) field1 else null#13620];
at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.org$apache$spark$sql$hive$thriftserver$SparkExecuteStatementOperation$$execute(SparkExecuteStatementOperation.scala:246)
at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation$$anon$1$$anon$2.run(SparkExecuteStatementOperation.scala:154)
at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation$$anon$1$$anon$2.run(SparkExecuteStatementOperation.scala:151)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:422)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1491)
at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation$$anon$1.run(SparkExecuteStatementOperation.scala:164)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org