[ https://issues.apache.org/jira/browse/SPARK-30974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Akshay updated SPARK-30974: --------------------------- Summary: org.apache.spark.sql.AnalysisException: expression 'default.udfvalidation.`empname`' is neither present in the group by, nor is it an aggregate function. (was: org.apache.spark.sql.AnalysisException: expression 'default.udfvalidation.`empname`' is neither present in the group by, nor is it an aggregate function. Add to group by or wrap in first() (or first_value) if you don't care which value you get.;;) > org.apache.spark.sql.AnalysisException: expression > 'default.udfvalidation.`empname`' is neither present in the group by, nor is > it an aggregate function. > ---------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: SPARK-30974 > URL: https://issues.apache.org/jira/browse/SPARK-30974 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.4.2 > Reporter: Akshay > Priority: Minor > > I'm getting the following exception while executing the query in spark 2.4.2 > !image-2020-02-27-20-07-03-701.png! > > > !image-2020-02-27-20-03-01-399.png! -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org