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 2014/10/02 02:36:31 UTC

svn commit: r1628871 [4/5] - in /tajo/site/docs/current: ./ _sources/configuration/ _sources/getting_started/ _sources/sql_language/ _static/ backup_and_restore/ configuration/ functions/ getting_started/ partitioning/ sql_language/ table_management/

Modified: tajo/site/docs/current/getting_started/downloading_source.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/getting_started/downloading_source.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/getting_started/downloading_source.html (original)
+++ tajo/site/docs/current/getting_started/downloading_source.html Thu Oct  2 00:36:30 2014
@@ -1,6 +1,5 @@
 
 
-
 <!DOCTYPE html>
 <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
 <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
@@ -172,14 +171,14 @@
 Click on the suggested mirror link. This will take you to a mirror of Tajo Releases.
 Download the file that ends in .tar.gz to your local filesystem; e.g. tajo-x.y.z-src.tar.gz.</p>
 <p>Decompress and untar your download and then change into the unpacked directory.</p>
-<div class="highlight-python"><div class="highlight"><pre><span class="n">tar</span> <span class="n">xzvf</span> <span class="n">tajo</span><span class="o">-</span><span class="n">x</span><span class="o">.</span><span class="n">y</span><span class="o">.</span><span class="n">z</span><span class="o">-</span><span class="n">src</span><span class="o">.</span><span class="n">tar</span><span class="o">.</span><span class="n">gz</span>
+<div class="highlight-python"><div class="highlight"><pre>tar xzvf tajo-x.y.z-src.tar.gz
 </pre></div>
 </div>
 </div>
 <div class="section" id="get-the-source-code-via-git">
 <h2>Get the source code via Git<a class="headerlink" href="#get-the-source-code-via-git" title="Permalink to this headline">¶</a></h2>
 <p>The development codebase can also be downloaded from <a class="reference external" href="https://git-wip-us.apache.org/repos/asf/tajo.git">the Apache git repository</a> as follows:</p>
-<div class="highlight-python"><div class="highlight"><pre><span class="n">git</span> <span class="n">clone</span> <span class="n">https</span><span class="p">:</span><span class="o">//</span><span class="n">git</span><span class="o">-</span><span class="n">wip</span><span class="o">-</span><span class="n">us</span><span class="o">.</span><span class="n">apache</span><span class="o">.</span><span class="n">org</span><span class="o">/</span><span class="n">repos</span><span class="o">/</span><span class="n">asf</span><span class="o">/</span><span class="n">tajo</span><span class="o">.</span><span class="n">git</span>
+<div class="highlight-python"><div class="highlight"><pre>git clone https://git-wip-us.apache.org/repos/asf/tajo.git
 </pre></div>
 </div>
 <p>A read-only git repository is also mirrored on <a class="reference external" href="https://github.com/apache/tajo">Github</a>.</p>

Modified: tajo/site/docs/current/getting_started/first_query.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/getting_started/first_query.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/getting_started/first_query.html (original)
+++ tajo/site/docs/current/getting_started/first_query.html Thu Oct  2 00:36:30 2014
@@ -1,6 +1,5 @@
 
 
-
 <!DOCTYPE html>
 <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
 <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
@@ -178,45 +177,47 @@
 </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>
-<div class="highlight-python"><pre>$ $TAJO_HOME/bin/tsql
-tajo&gt;</pre>
+<div class="highlight-python"><div class="highlight"><pre>$ $TAJO_HOME/bin/tsql
+tajo&gt;
+</pre></div>
 </div>
 <p>In order to load the table we created above, we should think of a schema of the table.
 Here, we assume the schema as (int, text, float, text).</p>
-<div class="highlight-python"><pre>$ $TAJO_HOME/bin/tsql
+<div class="highlight-python"><div class="highlight"><pre>$ $TAJO_HOME/bin/tsql
 tajo&gt; create external table table1 (
       id int,
       name text,
       score float,
       type text)
-      using csv with ('csvfile.delimiter'='|') location 'file:/home/x/table1';</pre>
+      using csv with (&#39;csvfile.delimiter&#39;=&#39;|&#39;) location &#39;file:/home/x/table1&#39;;
+</pre></div>
 </div>
 <p>To load an external table, you need to use ‘create external table’ statement.
 In the location clause, you should use the absolute directory path with an appropriate scheme.
 If the table resides in HDFS, you should use ‘hdfs’ instead of ‘file’.</p>
 <p>If you want to know DDL statements in more detail, please see Query Language.</p>
-<div class="highlight-python"><div class="highlight"><pre> <span class="n">tajo</span><span class="o">&gt;</span> \<span class="n">d</span>
- <span class="n">table1</span>
+<div class="highlight-python"><div class="highlight"><pre> tajo&gt; \d
+ table1
 
-<span class="sb">``</span>\<span class="n">d</span><span class="sb">``</span> <span class="n">command</span> <span class="n">shows</span> <span class="n">the</span> <span class="nb">list</span> <span class="n">of</span> <span class="n">tables</span><span class="o">.</span> <span class="p">::</span>
+``\d`` command shows the list of tables. ::
 
- <span class="n">tajo</span><span class="o">&gt;</span> \<span class="n">d</span> <span class="n">table1</span>
+ tajo&gt; \d table1
 
- <span class="n">table</span> <span class="n">name</span><span class="p">:</span> <span class="n">table1</span>
- <span class="n">table</span> <span class="n">path</span><span class="p">:</span> <span class="nb">file</span><span class="p">:</span><span class="o">/</span><span class="n">home</span><span class="o">/</span><span class="n">x</span><span class="o">/</span><span class="n">table1</span>
- <span class="n">store</span> <span class="nb">type</span><span class="p">:</span> <span class="n">CSV</span>
- <span class="n">number</span> <span class="n">of</span> <span class="n">rows</span><span class="p">:</span> <span class="mi">0</span>
- <span class="n">volume</span> <span class="p">(</span><span class="nb">bytes</span><span class="p">):</span> <span class="mi">78</span> <span class="n">B</span>
- <span class="n">schema</span><span class="p">:</span>
- <span class="nb">id</span>      <span class="n">INT</span>
- <span class="n">name</span>    <span class="n">TEXT</span>
- <span class="n">score</span>   <span class="n">FLOAT</span>
- <span class="nb">type</span>    <span class="n">TEXT</span>
+ table name: table1
+ table path: file:/home/x/table1
+ store type: CSV
+ number of rows: 0
+ volume (bytes): 78 B
+ schema:
+ id      INT
+ name    TEXT
+ score   FLOAT
+ 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>Also, you can execute SQL queries as follows:</p>
-<div class="highlight-python"><pre>tajo&gt; select * from table1 where id &gt; 2;
+<div class="highlight-python"><div class="highlight"><pre>tajo&gt; select * from table1 where id &gt; 2;
 final state: QUERY_SUCCEEDED, init time: 0.069 sec, response time: 0.397 sec
 result: file:/tmp/tajo-hadoop/staging/q_1363768615503_0001_000001/RESULT, 3 rows ( 35B)
 
@@ -227,7 +228,8 @@ id,  name,  score,  type
 5,  mno,  5.6,  e
 
 tajo&gt; \q
-bye</pre>
+bye
+</pre></div>
 </div>
 <p>Feel free to enjoy Tajo with SQL standards.
 If you want to know more explanation for SQL supported by Tajo, please refer <a class="reference internal" href="../sql_language.html"><em>SQL Language</em></a>.</p>

Modified: tajo/site/docs/current/getting_started/local_setup.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/getting_started/local_setup.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/getting_started/local_setup.html (original)
+++ tajo/site/docs/current/getting_started/local_setup.html Thu Oct  2 00:36:30 2014
@@ -1,6 +1,5 @@
 
 
-
 <!DOCTYPE html>
 <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
 <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->

Modified: tajo/site/docs/current/getting_started/prerequisites.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/getting_started/prerequisites.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/getting_started/prerequisites.html (original)
+++ tajo/site/docs/current/getting_started/prerequisites.html Thu Oct  2 00:36:30 2014
@@ -1,6 +1,5 @@
 
 
-
 <!DOCTYPE html>
 <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
 <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->

Modified: tajo/site/docs/current/hcatalog_integration.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/hcatalog_integration.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/hcatalog_integration.html (original)
+++ tajo/site/docs/current/hcatalog_integration.html Thu Oct  2 00:36:30 2014
@@ -1,6 +1,5 @@
 
 
-
 <!DOCTYPE html>
 <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
 <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
@@ -173,25 +172,27 @@ This instruction would take no more than
 <p>First, you need to compile the source code with hcatalog profile.
 Currently, Tajo supports hcatalog-0.11.0 and hcatalog-0.12.0 profile.
 So, if you want to use Hive 0.11.0, you need to set <tt class="docutils literal"><span class="pre">-Phcatalog-0.11.0</span></tt> as the maven profile</p>
-<div class="highlight-python"><pre>$ mvn clean package -DskipTests -Pdist -Dtar -Phcatalog-0.11.0</pre>
+<div class="highlight-python"><div class="highlight"><pre>$ mvn clean package -DskipTests -Pdist -Dtar -Phcatalog-0.11.0
+</pre></div>
 </div>
 <p>Or, if you want to use Hive 0.12.0, you need to set <tt class="docutils literal"><span class="pre">-Phcatalog-0.12.0</span></tt> as the maven profile</p>
-<div class="highlight-python"><pre>$ mvn clean package -DskipTests -Pdist -Dtar -Phcatalog-0.12.0</pre>
+<div class="highlight-python"><div class="highlight"><pre>$ mvn clean package -DskipTests -Pdist -Dtar -Phcatalog-0.12.0
+</pre></div>
 </div>
 <p>Then, 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>
-<div class="highlight-python"><div class="highlight"><pre><span class="n">export</span> <span class="n">HIVE_HOME</span><span class="o">=/</span><span class="n">path</span><span class="o">/</span><span class="n">to</span><span class="o">/</span><span class="n">your</span><span class="o">/</span><span class="n">hive</span><span class="o">/</span><span class="n">directory</span>
+<div class="highlight-python"><div class="highlight"><pre>export HIVE_HOME=/path/to/your/hive/directory
 </pre></div>
 </div>
 <p>If you need to use jdbc to connect HiveMetaStore, you have to prepare MySQL jdbc driver.
 Next, you should set the path of MySQL JDBC driver jar file to the environment variable HIVE_JDBC_DRIVER_DIR in conf/tajo-env.sh as follows:</p>
-<div class="highlight-python"><div class="highlight"><pre><span class="n">export</span> <span class="n">HIVE_JDBC_DRIVER_DIR</span><span class="o">==/</span><span class="n">path</span><span class="o">/</span><span class="n">to</span><span class="o">/</span><span class="n">your</span><span class="o">/</span><span class="n">mysql_jdbc_driver</span><span class="o">/</span><span class="n">mysql</span><span class="o">-</span><span class="n">connector</span><span class="o">-</span><span class="n">java</span><span class="o">-</span><span class="n">x</span><span class="o">.</span><span class="n">x</span><span class="o">.</span><span class="n">x</span><span class="o">-</span><span class="nb">bin</span><span class="o">.</span><span class="n">jar</span>
+<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 HCatalogStore as Tajo catalog driver class in <tt class="docutils literal"><span class="pre">conf/catalog-site.xml</span></tt> as follows:</p>
-<div class="highlight-python"><div class="highlight"><pre><span class="o">&lt;</span><span class="nb">property</span><span class="o">&gt;</span>
-  <span class="o">&lt;</span><span class="n">name</span><span class="o">&gt;</span><span class="n">tajo</span><span class="o">.</span><span class="n">catalog</span><span class="o">.</span><span class="n">store</span><span class="o">.</span><span class="n">class</span><span class="o">&lt;/</span><span class="n">name</span><span class="o">&gt;</span>
-  <span class="o">&lt;</span><span class="n">value</span><span class="o">&gt;</span><span class="n">org</span><span class="o">.</span><span class="n">apache</span><span class="o">.</span><span class="n">tajo</span><span class="o">.</span><span class="n">catalog</span><span class="o">.</span><span class="n">store</span><span class="o">.</span><span class="n">HCatalogStore</span><span class="o">&lt;/</span><span class="n">value</span><span class="o">&gt;</span>
-<span class="o">&lt;/</span><span class="nb">property</span><span class="o">&gt;</span>
+<div class="highlight-python"><div class="highlight"><pre>&lt;property&gt;
+  &lt;name&gt;tajo.catalog.store.class&lt;/name&gt;
+  &lt;value&gt;org.apache.tajo.catalog.store.HCatalogStore&lt;/value&gt;
+&lt;/property&gt;
 </pre></div>
 </div>
 </div>
@@ -233,7 +234,7 @@ Next, you should set the path of MySQL J
 
     <script type="text/javascript">
         var DOCUMENTATION_OPTIONS = {
-            URL_ROOT:'',
+            URL_ROOT:'./',
             VERSION:'0.8.0',
             COLLAPSE_INDEX:false,
             FILE_SUFFIX:'.html',

Modified: tajo/site/docs/current/index.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/index.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/index.html (original)
+++ tajo/site/docs/current/index.html Thu Oct  2 00:36:30 2014
@@ -1,6 +1,5 @@
 
 
-
 <!DOCTYPE html>
 <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
 <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
@@ -250,8 +249,9 @@ As a result, some contents can be mismat
 <li class="toctree-l3"><a class="reference internal" href="sql_language/queries.html#overview">Overview</a></li>
 <li class="toctree-l3"><a class="reference internal" href="sql_language/queries.html#from-clause">From Clause</a></li>
 <li class="toctree-l3"><a class="reference internal" href="sql_language/queries.html#where-clause">Where Clause</a></li>
-<li class="toctree-l3"><a class="reference internal" href="sql_language/queries.html#groupby-clause">Groupby Clause</a></li>
-<li class="toctree-l3"><a class="reference internal" href="sql_language/queries.html#select-list">Select list</a></li>
+<li class="toctree-l3"><a class="reference internal" href="sql_language/queries.html#groupby-and-having-clauses">Groupby and Having Clauses</a></li>
+<li class="toctree-l3"><a class="reference internal" href="sql_language/queries.html#orderby-and-limit-clauses">Orderby and Limit Clauses</a></li>
+<li class="toctree-l3"><a class="reference internal" href="sql_language/queries.html#window-functions">Window Functions</a></li>
 </ul>
 </li>
 <li class="toctree-l2"><a class="reference internal" href="sql_language/sql_expression.html">SQL Expressions</a><ul>
@@ -377,7 +377,7 @@ As a result, some contents can be mismat
 
     <script type="text/javascript">
         var DOCUMENTATION_OPTIONS = {
-            URL_ROOT:'',
+            URL_ROOT:'./',
             VERSION:'0.8.0',
             COLLAPSE_INDEX:false,
             FILE_SUFFIX:'.html',

Modified: tajo/site/docs/current/introduction.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/introduction.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/introduction.html (original)
+++ tajo/site/docs/current/introduction.html Thu Oct  2 00:36:30 2014
@@ -1,6 +1,5 @@
 
 
-
 <!DOCTYPE html>
 <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
 <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
@@ -210,7 +209,7 @@ queries in order to avoid the worst quer
 
     <script type="text/javascript">
         var DOCUMENTATION_OPTIONS = {
-            URL_ROOT:'',
+            URL_ROOT:'./',
             VERSION:'0.8.0',
             COLLAPSE_INDEX:false,
             FILE_SUFFIX:'.html',

Modified: tajo/site/docs/current/jdbc_driver.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/jdbc_driver.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/jdbc_driver.html (original)
+++ tajo/site/docs/current/jdbc_driver.html Thu Oct  2 00:36:30 2014
@@ -1,6 +1,5 @@
 
 
-
 <!DOCTYPE html>
 <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
 <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
@@ -296,7 +295,7 @@ So, the host names must be shared with t
 
     <script type="text/javascript">
         var DOCUMENTATION_OPTIONS = {
-            URL_ROOT:'',
+            URL_ROOT:'./',
             VERSION:'0.8.0',
             COLLAPSE_INDEX:false,
             FILE_SUFFIX:'.html',

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

Modified: tajo/site/docs/current/partitioning/column_partitioning.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/partitioning/column_partitioning.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/partitioning/column_partitioning.html (original)
+++ tajo/site/docs/current/partitioning/column_partitioning.html Thu Oct  2 00:36:30 2014
@@ -1,6 +1,5 @@
 
 
-
 <!DOCTYPE html>
 <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
 <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
@@ -171,9 +170,9 @@
 <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>
-<div class="highlight-python"><div class="highlight"><pre><span class="nb">id</span>          <span class="n">INT</span><span class="p">,</span>
-<span class="n">item_name</span>   <span class="n">TEXT</span><span class="p">,</span>
-<span class="n">price</span>       <span class="n">FLOAT</span>
+<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.

Modified: tajo/site/docs/current/partitioning/hash_partitioning.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/partitioning/hash_partitioning.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/partitioning/hash_partitioning.html (original)
+++ tajo/site/docs/current/partitioning/hash_partitioning.html Thu Oct  2 00:36:30 2014
@@ -1,6 +1,5 @@
 
 
-
 <!DOCTYPE html>
 <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
 <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->

Modified: tajo/site/docs/current/partitioning/intro_to_partitioning.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/partitioning/intro_to_partitioning.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/partitioning/intro_to_partitioning.html (original)
+++ tajo/site/docs/current/partitioning/intro_to_partitioning.html Thu Oct  2 00:36:30 2014
@@ -1,6 +1,5 @@
 
 
-
 <!DOCTYPE html>
 <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
 <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->

Modified: tajo/site/docs/current/partitioning/range_partitioning.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/partitioning/range_partitioning.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/partitioning/range_partitioning.html (original)
+++ tajo/site/docs/current/partitioning/range_partitioning.html Thu Oct  2 00:36:30 2014
@@ -1,6 +1,5 @@
 
 
-
 <!DOCTYPE html>
 <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
 <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->

Modified: tajo/site/docs/current/search.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/search.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/search.html (original)
+++ tajo/site/docs/current/search.html Thu Oct  2 00:36:30 2014
@@ -196,7 +196,7 @@
 
     <script type="text/javascript">
         var DOCUMENTATION_OPTIONS = {
-            URL_ROOT:'',
+            URL_ROOT:'./',
             VERSION:'0.8.0',
             COLLAPSE_INDEX:false,
             FILE_SUFFIX:'.html',

Modified: tajo/site/docs/current/searchindex.js
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/searchindex.js?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/searchindex.js (original)
+++ tajo/site/docs/current/searchindex.js Thu Oct  2 00:36:30 2014
@@ -1 +1 @@
-Search.setIndex({envversion:42,terms:{represent:[32,14],all:[37,12,36,2,38,3,6,7,25,43,20],code:[3,23],dist:[37,34,25],c_name:20,queri:[12,8,23],consum:32,month:14,four:39,scalar:32,concept:37,mno:43,follow:[3,5,7,8,11,12,34,15,16,17,18,19,24,25,28,30,32,20,36,37,38,39,42,43],disk:[3,8],row:[12,43,5,15,7,25,32,17],content:[9,30],privat:37,depend:[36,37,7],zone:19,getconnect:37,decim:19,init:43,program:[42,32],those:[15,32,37,5],sql_languag:12,emploi:13,digit:19,sourc:[12,23],string:[10,3,42,14],geoip_country_cod:3,fals:[19,32,3,7],"void":37,csvfile:[43,30,5],volum:[12,43],condit:6,veri:[2,38,7],affect:[25,8],hdfs_locat:15,exact:19,dbname:12,tri:37,recordcompresswrit:17,list:[12,43,38,16,7,18],hive:36,unquot:12,item:7,interfac:5,adjust:[15,24,32,8,5],plain:[15,17],println:37,tajo_src:34,tajo_hom:[37,12,2,38,42,43,25],dir:[38,11,8],pleas:[37,2,38,3,5,15,32,20,8,43],upper:35,templet:42,smaller:11,ten:[36,23],resourc:[40,38],shut:23,sign:7,enjoi:43,dowload:23,second:[35,25],cost:13,desi
 gn:[13,16,42,32],val3:12,val2:[7,12],val1:[7,12],port:[24,37,38,12,25],tmpdir:8,compat:8,index:9,abc:[7,43],addr:[3,25],compar:19,cast:[],section:[36,37,38,5,15,23,8],uncompress:[17,32],current:[24,12,36,37,28,39,7,25,32,8],c_phone:20,"19th":14,version:[12,25],decompress:[32,18],supplier:12,"new":12,method:20,metadata:15,elimin:30,hash:[],valn:7,gener:[12,5],o_totalpric:12,here:[2,7,43,17],let:17,address:[19,40,38,3,25],path:[24,12,36,37,3,30,25,43,20],o_orderprior:12,strong:20,sinc:15,valu:[24,12,36,38,3,42,8],convert:[3,45],aaabc:7,deterior:32,derbi:25,shift:14,larger:[19,32],table_backup:20,precis:19,datetim:10,codebas:18,implement:[9,2,12],commonli:5,sequencefil:[15,39],via:[38,23],regardless:[15,32],data_typ:30,jar:[36,37,25],modul:[9,42],filenam:12,unix:14,"boolean":[19,3,32],namenode_hostnam:24,wip:[25,18],instal:[3,25,34],total:8,u0001:5,select:[11,35,37,3,14,7,43],compatibl:20,from:[35,18,20,43,14],describ:[36,12],would:[36,34],distinct:6,two:[2,28,15,7,42,20,45,17],next:[3
 6,37],connector:[36,25],few:42,call:[],usr:25,compressiontyp:17,stage:43,type:[12,3,14,42,43,20,8,35],until:12,more:[36,43,38,7,25,32,23,8],flat:[15,17,32],discompress:34,hiveql:36,claus:[19,16,7,43],mismatch:9,hurt:13,function_nam:45,rootdir:38,name2:12,name3:12,name1:12,known:16,postgresql:7,unpack:23,must:[19,24,37,25,32],hyunsik:[12,20],word:[15,8,5],hour:14,alia:[19,6,35,14],setup:[],work:[19,12,32],timestamptz:19,dev:3,cat:[38,20,43],itself:12,can:[9,37,12,36,2,38,43,5,15,25,16,7,42,18,30,32,34,8,17],parquet:39,purpos:[36,42],root:38,def:43,bewtween:19,dayofweek:14,prompt:12,tab:5,tar:[37,34,25,18],give:[30,8],process:[12,13,5,15,16,32],share:[15,37],backslash:12,indic:12,tabular:5,liter:[42,5],want:[24,37,11,12,36,2,38,16,17,42,43,30,20,8,25],occur:[15,30,14],ratio:8,sundai:14,end:[35,18],goal:13,quot:12,str2:35,str1:35,mapr:17,how:[36,2,38,23,8],purg:30,env:[],c_address:20,instead:[12,43,7,5],csv:[43,30,12,20],config:[12,36,37,38,40,42,25,8],lazybinaryserd:17,blockcompresswr
 it:17,map:19,recogn:5,ltrim:35,clone:[25,18],after:34,resultset:37,concatnen:35,befor:38,catalog:1,mai:[42,14],multipl:[8,5],underscor:7,mariadb:25,data:38,parallel:38,physic:38,"short":15,third:[25,14],favorit:38,correspond:15,element:42,issu:[],inform:[12,25],preced:3,environ:[36,24,2,42,8],allow:[24,36,43,38,5,15,30,32,8],anoth:45,worst:13,order:[37,12,13,36,32,38,5,15,6,25,19,16,8,43],feed:5,help:12,classpath:[],move:34,midnight:14,becaus:5,comma:5,vari:19,dynam:13,paramet:[35,3,14,15,30,32,5],smallint:19,write:[15,32,17,5],style:7,group:[6,7,32],cli:12,overwrit:44,snappycodec:[15,30,17,5],defin:5,whole:8,persist:25,main:[13,37,7,42],non:32,"float":[43,5,15,16,17,32,19,8],"return":[35,14,7,3,5],thei:[15,7],handl:37,timestamp:[19,14],nio:[],col2:[11,7],col3:11,nation:12,framework:32,lzo:32,bar:5,binaryserializerdeseri:[15,17],utc_usec_to:14,nor:7,introduct:[],choic:32,hive_jdbc_driver_dir:[36,25],name:[24,12,36,37,38,3,43,5,15,40,6,17,42,32,19,20,8,25],anyth:12,simpl:[2,43],drop:
 [],regexp_replac:35,instruct:[36,3,18],separ:[17,5],easili:[37,38],mode:[],each:[38,12,42],clsspath:37,tajo_worker_heaps:8,side:[37,35],mean:7,compil:[36,34,25],domain:[38,7,5],replac:35,saturdai:14,procedur:34,"static":37,connect:[36,37,12,25],year:14,our:5,now:[12,34,15,32,5,20],special:5,out:[37,8,18],"try":[37,12],network:10,part:12,space:35,o_orderkei:12,xxtajo:35,profil:[36,25],hivemetastor:[36,25],math:10,qualifi:[15,5],advanc:13,manipul:12,differ:7,free:43,standard:[13,19,7,43],asc:6,standalon:23,jdbc:36,asf:[25,18],dictionari:32,org:[12,36,37,5,15,30,17,25,18],"byte":[19,43,12,32],fridai:14,card:16,care:5,wai:[20,5],launch:[],could:14,omit:15,moment:[32,5],filter:7,length:19,licens:12,mvn:[36,37,34,25],first:[35,23,34,42,14],oper:10,ieee:19,rang:28,directli:[16,5],resourceconfigur:8,feel:43,onc:[3,18],arrai:7,independ:32,applciat:37,number:[38,12],system:[37,13,2,38,15,42,34,8],o_com:12,o_orderd:12,legaci:3,done:34,"long":[13,14],tpch:[12,20],open:13,primari:24,given:[11,12
 ,3,30,7,43,19,35],script:[34,42],interact:[13,12,43],mkdir:[38,43],capac:[38,8],least:7,master:[38,12],too:32,statement:[11,12,37,43,5,15,30,7,32,17],l_partkei:[30,11],scheme:[24,43],"final":[36,37,25,43],store:[12,13,36,5,15,17,25,43,8],listen:[37,38],mysql_jdbc_driv:[36,25],option:[20,14,30,12,34],especi:19,namespac:37,copi:[25,42],inexact:19,specifi:[24,11,12,36,37,3,5,15,7,25,32,19,45,8,17],github:18,mostli:15,rtrim:35,exactli:7,than:[36,11,7,23],target:[37,11,34,25],keyword:17,provid:[37,12,13,2,3,28,5,15,7,25,32,43,39,8,17],remov:[30,35],tree:34,zero:7,charact:[35,5,15,16,7,19],project:[13,32],serd:[15,5],l_orderkei:[30,11],balanc:13,float8:[19,11,12,20],minut:[36,23],schema:[16,43,11,12,32],unix_timestamp:14,textserd:17,ran:25,arg:37,argument:14,download:[3,18],manner:37,have:[24,36,30,25,18,6],further:5,need:[37,36,2,5,15,17,25,32,20,43],maxmind:3,predic:[44,16],packag:[36,37],date:[19,20],techniqu:13,equival:11,partsupp:12,serde2:[15,17],click:18,note:[7,25],also:[12,43,5,1
 6,17,18,7],exampl:[38,20],take:[36,23,18],xxxxxx:25,prepar:[36,34,25,43],singl:[38,7,32],begin:[12,14],c_nationkei:20,distribut:[],preliminari:[],buffer:[21,32],price:16,choos:[34,18],compress:[],deflatecodec:30,most:[25,5],microsecond:14,plan:[13,16,5],unicod:19,phase:16,metacharact:7,"class":[36,37,5,15,7,25,17],don:[37,20,42],url:[24,37],doc:12,later:23,request:8,uri:25,ghi:43,bracket:7,snapshot:[34,25],classnotfoundexcept:37,determin:8,querymast:8,think:43,show:[37,12,43,23],text:[12,35,43,38,3,14,15,16,7,32,30,19,5,20,17],syntax:45,column_refer:7,protocol:21,ship_dat:16,xml:[38,12],absolut:43,onli:[24,25,2,28,14,15,17,42,18,32,5],explicitli:42,locat:[11,37,3,15,30,43,20,8],execut:[38,12,8,23],copyright:12,explain:[37,2,38,5,15,23],configur:12,apach:[23,3,12],state:43,haven:16,smallest:32,l_quantiti:11,local:[23,3,8,18],count:35,unresolvedaddressexcept:[],variou:12,get:[],familiar:[15,32,5],express:[44,35],repo:[25,18],cannot:5,java_hom:2,progress:13,increas:38,requir:[2,14],pru
 ne:[],item_nam:16,enabl:[37,38,5,15,25,32],termin:5,borrow:7,"public":37,remot:38,integr:[],partit:[],contain:[38,37,30],clean:[36,37,34,25],where:[2,38,16,7,43,19,8],bytea:19,set:12,knowledg:5,startup:12,memstor:25,see:[2,38,25,8,43],num:12,sec:[25,43],result:[9,37,43,32],respons:[13,43],float4:19,close:37,rlike:7,unqualifi:16,o_orderstatu:12,concern:[20,42],awar:8,parent:34,correctli:19,pattern:35,char_length:35,enough:25,score:[15,32,17,43,5],subdir:11,between:[37,7],"\u02c6ab":35,posix:7,neither:7,approach:20,c_custkei:20,altern:7,accord:19,kei:[12,28,15,30,17,16],hadoop_hom:[2,38],stmt:37,outfil:20,disconnect:12,addit:[37,11,7,8],both:[13,15,35,17,5],last:6,delimit:[43,30,35,5],fault:13,region:12,gzipcodec:30,c_comment:20,groupbi:[],against:23,instanc:[24,2,38,23],compressioncodec:[15,5],logic:7,mani:[15,37,8],com:[38,3],load:[13,43],simpli:34,point:15,overview:[],"4028235e":19,split_part:35,header:15,rpc:[40,37,38],written:[15,17],toler:13,respect:[19,7],tuesdai:14,guid:12,ass
 um:[16,8,43],o_clerk:12,quit:12,xzvf:[37,34,18],vertic:5,java:[21,36,2,42],compos:[16,32],empti:[15,5],json:5,much:8,besid:5,basic:20,templat:25,c_mktsegment:20,blob:19,derbystor:25,bit:19,exercis:23,xxx:12,worker:[],search:9,ani:[32,37,7,5],tajojdbccli:37,input:35,"catch":37,repetit:7,countri:3,present:23,"case":[35,37,15,7,42,25,17],bye:43,look:18,implementaion:24,geoip:3,servic:[40,25],properti:[24,36,38,3,40,42,8],batch:13,durat:25,hdf:[24,12,13,37,38,30,43,23,8],"while":37,uniqu:12,abov:[15,17,43],error:30,wild:16,vice:15,howev:32,lazybinarycolumnarserd:15,textserializerdeseri:[15,17,5],bin:[12,36,2,38,25,43,20],layer:24,file:[24,37,31,12,36,2,38,3,5,42,18,20,34,8,43],advantag:32,ctrl:[38,43],best:5,key1:12,tabl:[36,20,43,12,23],tbname:12,cluster:[],archiv:[34,25],warehous:[13,30],textfil:[],conf:[24,12,36,2,38,3,42,25,8],varchar:19,abcdef:35,primit:19,conn:37,"null":[37,6],develop:[9,18],"35b":43,grant:25,suggest:18,shorten:25,hadoop:[37,13,2,38,43,5,15,30,7,42,32,21,23,17],sa
 me:[36,14,3,7],binaryserd:17,binari:34,html:12,split:35,document:[12,18],higher:21,week:14,varbit:19,lineitem:[30,11,12],http:[40,18,3,25,12],hostnam:[24,37,38,12],optim:13,nest:32,driver:36,geoip_in_countri:3,dai:14,jkl:43,column_nam:30,retriv:37,dskiptest:[36,37,34,25],user:[24,12,8,43],tajo_classpath:25,improv:32,extern:[30,15,16,20,43],col1:[11,7],tsql:20,chang:[37,38,12,25,18],built:[15,37],lower:35,appropri:[42,43],lib:25,mention:15,entri:[38,30],well:[30,19,11],parenthes:7,inherit:[15,5],without:[13,16,5],command:20,thi:[9,23,37,25,36,32,38,43,14,7,42,18,20,5,34,8,17],filesystem:[23,18],gzip:32,model:44,usual:[42,5],explan:43,identifi:25,just:[20,7,25,12],percent:7,dtar:[36,37,34,25],tcp:12,q_1363768615503_0001_000001:43,drivermanag:37,mysql:[36,25],rest:18,simultan:8,yet:16,languag:[13,12,43],inet4:[19,3],web:13,snappi:32,all_backup:20,easi:[20,28],field:[35,5],disk1:8,disk2:8,disk3:8,except:[37,25],littl:38,add:[2,25,36,37,38,30,42,8],codec:[15,30,17,5],host2:38,host1:38,ba
 ckup_and_restor:12,work1:12,approxim:19,match:[19,35],build:23,table_nam:[30,20],march:14,which:[12,13,37,15,30,17,25,43],format:[31,5],read:[32,18,38,5],bzip2codec:30,workload:8,phcatalog:[36,25],chmod:38,step:34,createdatabaseifnotexist:25,password:25,desc:6,insert:44,storage_typ:30,table1:[37,43,5,15,7,32,17],resid:43,like:[24,37,16,34],specif:[19,24,11],substr:35,should:[24,12,36,37,38,3,5,15,16,25,32,30,20,23,8,43],reoptim:13,manual:15,integ:[19,8],server:[25,42],query_succeed:43,collect:17,benefit:28,api:[],necessari:13,either:[19,36,32,7,18],output:[11,17],timetz:19,tajo:20,page:[9,38,32],versa:15,order_d:16,carriag:5,createstat:37,"1st":14,some:[9,36,43,5,15,42,32,19,34],tajowork:[42,8],sequecnefil:17,intern:42,previou:7,"export":[36,2,25],mirror:18,proper:[24,34,8],small:[19,32],tmp:[24,43],scale:13,lead:[16,35],channel:[],"512mb":8,avoid:[13,30],exec:17,definit:44,per:[38,12,8],tracker:[40,38],unit:[25,32],bigint:[19,30],ddl:[20,43],lineitem_100_snappi:30,fornam:37,three:[
 17,25],localhost:[38,40,30,12,25],refer:[37,38,3,5,15,17,32,43],machin:[12,25],core:[37,8],who:5,run:[38,12],power:7,xtajoxx:35,ab_bc_cd:35,usag:20,hive_hom:[36,25],maven:[36,25],broken:5,host:[37,38,12,25],character_length:35,repositori:18,peer:40,regexp:7,rcfile:39,c_acctbal:20,comparison:[19,7],actual:9,datanod:8,column:[],varbinari:19,manag:[36,28],degre:38,regular:35,includ:[37,8],disabl:[15,32,5],"1gb":[24,8],block:[17,32],columnarserd:15,client:[40,38,12],own:5,effici:32,lastli:25,encod:32,lazybinari:17,due:8,down:[7,23],pair:[15,17,42],"import":37,storag:[24,5,15,17,25,32,20],your:[24,37,25,36,32,38,34,15,42,18,20,5,23],git:[],val:12,support:[24,20],submit:[23,43],custom:[12,20],avail:[37,8,32],start:[38,35],current_databas:12,arithmet:[],editor:38,o_custkei:12,ipv4:[19,3],across:38,"function":12,form:[15,24],untar:18,tajoxx:35,l_comment:30,int4:[19,11,12,35],link:18,select_stat:30,int2:19,line:[38,5],"true":[3,17,25,32,19,8,7],int8:[19,11,12,20],info:40,"throw":37,columnar:
 [15,32],consist:[15,17,42,5],possibl:8,whether:[15,7],ecosystem:32,access:[36,37,38,32],day_of_week:14,record:[15,32,7,17,5],below:[15,20,32,23,5],limit:[8,32],site:[38,12],otherwis:[12,3,7],executequeri:37,defaultport:25,trim:35,featur:[15,36,32,5],creat:[20,43,38,12,23],btrim:35,"int":[35,43,14,15,16,17,32,19,5],certain:[15,32,11,5],dure:16,repres:[14,5],"char":19,exist:[30,15,11,12],o_shipprior:12,home:[36,2,20,25,43],doe:[37,32,30,5],check:18,fill:37,denot:7,know:[38,43],when:[37,30,32,11,5],detail:[43,38,25,32],getstr:37,"default":[38,12],other:[11,13,5,15,42,8],bool:19,rdbm:37,branch:9,varieti:42,test:[12,25],you:[2,3,5,7,14,8,11,12,34,23,15,16,17,18,24,25,30,32,20,36,37,38,42,43],node:[37,38,8],relat:32,database_nam:[30,12],umbil:[40,38],customserializerdeseri:5,sequenc:7,insensit:7,tajomast:[38,12,42],src:[37,18],algorithm:[15,32,8,5],trail:35,directori:[],descript:[12,40,7,25,43,19,8],tajo_master_heaps:24,tinyint:19,ignor:8,time:[13,19,43,7,12],pdist:[36,37,34,25],backward:
 8,cpu:8,unset:12,tajodriv:37},objtypes:{"0":"py:function"},objnames:{"0":["py","function","Python function"]},filenames:["partitioning/hash_partitioning","backup_and_restore","getting_started/local_setup","functions/network_func_and_operators","partitioning/range_partitioning","table_management/csv","sql_language/queries","sql_language/predicates","configuration/worker_configuration","index","functions","sql_language/insert","cli","introduction","functions/datetime_func_and_operators","table_management/rcfile","partitioning/column_partitioning","table_management/sequencefile","getting_started/downloading_source","sql_language/data_model","backup_and_restore/catalog","getting_started/prerequisites","functions/math_func_and_operators","getting_started","configuration/tajo_master_configuration","configuration/catalog_configuration","table_management/compression","faq","partitioning/intro_to_partitioning","table_partitioning","sql_language/ddl","table_management","table_management/parqu
 et","configuration","getting_started/building","functions/string_func_and_operators","hcatalog_integration","jdbc_driver","configuration/cluster_setup","table_management/file_formats","configuration/configuration_defaults","tajo_client_api","configuration/preliminary","getting_started/first_query","sql_language","sql_language/sql_expression"],titles:["Hash Partitioning","Backup and Restore","Setting up a local Tajo cluster","Network Functions and Operators","Range Partitioning","CSV (TextFile)","Queries","Predicates","Worker Configuration","Apache Tajo\u2122 (dev) - User documentation","Functions","INSERT (OVERWRITE) INTO","Tajo Shell (TSQL)","Introduction","DateTime Functions and Operators","RCFile","Column Partitioning","SequenceFile","Dowload and unpack the source code of Apache Tajo","Data Model","Backup and Restore Catalog","Prerequisites","Math Functions and Operators","Getting Started","Tajo Master Configuration","Catalog Configuration","Compression","FAQ","Introduction to Pa
 rtitioning","Table Partitioning","Data Definition Language","Table Management","Parquet","Configuration","Build source code","String Functions and Operators","HCatalog Integration","Tajo JDBC Driver","Cluster Setup","File Formats","Configuration Defaults","Tajo Client API","Preliminary","First query execution","SQL Language","SQL Expressions"],objects:{"":{trim:[35,0,1,""],upper:[35,0,1,""],lower:[35,0,1,""],ltrim:[35,0,1,""],btrim:[35,0,1,""],regexp_replace:[35,0,1,""],split_part:[35,0,1,""],char_length:[35,0,1,""],geoip_country_code:[3,0,1,""],rtrim:[35,0,1,""],utc_usec_to:[14,0,1,""],geoip_in_country:[3,0,1,""]}},titleterms:{code:[37,34,18],execut:43,queri:[6,43],session:12,permiss:38,hcatalogstor:25,languag:[44,30],xml:42,call:45,writer:17,apach:[9,18,5,15,16,32],configur:[24,33,40,8,25],binari:37,local:2,match:7,real:19,sourc:[37,34,18],synopsi:12,string:[7,45,35],get:[37,23,18],handl:5,faq:[27,37],insert:11,introduct:[13,28],mysqlstor:25,csv:5,like:7,level:20,drop:30,list:6,hi
 ve:[15,32,16,5],integr:36,partit:[0,29,16,28,4],each:8,fulli:38,tajo:[9,24,37,12,2,38,15,40,41,42,18],manag:31,set:[38,2,37],hcatalog:36,dump:20,dowload:18,meta:12,run:8,todo:[0,22,26,27,4,41,20],nio:37,variabl:12,network:3,databas:[30,20],preliminari:42,definit:30,pattern:7,method:28,math:22,mode:[38,8],hash:0,compress:[26,30],gener:15,usag:12,serializerdeseri:17,base:38,prerequisit:[21,3],releas:18,java:37,rcfile:15,valu:[19,5],launch:38,column:16,where:6,groupbi:6,datetim:14,backup:[1,20],first:43,oper:[22,35,3,14],rang:4,via:18,overview:6,format:39,sql:[44,20,45],number:[19,8],api:41,select:6,size:[24,8],git:18,from:[37,6],memori:[24,8],data:[19,30,8],support:3,doubl:19,overwrit:11,custom:5,start:23,master:[24,40],basic:12,arithmet:45,type:[19,45],"function":[22,10,35,3,14,45],shell:12,claus:6,worker:[40,38,8],rootdir:24,heap:[24,8],jdbc:37,unpack:18,prune:16,restor:[1,20],"default":40,setup:38,properti:[15,32,5],maximum:8,dev:9,cast:45,serd:17,introduc:17,parquet:32,similar:7,c
 reat:[30,15,32,16,5],site:42,indic:9,cluster:[2,38],unresolvedaddressexcept:37,textfil:5,file:39,tabl:[9,5,15,29,16,31,32,30],dedic:8,"null":5,serial:[15,5],make:38,ilik:7,when:15,how:[37,15,32,16,5],client:[37,41],read:15,build:[37,34],env:42,document:9,channel:37,compat:[15,32,16,5],express:[7,45],resourc:8,distribut:[37,38],classpath:37,driver:37,catalog:[20,42,25],regular:7,temporari:8,user:9,tajomast:24,tsql:12,parallel:8,physic:[15,32,5],task:8,directori:[38,8],predic:7,issu:[15,32,16,5],exampl:[37,8],command:12,enter:12,model:19,sequencefil:17,mariadbstor:25,latest:18}})
\ No newline at end of file
+Search.setIndex({envversion:42,terms:{represent:[33,15],all:[38,12,37,2,39,3,29,6,7,43,44,35],code:[3,43,23],dist:[38,14,43],c_name:35,rdbm:38,queri:[29,43,12,8,23],consum:33,concern:[35,25],month:15,four:40,scalar:[6,33],concept:38,per:[29,39,12,8],boolean_express:6,mno:44,follow:[3,5,6,7,8,11,12,35,16,17,18,19,20,24,25,28,29,31,33,14,37,38,39,40,43,44],disk:[3,8],row:[12,33,5,16,6,7,43,44,18],profil:[37,43],privat:38,depend:[37,38,7],c_acctbal:35,zone:20,git:43,getconnect:38,decim:20,init:44,hadmin:29,present:23,sql_languag:12,backup_and_restor:12,"case":[25,36,38,16,7,43,18],digit:20,sourc:[12,43,23],everi:[29,6],string:[10,3,25,15],fals:[20,33,3,7],"void":38,csvfile:[44,31,5],volum:[12,44],failur:29,veri:[2,39,7],affect:[43,8],implicitli:6,hdfs_locat:16,exact:20,dbname:12,tri:38,recordcompresswrit:18,implementaion:24,list:[12,44,39,29,17,7,19,6],hive:[9,37,43],"try":[29,38,12],item:7,adjust:[16,24,33,8,5],form:[16,24,6],cosin:22,vertic:5,dealt:6,println:38,div:22,tajo_src:14,loc
 at:[11,38,3,16,31,44,35,8],tajo_hom:[25,38,12,2,39,29,43,44],dir:[39,11,8],pleas:[38,2,39,3,5,16,6,44,33,35,8],prevent:29,templet:25,smaller:11,abil:29,ten:[37,23],natur:6,sign:[22,7],enjoi:44,dowload:23,second:[29,36,43],cost:13,design:[13,17,25,33],aggreg:6,pass:6,val3:12,val2:[7,12],val1:[7,12],durat:43,port:[24,12,38,39,29,43],tmpdir:8,integr:43,compat:[9,43,8],asin:22,abc:[7,44],addr:[3,43],compar:20,cast:9,section:[37,38,39,5,16,23,8],xtajoxx:36,calcul:6,access:[37,38,39,33],c_phone:35,"19th":15,version:[12,43,14],directori:43,supplier:12,"new":[29,12],fall:6,method:[9,35],metadata:16,ongo:29,elimin:[31,6],full:6,hash:9,deriv:6,gener:[29,12,5],never:29,o_totalpric:12,here:[2,7,44,18],tangent:22,address:[39,3,29,41,43,20],path:[24,12,37,38,3,31,43,44,35],o_orderprior:12,sine:22,sinc:16,valu:[22,25,24,12,37,39,3,29,43,8],wait:29,convert:[22,29,3,46],aaabc:7,deterior:33,convers:22,derbi:[29,43],shift:15,larger:[20,6,33],table_backup:35,precis:20,datetim:10,behav:6,codebas:19,impl
 ement:[9,2,12],ghi:44,commonli:5,sequencefil:[9,40,16],dayofweek:15,via:[29,39,23],regardless:[16,33],data_typ:31,cbrt:22,transit:29,filenam:12,unix:15,"boolean":[20,6,3,33],namenode_hostnam:24,wip:[43,19],instal:[3,43,14],total:[6,8],unit:[43,33],highli:14,from:[22,9,36,44,15,29,19,35],describ:[37,12],would:[37,14],memori:43,distinct:6,two:[2,28,16,7,25,35,46,18],next:[37,38],connector:[37,43],few:25,program:[25,33],call:[9,6],usr:43,recommend:14,type:[22,9,12,3,15,25,44,35,8,36],until:12,tajo_pid_dir:29,more:[37,33,39,6,7,43,44,23,8],sort:6,flat:[16,18,33],discompress:14,l_quantiti:[11,6],hiveql:37,claus:[9,44,17,7,20],mismatch:9,tbname:12,function_nam:46,rootdir:39,name2:12,name3:12,name1:12,known:17,postgresql:7,editor:[29,39],unpack:23,must:[24,38,29,6,43,33,20],tabular:5,word:[16,8,5],hour:15,formatha:29,alia:[20,6,36,15],setup:34,work:[20,12,33],uniqu:12,dev:3,cat:[29,39,35,44],orderbi:9,archiv:[14,43],can:[9,38,12,25,29,37,2,39,44,5,16,6,7,43,19,31,17,33,14,8,18],parquet:[9,
 40],purpos:[37,25],root:[22,39],def:44,bewtween:20,control:29,nearest:22,prompt:12,num1:22,tar:[38,14,43,19],give:[31,6,8],process:[12,13,5,16,17,33],share:[16,38,6],backslash:12,indic:12,high:34,liter:[25,5],want:[25,24,38,11,12,37,2,39,29,17,18,43,44,31,35,8],tarbal:29,tan:22,occur:[31,16,6,15],timestamptz:20,unresolvedaddressexcept:9,sundai:15,multipl:[29,6,8,5],goal:13,quot:12,haadmin:29,str1:36,hdf:[24,12,13,38,39,31,44,23,8],divis:22,how:[9,37,2,39,23,8],purg:31,env:[29,43],c_address:35,main:[13,38,7,25],instead:[12,44,7,5],csv:[9,44,31,12,35],config:[25,12,37,38,39,41,43,8],sin:22,blockcompresswrit:18,updat:29,transitiontoact:29,product:6,resourc:[29,41,39],ltrim:36,atan:22,clone:[43,19],after:[6,14],resultset:38,concatnen:36,befor:[29,6,39],catalog:1,o_com:12,end:[36,19],underscor:7,mariadb:43,data:39,parallel:39,physic:39,tajo_worker_heaps:8,github:19,essenti:29,third:[43,15],read:[33,19,39,5],divid:[22,6],favorit:[29,39],correspond:[16,6],element:[29,25],issu:9,inform:[29,
 12,43],preced:3,environ:[25,24,2,37,8],block:[18,33],allow:[24,37,33,39,5,16,31,44,6,8],anoth:[29,46],worst:13,order:[12,13,37,38,39,5,16,6,43,20,17,33,8,44],oper:[29,10],help:12,shorten:43,over:6,move:14,midnight:15,becaus:[29,6,5],comma:[6,5],same:[22,37,3,15,29,6,7],still:29,vari:20,dynam:13,entiti:29,smallint:20,mapr:18,style:7,outer:6,cli:12,window:9,html:12,persist:43,therefor:29,split:36,them:6,within:6,"return":[22,36,3,15,7,5],greater:22,thei:[16,7,29],handl:38,timestamp:[20,15],"1gb":[24,8],col2:[11,7],col3:11,initi:29,nation:12,framework:33,lzo:33,abscissa:22,item_nam:17,now:[12,14,16,33,5,35],utc_usec_to:15,nor:7,introduct:9,choic:33,subqueri:6,hive_jdbc_driver_dir:[37,43],name:[25,24,12,29,37,38,39,3,5,16,41,6,18,43,44,20,33,35,8],anyth:12,simpl:[2,44],drop:9,regexp_replac:36,o_orderd:12,lazybinaryserd:18,separ:[6,18,5],easili:[29,38,39],submit:[29,23,44],mode:43,each:[39,12,25],clsspath:38,complet:29,compatibl:35,side:[38,36],truncat:22,mean:7,compil:[37,14,43],failov:
 29,domain:[29,39,7,5],map:20,unequ:29,individu:6,saturdai:15,procedur:14,group:[6,7,33],resut:22,"static":38,connect:[37,38,12,43],year:[6,15],recogn:5,special:5,out:[38,8,19],unquot:12,network:10,space:36,develop:[9,19],o_orderkei:12,xxtajo:36,content:[9,31],hivemetastor:[37,43],current:[24,12,37,38,28,40,29,6,7,43,33,8],math:10,statist:29,shut:23,advanc:[13,6],lastli:43,manipul:12,given:[11,12,44,3,31,7,20,6,36],free:44,standard:[13,20,7,44],asc:6,small:[20,33],cartesian:6,asf:[43,19],dictionari:33,usual:[25,5],org:[12,37,38,5,16,31,18,43,19],"byte":[20,33,12,44],fridai:15,refer:[38,39,3,5,16,6,18,44,33],card:17,care:5,str2:36,val:12,launch:43,angl:22,could:15,omit:[16,6],retriv:38,round:22,filter:[6,7],length:20,rcfile:[9,40],standbi:29,umbil:[29,41,39],interact:[13,12,44],mvn:[37,38,14,43],first:[36,23,25,15,14,43],feed:5,rang:[9,28],directli:[17,5],resourceconfigur:8,feel:44,onc:[6,3,19],arrai:7,independ:33,applciat:38,number:[39,12],capac:[39,8],mai:[29,6,14,25,15],instruct:[3
 7,3,19],set:[12,43],done:14,unhealthi:29,tpch:[12,35],open:13,primari:[29,24],differ:[6,7],"long":[13,6,15],script:[14,25],licens:12,mkdir:[39,44],system:[38,29,13,2,39,16,25,14,8],least:[6,7],getstat:29,master:[34,39,12,43],too:33,statement:[11,12,38,5,16,6,7,44,31,33,18],l_partkei:[31,11,6],scheme:[24,44],"final":[37,38,43,44],store:[12,13,37,5,16,18,43,44,8],listen:[38,39],mysql_jdbc_driv:[37,43],option:[12,14,31,6,15,35],especi:20,namespac:38,copi:[25,43],inexact:20,grouping_column_refer:6,hurt:13,"short":[16,6],enclos:6,mostli:16,rtrim:36,standalon:23,exactli:7,geoip_country_cod:3,serv:29,kind:6,target:[22,11,38,29,43,14],keyword:[6,18],provid:[38,12,29,13,2,3,28,5,16,7,43,44,33,40,8,18],expr:6,remov:[31,36],tree:14,long_table_name_1234:6,charact:[36,5,16,17,7,20],project:[13,33],serd:[16,5],num:[6,12],posix:7,balanc:13,becom:29,entri:[29,31,39],sec:[43,44],minut:[37,23],schema:[17,33,11,12,44],comput:6,abov:[16,18,44],textserd:18,ran:43,respons:[13,44],ani:[38,5,29,6,7,33],dow
 nload:[3,19],manner:38,have:[9,24,37,31,43,19],further:5,need:[38,29,37,2,5,16,18,43,44,33,35],maxmind:3,"import":38,predic:[9,17,45],tajocli:29,date:[20,35],squar:22,equival:[11,6],partsupp:12,click:19,note:[7,43],also:[12,44,5,29,17,7,19,6,18],without:[13,17,6,5],take:[37,6,23,19],xxxxxx:43,techniqu:13,combin:6,subject:6,prepar:[37,14,43,44],singl:[29,39,7,33],even:29,begin:[12,15],c_nationkei:35,distribut:43,preliminari:34,buffer:[21,33],price:17,filesystem:[23,19],compress:9,deflatecodec:31,most:[43,5],microsecond:15,specifi:[24,11,12,37,38,3,5,16,46,6,7,43,33,20,14,8,18],arithmet:[9,6],phase:17,metacharact:7,"class":[37,38,5,16,7,43,18],dai:15,appear:6,other:[11,13,5,16,6,25,8],don:[38,35,25,14],url:[24,38],doc:12,later:23,request:8,uri:[29,43],quantiti:6,salari:6,part:12,snapshot:[14,43],classnotfoundexcept:38,determin:[6,8],pattern:[9,36],querymast:8,axi:22,sum:6,think:44,show:[38,12,44,23],text:[12,36,29,44,39,3,15,16,17,7,20,31,33,5,35,18],hostnam:[24,38,39,12],syntax:[6,46
 ],column_refer:7,l_discount:6,identifi:[6,43],ship_dat:17,find:29,xml:[29,39,12,43],absolut:[22,44],onli:[24,25,2,28,15,16,6,18,43,19,33,5],explicitli:[6,25],ratio:8,just:[12,29,6,7,43,35],copyright:12,explain:[2,38,39,5,16,6,23],configur:12,jar:[37,38,43],enough:43,than:[22,11,37,6,7,23],smallest:[22,33],central:29,templat:43,search_condit:6,local:[23,43,3,8,19],info:[29,41],cube:22,variou:12,get:43,familiar:[16,33,5],express:[9,36,45],stop:29,ceil:22,repo:[43,19],cannot:5,java_hom:2,progress:13,increas:39,requir:[2,6,15],prune:9,table_refer:6,bar:5,enabl:[29,38,39,5,16,43,33],termin:5,upper:36,borrow:7,"public":38,remot:39,common:6,partit:9,contain:[29,38,31,39],clean:[37,38,14,43],where:[9,2,39,17,7,44,20,8],bytea:20,dhadoop:14,legaci:3,frame:6,knowledg:5,startup:12,memstor:43,c_custkei:35,see:[2,39,43,8,44],arc:22,float8:[22,20,11,12,35],result:[9,38,29,6,33,44],arg:38,float4:20,close:38,rlike:7,unqualifi:[17,6],o_orderstatu:12,valn:7,awar:8,statu:29,kei:[12,28,16,31,18,17],corr
 ectli:[20,14],ieee:20,char_length:36,written:[16,18],score:[16,33,44,18,5],subdir:11,between:[38,7],"\u02c6ab":36,l_orderkei:[31,11,6],neither:7,paramet:[22,36,3,15,16,31,33,5],approach:35,across:[39,6],altern:7,accord:[20,6],parent:14,hadoop_hom:[2,39],snappi:33,stmt:38,outfil:35,disconnect:12,argument:[22,6,15],monitor:29,both:[36,13,5,16,6,18],last:6,delimit:[44,31,36,5],fault:13,region:12,gzipcodec:31,c_comment:35,groupbi:9,against:23,instanc:[24,2,39,23],compressioncodec:[16,5],logic:7,improv:33,whole:8,load:[13,44],simpli:14,point:[16,29],overview:9,format:[9,32,29,5],period:29,split_part:36,header:16,rpc:[29,41,38,39],featur:[16,37,33,5],non:[6,33],littl:39,shutdown:29,toler:13,respect:[20,7],tuesdai:15,guid:12,assum:[17,8,44],transitiontobackup:29,row_num:6,quit:12,xzvf:[38,14,19],strong:35,java:[9,25,37,2,43,21],compos:[17,33],empti:[16,6,5],compon:29,"int":[22,36,33,15,16,17,18,44,20,5],json:5,much:8,besid:5,basic:35,addit:[11,38,6,7,8],c_mktsegment:35,host2:[29,39],derbys
 tor:[29,43],o_custkei:12,remaind:22,exercis:23,num2:22,xxx:12,worker:34,search:9,apach:[23,3,43,12],tajojdbccli:38,coordin:22,zero:7,func:6,work1:12,"catch":38,repetit:7,countri:3,due:8,those:[16,33,38,5],emploi:13,bye:44,look:19,packag:[37,38],plain:[16,18],servic:[41,43],properti:[24,25,37,39,3,29,41,43,8],batch:13,rectangular:22,defin:5,"while":38,euler:22,behavior:6,error:31,wild:17,howev:33,lazybinarycolumnarserd:16,textserializerdeseri:[16,18,5],bin:[12,37,2,39,29,43,44,35],layer:24,file:[39,12,43,35],advantag:33,ctrl:[29,39,44],key1:12,tabl:[37,35,44,12,23],site:[29,39,12,43],activ:29,cluster:[34,43],itself:[29,12],warehous:[13,31],textfil:9,conf:[25,24,12,37,2,39,3,29,43,8],theta:22,mod:22,abcdef:36,primit:20,conn:38,tcp:12,"null":[38,6],let:18,"35b":44,grant:43,perform:6,suggest:19,belong:6,classpath:9,hadoop:[38,13,2,39,14,5,16,31,7,25,44,33,21,23,18],sqrt:22,binari:[9,14,43],complex:6,descend:6,largest:22,document:[12,19],dtar:[37,38,14,43],conflict:29,higher:21,week:15,v
 arbit:20,lineitem:[31,11,6,12],http:[12,3,29,41,43,19],nio:9,denot:7,optim:13,nest:33,driver:[9,37,43],geoip_in_countri:3,decompress:[33,19],jkl:44,column_nam:31,moment:[33,5],rais:22,dskiptest:[37,38,14,43],user:[24,12,29,43,44,8],tajo_classpath:43,mani:[16,38,8],extern:[31,16,17,35,44],catalogstor:29,col1:[11,7],tsql:35,typic:6,built:[16,38],lower:36,appropri:[25,44],lib:43,mention:16,com:[29,39,3],thu:14,floor:22,well:[31,11,20],parenthes:[6,7],inherit:[16,5],tinyint:20,exampl:[29,39,35],command:35,thi:[9,33,25,37,38,39,14,15,29,6,7,43,19,44,35,5,23,8,18],choos:[14,19],gzip:33,model:[9,45],createdatabaseifnotexist:43,left:6,explan:44,construct:6,protocol:21,execut:[29,39,12,8,23],less:22,when:[11,38,5,29,31,33,6],ordin:22,rest:[6,19],q_1363768615503_0001_000001:44,drivermanag:38,mysql:[37,43],simultan:8,yet:17,languag:[13,9,12,44],inet4:[20,3],web:13,binaryserializerdeseri:[16,18],all_backup:35,easi:[35,28],field:[36,5],disk1:8,disk2:8,disk3:8,except:[38,6,43],param:6,add:[38,25,
 37,2,39,29,31,43,8],codec:[16,31,18,5],blob:20,versa:16,pow:22,input:[22,36],expon:22,disrupt:29,modul:[9,25],match:[9,36,20],build:23,real:22,applic:6,varchar:20,which:[12,13,38,16,6,18,43,44,31],serde2:[16,18],preserv:29,untar:19,host1:[29,39],bzip2codec:31,"4028235e":20,workload:8,phcatalog:[37,43],chmod:39,lineitem_100_snappi:31,insert:[9,45,29],bit:20,password:43,desc:6,u0001:5,storage_typ:31,table1:[38,5,16,6,7,44,33,18],resid:44,like:[24,38,17,14],specif:[29,24,11,20],substr:[6,36],should:[24,33,12,37,38,39,3,5,16,17,43,44,31,35,23,8],reoptim:13,manual:16,integ:[22,20,8],server:[29,25,43],query_succeed:44,collect:18,benefit:28,api:9,necessari:13,either:[37,19,6,7,33,20],output:[11,6,18],timetz:20,tajo:35,page:[9,39,33],another_long_table_name_5678:6,geoip:3,right:6,order_d:17,createstat:38,interv:29,"1st":15,some:[9,37,33,5,16,6,25,44,20,14],back:29,tajowork:[29,25,8],sequecnefil:18,intern:25,previou:7,"export":[37,2,43],mirror:19,proper:[24,14,8],home:[37,2,35,43,44],march:1
 5,row_numb:6,tmp:[24,44],cnt:6,scale:13,tajo_master_heaps:24,lead:[17,36],channel:9,"512mb":8,avoid:[13,29,31],exec:18,definit:[9,45],best:5,alias_nam:6,tracker:[29,41,39],select:[22,11,36,38,3,15,6,7,44],bigint:[20,31],ddl:[35,44],condit:6,fornam:38,localhost:[12,39,29,41,31,43],radian:22,machin:[12,43],core:[38,8],who:5,run:[29,39,12],power:[22,7],uncompress:[18,33],ab_bc_cd:36,usag:35,pdist:[37,38,14,43],maven:[37,14,43],broken:5,step:14,atan2:22,character_length:36,repositori:19,peer:41,l_extendedpric:6,appli:29,unicod:20,stage:44,comparison:[20,7],actual:9,datanod:8,column:9,varbinari:20,aco:22,total2:6,manag:[9,37,28],degre:[22,39],regular:36,includ:[38,6,8],table_nam:[31,35],approxim:20,disabl:[16,33,5],hive_hom:[37,43],plan:[13,17,5],columnarserd:16,client:[9,12,39,29,41,43],own:5,effici:33,"float":[22,33,5,16,17,18,44,20,8],encod:33,lazybinari:18,automat:29,three:[18,43],down:[7,23],pair:[16,18,25],chang:[38,39,12,43,19],storag:[24,5,16,18,43,33,35],your:[24,25,29,37,38,39,
 14,23,16,43,19,33,5,35],jdbc:[9,37,43],wai:[29,35,5],support:[24,35,43],overwrit:[9,45,29],custom:[12,43,35],avail:34,start:[29,39,36],current_databas:12,interfac:5,inner:6,replac:36,unix_timestamp:15,ipv4:[20,3],"function":12,snappycodec:[16,31,18,5],forc:6,ascend:6,compressiontyp:18,tajoxx:36,l_comment:31,int4:[20,11,12,36],link:19,select_stat:31,int2:20,l_shipdat:6,line:[29,39,5],"true":[3,29,18,43,33,20,8,7],int8:[22,20,11,12,35],count:[6,36],"throw":38,columnar:[16,33],consist:[16,6,18,25,5],possibl:[6,8],whether:[16,6,7],ecosystem:33,vice:16,day_of_week:15,record:[16,33,7,18,5],below:[16,35,33,23,5],limit:[9,8],otherwis:[12,6,3,7],problem:29,executequeri:38,defaultport:43,trim:36,binaryserd:18,constant:22,creat:[9,12,39,23,43,44,35],btrim:36,host:[29,38,39,12,43],certain:[16,33,11,5],dure:17,repres:[15,5],"char":20,exist:[31,16,11,12],o_shipprior:12,our:5,doe:[31,33,38,6,5],check:19,fill:38,incorrect:29,tab:5,know:[39,6,44],sort_expr:6,index:9,percent:7,detail:[39,33,6,43,44],
 getstr:38,"default":[34,39,12,43],bracket:7,bool:20,o_clerk:12,branch:9,varieti:25,test:[12,43],you:[2,3,5,6,7,15,8,11,12,35,16,17,18,19,23,24,25,29,31,33,14,37,38,39,43,44],node:[29,38,39,8],polar:22,relat:[6,33],database_nam:[31,12],exp:22,customserializerdeseri:5,sequenc:7,briefli:6,insensit:7,tajomast:[34,39,12,43],src:[38,19],empsalari:6,haven:17,algorithm:[16,33,8,5],trail:36,hyunsik:[12,35],regexp:7,descript:[12,29,41,7,43,44,20,8],select_list:6,carriag:5,write:[16,33,18,5],ignor:8,invok:29,time:[13,20,44,7,12],backward:8,cpu:8,unset:12,tajodriv:38},objtypes:{"0":"py:function"},objnames:{"0":["py","function","Python function"]},filenames:["partitioning/hash_partitioning","backup_and_restore","getting_started/local_setup","functions/network_func_and_operators","partitioning/range_partitioning","table_management/csv","sql_language/queries","sql_language/predicates","configuration/worker_configuration","index","functions","sql_language/insert","cli","introduction","getting_start
 ed/building","functions/datetime_func_and_operators","table_management/rcfile","partitioning/column_partitioning","table_management/sequencefile","getting_started/downloading_source","sql_language/data_model","getting_started/prerequisites","functions/math_func_and_operators","getting_started","configuration/tajo_master_configuration","configuration/preliminary","table_management/compression","faq","partitioning/intro_to_partitioning","configuration/ha_configuration","table_partitioning","sql_language/ddl","table_management","table_management/parquet","configuration","backup_and_restore/catalog","functions/string_func_and_operators","hcatalog_integration","jdbc_driver","configuration/cluster_setup","table_management/file_formats","configuration/configuration_defaults","tajo_client_api","configuration/catalog_configuration","getting_started/first_query","sql_language","sql_language/sql_expression"],titles:["Hash Partitioning","Backup and Restore","Setting up a local Tajo cluster","Ne
 twork Functions and Operators","Range Partitioning","CSV (TextFile)","Queries","Predicates","Worker Configuration","Apache Tajo\u2122 (dev) - User documentation","Functions","INSERT (OVERWRITE) INTO","Tajo Shell (TSQL)","Introduction","Build source code","DateTime Functions and Operators","RCFile","Column Partitioning","SequenceFile","Dowload and unpack the source code of Apache Tajo","Data Model","Prerequisites","Math Functions and Operators","Getting Started","Tajo Master Configuration","Preliminary","Compression","FAQ","Introduction to Partitioning","High Availability for TajoMaster","Table Partitioning","Data Definition Language","Table Management","Parquet","Configuration","Backup and Restore Catalog","String Functions and Operators","HCatalog Integration","Tajo JDBC Driver","Cluster Setup","File Formats","Configuration Defaults","Tajo Client API","Catalog Configuration","First query execution","SQL Language","SQL Expressions"],objects:{"":{trim:[36,0,1,""],upper:[36,0,1,""],bt
 rim:[36,0,1,""],regexp_replace:[36,0,1,""],cbrt:[22,0,1,""],split_part:[36,0,1,""],sign:[22,0,1,""],geoip_country_code:[3,0,1,""],tan:[22,0,1,""],asin:[22,0,1,""],floor:[22,0,1,""],sqrt:[22,0,1,""],acos:[22,0,1,""],char_length:[36,0,1,""],abs:[22,0,1,""],degrees:[22,0,1,""],pow:[22,0,1,""],pi:[22,0,1,""],sin:[22,0,1,""],ltrim:[36,0,1,""],atan:[22,0,1,""],cos:[22,0,1,""],ceil:[22,0,1,""],rtrim:[36,0,1,""],utc_usec_to:[15,0,1,""],geoip_in_country:[3,0,1,""],mod:[22,0,1,""],lower:[36,0,1,""],radians:[22,0,1,""],atan2:[22,0,1,""],exp:[22,0,1,""],div:[22,0,1,""],round:[22,0,1,""]}},titleterms:{code:[38,14,19],execut:44,queri:[6,44],session:12,permiss:39,hcatalogstor:43,ilik:7,languag:[45,31],xml:25,how:[16,33,38,17,5],writer:18,apach:[9,19,5,16,17,33],window:6,local:2,match:7,real:20,sourc:[38,14,19],synopsi:12,string:[7,46,36],format:40,handl:5,faq:[27,38],insert:11,introduct:[13,28],mysqlstor:43,document:9,like:7,administr:29,level:35,drop:31,hive:[16,33,17,5],integr:37,partit:[0,30,17
 ,28,4],each:8,fulli:39,where:6,manag:32,set:[29,2,38,39],hcatalog:37,dump:35,dowload:19,meta:12,run:8,todo:[0,26,27,4,42,35],distribut:[38,39],variabl:12,network:3,cast:46,databas:[31,35],preliminari:25,definit:31,state:29,directori:[39,8],method:28,math:22,mode:[39,8],qualifi:6,hash:0,driver:38,gener:16,usag:12,serializerdeseri:18,base:39,prerequisit:[21,3],releas:19,from:[38,6],rcfile:16,valu:[20,5],launch:[29,39],via:19,tajo:[9,24,38,12,29,2,39,16,41,42,25,19],groupbi:6,datetim:15,backup:[29,1,35],first:44,oper:[22,36,3,15],rang:4,configur:[24,29,41,43,34,8],overview:6,tajomast:[29,24],number:[20,8],terminolog:29,api:42,size:[24,8],git:19,java:38,memori:[24,8],tsql:12,support:3,doubl:20,overwrit:11,custom:5,avail:29,start:23,call:46,basic:12,master:[29,24,41],type:[20,6,46],"function":[22,10,36,3,15,6,46],shell:12,claus:6,worker:[41,39,8],rootdir:24,heap:[24,8],jdbc:38,unpack:19,join:6,prune:17,restor:[1,35],"default":41,setup:39,properti:[16,33,5],maximum:8,dev:9,orderbi:6,colum
 n:17,serd:18,limit:6,introduc:18,parquet:33,similar:7,file:[29,40],creat:[31,16,33,17,5],site:25,indic:9,high:29,cluster:[29,2,39],unresolvedaddressexcept:38,textfil:5,have:6,tabl:[9,5,16,30,17,32,33,31,6],dedic:8,"null":5,serial:[16,5],issu:[16,33,17,5],make:39,get:[38,23,19],when:16,cross:6,binari:38,exampl:[38,6,8],build:[38,14],env:25,csv:5,channel:38,compat:[16,33,17,5],express:[7,46],resourc:8,nio:38,classpath:38,enter:12,compress:[26,31],catalog:[25,35,43],regular:7,temporari:8,user:9,sql:[45,35,46],data:[20,31,8],parallel:8,physic:[16,33,5],task:8,read:16,predic:7,arithmet:46,alias:6,client:[38,42],command:12,pattern:7,model:20,sequencefil:18,mariadbstor:43,latest:19}})
\ No newline at end of file

Modified: tajo/site/docs/current/sql_language.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language.html (original)
+++ tajo/site/docs/current/sql_language.html Thu Oct  2 00:36:30 2014
@@ -1,6 +1,5 @@
 
 
-
 <!DOCTYPE html>
 <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
 <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
@@ -211,7 +210,7 @@
 
     <script type="text/javascript">
         var DOCUMENTATION_OPTIONS = {
-            URL_ROOT:'',
+            URL_ROOT:'./',
             VERSION:'0.8.0',
             COLLAPSE_INDEX:false,
             FILE_SUFFIX:'.html',

Modified: tajo/site/docs/current/sql_language/data_model.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/data_model.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/data_model.html (original)
+++ tajo/site/docs/current/sql_language/data_model.html Thu Oct  2 00:36:30 2014
@@ -1,6 +1,5 @@
 
 
-
 <!DOCTYPE html>
 <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
 <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
@@ -177,7 +176,7 @@
 <col width="38%" />
 </colgroup>
 <thead valign="bottom">
-<tr class="row-odd"><th class="head">Supported</th>
+<tr class="row-odd"><th class="head">Support</th>
 <th class="head">SQL Type Name</th>
 <th class="head">Alias</th>
 <th class="head">Size (byte)</th>
@@ -298,14 +297,14 @@
 <td>variable-length binary string</td>
 <td>&nbsp;</td>
 </tr>
-<tr class="row-even"><td>&nbsp;</td>
+<tr class="row-even"><td>O</td>
 <td>date</td>
 <td>&nbsp;</td>
 <td>&nbsp;</td>
 <td>&nbsp;</td>
 <td>&nbsp;</td>
 </tr>
-<tr class="row-odd"><td>&nbsp;</td>
+<tr class="row-odd"><td>O</td>
 <td>time</td>
 <td>&nbsp;</td>
 <td>&nbsp;</td>
@@ -319,7 +318,7 @@
 <td>&nbsp;</td>
 <td>&nbsp;</td>
 </tr>
-<tr class="row-odd"><td>&nbsp;</td>
+<tr class="row-odd"><td>O</td>
 <td>timestamp</td>
 <td>&nbsp;</td>
 <td>&nbsp;</td>

Modified: tajo/site/docs/current/sql_language/ddl.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/ddl.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/ddl.html (original)
+++ tajo/site/docs/current/sql_language/ddl.html Thu Oct  2 00:36:30 2014
@@ -1,6 +1,5 @@
 
 
-
 <!DOCTYPE html>
 <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
 <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->

Modified: tajo/site/docs/current/sql_language/insert.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/insert.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/insert.html (original)
+++ tajo/site/docs/current/sql_language/insert.html Thu Oct  2 00:36:30 2014
@@ -1,6 +1,5 @@
 
 
-
 <!DOCTYPE html>
 <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
 <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->

Modified: tajo/site/docs/current/sql_language/predicates.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/predicates.html?rev=1628871&r1=1628870&r2=1628871&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/predicates.html (original)
+++ tajo/site/docs/current/sql_language/predicates.html Thu Oct  2 00:36:30 2014
@@ -1,6 +1,5 @@
 
 
-
 <!DOCTYPE html>
 <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
 <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
@@ -302,11 +301,12 @@
 </tbody>
 </table>
 <p>Here are examples:</p>
-<div class="highlight-sql"><pre>'abc'   ~   '.*c'               true
-'abc'   ~   'c'                 false
-'aaabc' ~   '([a-z]){3}bc       true
-'abc'   ~*  '.*C'               true
-'abc'   !~* 'B.*'               true</pre>
+<div class="highlight-sql"><div class="highlight"><pre>&#39;abc&#39;   ~   &#39;.*c&#39;               true
+&#39;abc&#39;   ~   &#39;c&#39;                 false
+&#39;aaabc&#39; ~   &#39;([a-z]){3}bc       true
+&#39;abc&#39;   ~*  &#39;.*C&#39;               true
+&#39;abc&#39;   !~* &#39;B.*&#39;               true
+</pre></div>
 </div>
 <p>Regular expressions operator is not in the SQL standard. We borrow this operator from PostgreSQL.</p>
 <p><em>Synopsis for REGEXP and RLIKE operators</em></p>