Sql技术grafana接入sls的同比实现

编程技巧
22年6月5日
编辑

MySQL

Sql技术：grafana接入sls的同比实现。Sql技术grafana接入sls的同比实现

代码演示

(*)| select
  time,
  to_unixtime(date_parse(concat(date_format(current_timestamp, '%Y-%m-%d '),time), '%Y-%m-%d %H:%i')) as t,
  diff [1] as today,
  diff [2] as yesterday,
  diff [3] as rate
FROM  (
    select
      time,
      compare(pv, 86400) as diff
    FROM      (
        select count(1) as pv , date_format(from_unixtime(__time__), '%H:%i') as time from log group by time
      )
    group by
      time
  )
order by
  time

温馨提示：
1.本站大部分内容均收集于网络!若内容若侵犯到您的权益，请发送邮件至：duhaomu@163.com，我们将第一时间处理！
2.资源所需价格并非资源售卖价格，是收集、整理、编辑详情以及本站运营的适当补贴，并且本站不提供任何免费技术支持。
3.所有资源仅限于参考和学习，版权归原作者所有，更多请阅读网站声明。

给TA赞赏