zenoyang commented on pull request #8555:
URL: https://github.com/apache/incubator-doris/pull/8555#issuecomment-1073540370
I used a table with 20 million rows to test the query. The current master
branch version query takes 18s. After optimization, it only takes 4s. The sql
is as follows: (1FE, 3BE)
```sql
select
dt, HLL_UNION_AGG(union_id)
from
xxx
where
dt = 20211130 and hour <= 19 and minute > 10
group by dt;
```
I started 10 concurrent queries for stress testing, and found that the
memory consumption was also reduced after optimization, as shown in the
following figure:
<img width="1606" alt="image"
src="https://user-images.githubusercontent.com/21984011/159217481-d6f20eb6-cdc5-4714-aa1f-e78b2e88a9e4.png";>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
![https://user-images.githubusercontent.com/21984011/159217481-d6f20eb6-cdc5-4714-aa1f-e78b2e88a9e4.png"](https://user-images.githubusercontent.com/21984011/159217481-d6f20eb6-cdc5-4714-aa1f-e78b2e88a9e4.png"){kind=link}