[ https://issues.apache.org/jira/browse/DRILL-7048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16800974#comment-16800974 ]
ASF GitHub Bot commented on DRILL-7048: --------------------------------------- kkhatua commented on pull request #1714: DRILL-7048: Implement JDBC Statement.setMaxRows() with System Option URL: https://github.com/apache/drill/pull/1714#discussion_r268800813 ########## File path: exec/jdbc/src/main/java/org/apache/drill/jdbc/impl/DrillStatementImpl.java ########## @@ -270,4 +271,10 @@ public void setResultSet(AvaticaResultSet resultSet) { public void setUpdateCount(int value) { updateCount = value; } + + @Override + public void setLargeMaxRows(long maxRowCount) throws SQLException { + execute("ALTER SESSION SET `" + ExecConstants.QUERY_MAX_ROWS + "`="+maxRowCount); + this.maxRowCount = maxRowCount; Review comment: We need this here to ensure that when `getLargeMaxRows()` is called, we are reading it back from the value that was set using `setLargeMaxRows()`. Avatica only holds the value that has been set. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Implement JDBC Statement.setMaxRows() with System Option > -------------------------------------------------------- > > Key: DRILL-7048 > URL: https://issues.apache.org/jira/browse/DRILL-7048 > Project: Apache Drill > Issue Type: New Feature > Components: Client - JDBC, Query Planning & Optimization > Affects Versions: 1.15.0 > Reporter: Kunal Khatua > Assignee: Kunal Khatua > Priority: Major > Labels: doc-impacting > Fix For: 1.17.0 > > > 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. -- This message was sent by Atlassian JIRA (v7.6.3#76005)