Expand description

A special-case optimizer rule that pushes limit into a grouped aggregation which has no aggregate expressions or sorting requirements

Structs§

  • An optimizer rule that passes a limit hint into grouped aggregations which don’t require all rows in the group to be processed for correctness. Example queries fitting this description are: SELECT distinct l_orderkey FROM lineitem LIMIT 10; SELECT l_orderkey FROM lineitem GROUP BY l_orderkey LIMIT 10;