You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "Akshay (Jira)" <ji...@apache.org> on 2020/02/27 14:43:00 UTC

[jira] [Created] (SPARK-30974) 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.;;

Akshay created 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. Add to group by or wrap in first() (or first_value) if you don't care which value you get.;;
                 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


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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org