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
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)