tajo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jihoon...@apache.org
Subject svn commit: r1706954 [3/6] - in /tajo/site/docs/devel: ./ _sources/ _sources/sql_language/ _sources/table_management/ _static/ backup_and_restore/ configuration/ functions/ index/ partitioning/ sql_language/ table_management/ tsql/
Date Tue, 06 Oct 2015 06:44:18 GMT
Modified: tajo/site/docs/devel/hive_integration.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/hive_integration.html?rev=1706954&r1=1706953&r2=1706954&view=diff
==============================================================================
--- tajo/site/docs/devel/hive_integration.html (original)
+++ tajo/site/docs/devel/hive_integration.html Tue Oct  6 06:44:17 2015
@@ -163,6 +163,8 @@
 <li class="toctree-l1"><a class="reference internal" href="jdbc_driver.html">Tajo
JDBC Driver</a><ul>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#how-to-get-jdbc-driver">How
to get JDBC driver</a></li>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#setting-the-classpath">Setting
the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting
to the Tajo cluster instance</a></li>
+<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connection-parameters">Connection
Parameters</a></li>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#an-example-jdbc-client">An
Example JDBC Client</a></li>
 </ul>
 </li>
@@ -209,10 +211,10 @@ This integration allows Tajo to access a
 Depending on your purpose, you can execute either SQL queries or HiveQL queries on the
 same tables managed in Apache Hive.</p>
 <p>In order to use this feature, you need to build Tajo with a specified maven profile
-and then add some configs into <tt class="docutils literal"><span class="pre">conf/tajo-env.sh</span></tt>
and <tt class="docutils literal"><span class="pre">conf/catalog-site.xml</span></tt>.
+and then add some configs into <code class="docutils literal"><span class="pre">conf/tajo-env.sh</span></code>
and <code class="docutils literal"><span class="pre">conf/catalog-site.xml</span></code>.
 This section describes how to setup HiveMetaStore integration.
 This instruction would take no more than five minutes.</p>
-<p>You need to set your Hive home directory to the environment variable <tt class="docutils
literal"><span class="pre">HIVE_HOME</span></tt> in conf/tajo-env.sh
as follows:</p>
+<p>You need to set your Hive home directory to the environment variable <code class="docutils
literal"><span class="pre">HIVE_HOME</span></code> in conf/tajo-env.sh
as follows:</p>
 <div class="highlight-python"><div class="highlight"><pre>export HIVE_HOME=/path/to/your/hive/directory
 </pre></div>
 </div>
@@ -221,7 +223,7 @@ Next, you should set the path of MySQL J
 <div class="highlight-python"><div class="highlight"><pre>export HIVE_JDBC_DRIVER_DIR==/path/to/your/mysql_jdbc_driver/mysql-connector-java-x.x.x-bin.jar
 </pre></div>
 </div>
-<p>Finally, you should specify HiveCatalogStore as Tajo catalog driver class in <tt
class="docutils literal"><span class="pre">conf/catalog-site.xml</span></tt>
as follows:</p>
+<p>Finally, you should specify HiveCatalogStore as Tajo catalog driver class in <code
class="docutils literal"><span class="pre">conf/catalog-site.xml</span></code>
as follows:</p>
 <div class="highlight-python"><div class="highlight"><pre>&lt;property&gt;
   &lt;name&gt;tajo.catalog.store.class&lt;/name&gt;
   &lt;value&gt;org.apache.tajo.catalog.store.HiveCatalogStore&lt;/value&gt;
@@ -232,10 +234,10 @@ Next, you should set the path of MySQL J
 <p class="first admonition-title">Note</p>
 <p>Hive stores a list of partitions for each table in its metastore. If new partitions
are
 directly added to HDFS, HiveMetastore will not able aware of these partitions unless the
