SHOW:
|
|
- or go back to the newest paste.
1 | > INSERT cpu,host=serverA,region=us_west value=0.64 | |
2 | > INSERT cpu,host=serverA,region=us_west,flag=present value=0.02 | |
3 | > select * from cpu | |
4 | name: cpu | |
5 | time flag host region value | |
6 | ---- ---- ---- ------ ----- | |
7 | 1531922717291594433 serverA us_west 0.64 | |
8 | 1531922750165106605 present serverA us_west 0.02 | |
9 | > select mean(value) from cpu group by flag | |
10 | name: cpu | |
11 | tags: flag= | |
12 | time mean | |
13 | ---- ---- | |
14 | 0 0.64 | |
15 | ||
16 | name: cpu | |
17 | tags: flag=present | |
18 | time mean | |
19 | ---- ---- | |
20 | 0 0.02 |