This is an automated email from the ASF dual-hosted git repository.
bridgetb pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 371211c add setMaxRows method to using jdbc driver for DRILL-7048
371211c is described below
commit 371211ccfad1d48bf366facf186faeb36b4d31f4
Author: Bridget Bevens <[email protected]>
AuthorDate: Tue May 7 16:56:29 2019 -0700
add setMaxRows method to using jdbc driver for DRILL-7048
---
docs/planning-and-execution-options/index.html | 4 ++--
docs/using-the-jdbc-driver/index.html | 8 +++++---
feed.xml | 4 ++--
3 files changed, 9 insertions(+), 7 deletions(-)
diff --git a/docs/planning-and-execution-options/index.html
b/docs/planning-and-execution-options/index.html
index 6ccd223..c89dc24 100644
--- a/docs/planning-and-execution-options/index.html
+++ b/docs/planning-and-execution-options/index.html
@@ -1320,7 +1320,7 @@
</div>
- Apr 18, 2019
+ May 7, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1434,7 +1434,7 @@ The <code>exec.query.max_rows</code> option overrides row
limit settings configu
<p>In addition to the <code>exec.query.max_rows</code> 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. </p>
-<p><strong>Note:</strong> You can also configure the row limit for a REST
client through the <a
href="/docs/rest-api-introduction/#post-query-json">autoLimit parameter in the
REST API</a>. </p>
+<p><strong>Note:</strong> You can also configure the row limit for a REST
client through the <a
href="/docs/rest-api-introduction/#post-query-json">autoLimit parameter in the
REST API</a> or a JDBC client through the <code>setMaxRows</code> method in the
<a href="/docs/using-the-jdbc-driver/#using-the-drill-driver-class-name">Java
API</a>. </p>
<p><img src="https://i.imgur.com/7nF0RBq.png"; alt=""><br>
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/using-the-jdbc-driver/index.html
b/docs/using-the-jdbc-driver/index.html
index a4640d8..b07ae79 100644
--- a/docs/using-the-jdbc-driver/index.html
+++ b/docs/using-the-jdbc-driver/index.html
@@ -1318,7 +1318,7 @@
</div>
- Oct 30, 2018
+ May 7, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1440,11 +1440,13 @@ drill.exec: {
<p>The class name for the JDBC driver is <a
href="/api/1.2/jdbc/">org.apache.drill.jdbc.Driver</a>. For details, see the
Apache Drill JDBC Driver version 1.2.0 <a href="/api/1.2/jdbc/">Javadoc</a>.
</p>
-<p>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 [...]
+<p>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 <a
href="https://drill.apache.org/docs/planning-and-execution-options/#setting-an-auto-limit-on-the-number-of-rows-returned-for-result-sets";>Setting
an Auto Limit on the Number of Rows Returned for Resul [...]
+
+<p>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 SQLTimeoutExcepti [...]
<h2 id="example-of-connecting-to-drill-programmatically">Example of Connecting
to Drill Programmatically</h2>
-<p>The following sample code shows using the class name in a snippet that
connects to Drill using the Drill-Jdbc-all driver:</p>
+<p>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:</p>
<div class="highlight"><pre><code class="language-text"
data-lang="text">Class.forName("org.apache.drill.jdbc.Driver");
Connection connection =DriverManager.getConnection("jdbc:drill:zk=
node3.mynode.com:2181/drill/my_cluster_com-drillbits");
diff --git a/feed.xml b/feed.xml
index 676c1d4..c38cf45 100644
--- a/feed.xml
+++ b/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Fri, 03 May 2019 16:38:22 -0700</pubDate>
- <lastBuildDate>Fri, 03 May 2019 16:38:22 -0700</lastBuildDate>
+ <pubDate>Tue, 07 May 2019 16:52:47 -0700</pubDate>
+ <lastBuildDate>Tue, 07 May 2019 16:52:47 -0700</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>
![https://i.imgur.com/7nF0RBq.png"](https://i.imgur.com/7nF0RBq.png"){kind=link}