You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@tajo.apache.org by hy...@apache.org on 2015/05/28 14:22:20 UTC
svn commit: r1682226 [2/5] - in /tajo/site/docs/devel: ./
_sources/table_management/ _static/ configuration/ functions/ index/
partitioning/ sql_language/ table_management/ tsql/
Modified: tajo/site/docs/devel/functions/string_func_and_operators.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/functions/string_func_and_operators.html?rev=1682226&r1=1682225&r2=1682226&view=diff
==============================================================================
--- tajo/site/docs/devel/functions/string_func_and_operators.html (original)
+++ tajo/site/docs/devel/functions/string_func_and_operators.html Thu May 28 12:22:19 2015
@@ -199,8 +199,8 @@
<h1>String Functions and Operators<a class="headerlink" href="#string-functions-and-operators" title="Permalink to this headline">¶</a></h1>
<dl class="function">
<dt>
-<tt class="descname">str1 || str2</tt></dt>
-<dd><p>Returns the concatnenated string of both side strings <tt class="docutils literal"><span class="pre">str1</span></tt> and <tt class="docutils literal"><span class="pre">str2</span></tt>.</p>
+<code class="descname">str1 || str2</code></dt>
+<dd><p>Returns the concatnenated string of both side strings <code class="docutils literal"><span class="pre">str1</span></code> and <code class="docutils literal"><span class="pre">str2</span></code>.</p>
<table class="docutils field-list" frame="void" rules="none">
<col class="field-name" />
<col class="field-body" />
@@ -226,7 +226,7 @@
<dl class="function">
<dt id="char_length">
-<tt class="descname">char_length</tt><big>(</big><em>string text</em><big>)</big><a class="headerlink" href="#char_length" title="Permalink to this definition">¶</a></dt>
+<code class="descname">char_length</code><span class="sig-paren">(</span><em>string text</em><span class="sig-paren">)</span><a class="headerlink" href="#char_length" title="Permalink to this definition">¶</a></dt>
<dd><p>Returns Number of characters in string</p>
<table class="docutils field-list" frame="void" rules="none">
<col class="field-name" />
@@ -250,7 +250,7 @@
<dl class="function">
<dt id="trim">
-<tt class="descname">trim</tt><big>(</big><em>[leading | trailing | both] [characters] from string</em><big>)</big><a class="headerlink" href="#trim" title="Permalink to this definition">¶</a></dt>
+<code class="descname">trim</code><span class="sig-paren">(</span><em>[leading | trailing | both] [characters] from string</em><span class="sig-paren">)</span><a class="headerlink" href="#trim" title="Permalink to this definition">¶</a></dt>
<dd><p>Removes the characters (a space by default) from the start/end/both ends of the string</p>
<table class="docutils field-list" frame="void" rules="none">
<col class="field-name" />
@@ -277,7 +277,7 @@
<dl class="function">
<dt id="btrim">
-<tt class="descname">btrim</tt><big>(</big><em>string text</em><span class="optional">[</span>, <em>characters text</em><span class="optional">]</span><big>)</big><a class="headerlink" href="#btrim" title="Permalink to this definition">¶</a></dt>
+<code class="descname">btrim</code><span class="sig-paren">(</span><em>string text</em><span class="optional">[</span>, <em>characters text</em><span class="optional">]</span><span class="sig-paren">)</span><a class="headerlink" href="#btrim" title="Permalink to this definition">¶</a></dt>
<dd><p>Removes the characters (a space by default) from the both ends of the string</p>
<table class="docutils field-list" frame="void" rules="none">
<col class="field-name" />
@@ -307,7 +307,7 @@
<dl class="function">
<dt id="ltrim">
-<tt class="descname">ltrim</tt><big>(</big><em>string text</em><span class="optional">[</span>, <em>characters text</em><span class="optional">]</span><big>)</big><a class="headerlink" href="#ltrim" title="Permalink to this definition">¶</a></dt>
+<code class="descname">ltrim</code><span class="sig-paren">(</span><em>string text</em><span class="optional">[</span>, <em>characters text</em><span class="optional">]</span><span class="sig-paren">)</span><a class="headerlink" href="#ltrim" title="Permalink to this definition">¶</a></dt>
<dd><p>Removes the characters (a space by default) from the start ends of the string</p>
<table class="docutils field-list" frame="void" rules="none">
<col class="field-name" />
@@ -334,7 +334,7 @@
<dl class="function">
<dt id="rtrim">
-<tt class="descname">rtrim</tt><big>(</big><em>string text</em><span class="optional">[</span>, <em>characters text</em><span class="optional">]</span><big>)</big><a class="headerlink" href="#rtrim" title="Permalink to this definition">¶</a></dt>
+<code class="descname">rtrim</code><span class="sig-paren">(</span><em>string text</em><span class="optional">[</span>, <em>characters text</em><span class="optional">]</span><span class="sig-paren">)</span><a class="headerlink" href="#rtrim" title="Permalink to this definition">¶</a></dt>
<dd><p>Removes the characters (a space by default) from the end ends of the string</p>
<table class="docutils field-list" frame="void" rules="none">
<col class="field-name" />
@@ -361,7 +361,7 @@
<dl class="function">
<dt id="split_part">
-<tt class="descname">split_part</tt><big>(</big><em>string text</em>, <em>delimiter text</em>, <em>field int</em><big>)</big><a class="headerlink" href="#split_part" title="Permalink to this definition">¶</a></dt>
+<code class="descname">split_part</code><span class="sig-paren">(</span><em>string text</em>, <em>delimiter text</em>, <em>field int</em><span class="sig-paren">)</span><a class="headerlink" href="#split_part" title="Permalink to this definition">¶</a></dt>
<dd><p>Splits a string on delimiter and return the given field (counting from one)</p>
<table class="docutils field-list" frame="void" rules="none">
<col class="field-name" />
@@ -389,7 +389,7 @@
<dl class="function">
<dt id="regexp_replace">
-<tt class="descname">regexp_replace</tt><big>(</big><em>string text</em>, <em>pattern text</em>, <em>replacement text</em><big>)</big><a class="headerlink" href="#regexp_replace" title="Permalink to this definition">¶</a></dt>
+<code class="descname">regexp_replace</code><span class="sig-paren">(</span><em>string text</em>, <em>pattern text</em>, <em>replacement text</em><span class="sig-paren">)</span><a class="headerlink" href="#regexp_replace" title="Permalink to this definition">¶</a></dt>
<dd><p>Replaces substrings matched to a given regular expression pattern</p>
<table class="docutils field-list" frame="void" rules="none">
<col class="field-name" />
@@ -417,7 +417,7 @@
<dl class="function">
<dt id="upper">
-<tt class="descname">upper</tt><big>(</big><em>string text</em><big>)</big><a class="headerlink" href="#upper" title="Permalink to this definition">¶</a></dt>
+<code class="descname">upper</code><span class="sig-paren">(</span><em>string text</em><span class="sig-paren">)</span><a class="headerlink" href="#upper" title="Permalink to this definition">¶</a></dt>
<dd><p>makes an input text to be upper case</p>
<table class="docutils field-list" frame="void" rules="none">
<col class="field-name" />
@@ -439,7 +439,7 @@
<dl class="function">
<dt id="lower">
-<tt class="descname">lower</tt><big>(</big><em>string text</em><big>)</big><a class="headerlink" href="#lower" title="Permalink to this definition">¶</a></dt>
+<code class="descname">lower</code><span class="sig-paren">(</span><em>string text</em><span class="sig-paren">)</span><a class="headerlink" href="#lower" title="Permalink to this definition">¶</a></dt>
<dd><p>makes an input text to be lower case</p>
<table class="docutils field-list" frame="void" rules="none">
<col class="field-name" />
Modified: tajo/site/docs/devel/getting_started.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/getting_started.html?rev=1682226&r1=1682225&r2=1682226&view=diff
==============================================================================
--- tajo/site/docs/devel/getting_started.html (original)
+++ tajo/site/docs/devel/getting_started.html Thu May 28 12:22:19 2015
@@ -271,7 +271,7 @@ Download the file that ends in .tar.gz t
</div>
<div class="admonition warning">
<p class="first admonition-title">Warning</p>
-<p class="last">By default, <em>Catalog server</em> which manages table meta data uses <a class="reference external" href="http://db.apache.org/derby/">Apache Derby</a> as a persistent storage, and Derby stores data into <tt class="docutils literal"><span class="pre">/tmp/tajo-catalog-${username}</span></tt> directory. But, some operating systems may remove all contents in <tt class="docutils literal"><span class="pre">/tmp</span></tt> when booting up. In order to ensure persistent store of your catalog data, you need to set a proper location of derby directory. To learn Catalog configuration, please refer to <a class="reference internal" href="configuration/catalog_configuration.html"><em>Catalog Configuration</em></a>.</p>
+<p class="last">By default, <em>Catalog server</em> which manages table meta data uses <a class="reference external" href="http://db.apache.org/derby/">Apache Derby</a> as a persistent storage, and Derby stores data into <code class="docutils literal"><span class="pre">/tmp/tajo-catalog-${username}</span></code> directory. But, some operating systems may remove all contents in <code class="docutils literal"><span class="pre">/tmp</span></code> when booting up. In order to ensure persistent store of your catalog data, you need to set a proper location of derby directory. To learn Catalog configuration, please refer to <a class="reference internal" href="configuration/catalog_configuration.html"><em>Catalog Configuration</em></a>.</p>
</div>
</div>
<div class="section" id="first-query-execution">
@@ -288,7 +288,7 @@ Download the file that ends in .tar.gz t
<CTRL + D>
</pre></div>
</div>
-<p>Apache Tajo⢠provides a SQL shell which allows users to interactively submit SQL queries. In order to use this shell, please execute <tt class="docutils literal"><span class="pre">bin/tsql</span></tt></p>
+<p>Apache Tajo⢠provides a SQL shell which allows users to interactively submit SQL queries. In order to use this shell, please execute <code class="docutils literal"><span class="pre">bin/tsql</span></code></p>
<div class="highlight-python"><div class="highlight"><pre>$ $TAJO_HOME/bin/tsql
tajo>
</pre></div>
@@ -327,7 +327,7 @@ If the table resides in HDFS, you should
type TEXT
</pre></div>
</div>
-<p><tt class="docutils literal"><span class="pre">\d</span> <span class="pre">[table</span> <span class="pre">name]</span></tt> command shows the description of a given table.</p>
+<p><code class="docutils literal"><span class="pre">\d</span> <span class="pre">[table</span> <span class="pre">name]</span></code> command shows the description of a given table.</p>
<p>Also, you can execute SQL queries as follows:</p>
<div class="highlight-python"><div class="highlight"><pre>tajo> select * from table1 where id > 2;
final state: QUERY_SUCCEEDED, init time: 0.069 sec, response time: 0.397 sec
Modified: tajo/site/docs/devel/hbase_integration.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/hbase_integration.html?rev=1682226&r1=1682225&r2=1682226&view=diff
==============================================================================
--- tajo/site/docs/devel/hbase_integration.html (original)
+++ tajo/site/docs/devel/hbase_integration.html Thu May 28 12:22:19 2015
@@ -196,9 +196,9 @@
<h1>HBase Integration<a class="headerlink" href="#hbase-integration" title="Permalink to this headline">¶</a></h1>
<p>Apache Tajo⢠storage supports integration with Apache HBaseâ¢.
This integration allows Tajo to access all tables used in Apache HBase.</p>
-<p>In order to use this feature, you need to build add some configs into <tt class="docutils literal"><span class="pre">conf/tajo-env.sh</span></tt> and then add some properties into a table create statement.</p>
+<p>In order to use this feature, you need to build add some configs into <code class="docutils literal"><span class="pre">conf/tajo-env.sh</span></code> and then add some properties into a table create statement.</p>
<p>This section describes how to setup HBase integration.</p>
-<p>First, you need to set your HBase home directory to the environment variable <tt class="docutils literal"><span class="pre">HBASE_HOME</span></tt> in conf/tajo-env.sh as follows:</p>
+<p>First, you need to set your HBase home directory to the environment variable <code class="docutils literal"><span class="pre">HBASE_HOME</span></code> in conf/tajo-env.sh as follows:</p>
<div class="highlight-python"><div class="highlight"><pre>export HBASE_HOME=/path/to/your/hbase/directory
</pre></div>
</div>
@@ -217,12 +217,12 @@ This integration allows Tajo to access a
</div>
<p>Options</p>
<ul class="simple">
-<li><tt class="docutils literal"><span class="pre">table</span></tt> : Set hbase origin table name. If you want to create an external table, the table must exists on HBase. The other way, if you want to create a managed table, the table must doesn’t exist on HBase.</li>
-<li><tt class="docutils literal"><span class="pre">columns</span></tt> : :key means HBase row key. The number of columns entry need to equals to the number of Tajo table column</li>
-<li><tt class="docutils literal"><span class="pre">hbase.zookeeper.quorum</span></tt> : Set zookeeper quorum address. You can use different zookeeper cluster on the same Tajo database. If you don’t set the zookeeper address, Tajo will refer the property of hbase-site.xml file.</li>
-<li><tt class="docutils literal"><span class="pre">hbase.zookeeper.property.clientPort</span></tt> : Set zookeeper client port. If you don’t set the port, Tajo will refer the property of hbase-site.xml file.</li>
+<li><code class="docutils literal"><span class="pre">table</span></code> : Set hbase origin table name. If you want to create an external table, the table must exists on HBase. The other way, if you want to create a managed table, the table must doesn’t exist on HBase.</li>
+<li><code class="docutils literal"><span class="pre">columns</span></code> : :key means HBase row key. The number of columns entry need to equals to the number of Tajo table column</li>
+<li><code class="docutils literal"><span class="pre">hbase.zookeeper.quorum</span></code> : Set zookeeper quorum address. You can use different zookeeper cluster on the same Tajo database. If you don’t set the zookeeper address, Tajo will refer the property of hbase-site.xml file.</li>
+<li><code class="docutils literal"><span class="pre">hbase.zookeeper.property.clientPort</span></code> : Set zookeeper client port. If you don’t set the port, Tajo will refer the property of hbase-site.xml file.</li>
</ul>
-<p><tt class="docutils literal"><span class="pre">IF</span> <span class="pre">NOT</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">CREATE</span> <span class="pre">[EXTERNAL]</span> <span class="pre">TABLE</span></tt> statement to avoid an error which occurs when the table does not exist.</p>
+<p><code class="docutils literal"><span class="pre">IF</span> <span class="pre">NOT</span> <span class="pre">EXISTS</span></code> allows <code class="docutils literal"><span class="pre">CREATE</span> <span class="pre">[EXTERNAL]</span> <span class="pre">TABLE</span></code> statement to avoid an error which occurs when the table does not exist.</p>
</div>
<div class="section" id="drop-table">
<h2>DROP TABLE<a class="headerlink" href="#drop-table" title="Permalink to this headline">¶</a></h2>
@@ -230,11 +230,11 @@ This integration allows Tajo to access a
<div class="highlight-sql"><div class="highlight"><pre><span class="k">DROP</span> <span class="k">TABLE</span> <span class="p">[</span><span class="n">IF</span> <span class="k">EXISTS</span><span class="p">]</span> <span class="o"><</span><span class="k">table_name</span><span class="o">></span> <span class="p">[</span><span class="n">PURGE</span><span class="p">]</span>
</pre></div>
</div>
-<p><tt class="docutils literal"><span class="pre">IF</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></tt> statement to avoid an error which occurs when the table does not exist. <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></tt> statement removes a table from Tajo catalog, but it does not remove the contents on HBase cluster. If <tt class="docutils literal"><span class="pre">PURGE</span></tt> option is given, <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></tt> statement will eliminate the entry in the catalog as well as the contents on HBase cluster.</p>
+<p><code class="docutils literal"><span class="pre">IF</span> <span class="pre">EXISTS</span></code> allows <code class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></code> statement to avoid an error which occurs when the table does not exist. <code class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></code> statement removes a table from Tajo catalog, but it does not remove the contents on HBase cluster. If <code class="docutils literal"><span class="pre">PURGE</span></code> option is given, <code class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></code> statement will eliminate the entry in the catalog as well as the contents on HBase cluster.</p>
</div>
<div class="section" id="insert-overwrite-into">
<h2>INSERT (OVERWRITE) INTO<a class="headerlink" href="#insert-overwrite-into" title="Permalink to this headline">¶</a></h2>
-<p>INSERT OVERWRITE statement overwrites a table data of an existing table. Tajo’s INSERT OVERWRITE statement follows <tt class="docutils literal"><span class="pre">INSERT</span> <span class="pre">INTO</span> <span class="pre">SELECT</span></tt> statement of SQL. The examples are as follows:</p>
+<p>INSERT OVERWRITE statement overwrites a table data of an existing table. Tajo’s INSERT OVERWRITE statement follows <code class="docutils literal"><span class="pre">INSERT</span> <span class="pre">INTO</span> <span class="pre">SELECT</span></code> statement of SQL. The examples are as follows:</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="c1">-- when a target table schema and output schema are equivalent to each other</span>
<span class="k">INSERT</span> <span class="n">OVERWRITE</span> <span class="k">INTO</span> <span class="n">t1</span> <span class="k">SELECT</span> <span class="n">l_orderkey</span><span class="p">,</span> <span class="n">l_partkey</span><span class="p">,</span> <span class="n">l_quantity</span> <span class="k">FROM</span> <span class="n">lineitem</span><span class="p">;</span>
<span class="c1">-- or</span>
@@ -275,7 +275,7 @@ put 'blog', 'jhkim-01',
put 'blog', 'jhkim-01', 'info:date', '2014-10-22'
</pre></div>
</div>
-<p>And then create the table and query the table meta data with <tt class="docutils literal"><span class="pre">\d</span></tt> option:</p>
+<p>And then create the table and query the table meta data with <code class="docutils literal"><span class="pre">\d</span></code> option:</p>
<div class="highlight-sql"><div class="highlight"><pre>default> \d blog;
table name: default.blog
Modified: tajo/site/docs/devel/hive_integration.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/hive_integration.html?rev=1682226&r1=1682225&r2=1682226&view=diff
==============================================================================
--- tajo/site/docs/devel/hive_integration.html (original)
+++ tajo/site/docs/devel/hive_integration.html Thu May 28 12:22:19 2015
@@ -199,10 +199,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>
@@ -211,7 +211,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>
@@ -222,10 +222,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=1682226&r1=1682225&r2=1682226&view=diff
==============================================================================
--- tajo/site/docs/devel/index.html (original)
+++ tajo/site/docs/devel/index.html Thu May 28 12:22:19 2015
@@ -439,9 +439,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/types.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/index/types.html?rev=1682226&r1=1682225&r2=1682226&view=diff
==============================================================================
--- tajo/site/docs/devel/index/types.html (original)
+++ tajo/site/docs/devel/index/types.html Thu May 28 12:22:19 2015
@@ -197,7 +197,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=1682226&r1=1682225&r2=1682226&view=diff
==============================================================================
--- tajo/site/docs/devel/index_overview.html (original)
+++ tajo/site/docs/devel/index_overview.html Thu May 28 12:22:19 2015
@@ -195,7 +195,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/jdbc_driver.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/jdbc_driver.html?rev=1682226&r1=1682225&r2=1682226&view=diff
==============================================================================
--- tajo/site/docs/devel/jdbc_driver.html (original)
+++ tajo/site/docs/devel/jdbc_driver.html Thu May 28 12:22:19 2015
@@ -201,11 +201,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>
@@ -219,22 +219,22 @@ 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="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=1682226&r1=1682225&r2=1682226&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=1682226&r1=1682225&r2=1682226&view=diff
==============================================================================
--- tajo/site/docs/devel/partitioning/column_partitioning.html (original)
+++ tajo/site/docs/devel/partitioning/column_partitioning.html Thu May 28 12:22:19 2015
@@ -200,15 +200,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>
@@ -220,15 +220,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>