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 <bbev...@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).
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");
