drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject [drill] branch gh-pages updated: add setMaxRows method info to JDBC driver page
Date Tue, 07 May 2019 23:47:29 GMT
This is an automated email from the ASF dual-hosted git repository.

bridgetb pushed a commit to branch gh-pages
in repository https://gitbox.apache.org/repos/asf/drill.git


The following commit(s) were added to refs/heads/gh-pages by this push:
     new 93f624b  add setMaxRows method info to JDBC driver page
93f624b is described below

commit 93f624b4e701572dcb087472e1798f43b00c4f32
Author: Bridget Bevens <bbevens@maprtech.com>
AuthorDate: Tue May 7 16:46:50 2019 -0700

    add setMaxRows method info to JDBC driver page
---
 .../030-planning-and-exececution-options.md                   |  4 ++--
 _docs/odbc-jdbc-interfaces/015-using-jdbc-driver.md           | 11 ++++++++---
 2 files changed, 10 insertions(+), 5 deletions(-)

diff --git a/_docs/configure-drill/configuration-options/030-planning-and-exececution-options.md
b/_docs/configure-drill/configuration-options/030-planning-and-exececution-options.md
index 0d8a564..d1d9589 100644
--- a/_docs/configure-drill/configuration-options/030-planning-and-exececution-options.md
+++ b/_docs/configure-drill/configuration-options/030-planning-and-exececution-options.md
@@ -1,6 +1,6 @@
 ---
 title: "Planning and Execution Options"
-date: 2019-04-18
+date: 2019-05-07
 parent: "Configuration Options"
 ---
 You can set Drill query planning and execution options per cluster, at the
@@ -115,7 +115,7 @@ The `exec.query.max_rows` option overrides row limit settings configured
in the
 ### Drill Web UI Row Limit Settings  
 In addition to the `exec.query.max_rows` option, the Query page in the Drill Web UI provides
a field where you can enter a limit on the number of rows returned from a result set when
you run a query.  
   
-**Note:** You can also configure the row limit for a REST client through the [autoLimit parameter
in the REST API]({{site.baseurl}}/docs/rest-api-introduction/#post-query-json).   
+**Note:** You can also configure the row limit for a REST client through the [autoLimit parameter
in the REST API]({{site.baseurl}}/docs/rest-api-introduction/#post-query-json) or a JDBC client
through the `setMaxRows` method in the [Java API]({{site.baseurl}}/docs/using-the-jdbc-driver/#using-the-drill-driver-class-name).
  
   
 ![](https://i.imgur.com/7nF0RBq.png)    
 When you submit the query, results display across one or multiple pages. You can set the
number of results that display per page. When results span multiple pages, scroll through
the pages using the links in the bottom right corner of the screen.
diff --git a/_docs/odbc-jdbc-interfaces/015-using-jdbc-driver.md b/_docs/odbc-jdbc-interfaces/015-using-jdbc-driver.md
index c02ec6a..1fb7096 100644
--- a/_docs/odbc-jdbc-interfaces/015-using-jdbc-driver.md
+++ b/_docs/odbc-jdbc-interfaces/015-using-jdbc-driver.md
@@ -1,6 +1,6 @@
 ---
 title: "Using the JDBC Driver"
-date: 2018-10-30 21:47:13 UTC
+date: 2019-05-07
 parent: "ODBC/JDBC Interfaces"
 ---
 This section explains how to install and use the JDBC driver for Apache Drill. To use the
JDBC driver, you have to:
@@ -111,11 +111,16 @@ For definitions of other URL components, see [Using the JDBC URL for
a Random Dr
 
 The class name for the JDBC driver is [org.apache.drill.jdbc.Driver]({{site.baseurl}}/api/1.2/jdbc/).
For details, see the Apache Drill JDBC Driver version 1.2.0 [Javadoc]({{site.baseurl}}/api/1.2/jdbc/).
 
 
-As of Drill 1.13, you can use the setQueryTimeout(int milliseconds) method in the interface
DrillStatement to limit the amount of time that the JDBC driver allows a query to run before
canceling the query. The setQueryTimeout method sets the number of seconds that the JDBC driver
waits for a Statement object to execute before canceling it. By default, there is no limit
on the amount of time allowed for a running statement to complete. When you configure a limit,
an SQLTimeoutException is [...]
+Starting in Drill 1.16, the DrillStatement interface supports the setMaxRows method. The
setMaxRows method sets a limit on the number of rows returned for a result set. The limit
set is applied automatically at runtime. By default, there is no limit on the number of rows
returned. See [Setting an Auto Limit on the Number of Rows Returned for Result Sets](https://drill.apache.org/docs/planning-and-execution-options/#setting-an-auto-limit-on-the-number-of-rows-returned-for-result-sets).
 
+ 
+Starting in 1.13, the DrillStatement interface supports the setQueryTimeout method. The setQueryTimeout
method limits the amount of time that the JDBC driver allows a query to run before canceling
the query. The setQueryTimeout method sets the number of seconds that the JDBC driver waits
for a Statement object to execute before canceling it. By default, there is no limit on the
amount of time allowed for a running statement to complete. When you configure a limit, an
SQLTimeoutException  [...]
+  
+
+
 
 ## Example of Connecting to Drill Programmatically
 
-The following sample code shows using the class name in a snippet that connects to Drill
using the Drill-Jdbc-all driver:
+The following sample code shows you how to use the class name in a snippet to connect to
Drill using the Drill-Jdbc-all driver:
 
 ```
 Class.forName("org.apache.drill.jdbc.Driver");


Mime
View raw message