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:44:00 UTC
[jira] [Updated] (SPARK-30974)
org.apache.spark.sql.AnalysisException: expression
'default.udfvalidation.`empname`' is neither present in the group by, nor
is it an aggregate function.
[ 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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org