drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject [drill-site] branch asf-site updated: add setMaxRows method to using jdbc driver for DRILL-7048
Date Tue, 07 May 2019 23:56:43 GMT
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 <bbevens@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(&quot;org.apache.drill.jdbc.Driver&quot;);
 Connection connection =DriverManager.getConnection(&quot;jdbc:drill:zk=
 node3.mynode.com:2181/drill/my_cluster_com-drillbits&quot;);
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>


Mime
View raw message