最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

amazon web services - AWS Managed TSDB alerting - Stack Overflow

programmeradmin4浏览0评论

I am trying to create an alerting rule using the below query on grafana

SELECT 
  $__timeGroupAlias(time, '5m'), 
  nodeName,
  mountPoint,
  MAX(totalSpace) AS totalSpace,
  MAX(freeSpace) AS freeSpace,
  (MAX(totalSpace) - MAX(freeSpace)) AS "UsedSpace",
  (CAST(MAX(totalSpace) - MAX(freeSpace) AS DOUBLE) / CAST(MAX(totalSpace) AS DOUBLE)) * 100 AS "Disk Utilization (%)"
FROM $database."hub-disk-usage"
WHERE $__timeFilter(time) 
GROUP BY 1, nodeName, mountPoint
ORDER BY 1 DESC

However I am getting the error

Failed to evaluate queries and expressions: failed to execute query A: ValidationException: The query syntax is invalid at line 2:3

Can someone please advice

I am expecting a table with the diskusage to be populated

发布评论

评论列表(0)

  1. 暂无评论