[DRILL-6050] Provide a limit to number of rows fetched for a query in UI

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.16.0, 1.17.0
• Component/s: Web Server
• Labels: doc-complete ready-to-commit user-experience
• Assignee: Kunal Khatua
• Reporter: Kunal Khatua
• Reviewer: Sorabh Hamirwasia
• Created: 21/Dec/17 22:52
• Updated: 01/May/19 22:42
• Resolved: 09/Jan/19 22:25

Description

Currently, the WebServer side needs to process the entire set of results and stream it back to the WebClient.
Since the WebUI does paginate results, we can load a larger set for pagination on the browser client and relieve pressure off the WebServer to host all the data.
e.g. Fetching all rows from a 1Billion records table is impractical and can be capped at 10K. Currently, the user has to explicitly specify LIMIT in the submitted query.
An option can be provided in the field to allow for this entry.

Issue Links

• causes: DRILL-6960 Auto Limit Wrapping should not apply to non-select query
• is depended upon by: DRILL-6933 Ctrl+Enter meta combo not working on Windows & mac OS
• links to: GitHub Pull Request #1593