user
-<tt class="docutils literal"><span class="pre">ALTER</span> <span class="pre">TABLE</span>
<span class="pre">table_name</span> <span class="pre">ADD</span> <span
class="pre">PARTITION</span></tt> commands on each of the newly added partitions
or
-<tt class="docutils literal"><span class="pre">MSCK</span> <span class="pre">REPAIR</span>
<span class="pre">TABLE</span>&nbsp; <span class="pre">table_name</span></tt>
command.</p>
-<p>But current tajo doesn&#8217;t provide <tt class="docutils literal"><span
class="pre">ADD</span> <span class="pre">PARTITION</span></tt>
command and hive doesn&#8217;t provide an api for
-responding to <tt class="docutils literal"><span class="pre">MSK</span>
<span class="pre">REPAIR</span> <span class="pre">TABLE</span></tt>
command. Thus, if you insert data to hive partitioned
+<code class="docutils literal"><span class="pre">ALTER</span> <span
class="pre">TABLE</span> <span class="pre">table_name</span> <span
class="pre">ADD</span> <span class="pre">PARTITION</span></code>
commands on each of the newly added partitions or
+<code class="docutils literal"><span class="pre">MSCK</span> <span class="pre">REPAIR</span>
<span class="pre">TABLE</span>&nbsp; <span class="pre">table_name</span></code>
command.</p>
+<p>But current tajo doesn&#8217;t provide <code class="docutils literal"><span
class="pre">ADD</span> <span class="pre">PARTITION</span></code>
command and hive doesn&#8217;t provide an api for
+responding to <code class="docutils literal"><span class="pre">MSK</span>
<span class="pre">REPAIR</span> <span class="pre">TABLE</span></code>
command. Thus, if you insert data to hive partitioned
 table and you want to scan the updated partitions through Tajo, you must run following command
on hive</p>
 <div class="last highlight-python"><div class="highlight"><pre>$ MSCK REPAIR
TABLE [table_name];
 </pre></div>

Modified: tajo/site/docs/devel/index.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/index.html?rev=1706954&r1=1706953&r2=1706954&view=diff
==============================================================================
--- tajo/site/docs/devel/index.html (original)
+++ tajo/site/docs/devel/index.html Tue Oct  6 06:44:17 2015
@@ -162,6 +162,8 @@
 <li class="toctree-l1"><a class="reference internal" href="jdbc_driver.html">Tajo
JDBC Driver</a><ul>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#how-to-get-jdbc-driver">How
to get JDBC driver</a></li>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#setting-the-classpath">Setting
the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting
to the Tajo cluster instance</a></li>
+<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connection-parameters">Connection
Parameters</a></li>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#an-example-jdbc-client">An
Example JDBC Client</a></li>
 </ul>
 </li>
@@ -318,8 +320,8 @@ As a result, some contents can be mismat
 <li class="toctree-l3"><a class="reference internal" href="sql_language/alter_table.html#rename-column">RENAME
COLUMN</a></li>
 <li class="toctree-l3"><a class="reference internal" href="sql_language/alter_table.html#add-column">ADD
COLUMN</a></li>
 <li class="toctree-l3"><a class="reference internal" href="sql_language/alter_table.html#set-property">SET
PROPERTY</a></li>
-<li class="toctree-l3"><a class="reference internal" href="sql_language/alter_table.html#add-partition">ADD
PARTITION</a></li>
 <li class="toctree-l3"><a class="reference internal" href="sql_language/alter_table.html#drop-partition">DROP
PARTITION</a></li>
+<li class="toctree-l3"><a class="reference internal" href="sql_language/alter_table.html#repair-partition">REPAIR
PARTITION</a></li>
 </ul>
 </li>
 <li class="toctree-l2"><a class="reference internal" href="sql_language/queries.html">Queries</a><ul>
@@ -400,6 +402,7 @@ As a result, some contents can be mismat
 </li>
 <li class="toctree-l2"><a class="reference internal" href="table_management/file_formats.html">File
Formats</a><ul>
 <li class="toctree-l3"><a class="reference internal" href="table_management/text.html">TEXT</a></li>
+<li class="toctree-l3"><a class="reference internal" href="table_management/json.html">JSON</a></li>
 <li class="toctree-l3"><a class="reference internal" href="table_management/rcfile.html">RCFile</a></li>
 <li class="toctree-l3"><a class="reference internal" href="table_management/parquet.html">Parquet</a></li>
 <li class="toctree-l3"><a class="reference internal" href="table_management/orc.html">ORC</a></li>
@@ -483,6 +486,8 @@ As a result, some contents can be mismat
 </ul>
 </li>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#setting-the-classpath">Setting
the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting
to the Tajo cluster instance</a></li>
+<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connection-parameters">Connection
Parameters</a></li>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#an-example-jdbc-client">An
Example JDBC Client</a></li>
 </ul>
 </li>
