Skip to content

[Bug] Duplicate results in 'Group By' query #6028

Closed
@EmmyMiao87

Description

Describe the bug
When the query contains a group by clause, the result is wrong.
There are duplicate groups in result.

To Reproduce
Steps to reproduce the behavior:

  1. create a table with more than one partition
create table test (k1 int ,k2 int) partition by range(k1) (partition p1 values less than 1, partition p2 values less than 2)
distributed by hash(k1) buckets 32;
  1. insert into some values in both partitions
  2. query, duplicate results
select k1 from test group by k1;
  1. There is only one aggregation node in the plan tree. The aggregation node is wrongly evaluated as colocate.
explain select k1 from test group by k1;

Expected behavior
There is no duplicate k1 in result.

Version
Doris: 0.14.12

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    area/colocatedIssues or PRs related to colocated tablesarea/plannerIssues or PRs related to the query plannerkind/fixCategorizes issue or PR as related to a bug.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions