You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I had searched in the issues and found no similar issues.
Version
2.1
What's Wrong?
nereids planner slower than old planner
What You Expected?
fix this issue
How to Reproduce?
CREATE TABLE `test_tbl` (
`id` VARCHAR(200) NULL,
`create_time` DATETIME NULL,
`amount` DECIMAL(21, 10) NULL,
`num` VARCHAR(1020) NULL
) ENGINE=OLAP
UNIQUE KEY(`id`, `create_time`)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(`id`) BUCKETS 10
PROPERTIES (
"replication_allocation" = "tag.location.default: 1"
);
SELECT count(id) FROM ( SELECT id, sum(amount) AS am, count(DISTINCT num) AS num FROM test_tbl GROUP BY id ) s1 WHERE 1 = 1 AND am >= 10 AND am <= 1000000 AND num >= 2 AND num <= 10000;
20000000 records in test_tbl
with set enable_nereids_planner=true, cost 11.40s
with set enable_nereids_planner=false, cost 4.66s
Search before asking
Version
2.1
What's Wrong?
nereids planner slower than old planner
What You Expected?
fix this issue
How to Reproduce?
20000000 records in test_tbl
with
set enable_nereids_planner=true
, cost 11.40swith
set enable_nereids_planner=false
, cost 4.66sAnything Else?
No response
Are you willing to submit PR?
Code of Conduct
The text was updated successfully, but these errors were encountered: