pub struct ReplaceDistinctWithAggregate {}
Expand description
Optimizer that replaces logical [Distinct] with a logical [Aggregate]
SELECT DISTINCT a, b FROM tab
Into
SELECT a, b FROM tab GROUP BY a, b
On the other hand, for a DISTINCT ON
query the replacement is
a bit more involved and effectively converts
SELECT DISTINCT ON (a) b FROM tab ORDER BY a DESC, c
into
SELECT b FROM (
SELECT a, FIRST_VALUE(b ORDER BY a DESC, c) AS b
FROM tab
GROUP BY a
)
ORDER BY a DESC
Optimizer that replaces logical [Distinct] with a logical [Aggregate]
Implementations§
Trait Implementations§
source§impl Default for ReplaceDistinctWithAggregate
impl Default for ReplaceDistinctWithAggregate
source§fn default() -> ReplaceDistinctWithAggregate
fn default() -> ReplaceDistinctWithAggregate
Returns the “default value” for a type. Read more
source§impl OptimizerRule for ReplaceDistinctWithAggregate
impl OptimizerRule for ReplaceDistinctWithAggregate
source§fn supports_rewrite(&self) -> bool
fn supports_rewrite(&self) -> bool
Does this rule support rewriting owned plans (rather than by reference)?
source§fn rewrite(
&self,
plan: LogicalPlan,
config: &dyn OptimizerConfig,
) -> Result<Transformed<LogicalPlan>>
fn rewrite( &self, plan: LogicalPlan, config: &dyn OptimizerConfig, ) -> Result<Transformed<LogicalPlan>>
Try to rewrite
plan
to an optimized form, returning Transformed::yes
if the plan was rewritten and Transformed::no
if it was not. Read moresource§fn apply_order(&self) -> Option<ApplyOrder>
fn apply_order(&self) -> Option<ApplyOrder>
How should the rule be applied by the optimizer? See comments on
ApplyOrder
for details. Read moresource§fn try_optimize(
&self,
_plan: &LogicalPlan,
_config: &dyn OptimizerConfig,
) -> Result<Option<LogicalPlan>>
fn try_optimize( &self, _plan: &LogicalPlan, _config: &dyn OptimizerConfig, ) -> Result<Option<LogicalPlan>>
👎Deprecated since 40.0.0: please implement supports_rewrite and rewrite instead
Try and rewrite
plan
to an optimized form, returning None if the plan
cannot be optimized by this rule. Read moreAuto Trait Implementations§
impl Freeze for ReplaceDistinctWithAggregate
impl RefUnwindSafe for ReplaceDistinctWithAggregate
impl Send for ReplaceDistinctWithAggregate
impl Sync for ReplaceDistinctWithAggregate
impl Unpin for ReplaceDistinctWithAggregate
impl UnwindSafe for ReplaceDistinctWithAggregate
Blanket Implementations§
source§impl<T> BorrowMut<T> for Twhere
T: ?Sized,
impl<T> BorrowMut<T> for Twhere
T: ?Sized,
source§fn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more
source§impl<T> IntoEither for T
impl<T> IntoEither for T
source§fn into_either(self, into_left: bool) -> Either<Self, Self>
fn into_either(self, into_left: bool) -> Either<Self, Self>
Converts
self
into a Left
variant of Either<Self, Self>
if into_left
is true
.
Converts self
into a Right
variant of Either<Self, Self>
otherwise. Read moresource§fn into_either_with<F>(self, into_left: F) -> Either<Self, Self>
fn into_either_with<F>(self, into_left: F) -> Either<Self, Self>
Converts
self
into a Left
variant of Either<Self, Self>
if into_left(&self)
returns true
.
Converts self
into a Right
variant of Either<Self, Self>
otherwise. Read more