tomcat错误请求数量以及与上一小时错误请求比较

关键词

网站日志分析,嵌套子查询,通用聚合分析

相关函数

count,compare

内存SQL获取到状态大于等于400的请求数，中间层SQL使用compare函数获取3600秒前的数据，外层中c1是当前时间的错误数量，c2是3600秒前的错误数量，c3是c1/c2的比值，用于展示趋势， 图中使用的是单值图中的同比环比图展示，c1为显示值，c3是对比值

status >= 400 |
SELECT
  diff [1] AS c1,
  diff [2] AS c2,
  round(diff [1] * 100.0 / diff [2] - 100.0, 2) AS c3
FROM
  (
    select
      compare(c, 3600) AS diff
    from
      (
        select
          count(1) as c
        from
          log
      )
  )

SQL查询结果样例：