Simeon Simeonov created SPARK-9210:
--------------------------------------
Summary: 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: Minor
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}}.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
