[GitHub] [doris] Accelarator commented on issue #14101: [Problem] duplicate表做简单的group by时耗时1min51s

[GitBox]

Accelarator commented on issue #14101:
URL: https://github.com/apache/doris/issues/14101#issuecomment-1308296257

   > 1. ALTER TABLE app_online_duration_detail SET ("colocate_with" = 
"group_name");--这是异步操作，执行完成数据会重新分布，需要等一会。
   > 2. set parallel_fragment_exec_instance_num = 16;
   >    再试试看呢
   
   加上colocate_with
   
![image](https://user-images.githubusercontent.com/18416349/200758837-b141b6b4-3935-49a1-8e46-7524ecf44b2e.png)
   
   **set parallel_fragment_exec_instance_num = 8：**
   
![image](https://user-images.githubusercontent.com/18416349/200759487-c17b47e2-a910-4657-9f7f-d8e1351486b3.png)
   
   
   **set parallel_fragment_exec_instance_num = 16：**
   
![image](https://user-images.githubusercontent.com/18416349/200759934-91f0c2c7-b93b-44ff-a06b-0aa27de647a3.png)
   
   并发设置成32需要42s


-- 
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

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