Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via GitHub by martint
, 1 year ago
':input(1)' must be an aggregate expression or appear in GROUP BY clause
via GitHub by martint
, 1 year ago
'"id"' must be an aggregate expression or appear in GROUP BY clause
com.facebook.presto.sql.analyzer.SemanticException: ':input(1)' must be an aggregate expression or appear in GROUP BY clause	at com.facebook.presto.sql.analyzer.AggregationAnalyzer.analyze(AggregationAnalyzer.java:133)	at com.facebook.presto.sql.analyzer.StatementAnalyzer.verifyAggregations(StatementAnalyzer.java:1433)	at com.facebook.presto.sql.analyzer.StatementAnalyzer.analyzeAggregations(StatementAnalyzer.java:1394)	at com.facebook.presto.sql.analyzer.StatementAnalyzer.visitQuerySpecification(StatementAnalyzer.java:655)	at com.facebook.presto.sql.analyzer.StatementAnalyzer.visitQuerySpecification(StatementAnalyzer.java:161)	at com.facebook.presto.sql.tree.QuerySpecification.accept(QuerySpecification.java:125)	at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:22)	at com.facebook.presto.sql.analyzer.StatementAnalyzer.visitQuery(StatementAnalyzer.java:409)	at com.facebook.presto.sql.analyzer.StatementAnalyzer.visitQuery(StatementAnalyzer.java:161)	at com.facebook.presto.sql.tree.Query.accept(Query.java:103)	at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:22)	at com.facebook.presto.sql.analyzer.Analyzer.analyze(Analyzer.java:62)	at com.facebook.presto.execution.SqlQueryExecution.doAnalyzeQuery(SqlQueryExecution.java:274)	at com.facebook.presto.execution.SqlQueryExecution.analyzeQuery(SqlQueryExecution.java:260)	at com.facebook.presto.execution.SqlQueryExecution.start(SqlQueryExecution.java:224)	at com.facebook.presto.execution.QueuedExecution.lambda$start$1(QueuedExecution.java:62)	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)	at java.lang.Thread.run(Thread.java:745)