PROSAGA码农传奇-InfluxDB-InfluxDB获取更改列表

InfluxDB获取更改列表

作者: 一腔诗意喂了狗
发布时间: 2024-09-15 06:00:44 (21小时前)
转自：

<div class =“post-text”itemprop =“text”>
  <P>
    同
     <code>
      group by time
    </code>
     您可以使用
     <code>
      last()
    </code>
     和
     <code>
      difference()
    </code>
     函数用于每个时间间隔获取值更改。
  </p>
   <pre>
    <code>
      SELECT LAST(value)-DIFFERENCE(LAST(value)) as FromValue, LAST(value) as ToValue
FROM demo where time > 1549983975150000000 
GROUP BY time(10ms),tagA FILL(none)

</code>
  </pre>
   <pre>
    <code>
      name: demo
tags: tagA=1
time                FromValue ToValue
----                --------- -------
1549984410470000000           10
1549984421820000000 10        15
1549984431180000000 15        17
1549984436350000000 17        10
1549984753810000000 10        10

</code>
  </pre>
   <pre>
    <code>
      SELECT * FROM demo
name: demo
time                tagA value
----                ---- -----
1549984410475859753 1     10
1549984421827992234 1     15
1549984431180379398 1     17
1549984436356232522 1     10
1549984753817094214 1     10

</code>
  </pre>
</DIV>