You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2019/05/07 23:56:43 UTC
[drill-site] branch asf-site updated: add setMaxRows method to
using jdbc driver for DRILL-7048
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 <bb...@maprtech.com>
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>