[DRILL-6339] New option to disable TopN (for testing Sort)

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.13.0
• Fix Version/s: 1.14.0
• Component/s: Query Planning & Optimization
• Labels: ready-to-commit
• Assignee: Boaz Ben-Zvi
• Reporter: Boaz Ben-Zvi
• Reviewer: Arina Ielchiieva
• Created: 17/Apr/18 20:57
• Updated: 19/Jun/18 20:26
• Resolved: 23/Apr/18 17:08

Description

   When a query uses ... ORDER BY ... LIMIT ..., the planner unconditionally picks the TopN operator to (efficiently) implement this order.  This precludes an easy way to test the External Sort operator over a large dataset (e.g., test spilling).

   A new internal option to disable picking TopN (hence using the External Sort instead) would be useful for various testings. (And may be in other scenarios, like a bug found in the TopN).

 

Issue Links

• links to: GitHub Pull Request #1219