[ https://issues.apache.org/jira/browse/SPARK-9210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael Armbrust resolved SPARK-9210. ------------------------------------- Resolution: Fixed Assignee: Yin Huai Fix Version/s: 1.6.0 > checkValidAggregateExpression() throws exceptions with bad error messages > ------------------------------------------------------------------------- > > Key: SPARK-9210 > URL: https://issues.apache.org/jira/browse/SPARK-9210 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 1.4.1 > Environment: N/A > Reporter: Simeon Simeonov > Assignee: Yin Huai > Priority: Trivial > Fix For: 1.6.0 > > > When a result column in {{SELECT ... GROUP BY}} is neither one of the {{GROUP > BY}} expressions nor uses an aggregation function, > {{org.apache.spark.sql.catalyst.analysis.CheckAnalysis}} throws > {{org.apache.spark.sql.AnalysisException}} with the message "expression > '_column expression_' is neither present in the group by, nor is it an > aggregate function. Add to group by or wrap in first() if you don't care > which value you get." > The remedy suggestion in the exception message is incorrect: the function > name is {{first_value}}, not {{first}}. -- 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