Hi Katte:
I think you got mistake,
your rollup in second test is
ALTER TABLE tb06 ADD ROLLUP rollup_key9_1(prod, region, brand, value_2) from
rollup_key9;
which contains columns (prod, region, brand, value_2)
But your query is related to columns （prod, region, channel, value_2). The
column `cha
Hi Katte
Katte 于2019年9月24日周二 下午1:56写道：
> 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.
> --
> # n
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(
