[ https://issues.apache.org/jira/browse/SPARK-13971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15207168#comment-15207168 ]
Sunitha Kambhampati commented on SPARK-13971: --------------------------------------------- fwiw, it is not the exact same env but I tried the same query against the master ( v2.0 snapshot) and it worked fine using the sqlContext. > 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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org