@@ -494,9 +499,9 @@ As a result, some contents can be mismat
 <div class="section" id="indices-and-tables">
 <h1>Indices and tables<a class="headerlink" href="#indices-and-tables" title="Permalink
to this headline">¶</a></h1>
 <ul class="simple">
-<li><a class="reference internal" href="genindex.html"><em>Index</em></a></li>
-<li><a class="reference internal" href="py-modindex.html"><em>Module Index</em></a></li>
-<li><a class="reference internal" href="search.html"><em>Search Page</em></a></li>
+<li><a class="reference internal" href="genindex.html"><span>Index</span></a></li>
+<li><a class="reference internal" href="py-modindex.html"><span>Module
Index</span></a></li>
+<li><a class="reference internal" href="search.html"><span>Search Page</span></a></li>
 </ul>
 </div>
 

Modified: tajo/site/docs/devel/index/future_work.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/index/future_work.html?rev=1706954&r1=1706953&r2=1706954&view=diff
==============================================================================
--- tajo/site/docs/devel/index/future_work.html (original)
+++ tajo/site/docs/devel/index/future_work.html Tue Oct  6 06:44:17 2015
@@ -164,6 +164,8 @@
 <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo
JDBC Driver</a><ul>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How
to get JDBC driver</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting
the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting
to the Tajo cluster instance</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection
Parameters</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An
Example JDBC Client</a></li>
 </ul>
 </li>

Modified: tajo/site/docs/devel/index/how_to_use.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/index/how_to_use.html?rev=1706954&r1=1706953&r2=1706954&view=diff
==============================================================================
--- tajo/site/docs/devel/index/how_to_use.html (original)
+++ tajo/site/docs/devel/index/how_to_use.html Tue Oct  6 06:44:17 2015
@@ -164,6 +164,8 @@
 <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo
JDBC Driver</a><ul>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How
to get JDBC driver</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting
the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting
to the Tajo cluster instance</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection
Parameters</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An
Example JDBC Client</a></li>
 </ul>
 </li>

Modified: tajo/site/docs/devel/index/types.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/index/types.html?rev=1706954&r1=1706953&r2=1706954&view=diff
==============================================================================
--- tajo/site/docs/devel/index/types.html (original)
+++ tajo/site/docs/devel/index/types.html Tue Oct  6 06:44:17 2015
@@ -164,6 +164,8 @@
 <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo
JDBC Driver</a><ul>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How
to get JDBC driver</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting
the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting
to the Tajo cluster instance</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection
Parameters</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An
Example JDBC Client</a></li>
 </ul>
 </li>
@@ -207,7 +209,7 @@
             
   <div class="section" id="index-types">
 <h1>Index Types<a class="headerlink" href="#index-types" title="Permalink to this
headline">¶</a></h1>
-<p>Currently, Tajo supports only one type of index, <tt class="docutils literal"><span
class="pre">TWO_LEVEL_BIN_TREE</span></tt>, shortly <tt class="docutils
literal"><span class="pre">BST</span></tt>. The BST index is a kind of
binary search tree which is extended to be permanently stored on disk. It consists of two
levels of nodes; a leaf node indexes the keys with the positions of data in an HDFS block
and a root node indexes the keys with the leaf node indices.</p>
+<p>Currently, Tajo supports only one type of index, <code class="docutils literal"><span
class="pre">TWO_LEVEL_BIN_TREE</span></code>, shortly <code class="docutils
literal"><span class="pre">BST</span></code>. The BST index is a kind
of binary search tree which is extended to be permanently stored on disk. It consists of two
levels of nodes; a leaf node indexes the keys with the positions of data in an HDFS block
and a root node indexes the keys with the leaf node indices.</p>
 <p>When an index scan is started, the query engine first reads the root node and finds
the search key. If it finds a leaf node corresponding to the search key, it subsequently finds
the search key in that leaf node. Finally, it directly reads a tuple corresponding to the
search key from HDFS.</p>
 </div>
 

Modified: tajo/site/docs/devel/index_overview.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/index_overview.html?rev=1706954&r1=1706953&r2=1706954&view=diff
==============================================================================
--- tajo/site/docs/devel/index_overview.html (original)
+++ tajo/site/docs/devel/index_overview.html Tue Oct  6 06:44:17 2015
@@ -163,6 +163,8 @@
 <li class="toctree-l1"><a class="reference internal" href="jdbc_driver.html">Tajo
