mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-14 09:12:57 +00:00
b476584f56
* quantile udaf Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * extrapolate rate Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * predict_linear, round, holt_winters, quantile_overtime Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix clippy Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix quantile function Signed-off-by: Ruihang Xia <waynestxia@gmail.com> --------- Signed-off-by: Ruihang Xia <waynestxia@gmail.com>
66 lines
2.4 KiB
Plaintext
66 lines
2.4 KiB
Plaintext
create table metric_total (
|
|
ts timestamp time index,
|
|
val double,
|
|
);
|
|
|
|
Affected Rows: 0
|
|
|
|
insert into metric_total values
|
|
(0, 1),
|
|
(10000, 2);
|
|
|
|
Affected Rows: 2
|
|
|
|
tql eval (10, 10, '1s') sum_over_time(metric_total[50s:10s]);
|
|
|
|
+---------------------+----------------------------------+
|
|
| ts | prom_sum_over_time(ts_range,val) |
|
|
+---------------------+----------------------------------+
|
|
| 1970-01-01T00:00:10 | 3.0 |
|
|
+---------------------+----------------------------------+
|
|
|
|
tql eval (10, 10, '1s') sum_over_time(metric_total[50s:5s]);
|
|
|
|
+---------------------+----------------------------------+
|
|
| ts | prom_sum_over_time(ts_range,val) |
|
|
+---------------------+----------------------------------+
|
|
| 1970-01-01T00:00:10 | 4.0 |
|
|
+---------------------+----------------------------------+
|
|
|
|
tql eval (300, 300, '1s') sum_over_time(metric_total[50s:10s]);
|
|
|
|
+---------------------+----------------------------------+
|
|
| ts | prom_sum_over_time(ts_range,val) |
|
|
+---------------------+----------------------------------+
|
|
| 1970-01-01T00:05:00 | 10.0 |
|
|
+---------------------+----------------------------------+
|
|
|
|
tql eval (359, 359, '1s') sum_over_time(metric_total[60s:10s]);
|
|
|
|
+---------------------+----------------------------------+
|
|
| ts | prom_sum_over_time(ts_range,val) |
|
|
+---------------------+----------------------------------+
|
|
| 1970-01-01T00:05:59 | 2.0 |
|
|
+---------------------+----------------------------------+
|
|
|
|
tql eval (10, 10, '1s') rate(metric_total[20s:10s]);
|
|
|
|
+---------------------+-----------------------------------------+
|
|
| ts | prom_rate(ts_range,val,ts,Int64(20000)) |
|
|
+---------------------+-----------------------------------------+
|
|
| 1970-01-01T00:00:10 | 0.1 |
|
|
+---------------------+-----------------------------------------+
|
|
|
|
tql eval (20, 20, '1s') rate(metric_total[20s:5s]);
|
|
|
|
+---------------------+-----------------------------------------+
|
|
| ts | prom_rate(ts_range,val,ts,Int64(20000)) |
|
|
+---------------------+-----------------------------------------+
|
|
| 1970-01-01T00:00:20 | 0.06666666666666667 |
|
|
+---------------------+-----------------------------------------+
|
|
|
|
drop table metric_total;
|
|
|
|
Affected Rows: 0
|
|
|