pinot icon indicating copy to clipboard operation
pinot copied to clipboard

[multistage] Support limit properly

Open walterddr opened this issue 3 years ago • 1 comments
trafficstars

Currently select * from tbl limit 10 returns a unimplemented exception because limit is considered as an Order By with fetch top 10.

since we do not order with limit normally we should:

  • [ ] relax the planner condition to allow randomly return 10 rows
  • [ ] truncate the final result to the limit
  • [ ] propagate limit down to table scan

walterddr avatar Aug 13 '22 17:08 walterddr

fetch unorder is supported but we should still limit the number of rows returned at final stage.

walterddr avatar Aug 24 '22 14:08 walterddr