JDBC Driver</a><ul>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#how-to-get-jdbc-driver">How
to get JDBC driver</a></li>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#setting-the-classpath">Setting
the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting
to the Tajo cluster instance</a></li>
+<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connection-parameters">Connection
Parameters</a></li>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#an-example-jdbc-client">An
Example JDBC Client</a></li>
 </ul>
 </li>
@@ -205,7 +207,7 @@
   <div class="section" id="index-experimental-feature">
 <h1>Index (Experimental Feature)<a class="headerlink" href="#index-experimental-feature"
title="Permalink to this headline">¶</a></h1>
 <p>An index is a data structure that is used for efficient query processing. Using
an index, the Tajo query engine can directly retrieve search values.</p>
-<p>This is still an experimental feature. In order to use indexes, you must check out
the source code of the <tt class="docutils literal"><span class="pre">index_support</span></tt>
branch:</p>
+<p>This is still an experimental feature. In order to use indexes, you must check out
the source code of the <code class="docutils literal"><span class="pre">index_support</span></code>
branch:</p>
 <div class="highlight-python"><div class="highlight"><pre>git clone -b
index_support https://git-wip-us.apache.org/repos/asf/tajo.git tajo-index
 </pre></div>
 </div>

Modified: tajo/site/docs/devel/introduction.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/introduction.html?rev=1706954&r1=1706953&r2=1706954&view=diff
==============================================================================
--- tajo/site/docs/devel/introduction.html (original)
+++ tajo/site/docs/devel/introduction.html Tue Oct  6 06:44:17 2015
@@ -163,6 +163,8 @@
 <li class="toctree-l1"><a class="reference internal" href="jdbc_driver.html">Tajo
JDBC Driver</a><ul>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#how-to-get-jdbc-driver">How
to get JDBC driver</a></li>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#setting-the-classpath">Setting
the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting
to the Tajo cluster instance</a></li>
+<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connection-parameters">Connection
Parameters</a></li>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#an-example-jdbc-client">An
Example JDBC Client</a></li>
 </ul>
 </li>

Modified: tajo/site/docs/devel/jdbc_driver.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/jdbc_driver.html?rev=1706954&r1=1706953&r2=1706954&view=diff
==============================================================================
--- tajo/site/docs/devel/jdbc_driver.html (original)
+++ tajo/site/docs/devel/jdbc_driver.html Tue Oct  6 06:44:17 2015
@@ -163,6 +163,8 @@
 <li class="toctree-l1 current"><a class="current reference internal" href="">Tajo
JDBC Driver</a><ul>
 <li class="toctree-l2"><a class="reference internal" href="#how-to-get-jdbc-driver">How
to get JDBC driver</a></li>
 <li class="toctree-l2"><a class="reference internal" href="#setting-the-classpath">Setting
the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="#connecting-to-the-tajo-cluster-instance">Connecting
to the Tajo cluster instance</a></li>
+<li class="toctree-l2"><a class="reference internal" href="#connection-parameters">Connection
Parameters</a></li>
 <li class="toctree-l2"><a class="reference internal" href="#an-example-jdbc-client">An
Example JDBC Client</a></li>
 </ul>
 </li>
@@ -211,11 +213,11 @@ In this section, we explain how to get J
 <h2>How to get JDBC driver<a class="headerlink" href="#how-to-get-jdbc-driver" title="Permalink
to this headline">¶</a></h2>
 <div class="section" id="direct-download">
 <h3>Direct Download<a class="headerlink" href="#direct-download" title="Permalink
to this headline">¶</a></h3>
-<p>You can directly download a JDBC driver jar file (<tt class="docutils literal"><span
class="pre">tajo-jdbc-x.y.z.jar</span></tt>) from <a class="reference external"
href="http://tajo.apache.org/downloads.html">Downloads</a>.</p>
+<p>You can directly download a JDBC driver jar file (<code class="docutils literal"><span
class="pre">tajo-jdbc-x.y.z.jar</span></code>) from <a class="reference
external" href="http://tajo.apache.org/downloads.html">Downloads</a>.</p>
 </div>
 <div class="section" id="from-binary-distribution">
 <h3>From Binary Distribution<a class="headerlink" href="#from-binary-distribution"
