Open kaijianding opened 3 days ago
CREATE TABLE `test_pt` ( `id` int(11) NULL COMMENT "id", `pt` date NOT NULL COMMENT "", `gmv` int(11) NULL COMMENT "gmv" ) ENGINE=OLAP DUPLICATE KEY(`id`) COMMENT "OLAP" PARTITION BY date_trunc('day', pt) DISTRIBUTED BY HASH(`pt`) PROPERTIES ( "replication_num" = "1" ); insert into test_pt values(1,'2024-06-28', 10); CREATE MATERIALIZED VIEW `test_pt_mv` PARTITION BY (`pt`) DISTRIBUTED BY RANDOM REFRESH ASYNC START("2024-03-08 03:00:00") EVERY(INTERVAL 1 MINUTE) PROPERTIES ( "replication_num" = "1" ) AS SELECT pt, id, sum(gmv) AS sum_gmv FROM test_pt GROUP BY pt,id; explain select pt,max(id),sum(gmv) from test_pt group by pt;
select pt,max(id),sum(gmv) from test_pt group by pt should be rewritten by test_pt_mv
select pt,max(id),sum(gmv) from test_pt group by pt
test_pt_mv
Does this PR entail a change in behavior?
Issues 0 New issues 0 Accepted issues
Measures 0 Security Hotspots 0.0% Coverage on New Code 0.0% Duplication on New Code
See analysis details on SonarCloud
:white_check_mark: pass : 0 / 0 (0%)
Why I'm doing:
select pt,max(id),sum(gmv) from test_pt group by pt
should be rewritten bytest_pt_mv
What I'm doing:
What type of PR is this:
Does this PR entail a change in behavior?
Checklist:
Bugfix cherry-pick branch check: