mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-10-14 16:03:27 +00:00
discord9andNing Sun
94d7e2c7fc
* feat!: upgrade DataFusion dependencies to 55 Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * refactor: migrate DataFusion 55 APIs Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix: preserve table function planning behavior Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix: preserve PostgreSQL query compatibility Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix: preserve distributed execution plan behavior Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: cover DataFusion 55 behavior regressions Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: update DataFusion 55 SQLness expectations Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix: complete DataFusion 55 test API migration Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix: address DataFusion 55 CI regressions Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix: address remaining DataFusion 55 regressions Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix: adapt latest base code to DataFusion 55 Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: normalize environment-specific DataFusion 55 plans Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: align final DataFusion 55 expectations Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: isolate DataFusion 55 regression cases Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: preserve empty result schema in timestamp widening Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: preserve JSON source column order Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * chore: use released DataFusion 55 integrations Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: adapt latest execution plan mock to DataFusion 55 Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix: pin DataFusion recursive schema and date repairs Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix(promql): align dictionary temporality match keys Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix: retain Greptime DataFusion fork behaviors on version 55 Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: restore ordinary function error expectations Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: refresh distributed count compatibility plan Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix(query): adapt last-row cast hint to DataFusion 55 Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: refresh instant last-row empty results for Arrow 59 Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * style: simplify DataFusion expression visitor imports Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: restore sorting and PostgreSQL column-order assertions Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix(function): restore primitive numeric coercion signatures Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * refactor(function): share geo integer signature types Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: cover timestamp widening overflow boundaries Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: fix decimal coercion regression imports Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix(function): preserve scalar count_hash NULL state semantics Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: simplify decimal clamp case type inference Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: retain historical count_hash wrapper result Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix: restore timestamp widening equality and IN pruning Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix: carry upstream aggregate dynamic filter correctness fix Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix: carry upstream null and predicate simplification fixes Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: restore baseline JSON ordering expectations Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: restore histogram JSON ordering expectations Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: refresh empty PromQL range result schemas Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: align native timestamp plan with DF55 decimal display Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: refresh native timestamp SQLness results for DF55 Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: regenerate NULL sample empty result headers for DF55 Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: use DF55 child replacement API in timestamp regressions Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix: expose pushed scan dynamic filters to DF55 producers Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix: encode string-backed PostgreSQL OID aliases in binary results Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: verify REGPROC binary and text over PostgreSQL protocol Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: register real PostgreSQL catalogs in server fixtures Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix: complete DF55 expression inventories for custom query plans Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: correct RangeSelect expression fixture and column identities Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * ci: wait for Kafka WAL helper deployment rollout Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * test: update custom storage empty result headers Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix: require exact row counts in scan statistics Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> * fix: suppress deprecated partition_statistics warning in test Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> --------- Signed-off-by: discord9 <55937128+discord9@users.noreply.github.com> Co-authored-by: Ning Sun <sunng@protonmail.com>
237 lines
11 KiB
Plaintext
237 lines
11 KiB
Plaintext
-- Test sum(rate()) function combinations
|
|
CREATE TABLE metrics (
|
|
ts TIMESTAMP TIME INDEX,
|
|
val DOUBLE,
|
|
host STRING,
|
|
`service` STRING,
|
|
PRIMARY KEY (host, service)
|
|
);
|
|
|
|
Affected Rows: 0
|
|
|
|
-- Insert test data with multiple time series
|
|
INSERT INTO metrics VALUES
|
|
-- host1, service1
|
|
(0, 10, 'host1', 'service1'),
|
|
(30000, 15, 'host1', 'service1'),
|
|
(60000, 20, 'host1', 'service1'),
|
|
(90000, 25, 'host1', 'service1'),
|
|
(120000, 30, 'host1', 'service1'),
|
|
(150000, 35, 'host1', 'service1'),
|
|
(180000, 40, 'host1', 'service1'),
|
|
(210000, 45, 'host1', 'service1'),
|
|
(240000, 50, 'host1', 'service1'),
|
|
-- host1, service2
|
|
(0, 5, 'host1', 'service2'),
|
|
(30000, 10, 'host1', 'service2'),
|
|
(60000, 15, 'host1', 'service2'),
|
|
(90000, 20, 'host1', 'service2'),
|
|
(120000, 25, 'host1', 'service2'),
|
|
(150000, 30, 'host1', 'service2'),
|
|
(180000, 35, 'host1', 'service2'),
|
|
(210000, 40, 'host1', 'service2'),
|
|
(240000, 45, 'host1', 'service2'),
|
|
-- host2, service1
|
|
(0, 8, 'host2', 'service1'),
|
|
(30000, 13, 'host2', 'service1'),
|
|
(60000, 18, 'host2', 'service1'),
|
|
(90000, 23, 'host2', 'service1'),
|
|
(120000, 28, 'host2', 'service1'),
|
|
(150000, 33, 'host2', 'service1'),
|
|
(180000, 38, 'host2', 'service1'),
|
|
(210000, 43, 'host2', 'service1'),
|
|
(240000, 48, 'host2', 'service1');
|
|
|
|
Affected Rows: 27
|
|
|
|
-- Test basic sum(rate()) - sum rate across all series
|
|
-- SQLNESS SORT_RESULT 2 1
|
|
TQL EVAL (60, 180, '60s') sum(rate(metrics[1m]));
|
|
|
|
+---------------------+----------------------------------------------+
|
|
| ts | sum(prom_rate(ts_range,val,ts,Int64(60000))) |
|
|
+---------------------+----------------------------------------------+
|
|
| 1970-01-01T00:01:00 | 0.5 |
|
|
| 1970-01-01T00:02:00 | 0.5 |
|
|
| 1970-01-01T00:03:00 | 0.5 |
|
|
+---------------------+----------------------------------------------+
|
|
|
|
-- Test sum(rate()) with grouping by host
|
|
-- SQLNESS SORT_RESULT 2 1
|
|
TQL EVAL (60, 180, '60s') sum by(host) (rate(metrics[1m]));
|
|
|
|
+-------+---------------------+----------------------------------------------+
|
|
| host | ts | sum(prom_rate(ts_range,val,ts,Int64(60000))) |
|
|
+-------+---------------------+----------------------------------------------+
|
|
| host1 | 1970-01-01T00:01:00 | 0.3333333333333333 |
|
|
| host1 | 1970-01-01T00:02:00 | 0.3333333333333333 |
|
|
| host1 | 1970-01-01T00:03:00 | 0.3333333333333333 |
|
|
| host2 | 1970-01-01T00:01:00 | 0.16666666666666666 |
|
|
| host2 | 1970-01-01T00:02:00 | 0.16666666666666666 |
|
|
| host2 | 1970-01-01T00:03:00 | 0.16666666666666666 |
|
|
+-------+---------------------+----------------------------------------------+
|
|
|
|
-- Test sum(rate()) with grouping by service
|
|
-- SQLNESS SORT_RESULT 2 1
|
|
TQL EVAL (60, 180, '60s') sum by(service) (rate(metrics[1m]));
|
|
|
|
+----------+---------------------+----------------------------------------------+
|
|
| service | ts | sum(prom_rate(ts_range,val,ts,Int64(60000))) |
|
|
+----------+---------------------+----------------------------------------------+
|
|
| service1 | 1970-01-01T00:01:00 | 0.3333333333333333 |
|
|
| service1 | 1970-01-01T00:02:00 | 0.3333333333333333 |
|
|
| service1 | 1970-01-01T00:03:00 | 0.3333333333333333 |
|
|
| service2 | 1970-01-01T00:01:00 | 0.16666666666666666 |
|
|
| service2 | 1970-01-01T00:02:00 | 0.16666666666666666 |
|
|
| service2 | 1970-01-01T00:03:00 | 0.16666666666666666 |
|
|
+----------+---------------------+----------------------------------------------+
|
|
|
|
-- Test sum(rate()) with label filtering
|
|
-- SQLNESS SORT_RESULT 2 1
|
|
TQL EVAL (60, 180, '60s') sum(rate(metrics{host="host1"}[1m]));
|
|
|
|
+---------------------+----------------------------------------------+
|
|
| ts | sum(prom_rate(ts_range,val,ts,Int64(60000))) |
|
|
+---------------------+----------------------------------------------+
|
|
| 1970-01-01T00:01:00 | 0.3333333333333333 |
|
|
| 1970-01-01T00:02:00 | 0.3333333333333333 |
|
|
| 1970-01-01T00:03:00 | 0.3333333333333333 |
|
|
+---------------------+----------------------------------------------+
|
|
|
|
-- Test sum(rate()) with multiple label filters
|
|
-- SQLNESS SORT_RESULT 2 1
|
|
TQL EVAL (60, 180, '60s') sum(rate(metrics{host="host1", service="service1"}[1m]));
|
|
|
|
+---------------------+----------------------------------------------+
|
|
| ts | sum(prom_rate(ts_range,val,ts,Int64(60000))) |
|
|
+---------------------+----------------------------------------------+
|
|
| 1970-01-01T00:01:00 | 0.16666666666666666 |
|
|
| 1970-01-01T00:02:00 | 0.16666666666666666 |
|
|
| 1970-01-01T00:03:00 | 0.16666666666666666 |
|
|
+---------------------+----------------------------------------------+
|
|
|
|
-- Test sum(rate()) with regex label matching
|
|
-- SQLNESS SORT_RESULT 2 1
|
|
TQL EVAL (60, 180, '60s') sum(rate(metrics{host=~"host.*"}[1m]));
|
|
|
|
+---------------------+----------------------------------------------+
|
|
| ts | sum(prom_rate(ts_range,val,ts,Int64(60000))) |
|
|
+---------------------+----------------------------------------------+
|
|
| 1970-01-01T00:01:00 | 0.5 |
|
|
| 1970-01-01T00:02:00 | 0.5 |
|
|
| 1970-01-01T00:03:00 | 0.5 |
|
|
+---------------------+----------------------------------------------+
|
|
|
|
-- Test sum(rate()) with different time ranges
|
|
-- SQLNESS SORT_RESULT 2 1
|
|
TQL EVAL (60, 180, '60s') sum(rate(metrics[31s]));
|
|
|
|
+---------------------+----------------------------------------------+
|
|
| ts | sum(prom_rate(ts_range,val,ts,Int64(31000))) |
|
|
+---------------------+----------------------------------------------+
|
|
| 1970-01-01T00:01:00 | 0.5 |
|
|
| 1970-01-01T00:02:00 | 0.5 |
|
|
| 1970-01-01T00:03:00 | 0.5 |
|
|
+---------------------+----------------------------------------------+
|
|
|
|
-- Test sum(rate()) with longer evaluation window
|
|
-- SQLNESS SORT_RESULT 2 1
|
|
TQL EVAL (60, 240, '60s') sum(rate(metrics[1m]));
|
|
|
|
+---------------------+----------------------------------------------+
|
|
| ts | sum(prom_rate(ts_range,val,ts,Int64(60000))) |
|
|
+---------------------+----------------------------------------------+
|
|
| 1970-01-01T00:01:00 | 0.5 |
|
|
| 1970-01-01T00:02:00 | 0.5 |
|
|
| 1970-01-01T00:03:00 | 0.5 |
|
|
| 1970-01-01T00:04:00 | 0.5 |
|
|
+---------------------+----------------------------------------------+
|
|
|
|
-- Test sum(rate()) combined with arithmetic operations
|
|
-- SQLNESS SORT_RESULT 2 1
|
|
TQL EVAL (60, 180, '60s') sum(rate(metrics[1m])) * 100;
|
|
|
|
+---------------------+-------------------------------------------------------------+
|
|
| ts | sum(prom_rate(ts_range,val,ts,Int64(60000))) * Float64(100) |
|
|
+---------------------+-------------------------------------------------------------+
|
|
| 1970-01-01T00:01:00 | 50.0 |
|
|
| 1970-01-01T00:02:00 | 50.0 |
|
|
| 1970-01-01T00:03:00 | 50.0 |
|
|
+---------------------+-------------------------------------------------------------+
|
|
|
|
-- Test sum(rate()) with grouping and arithmetic
|
|
-- SQLNESS SORT_RESULT 2 1
|
|
TQL EVAL (60, 180, '60s') sum by(host) (rate(metrics[1m])) * 60;
|
|
|
|
+-------+---------------------+------------------------------------------------------------+
|
|
| host | ts | sum(prom_rate(ts_range,val,ts,Int64(60000))) * Float64(60) |
|
|
+-------+---------------------+------------------------------------------------------------+
|
|
| host1 | 1970-01-01T00:01:00 | 20.0 |
|
|
| host1 | 1970-01-01T00:02:00 | 20.0 |
|
|
| host1 | 1970-01-01T00:03:00 | 20.0 |
|
|
| host2 | 1970-01-01T00:01:00 | 10.0 |
|
|
| host2 | 1970-01-01T00:02:00 | 10.0 |
|
|
| host2 | 1970-01-01T00:03:00 | 10.0 |
|
|
+-------+---------------------+------------------------------------------------------------+
|
|
|
|
-- Test querying non-existent table
|
|
TQL EVAL (60, 180, '60s') sum(rate(non_existent_table[1m]));
|
|
|
|
+------+----------------------------------------------------+
|
|
| time | sum(prom_rate(time_range,value,time,Int64(60000))) |
|
|
+------+----------------------------------------------------+
|
|
+------+----------------------------------------------------+
|
|
|
|
-- Test querying non-existent label
|
|
TQL EVAL (60, 180, '60s') sum(rate(metrics{non_existent_label="value"}[1m]));
|
|
|
|
+----+----------------------------------------------+
|
|
| ts | sum(prom_rate(ts_range,val,ts,Int64(60000))) |
|
|
+----+----------------------------------------------+
|
|
+----+----------------------------------------------+
|
|
|
|
-- Test querying non-existent label value
|
|
TQL EVAL (60, 180, '60s') sum(rate(metrics{host="non_existent_host"}[1m]));
|
|
|
|
+----+----------------------------------------------+
|
|
| ts | sum(prom_rate(ts_range,val,ts,Int64(60000))) |
|
|
+----+----------------------------------------------+
|
|
+----+----------------------------------------------+
|
|
|
|
-- Test querying multiple non-existent labels
|
|
TQL EVAL (60, 180, '60s') sum(rate(metrics{non_existent_label1="value1", non_existent_label2="value2"}[1m]));
|
|
|
|
+----+----------------------------------------------+
|
|
| ts | sum(prom_rate(ts_range,val,ts,Int64(60000))) |
|
|
+----+----------------------------------------------+
|
|
+----+----------------------------------------------+
|
|
|
|
-- Test querying mix of existing and non-existent labels
|
|
TQL EVAL (60, 180, '60s') sum(rate(metrics{host="host1", non_existent_label="value"}[1m]));
|
|
|
|
+----+----------------------------------------------+
|
|
| ts | sum(prom_rate(ts_range,val,ts,Int64(60000))) |
|
|
+----+----------------------------------------------+
|
|
+----+----------------------------------------------+
|
|
|
|
-- Test querying non-existent table with non-existent labels
|
|
TQL EVAL (60, 180, '60s') sum(rate(non_existent_table{non_existent_label="value"}[1m]));
|
|
|
|
+------+----------------------------------------------------+
|
|
| time | sum(prom_rate(time_range,value,time,Int64(60000))) |
|
|
+------+----------------------------------------------------+
|
|
+------+----------------------------------------------------+
|
|
|
|
-- Test querying non-existent table with multiple non-existent labels
|
|
TQL EVAL (60, 180, '60s') sum(rate(non_existent_table{label1="value1", label2="value2"}[1m]));
|
|
|
|
+------+----------------------------------------------------+
|
|
| time | sum(prom_rate(time_range,value,time,Int64(60000))) |
|
|
+------+----------------------------------------------------+
|
|
+------+----------------------------------------------------+
|
|
|
|
DROP TABLE metrics;
|
|
|
|
Affected Rows: 0
|
|
|