mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-05-15 04:20:39 +00:00
2dc4c294cf
* feat: support group by op in promql Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * restrict to single field table Signed-off-by: Ruihang Xia <waynestxia@gmail.com> --------- Signed-off-by: Ruihang Xia <waynestxia@gmail.com>
41 lines
1.3 KiB
SQL
41 lines
1.3 KiB
SQL
-- Regression test for promql `group()` aggregator planning.
|
|
|
|
CREATE TABLE kubernetes_build_info (
|
|
ts timestamp(3) time index,
|
|
cluster_name STRING,
|
|
service_name STRING,
|
|
job_name STRING,
|
|
instance STRING,
|
|
val DOUBLE,
|
|
PRIMARY KEY(cluster_name, service_name, job_name, instance),
|
|
);
|
|
|
|
INSERT INTO TABLE kubernetes_build_info VALUES
|
|
(0, 'cluster_a', 'kubernetes', 'apiserver', '0', 123.0),
|
|
(0, 'cluster_a', 'kubernetes', 'apiserver', '1', 456.0),
|
|
(0, 'cluster_b', 'kubernetes', 'apiserver', '0', 789.0);
|
|
|
|
TQL EVAL (0, 0, '1s') sum(group by (cluster_name)(kubernetes_build_info{service_name="kubernetes",job_name="apiserver"}));
|
|
|
|
DROP TABLE kubernetes_build_info;
|
|
|
|
-- `group()` doesn't support multi-field input without selecting a single field.
|
|
CREATE TABLE kubernetes_build_info_multi (
|
|
ts timestamp(3) time index,
|
|
cluster_name STRING,
|
|
service_name STRING,
|
|
job_name STRING,
|
|
instance STRING,
|
|
cpu DOUBLE,
|
|
mem DOUBLE,
|
|
PRIMARY KEY(cluster_name, service_name, job_name, instance),
|
|
);
|
|
|
|
INSERT INTO TABLE kubernetes_build_info_multi VALUES
|
|
(0, 'cluster_a', 'kubernetes', 'apiserver', '0', 1.0, 2.0),
|
|
(0, 'cluster_b', 'kubernetes', 'apiserver', '0', 3.0, 4.0);
|
|
|
|
TQL EVAL (0, 0, '1s') group by (cluster_name)(kubernetes_build_info_multi{service_name="kubernetes",job_name="apiserver"});
|
|
|
|
DROP TABLE kubernetes_build_info_multi;
|