[GitHub] [incubator-doris] HappenLee opened a new issue #4215: [BUG] Make a wrong choice of colocate join

[GitBox]

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


   **Describe the bug**
      There are two colocate table：colocate1 and colocate2
      ```
   create table colocate1 
        (k1 int, k2 int, k3 int) distributed by hash(k1, k2) buckets 1 
         properties("replication_num" = "1",
         "colocate_with" = "group1");
       
      create table colocate2 
        (k1 int, k2 int, k3 int) distributed by hash(k1, k2) buckets 1 
         properties("replication_num" = "1",
         "colocate_with" = "group1");
   ```
   
   if the query like
   
   ```
   select * from test.colocate1 t1, test.colocate2 t2 where t1.k2 = t2.k2
   ```
   
   the query should not be colocate join. Because the distribute column is 
(k1,k2)
   
   But the Doris chose the colocate join, it's a mistake.
   
   
   
   **Expected behavior**
   
   the query like
   
   ```
   select * from test.colocate1 t1, test.colocate2 t2 where t1.k2 = t2.k2
   ```
   
   should not be colocate join.
   


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

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