Skip to content

exec: unordered distinct #39240

@jordanlewis

Description

@jordanlewis

The vectorized engine currently only handles DISTINCT on fully-ordered columns. It doesn't yet know how to deal with distincts on unordered (or partially ordered) columns.

This issue tracks implemented an unordered distinct operator. Unordered distinct is implemented with a hash table. The DistSQL implementation of unordered distinct could serve as a guide - but it's possible that we could get away with reusing much of the unordered aggregation code rather than doing something from scratch.

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-vecSQL vectorized engineC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions