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>
