DA1OOO opened a new issue, #29041: URL: https://github.com/apache/doris/issues/29041
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version Doris 2.3 ### What's Wrong? **table size**: `8MB, 9k+ rows, partitioned by hour, buckets num = 9`  **tablets number**: 15957 / 3 replica  **difference when enable pipeline**: `0.06s -> 19s` <img width="884" alt="image" src="https://github.com/apache/doris/assets/56857867/8809f7a5-c692-44fd-9fe1-1e7e694b5642";> btw, in query profile, this query time as follow, different to mysql client. https://github.com/apache/doris/discussions/29024  Finally, explain the reason **why we have so many tablets**: we have a table. **size = 25GB, rowCount = 302965685**, due to business continuity, we **partition by hour**. then, we create a simple materialized view `create materialized view as select geo_country from xxx group by geo_country`. after created, found that tablets has doubled. but materialized view size is small. when we select on materialized view, the query is very slow.  so we create a test table (as above) that only have 1 column, partitions by hour to test query time. Then we discovered the problem mentioned at the beginning of the issue. ### What You Expected? fix, we want enable pipeline to use workload group function. ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
