[ https://issues.apache.org/jira/browse/SPARK-9210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Simeon Simeonov updated SPARK-9210: ----------------------------------- Description: 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}}. was: 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 incorrect: the function name is {{first_value}}, not {{first}}. > 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 > Priority: Trivial > > 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