title="Permalink to this headline">¶</a></h3>
-<p>Tajo binary distribution provides JDBC jar file located in <tt class="docutils
literal"><span class="pre">${TAJO_HOME}/share/jdbc-dist/tajo-jdbc-x.y.z.jar</span></tt>.</p>
+<p>Tajo binary distribution provides JDBC jar file located in <code class="docutils
literal"><span class="pre">${TAJO_HOME}/share/jdbc-dist/tajo-jdbc-x.y.z.jar</span></code>.</p>
 </div>
 <div class="section" id="from-building-source-code">
 <h3>From Building Source Code<a class="headerlink" href="#from-building-source-code"
title="Permalink to this headline">¶</a></h3>
@@ -229,22 +231,67 @@ In this section, we explain how to get J
 </div>
 <div class="section" id="setting-the-classpath">
 <h2>Setting the CLASSPATH<a class="headerlink" href="#setting-the-classpath" title="Permalink
to this headline">¶</a></h2>
-<p>In order to use the JDBC driver, you should add <tt class="docutils literal"><span
class="pre">tajo-jdbc-x.y.z.jar</span></tt> in your <tt class="docutils
literal"><span class="pre">CLASSPATH</span></tt>.</p>
+<p>In order to use the JDBC driver, you should add <code class="docutils literal"><span
class="pre">tajo-jdbc-x.y.z.jar</span></code> in your <code class="docutils
literal"><span class="pre">CLASSPATH</span></code>.</p>
 <div class="highlight-bash"><div class="highlight"><pre><span class="nv">CLASSPATH</span><span
class="o">=</span>path/to/tajo-jdbc-x.y.z.jar:<span class="nv">$CLASSPATH</span>
 </pre></div>
 </div>
 </div>
