Hi All, I have 100 millions data is stored in Doris. I testing rullup performance as the following:
The fist test is was normal and performace improved a lot after created rollup. ------------------------------------------------------ # no create rollup --- costs 4.73 sec SELECT key1, key2, SUM(value_10) FROM tb06 group by key1, key2; # add rollup ALTER TABLE tb06 ADD ROLLUP rollup_key7(key1, key2, value_10); # after created rollup --- 0.02 sec SELECT key1, key2, SUM(value_10) FROM tb06 group by key1, key2; 0.02 ------------------------------------------------------ But the second test found no significant improverment in performance after created rollup. ------------------------------------------------------ # no create rollup --- costs 21.75 sec SELECT prod, region, channel, SUM(value_2) FROM tb06 group by prod, region, channel; # add rollup ALTER TABLE tb06 ADD ROLLUP rollup_key9_1(prod, region, brand, value_2) from rollup_key9; # after created rollup --- 20.97 sec SELECT prod, region, channel, SUM(value_2) FROM tb06 group by prod, region, channel; I want to know if this test is normal, and rollup does not work very well when there is a large amount of data and more number of keys grouped together. 发送自 Windows 10 版邮件应用
