-
Notifications
You must be signed in to change notification settings - Fork 4.1k
exec: unordered distinct #39240
Copy link
Copy link
Closed
Labels
A-sql-vecSQL vectorized engineSQL vectorized engineC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
Description
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.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-sql-vecSQL vectorized engineSQL vectorized engineC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)