+<div class="section" id="connecting-to-the-tajo-cluster-instance">
+<h2>Connecting to the Tajo cluster instance<a class="headerlink" href="#connecting-to-the-tajo-cluster-instance"
title="Permalink to this headline">¶</a></h2>
+<p>A Tajo cluster is represented by a URL. Tajo JDBC driver can take the following
URL forms:</p>
+<blockquote>
+<div><ul class="simple">
+<li><code class="docutils literal"><span class="pre">jdbc:tajo://host/</span></code></li>
+<li><code class="docutils literal"><span class="pre">jdbc:tajo://host/database</span></code></li>
+<li><code class="docutils literal"><span class="pre">jdbc:tajo://host:port/</span></code></li>
+<li><code class="docutils literal"><span class="pre">jdbc:tajo://host:port/database</span></code></li>
+</ul>
+</div></blockquote>
+<p>Each part of URL has the following meanings:</p>
+<blockquote>
+<div><ul class="simple">
+<li><code class="docutils literal"><span class="pre">host</span></code>
- The hostname of the TajoMaster. You can put hostname or ip address here.</li>
+<li><code class="docutils literal"><span class="pre">port</span></code>
- The port number that server is listening. Default port number is 26002.</li>
+<li><code class="docutils literal"><span class="pre">database</span></code>
- The database name. The default database name is <code class="docutils literal"><span
class="pre">default</span></code>.</li>
+</ul>
+<p>To connect, you need to get <code class="docutils literal"><span class="pre">Connection</span></code>
instance from Java JDBC Driver Manager as follows:</p>
+</div></blockquote>
+<div class="highlight-java"><div class="highlight"><pre><span class="n">Connection</span>
<span class="n">db</span> <span class="o">=</span> <span class="n">DriverManager</span><span
class="o">.</span><span class="na">getConnection</span><span class="o">(</span><span
class="n">url</span><span class="o">);</span>
+</pre></div>
+</div>
+</div>
+<div class="section" id="connection-parameters">
+<h2>Connection Parameters<a class="headerlink" href="#connection-parameters" title="Permalink
to this headline">¶</a></h2>
+<p>Connection parameters lets the JDBC Copnnection to enable or disable additional
features. You should use <code class="docutils literal"><span class="pre">java.util.Properties</span></code>
to pass your connection parameters into <code class="docutils literal"><span class="pre">Connection</span></code>.
The following example means that the transmission of ResultSet uses compression and its connection
timeout is 15 seconds.</p>
+<div class="highlight-java"><div class="highlight"><pre><span class="n">String</span>
<span class="n">url</span> <span class="o">=</span> <span class="s">&quot;jdbc:tajo://localhost/test&quot;</span><span
class="o">;</span>
+<span class="n">Properties</span> <span class="n">props</span> <span
class="o">=</span> <span class="k">new</span> <span class="n">Properties</span><span
class="o">();</span>
+<span class="n">props</span><span class="o">.</span><span class="na">setProperty</span><span
class="o">(</span><span class="s">&quot;useCompression&quot;</span><span
class="o">,</span><span class="s">&quot;true&quot;</span><span
class="o">);</span>  <span class="c1">// use compression for ResultSet</span>
+<span class="n">props</span><span class="o">.</span><span class="na">setProperty</span><span
class="o">(</span><span class="s">&quot;connectTimeout&quot;</span><span
class="o">,</span><span class="s">&quot;15000&quot;</span><span
class="o">);</span> <span class="c1">// 15 seconds</span>
+<span class="n">Connection</span> <span class="n">conn</span> <span
class="o">=</span> <span class="n">DriverManager</span><span class="o">.</span><span
class="na">getConnection</span><span class="o">(</span><span class="n">url</span><span
class="o">,</span> <span class="n">props</span><span class="o">);</span>
+</pre></div>
+</div>
+<p>The connection parameters that Tajo currently supports are as follows:</p>
+<blockquote>
+<div><ul class="simple">
+<li><code class="docutils literal"><span class="pre">useCompression</span>
<span class="pre">=</span> <span class="pre">bool</span></code>
- Enable compressed transfer for ResultSet.</li>
+<li><code class="docutils literal"><span class="pre">defaultRowFetchSize</span>
<span class="pre">=</span> <span class="pre">int</span></code>
- Determine the number of rows fetched in ResultSet by one fetch with trip to the Server.</li>
+<li><code class="docutils literal"><span class="pre">connectTimeout</span>
<span class="pre">=</span> <span class="pre">int</span> <span class="pre">(seconds)</span></code>
- The timeout value used for socket connect operations. If connecting to the server takes
longer than this value, the connection is broken. The timeout is specified in seconds and
a value of zero means that it is disabled.</li>
+<li><code class="docutils literal"><span class="pre">socketTimeout</span>
<span class="pre">=</span> <span class="pre">int</span> <span class="pre">(seconds)</span></code>
- The timeout value used for socket read operations. If reading from the server takes longer
than this value, the connection is closed. This can be used as both a brute force global query
timeout and a method of detecting network problems. The timeout is specified in seconds and
a value of zero means that it is disabled.</li>
+<li><code class="docutils literal"><span class="pre">retry</span>
<span class="pre">=</span> <span class="pre">int</span></code>
- Number of retry operation. Tajo JDBC driver is resilient against some network or connection
problems. It determines how many times the connection will retry.</li>
+</ul>
+</div></blockquote>
+</div>
 <div class="section" id="an-example-jdbc-client">
 <h2>An Example JDBC Client<a class="headerlink" href="#an-example-jdbc-client" title="Permalink
to this headline">¶</a></h2>
-<p>The JDBC driver class name is <tt class="docutils literal"><span class="pre">org.apache.tajo.jdbc.TajoDriver</span></tt>.
-You can get the driver <tt class="docutils literal"><span class="pre">Class.forName(&quot;org.apache.tajo.jdbc.TajoDriver&quot;)</span></tt>.
-The connection url should be <tt class="docutils literal"><span class="pre">jdbc:tajo://&lt;TajoMaster</span>
<span class="pre">hostname&gt;:&lt;TajoMaster</span> <span class="pre">client</span>
<span class="pre">rpc</span> <span class="pre">port&gt;/&lt;database</span>
<span class="pre">name&gt;</span></tt>.
-The default TajoMaster client rpc port is <tt class="docutils literal"><span class="pre">26002</span></tt>.
+<p>The JDBC driver class name is <code class="docutils literal"><span class="pre">org.apache.tajo.jdbc.TajoDriver</span></code>.
+You can get the driver <code class="docutils literal"><span class="pre">Class.forName(&quot;org.apache.tajo.jdbc.TajoDriver&quot;)</span></code>.
+The connection url should be <code class="docutils literal"><span class="pre">jdbc:tajo://&lt;TajoMaster</span>
<span class="pre">hostname&gt;:&lt;TajoMaster</span> <span class="pre">client</span>
<span class="pre">rpc</span> <span class="pre">port&gt;/&lt;database</span>
<span class="pre">name&gt;</span></code>.
+The default TajoMaster client rpc port is <code class="docutils literal"><span class="pre">26002</span></code>.
 If you want to change the listening port, please refer <a class="reference internal" href="configuration/cluster_setup.html"><em>Cluster
