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><property> <name>tajo.catalog.store.class</name> <value>org.apache.tajo.catalog.store.HiveCatalogStore</value> @@ -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> <span class="pre">table_name</span></tt> command.</p> -<p>But current tajo doesn’t provide <tt class="docutils literal"><span class="pre">ADD</span> <span class="pre">PARTITION</span></tt> command and hive doesn’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> <span class="pre">table_name</span></code> command.</p> +<p>But current tajo doesn’t provide <code class="docutils literal"><span class="pre">ADD</span> <span class="pre">PARTITION</span></code> command and hive doesn’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">"jdbc:tajo://localhost/test"</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">"useCompression"</span><span class="o">,</span><span class="s">"true"</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">"connectTimeout"</span><span class="o">,</span><span class="s">"15000"</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("org.apache.tajo.jdbc.TajoDriver")</span></tt>. -The connection url should be <tt class="docutils literal"><span class="pre">jdbc:tajo://<TajoMaster</span> <span class="pre">hostname>:<TajoMaster</span> <span class="pre">client</span> <span class="pre">rpc</span> <span class="pre">port>/<database</span> <span class="pre">name></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("org.apache.tajo.jdbc.TajoDriver")</span></code>. +The connection url should be <code class="docutils literal"><span class="pre">jdbc:tajo://<TajoMaster</span> <span class="pre">hostname>:<TajoMaster</span> <span class="pre">client</span> <span class="pre">rpc</span> <span class="pre">port>/<database</span> <span class="pre">name></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’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’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"><></span></tt></li> -<li><tt class="docutils literal"><span class="pre">></span></tt></li> -<li><tt class="docutils literal"><span class="pre"><</span></tt></li> -<li><tt class="docutils literal"><span class="pre">>=</span></tt></li> -<li><tt class="docutils literal"><span class="pre"><=</span></tt></li> +<li><code class="docutils literal"><span class="pre">=</span></code></li> +<li><code class="docutils literal"><span class="pre"><></span></code></li> +<li><code class="docutils literal"><span class="pre">></span></code></li> +<li><code class="docutils literal"><span class="pre"><</span></code></li> +<li><code class="docutils literal"><span class="pre">>=</span></code></li> +<li><code class="docutils literal"><span class="pre"><=</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>
