column "ms.xxx_time" must appear in the GROUP BY clause or be used in an aggregate function

最新推荐文章于 2024-06-20 09:59:06 发布

殇莫忆

最新推荐文章于 2024-06-20 09:59:06 发布

阅读量2.6w

点赞数 3

分类专栏：报错报错的专栏文章标签：报错

本文链接：https://blog.csdn.net/qq_28289405/article/details/81178764

版权

报错同时被 2 个专栏收录

55 篇文章 0 订阅

订阅专栏

报错的专栏

55 篇文章 1 订阅

订阅专栏

 SELECT
        avg() as ,
        max() as ,
        min() as ,
        count() as ,
        sum() as ,
        to_char(xxx,
        'yyyy-MM-dd hh24:MI:ss') 
    FROM
        metrics  
    where
        metrics.tag =?  
        and zzz_time between ? and ?
2018-07-24 09:29:56.785  WARN 9768 --- [nio-8080-exec-4] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42803
2018-07-24 09:29:56.785 ERROR 9768 --- [nio-8080-exec-4] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: column "metrics.server_time" must appear in the GROUP BY clause or be used in an aggregate function
  位置：147
2018-07-24 09:29:56.938 ERROR 9768 --- [nio-8080-exec-4] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet] with root cause

org.postgresql.util.PSQLException: ERROR: column "metrics.server_time" must appear in the GROUP BY clause or be used in an aggregate function
  位置：147