[DRILL-7048] Implement JDBC Statement.setMaxRows() with System Option

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.16.0
• Fix Version/s: 1.16.0
• Component/s: Client - JDBC, Query Planning & Optimization
• Labels: doc-impacting ready-to-commit
• Assignee: Kunal Khatua
• Reporter: Kunal Khatua
• Reviewer: Vova Vysotskyi
• Created: 21/Feb/19 21:33
• Updated: 11/May/19 22:08
• Resolved: 05/Apr/19 23:10

Description

With DRILL-6960, the webUI will get an auto-limit on the number of results fetched.

Since more of the plumbing is already there, it makes sense to provide the same for the JDBC client.

In addition, it would be nice if the Server can have a pre-defined value as well (default 0; i.e. no limit) so that an admin would be able to ensure a max limit on the resultset size as well.

Issue Links

• requires: DRILL-6960 Auto Limit Wrapping should not apply to non-select query
• links to: GitHub Pull Request #1714