Setup</em></a>.</p>
 <div class="admonition note">
 <p class="first admonition-title">Note</p>
 <p class="last">Currently, Tajo does not support the concept of database and namespace.
-All tables are contained in <tt class="docutils literal"><span class="pre">default</span></tt>
database. So, you don&#8217;t need to specify any database name.</p>
+All tables are contained in <code class="docutils literal"><span class="pre">default</span></code>
database. So, you don&#8217;t need to specify any database name.</p>
 </div>
 <p>The following shows an example of JDBC Client.</p>
 <div class="highlight-java"><div class="highlight"><pre><span class="kn">import</span>
<span class="nn">java.sql.Connection</span><span class="o">;</span>

Modified: tajo/site/docs/devel/objects.inv
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/objects.inv?rev=1706954&r1=1706953&r2=1706954&view=diff
==============================================================================
Binary files - no diff available.

Modified: tajo/site/docs/devel/partitioning/column_partitioning.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/partitioning/column_partitioning.html?rev=1706954&r1=1706953&r2=1706954&view=diff
==============================================================================
--- tajo/site/docs/devel/partitioning/column_partitioning.html (original)
+++ tajo/site/docs/devel/partitioning/column_partitioning.html Tue Oct  6 06:44:17 2015
@@ -164,6 +164,8 @@
 <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo
JDBC Driver</a><ul>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How
to get JDBC driver</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting
the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting
to the Tajo cluster instance</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection
Parameters</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An
Example JDBC Client</a></li>
 </ul>
 </li>
@@ -210,15 +212,15 @@
 <p>The column table partition is designed to support the partition of Apache Hive™.</p>
 <div class="section" id="how-to-create-a-column-partitioned-table">
 <h2>How to Create a Column Partitioned Table<a class="headerlink" href="#how-to-create-a-column-partitioned-table"
title="Permalink to this headline">¶</a></h2>
-<p>You can create a partitioned table by using the <tt class="docutils literal"><span
class="pre">PARTITION</span> <span class="pre">BY</span></tt> clause.
For a column partitioned table, you should use
-the <tt class="docutils literal"><span class="pre">PARTITION</span> <span
class="pre">BY</span> <span class="pre">COLUMN</span></tt> clause
with partition keys.</p>
-<p>For example, assume there is a table <tt class="docutils literal"><span
class="pre">orders</span></tt> composed of the following schema.</p>
+<p>You can create a partitioned table by using the <code class="docutils literal"><span
class="pre">PARTITION</span> <span class="pre">BY</span></code>
clause. For a column partitioned table, you should use
+the <code class="docutils literal"><span class="pre">PARTITION</span> <span
class="pre">BY</span> <span class="pre">COLUMN</span></code> clause
with partition keys.</p>
+<p>For example, assume there is a table <code class="docutils literal"><span
class="pre">orders</span></code> composed of the following schema.</p>
 <div class="highlight-python"><div class="highlight"><pre>id          INT,
 item_name   TEXT,
 price       FLOAT
 </pre></div>
 </div>
-<p>Also, assume that you want to use <tt class="docutils literal"><span class="pre">order_date</span>
<span class="pre">TEXT</span></tt> and <tt class="docutils literal"><span
class="pre">ship_date</span> <span class="pre">TEXT</span></tt>
as the partition keys.
+<p>Also, assume that you want to use <code class="docutils literal"><span
class="pre">order_date</span> <span class="pre">TEXT</span></code>
and <code class="docutils literal"><span class="pre">ship_date</span> <span
class="pre">TEXT</span></code> as the partition keys.
 Then, you should create a table as follows:</p>
 <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span>
