mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-08 06:12:55 +00:00
115 lines
3.2 KiB
Plaintext
115 lines
3.2 KiB
Plaintext
-- Referenced from https://github.com/prometheus/prometheus/blob/a48d348811619ba4e8eae9c3eaae4857749a1578/promql/promqltest/testdata/functions.test#L172-L185
|
|
create table calculate_rate_offset_total (
|
|
ts timestamp time index,
|
|
val double,
|
|
x string primary key
|
|
);
|
|
|
|
Affected Rows: 0
|
|
|
|
insert into calculate_rate_offset_total values
|
|
(0, 0.0, 'a'),
|
|
(300000, 10.0, 'a'),
|
|
(600000, 20.0, 'a'),
|
|
(900000, 30.0, 'a'),
|
|
(1200000, 40.0, 'a'),
|
|
(1500000, 50.0, 'a'),
|
|
(1800000, 60.0, 'a'),
|
|
(2100000, 70.0, 'a'),
|
|
(2400000, 80.0, 'a'),
|
|
(2700000, 90.0, 'a'),
|
|
(3000000, 100.0, 'a'),
|
|
(0, 0.0, 'b'),
|
|
(300000, 20.0, 'b'),
|
|
(600000, 40.0, 'b'),
|
|
(900000, 60.0, 'b'),
|
|
(1200000, 80.0, 'b'),
|
|
(1500000, 100.0, 'b'),
|
|
(1800000, 120.0, 'b'),
|
|
(2100000, 140.0, 'b'),
|
|
(2400000, 160.0, 'b'),
|
|
(2700000, 180.0, 'b'),
|
|
(3000000, 200.0, 'b');
|
|
|
|
Affected Rows: 22
|
|
|
|
-- SQLNESS SORT_RESULT 3 1
|
|
tql eval (1500, 1500, '1s') calculate_rate_offset_total;
|
|
|
|
+---------------------+-------+---+
|
|
| ts | val | x |
|
|
+---------------------+-------+---+
|
|
| 1970-01-01T00:25:00 | 100.0 | b |
|
|
| 1970-01-01T00:25:00 | 50.0 | a |
|
|
+---------------------+-------+---+
|
|
|
|
-- SQLNESS SORT_RESULT 3 1
|
|
tql eval (1500, 1500, '1s') calculate_rate_offset_total offset 10m;
|
|
|
|
+---------------------+-------+---+
|
|
| ts | val | x |
|
|
+---------------------+-------+---+
|
|
| 1970-01-01T00:25:00 | 140.0 | b |
|
|
| 1970-01-01T00:25:00 | 70.0 | a |
|
|
+---------------------+-------+---+
|
|
|
|
-- SQLNESS SORT_RESULT 3 1
|
|
tql eval (1500, 1500, '1s') calculate_rate_offset_total offset -10m;
|
|
|
|
+---------------------+------+---+
|
|
| ts | val | x |
|
|
+---------------------+------+---+
|
|
| 1970-01-01T00:25:00 | 30.0 | a |
|
|
| 1970-01-01T00:25:00 | 60.0 | b |
|
|
+---------------------+------+---+
|
|
|
|
-- SQLNESS SORT_RESULT 3 1
|
|
tql eval (0, 0, '1s') calculate_rate_offset_total offset 10m;
|
|
|
|
+---------------------+------+---+
|
|
| ts | val | x |
|
|
+---------------------+------+---+
|
|
| 1970-01-01T00:00:00 | 20.0 | a |
|
|
| 1970-01-01T00:00:00 | 40.0 | b |
|
|
+---------------------+------+---+
|
|
|
|
tql eval (0, 0, '1s') calculate_rate_offset_total offset -10m;
|
|
|
|
++
|
|
++
|
|
|
|
tql eval (3000, 3000, '1s') calculate_rate_offset_total offset 10m;
|
|
|
|
++
|
|
++
|
|
|
|
-- SQLNESS SORT_RESULT 3 1
|
|
tql eval (3000, 3000, '1s') calculate_rate_offset_total offset -10m;
|
|
|
|
+---------------------+-------+---+
|
|
| ts | val | x |
|
|
+---------------------+-------+---+
|
|
| 1970-01-01T00:50:00 | 160.0 | b |
|
|
| 1970-01-01T00:50:00 | 80.0 | a |
|
|
+---------------------+-------+---+
|
|
|
|
tql eval (3000, 3000, '1s') rate(calculate_rate_window_total[10m]);
|
|
|
|
++
|
|
++
|
|
|
|
-- SQLNESS SORT_RESULT 3 1
|
|
tql eval (3000, 3000, '1s') rate(calculate_rate_offset_total[10m] offset 5m);
|
|
|
|
+---------------------+------------------------------------------+---+
|
|
| ts | prom_rate(ts_range,val,ts,Int64(600000)) | x |
|
|
+---------------------+------------------------------------------+---+
|
|
| 1970-01-01T00:50:00 | 0.03333333333333333 | a |
|
|
| 1970-01-01T00:50:00 | 0.06666666666666667 | b |
|
|
+---------------------+------------------------------------------+---+
|
|
|
|
drop table calculate_rate_offset_total;
|
|
|
|
Affected Rows: 0
|
|
|