[GitHub] [incubator-doris] Userwhite opened a new issue #6113: [Bug] 表名影响了colocate agg

Mon, 28 Jun 2021 20:30:10 -0700 


Userwhite opened a new issue #6113:
URL: https://github.com/apache/incubator-doris/issues/6113


   **Describe the bug**
   colocate agg判断的时候，如果Group by字段带上表名, 则不会实现colocate agg。
   
   **To Reproduce**
   * explain select count(1) from a join b on a.k1 = b.k1 group by a.k1;
   * explain select count(1) from a group by a.k1;
   * 
   **Expected behavior**
   计划中Group by不需要做merge finalize
   
   **Screenshots**
   表a、b的结构如下：
   
![image](https://user-images.githubusercontent.com/49226823/123732762-f7f6b280-d8cc-11eb-86c5-c4b85e018245.png)
   
![image](https://user-images.githubusercontent.com/49226823/123732777-fd53fd00-d8cc-11eb-8387-eaf8a424f280.png)
   
   不加表名的Group by可以正常work：
   
![image](https://user-images.githubusercontent.com/49226823/123732823-12309080-d8cd-11eb-9f98-ff2a73ac2c84.png)
   
   加了表名之后不能优化成colocate agg:
   
![image](https://user-images.githubusercontent.com/49226823/123732871-270d2400-d8cd-11eb-9d2e-b1afeb9b4770.png)
   
   colocate join加Group by中包含表名也是如此：
   
![image](https://user-images.githubusercontent.com/49226823/123732957-4310c580-d8cd-11eb-9507-157e2c4c664c.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]

Reply via email to