<span class="k">TABLE</span> <span class="n">orders</span> <span
class="p">(</span>
   <span class="n">id</span> <span class="nb">INT</span><span class="p">,</span>
@@ -230,15 +232,15 @@ Then, you should create a table as follo
 </div>
 <div class="section" id="partition-pruning-on-column-partitioned-tables">
 <h2>Partition Pruning on Column Partitioned Tables<a class="headerlink" href="#partition-pruning-on-column-partitioned-tables"
title="Permalink to this headline">¶</a></h2>
-<p>The following predicates in the <tt class="docutils literal"><span class="pre">WHERE</span></tt>
clause can be used to prune unqualified column partitions without processing
+<p>The following predicates in the <code class="docutils literal"><span class="pre">WHERE</span></code>
clause can be used to prune unqualified column partitions without processing
 during query planning phase.</p>
 <ul class="simple">
-<li><tt class="docutils literal"><span class="pre">=</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">&lt;&gt;</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">&gt;</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">&lt;</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">&gt;=</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">&lt;=</span></tt></li>
+<li><code class="docutils literal"><span class="pre">=</span></code></li>
+<li><code class="docutils literal"><span class="pre">&lt;&gt;</span></code></li>
+<li><code class="docutils literal"><span class="pre">&gt;</span></code></li>
+<li><code class="docutils literal"><span class="pre">&lt;</span></code></li>
+<li><code class="docutils literal"><span class="pre">&gt;=</span></code></li>
+<li><code class="docutils literal"><span class="pre">&lt;=</span></code></li>
 <li>LIKE predicates with a leading wild-card character</li>
 <li>IN list predicates</li>
 </ul>

Modified: tajo/site/docs/devel/partitioning/hash_partitioning.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/partitioning/hash_partitioning.html?rev=1706954&r1=1706953&r2=1706954&view=diff
==============================================================================
--- tajo/site/docs/devel/partitioning/hash_partitioning.html (original)
+++ tajo/site/docs/devel/partitioning/hash_partitioning.html Tue Oct  6 06:44:17 2015
@@ -164,6 +164,8 @@
 <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo
JDBC Driver</a><ul>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How
to get JDBC driver</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting
the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting
to the Tajo cluster instance</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection
Parameters</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An
Example JDBC Client</a></li>
 </ul>
 </li>

Modified: tajo/site/docs/devel/partitioning/intro_to_partitioning.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/partitioning/intro_to_partitioning.html?rev=1706954&r1=1706953&r2=1706954&view=diff
==============================================================================
--- tajo/site/docs/devel/partitioning/intro_to_partitioning.html (original)
+++ tajo/site/docs/devel/partitioning/intro_to_partitioning.html Tue Oct  6 06:44:17 2015
@@ -164,6 +164,8 @@
 <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo
JDBC Driver</a><ul>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How
to get JDBC driver</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting
the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting
to the Tajo cluster instance</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection
Parameters</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An
Example JDBC Client</a></li>
 </ul>
 </li>

Modified: tajo/site/docs/devel/partitioning/range_partitioning.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/partitioning/range_partitioning.html?rev=1706954&r1=1706953&r2=1706954&view=diff
==============================================================================
--- tajo/site/docs/devel/partitioning/range_partitioning.html (original)
+++ tajo/site/docs/devel/partitioning/range_partitioning.html Tue Oct  6 06:44:17 2015
@@ -164,6 +164,8 @@
 <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo
JDBC Driver</a><ul>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How
to get JDBC driver</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting
the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting
to the Tajo cluster instance</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection
Parameters</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An
Example JDBC Client</a></li>
 </ul>
 </li>

Modified: tajo/site/docs/devel/search.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/search.html?rev=1706954&r1=1706953&r2=1706954&view=diff
==============================================================================
--- tajo/site/docs/devel/search.html (original)
+++ tajo/site/docs/devel/search.html Tue Oct  6 06:44:17 2015
@@ -161,6 +161,8 @@
 <li class="toctree-l1"><a class="reference internal" href="jdbc_driver.html">Tajo
JDBC Driver</a><ul>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#how-to-get-jdbc-driver">How
to get JDBC driver</a></li>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#setting-the-classpath">Setting
the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting
to the Tajo cluster instance</a></li>
+<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connection-parameters">Connection
Parameters</a></li>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#an-example-jdbc-client">An
Example JDBC Client</a></li>
 </ul>
 </li>




Mime
View raw message