You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@tajo.apache.org by ji...@apache.org on 2016/05/19 02:00:27 UTC
svn commit: r1744489 [43/43] - in /tajo/site/docs: 0.11.3/ 0.11.3/_sources/
0.11.3/_sources/backup_and_restore/ 0.11.3/_sources/configuration/
0.11.3/_sources/functions/ 0.11.3/_sources/index/
0.11.3/_sources/partitioning/ 0.11.3/_sources/sql_language/...
Modified: tajo/site/docs/current/time_zone.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/time_zone.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/time_zone.html (original)
+++ tajo/site/docs/current/time_zone.html Thu May 19 02:00:25 2016
@@ -7,7 +7,7 @@
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Time Zone — Apache Tajo 0.11.0 documentation</title>
+ <title>Time Zone — Apache Tajo 0.11.3 documentation</title>
@@ -28,7 +28,7 @@
- <link rel="top" title="Apache Tajo 0.11.0 documentation" href="index.html"/>
+ <link rel="top" title="Apache Tajo 0.11.3 documentation" href="index.html"/>
<link rel="next" title="Functions" href="functions.html"/>
<link rel="prev" title="EXPLAIN" href="sql_language/explain.html"/>
@@ -208,7 +208,7 @@
<div class="section" id="time-zone">
<h1>Time Zone<a class="headerlink" href="#time-zone" title="Permalink to this headline">¶</a></h1>
-<p>Time zone affects some data types (e.g., <code class="docutils literal"><span class="pre">Timestamp</span></code> and <code class="docutils literal"><span class="pre">Time</span></code>) and operations (e.g., <code class="docutils literal"><span class="pre">to_char</span></code>). Tables can have different time zones. Internally, Tajo translates all table rows to UTC values and processes them. It becomes easier for Tajo to handle multiple different time zones.</p>
+<p>Time zone affects <tt class="docutils literal"><span class="pre">Timestamp</span></tt> data type and operations (e.g., <tt class="docutils literal"><span class="pre">to_char</span></tt>). Tables can have different time zones. Internally, Tajo translates all table rows to UTC values and processes them. It becomes easier for Tajo to handle multiple different time zones.</p>
<p>In Tajo, there are some time zong settings.</p>
<div class="section" id="server-cluster-time-zone">
<h2>Server Cluster Time Zone<a class="headerlink" href="#server-cluster-time-zone" title="Permalink to this headline">¶</a></h2>
@@ -222,8 +222,8 @@
</div>
<div class="section" id="table-time-zone">
<h2>Table Time Zone<a class="headerlink" href="#table-time-zone" title="Permalink to this headline">¶</a></h2>
-<p>In Tajo, a table property <code class="docutils literal"><span class="pre">timezone</span></code> allows users to specify a time zone that the table uses for reading or writing.
-When each table row are read or written, <code class="docutils literal"><span class="pre">`timestamp`</span></code> and <code class="docutils literal"><span class="pre">`time`</span></code> column values are adjusted by a given time zone if it is set.</p>
+<p>In Tajo, a table property <tt class="docutils literal"><span class="pre">timezone</span></tt> allows users to specify a time zone that the table uses for reading or writing.
+When each table row are read or written, <tt class="docutils literal"><span class="pre">`timestamp`</span></tt> column values are adjusted by a given time zone if it is set.</p>
<p>You can specify a table time zone as follows:</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">EXTERNAL</span> <span class="k">TABLE</span> <span class="n">table1</span> <span class="p">(</span>
<span class="n">t_timestamp</span> <span class="k">TIMESTAMP</span><span class="p">,</span>
@@ -235,13 +235,13 @@ When each table row are read or written,
</div>
<div class="section" id="client-time-zone">
<h2>Client Time Zone<a class="headerlink" href="#client-time-zone" title="Permalink to this headline">¶</a></h2>
-<p>Each client has its own time zone setting. It translates retrieved timestamp and time values by time zone. In order to set client time zone, you should set the session variable <code class="docutils literal"><span class="pre">TIMEZONE</span></code>. There are some ways to set this session variable.</p>
-<p>In <code class="docutils literal"><span class="pre">tsql</span></code>, you can use <code class="docutils literal"><span class="pre">\set</span> <span class="pre">timezone</span></code> meta command as follows:</p>
+<p>Each client has its own time zone setting. It translates retrieved timestamp and time values by time zone. In order to set client time zone, you should set the session variable <tt class="docutils literal"><span class="pre">TIMEZONE</span></tt>. There are some ways to set this session variable.</p>
+<p>In <tt class="docutils literal"><span class="pre">tsql</span></tt>, you can use <tt class="docutils literal"><span class="pre">\set</span> <span class="pre">timezone</span></tt> meta command as follows:</p>
<p><strong>tsql</strong></p>
<div class="highlight-sh"><div class="highlight"><pre>default> <span class="se">\s</span>et timezone GMT+9
</pre></div>
</div>
-<p>The following ways use SQL statements. So, this way is available in <code class="docutils literal"><span class="pre">tsql</span></code>, JDBC, and Tajo Java API.</p>
+<p>The following ways use SQL statements. So, this way is available in <tt class="docutils literal"><span class="pre">tsql</span></tt>, JDBC, and Tajo Java API.</p>
<p><strong>SQL</strong></p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">SET</span> <span class="n">TIME</span> <span class="k">ZONE</span> <span class="s1">'GMT+9'</span><span class="p">;</span>
@@ -265,20 +265,20 @@ When each table row are read or written,
</div>
<div class="section" id="examples-of-time-zone">
<h2>Examples of Time Zone<a class="headerlink" href="#examples-of-time-zone" title="Permalink to this headline">¶</a></h2>
-<p>For example, consider that there is a list of delimited text lines where each rows are written with <code class="docutils literal"><span class="pre">Asia/Seoul</span></code> time zone (i.e., GMT + 9).</p>
+<p>For example, consider that there is a list of delimited text lines where each rows are written with <tt class="docutils literal"><span class="pre">Asia/Seoul</span></tt> time zone (i.e., GMT + 9).</p>
<div class="highlight-text"><div class="highlight"><pre>1980-4-1 01:50:30.010|1980-04-01
80/4/1 1:50:30 AM|80/4/1
1980 April 1 1:50:30|1980-04-01
</pre></div>
</div>
-<p>In order to register the table, we should put a table property <code class="docutils literal"><span class="pre">'timezone'='Asia/Seoul'</span></code> in <code class="docutils literal"><span class="pre">CREATE</span> <span class="pre">TABLE</span></code> statement as follows:</p>
+<p>In order to register the table, we should put a table property <tt class="docutils literal"><span class="pre">'timezone'='Asia/Seoul'</span></tt> in <tt class="docutils literal"><span class="pre">CREATE</span> <span class="pre">TABLE</span></tt> statement as follows:</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">EXTERNAL</span> <span class="k">TABLE</span> <span class="n">table1</span> <span class="p">(</span>
<span class="n">t_timestamp</span> <span class="k">TIMESTAMP</span><span class="p">,</span>
<span class="n">t_date</span> <span class="nb">DATE</span>
<span class="p">)</span> <span class="k">USING</span> <span class="nb">TEXT</span> <span class="k">WITH</span><span class="p">(</span><span class="s1">'text.delimiter'</span><span class="o">=</span><span class="s1">'|'</span><span class="p">,</span> <span class="s1">'timezone'</span><span class="o">=</span><span class="s1">'ASIA/Seoul'</span><span class="p">)</span> <span class="k">LOCATION</span> <span class="s1">'/path-to-table/'</span>
</pre></div>
</div>
-<p>By default, <code class="docutils literal"><span class="pre">tsql</span></code> and <code class="docutils literal"><span class="pre">TajoClient</span></code> API use UTC time zone. So, timestamp values in the result are adjusted by the time zone offset. But, date is not adjusted because date type does not consider time zone.</p>
+<p>By default, <tt class="docutils literal"><span class="pre">tsql</span></tt> and <tt class="docutils literal"><span class="pre">TajoClient</span></tt> API use UTC time zone. So, timestamp values in the result are adjusted by the time zone offset. But, date is not adjusted because date type does not consider time zone.</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">default</span><span class="o">></span> <span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">table1</span>
<span class="n">t_timestamp</span><span class="p">,</span> <span class="n">t_date</span>
<span class="c1">----------------------------------</span>
@@ -318,7 +318,7 @@ When each table row are read or written,
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -338,7 +338,7 @@ When each table row are read or written,
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT:'./',
- VERSION:'0.11.0',
+ VERSION:'0.11.3',
COLLAPSE_INDEX:false,
FILE_SUFFIX:'.html',
HAS_SOURCE: true
Modified: tajo/site/docs/current/tsql.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/tsql.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/tsql.html (original)
+++ tajo/site/docs/current/tsql.html Thu May 19 02:00:25 2016
@@ -7,7 +7,7 @@
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Tajo Shell (TSQL) — Apache Tajo 0.11.0 documentation</title>
+ <title>Tajo Shell (TSQL) — Apache Tajo 0.11.3 documentation</title>
@@ -28,7 +28,7 @@
- <link rel="top" title="Apache Tajo 0.11.0 documentation" href="index.html"/>
+ <link rel="top" title="Apache Tajo 0.11.3 documentation" href="index.html"/>
<link rel="next" title="Meta Commands" href="tsql/meta_command.html"/>
<link rel="prev" title="The storage-site.json File" href="configuration/storage-site-json.html"/>
@@ -241,7 +241,7 @@
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -261,7 +261,7 @@
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT:'./',
- VERSION:'0.11.0',
+ VERSION:'0.11.3',
COLLAPSE_INDEX:false,
FILE_SUFFIX:'.html',
HAS_SOURCE: true
Modified: tajo/site/docs/current/tsql/admin_command.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/tsql/admin_command.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/tsql/admin_command.html (original)
+++ tajo/site/docs/current/tsql/admin_command.html Thu May 19 02:00:25 2016
@@ -7,7 +7,7 @@
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Administration Commands — Apache Tajo 0.11.0 documentation</title>
+ <title>Administration Commands — Apache Tajo 0.11.3 documentation</title>
@@ -28,7 +28,7 @@
- <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/>
+ <link rel="top" title="Apache Tajo 0.11.3 documentation" href="../index.html"/>
<link rel="up" title="Tajo Shell (TSQL)" href="../tsql.html"/>
<link rel="next" title="Introducing to TSQL" href="intro.html"/>
<link rel="prev" title="Session Variables" href="variables.html"/>
@@ -227,14 +227,14 @@ usage: admin [options]
</div>
<div class="section" id="basic-usages">
<h3>Basic usages<a class="headerlink" href="#basic-usages" title="Permalink to this headline">¶</a></h3>
-<p><code class="docutils literal"><span class="pre">-list</span></code> option shows a list of all running queries as follows:</p>
+<p><tt class="docutils literal"><span class="pre">-list</span></tt> option shows a list of all running queries as follows:</p>
<div class="highlight-python"><div class="highlight"><pre>default> \admin -list
QueryId State StartTime Query
-------------------- ------------------- ------------------- -----------------------------
q_1411357607375_0006 QUERY_RUNNING 2014-09-23 07:19:40 select count(*) from lineitem
</pre></div>
</div>
-<p><code class="docutils literal"><span class="pre">-desc</span></code> option shows a detailed description of a specified running query as follows:</p>
+<p><tt class="docutils literal"><span class="pre">-desc</span></tt> option shows a detailed description of a specified running query as follows:</p>
<div class="highlight-python"><div class="highlight"><pre>default> \admin -desc q_1411357607375_0006
Id: 1
Query Id: q_1411357607375_0006
@@ -246,12 +246,12 @@ Query Statement:
select count(*) from lineitem
</pre></div>
</div>
-<p><code class="docutils literal"><span class="pre">-kill</span></code> option kills a specified running query as follows:</p>
+<p><tt class="docutils literal"><span class="pre">-kill</span></tt> option kills a specified running query as follows:</p>
<div class="highlight-python"><div class="highlight"><pre>default> \admin -kill q_1411357607375_0007
q_1411357607375_0007 is killed successfully.
</pre></div>
</div>
-<p><code class="docutils literal"><span class="pre">-showmasters</span></code> option shows a list of all tajo masters as follows:</p>
+<p><tt class="docutils literal"><span class="pre">-showmasters</span></tt> option shows a list of all tajo masters as follows:</p>
<div class="highlight-python"><div class="highlight"><pre>default> \admin -showmasters
grtajo01
</pre></div>
@@ -278,7 +278,7 @@ grtajo01
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -298,7 +298,7 @@ grtajo01
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT:'../',
- VERSION:'0.11.0',
+ VERSION:'0.11.3',
COLLAPSE_INDEX:false,
FILE_SUFFIX:'.html',
HAS_SOURCE: true
Modified: tajo/site/docs/current/tsql/background_command.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/tsql/background_command.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/tsql/background_command.html (original)
+++ tajo/site/docs/current/tsql/background_command.html Thu May 19 02:00:25 2016
@@ -7,7 +7,7 @@
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Executing as background process — Apache Tajo 0.11.0 documentation</title>
+ <title>Executing as background process — Apache Tajo 0.11.3 documentation</title>
@@ -28,7 +28,7 @@
- <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/>
+ <link rel="top" title="Apache Tajo 0.11.3 documentation" href="../index.html"/>
<link rel="up" title="Tajo Shell (TSQL)" href="../tsql.html"/>
<link rel="next" title="SQL Language" href="../sql_language.html"/>
<link rel="prev" title="Executing Queries from Files" href="execute_file.html"/>
@@ -252,7 +252,7 @@ $
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -272,7 +272,7 @@ $
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT:'../',
- VERSION:'0.11.0',
+ VERSION:'0.11.3',
COLLAPSE_INDEX:false,
FILE_SUFFIX:'.html',
HAS_SOURCE: true
Modified: tajo/site/docs/current/tsql/dfs_command.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/tsql/dfs_command.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/tsql/dfs_command.html (original)
+++ tajo/site/docs/current/tsql/dfs_command.html Thu May 19 02:00:25 2016
@@ -7,7 +7,7 @@
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Executing HDFS commands — Apache Tajo 0.11.0 documentation</title>
+ <title>Executing HDFS commands — Apache Tajo 0.11.3 documentation</title>
@@ -28,7 +28,7 @@
- <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/>
+ <link rel="top" title="Apache Tajo 0.11.3 documentation" href="../index.html"/>
<link rel="up" title="Tajo Shell (TSQL)" href="../tsql.html"/>
<link rel="next" title="Session Variables" href="variables.html"/>
<link rel="prev" title="Meta Commands" href="meta_command.html"/>
@@ -211,7 +211,7 @@
<div class="section" id="executing-hdfs-commands">
<h1>Executing HDFS commands<a class="headerlink" href="#executing-hdfs-commands" title="Permalink to this headline">¶</a></h1>
-<p>You can run the hadoop dfs command (FsShell) within tsql. <code class="docutils literal"><span class="pre">\dfs</span></code> command provides a shortcut to the hadoop dfs commands. If you want to use this command, just specify FsShell arguments and add the semicolon at the end as follows:</p>
+<p>You can run the hadoop dfs command (FsShell) within tsql. <tt class="docutils literal"><span class="pre">\dfs</span></tt> command provides a shortcut to the hadoop dfs commands. If you want to use this command, just specify FsShell arguments and add the semicolon at the end as follows:</p>
<div class="highlight-sql"><div class="highlight"><pre>default> \dfs -ls /
Found 3 items
drwxr-xr-x - tajo supergroup 0 2014-08-14 04:04 /tajo
@@ -252,7 +252,7 @@ drwxr-xr-x - tajo supergroup
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -272,7 +272,7 @@ drwxr-xr-x - tajo supergroup
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT:'../',
- VERSION:'0.11.0',
+ VERSION:'0.11.3',
COLLAPSE_INDEX:false,
FILE_SUFFIX:'.html',
HAS_SOURCE: true
Modified: tajo/site/docs/current/tsql/execute_file.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/tsql/execute_file.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/tsql/execute_file.html (original)
+++ tajo/site/docs/current/tsql/execute_file.html Thu May 19 02:00:25 2016
@@ -7,7 +7,7 @@
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Executing Queries from Files — Apache Tajo 0.11.0 documentation</title>
+ <title>Executing Queries from Files — Apache Tajo 0.11.3 documentation</title>
@@ -28,7 +28,7 @@
- <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/>
+ <link rel="top" title="Apache Tajo 0.11.3 documentation" href="../index.html"/>
<link rel="up" title="Tajo Shell (TSQL)" href="../tsql.html"/>
<link rel="next" title="Executing as background process" href="background_command.html"/>
<link rel="prev" title="Executing a single command" href="single_command.html"/>
@@ -213,7 +213,7 @@
<h1>Executing Queries from Files<a class="headerlink" href="#executing-queries-from-files" title="Permalink to this headline">¶</a></h1>
<div class="section" id="basic-usages">
<h2>Basic usages<a class="headerlink" href="#basic-usages" title="Permalink to this headline">¶</a></h2>
-<p><code class="docutils literal"><span class="pre">-f</span></code> command allows tsql to execute more than one SQL statements stored in a text file as follows:</p>
+<p><tt class="docutils literal"><span class="pre">-f</span></tt> command allows tsql to execute more than one SQL statements stored in a text file as follows:</p>
<div class="highlight-sql"><div class="highlight"><pre>$ cat aggregation.sql
select count(*) from table1;
select sum(score) from table1;
@@ -278,7 +278,7 @@ Progress: 100%, response time: 0.331 sec
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -298,7 +298,7 @@ Progress: 100%, response time: 0.331 sec
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT:'../',
- VERSION:'0.11.0',
+ VERSION:'0.11.3',
COLLAPSE_INDEX:false,
FILE_SUFFIX:'.html',
HAS_SOURCE: true
Modified: tajo/site/docs/current/tsql/intro.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/tsql/intro.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/tsql/intro.html (original)
+++ tajo/site/docs/current/tsql/intro.html Thu May 19 02:00:25 2016
@@ -7,7 +7,7 @@
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Introducing to TSQL — Apache Tajo 0.11.0 documentation</title>
+ <title>Introducing to TSQL — Apache Tajo 0.11.3 documentation</title>
@@ -28,7 +28,7 @@
- <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/>
+ <link rel="top" title="Apache Tajo 0.11.3 documentation" href="../index.html"/>
<link rel="up" title="Tajo Shell (TSQL)" href="../tsql.html"/>
<link rel="next" title="Executing a single command" href="single_command.html"/>
<link rel="prev" title="Administration Commands" href="admin_command.html"/>
@@ -216,16 +216,16 @@
<div class="highlight-bash"><div class="highlight"><pre>bin/tsql <span class="o">[</span>options<span class="o">]</span> <span class="o">[</span>database name<span class="o">]</span>
</pre></div>
</div>
-<p>If a <em>database_name</em> is given, tsql connects to the database at startup time. Otherwise, tsql connects to <code class="docutils literal"><span class="pre">default</span></code> database.</p>
+<p>If a <em>database_name</em> is given, tsql connects to the database at startup time. Otherwise, tsql connects to <tt class="docutils literal"><span class="pre">default</span></tt> database.</p>
<p>Options</p>
<ul class="simple">
-<li><code class="docutils literal"><span class="pre">-c</span> <span class="pre">"quoted</span> <span class="pre">sql"</span></code> : Execute quoted sql statements, and then the shell will exist.</li>
-<li><code class="docutils literal"><span class="pre">-f</span> <span class="pre">filename</span> <span class="pre">(--file</span> <span class="pre">filename)</span></code> : Use the file named filename as the source of commands instead of interactive shell.</li>
-<li><code class="docutils literal"><span class="pre">-h</span> <span class="pre">hostname</span> <span class="pre">(--host</span> <span class="pre">hostname)</span></code> : Specifies the host name of the machine on which the Tajo master is running.</li>
-<li><code class="docutils literal"><span class="pre">-p</span> <span class="pre">port</span> <span class="pre">(--port</span> <span class="pre">port)</span></code> : Specifies the TCP port. If it is not set, the port will be 26002 by default.</li>
-<li><code class="docutils literal"><span class="pre">-conf</span> <span class="pre">configuration</span> <span class="pre">(--conf</span> <span class="pre">configuration)</span></code> : Setting Tajo configuration value.</li>
-<li><code class="docutils literal"><span class="pre">-param</span> <span class="pre">parameter</span> <span class="pre">(--param</span> <span class="pre">parameter)</span></code> : Use a parameter value in SQL file.</li>
-<li><code class="docutils literal"><span class="pre">-B</span> <span class="pre">(--background)</span></code> : Execute as background process.</li>
+<li><tt class="docutils literal"><span class="pre">-c</span> <span class="pre">"quoted</span> <span class="pre">sql"</span></tt> : Execute quoted sql statements, and then the shell will exist.</li>
+<li><tt class="docutils literal"><span class="pre">-f</span> <span class="pre">filename</span> <span class="pre">(--file</span> <span class="pre">filename)</span></tt> : Use the file named filename as the source of commands instead of interactive shell.</li>
+<li><tt class="docutils literal"><span class="pre">-h</span> <span class="pre">hostname</span> <span class="pre">(--host</span> <span class="pre">hostname)</span></tt> : Specifies the host name of the machine on which the Tajo master is running.</li>
+<li><tt class="docutils literal"><span class="pre">-p</span> <span class="pre">port</span> <span class="pre">(--port</span> <span class="pre">port)</span></tt> : Specifies the TCP port. If it is not set, the port will be 26002 by default.</li>
+<li><tt class="docutils literal"><span class="pre">-conf</span> <span class="pre">configuration</span> <span class="pre">(--conf</span> <span class="pre">configuration)</span></tt> : Setting Tajo configuration value.</li>
+<li><tt class="docutils literal"><span class="pre">-param</span> <span class="pre">parameter</span> <span class="pre">(--param</span> <span class="pre">parameter)</span></tt> : Use a parameter value in SQL file.</li>
+<li><tt class="docutils literal"><span class="pre">-B</span> <span class="pre">(--background)</span></tt> : Execute as background process.</li>
</ul>
</div>
<div class="section" id="entering-tsql-shell">
@@ -264,7 +264,7 @@ default>
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -284,7 +284,7 @@ default>
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT:'../',
- VERSION:'0.11.0',
+ VERSION:'0.11.3',
COLLAPSE_INDEX:false,
FILE_SUFFIX:'.html',
HAS_SOURCE: true
Modified: tajo/site/docs/current/tsql/meta_command.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/tsql/meta_command.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/tsql/meta_command.html (original)
+++ tajo/site/docs/current/tsql/meta_command.html Thu May 19 02:00:25 2016
@@ -7,7 +7,7 @@
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Meta Commands — Apache Tajo 0.11.0 documentation</title>
+ <title>Meta Commands — Apache Tajo 0.11.3 documentation</title>
@@ -28,7 +28,7 @@
- <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/>
+ <link rel="top" title="Apache Tajo 0.11.3 documentation" href="../index.html"/>
<link rel="up" title="Tajo Shell (TSQL)" href="../tsql.html"/>
<link rel="next" title="Executing HDFS commands" href="dfs_command.html"/>
<link rel="prev" title="Tajo Shell (TSQL)" href="../tsql.html"/>
@@ -256,7 +256,7 @@ Documentations
</div>
<div class="section" id="basic-usages">
<h2>Basic usages<a class="headerlink" href="#basic-usages" title="Permalink to this headline">¶</a></h2>
-<p><code class="docutils literal"><span class="pre">\l</span></code> command shows a list of all databases as follows:</p>
+<p><tt class="docutils literal"><span class="pre">\l</span></tt> command shows a list of all databases as follows:</p>
<div class="highlight-python"><div class="highlight"><pre>default> \l
default
tpch
@@ -264,7 +264,7 @@ work1
default>
</pre></div>
</div>
-<p><code class="docutils literal"><span class="pre">\d</span></code> command shows a list of tables in the current database as follows:</p>
+<p><tt class="docutils literal"><span class="pre">\d</span></tt> command shows a list of tables in the current database as follows:</p>
<div class="highlight-python"><div class="highlight"><pre>default> \d
customer
lineitem
@@ -276,7 +276,7 @@ region
supplier
</pre></div>
</div>
-<p><code class="docutils literal"><span class="pre">\d</span> <span class="pre">[table</span> <span class="pre">name]</span></code> command also shows a table description as follows:</p>
+<p><tt class="docutils literal"><span class="pre">\d</span> <span class="pre">[table</span> <span class="pre">name]</span></tt> command also shows a table description as follows:</p>
<div class="highlight-python"><div class="highlight"><pre>default> \d orders
table name: orders
@@ -296,13 +296,13 @@ o_shippriority INT4
o_comment TEXT
</pre></div>
</div>
-<p>The prompt <code class="docutils literal"><span class="pre">default></span></code> indicates the current database. Basically, all SQL statements and meta commands work in the current database. Also, you can change the current database with <code class="docutils literal"><span class="pre">\c</span></code> command.</p>
+<p>The prompt <tt class="docutils literal"><span class="pre">default></span></tt> indicates the current database. Basically, all SQL statements and meta commands work in the current database. Also, you can change the current database with <tt class="docutils literal"><span class="pre">\c</span></tt> command.</p>
<div class="highlight-sql"><div class="highlight"><pre>default> \c work1
You are now connected to database "test" as user "hyunsik".
work1>
</pre></div>
</div>
-<p><code class="docutils literal"><span class="pre">\df</span></code> command shows a list of all built-in functions as follows:</p>
+<p><tt class="docutils literal"><span class="pre">\df</span></tt> command shows a list of all built-in functions as follows:</p>
<div class="highlight-python"><div class="highlight"><pre>default> \df
Name | Result type | Argument types | Description | Type
-----------------+-----------------+-----------------------+-----------------------------------------------+-----------
@@ -320,7 +320,7 @@ work1>
For Reference, many details have been omitted in order to present a clear picture of the process.
</pre></div>
</div>
-<p><code class="docutils literal"><span class="pre">\df</span> <span class="pre">[function</span> <span class="pre">name]</span></code> command also shows a function description as follows:</p>
+<p><tt class="docutils literal"><span class="pre">\df</span> <span class="pre">[function</span> <span class="pre">name]</span></tt> command also shows a function description as follows:</p>
<div class="highlight-python"><div class="highlight"><pre>default> \df round;
Name | Result type | Argument types | Description | Type
-----------------+-----------------+-----------------------+-----------------------------------------------+-----------
@@ -367,7 +367,7 @@ Example:
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -387,7 +387,7 @@ Example:
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT:'../',
- VERSION:'0.11.0',
+ VERSION:'0.11.3',
COLLAPSE_INDEX:false,
FILE_SUFFIX:'.html',
HAS_SOURCE: true
Modified: tajo/site/docs/current/tsql/single_command.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/tsql/single_command.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/tsql/single_command.html (original)
+++ tajo/site/docs/current/tsql/single_command.html Thu May 19 02:00:25 2016
@@ -7,7 +7,7 @@
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Executing a single command — Apache Tajo 0.11.0 documentation</title>
+ <title>Executing a single command — Apache Tajo 0.11.3 documentation</title>
@@ -28,7 +28,7 @@
- <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/>
+ <link rel="top" title="Apache Tajo 0.11.3 documentation" href="../index.html"/>
<link rel="up" title="Tajo Shell (TSQL)" href="../tsql.html"/>
<link rel="next" title="Executing Queries from Files" href="execute_file.html"/>
<link rel="prev" title="Introducing to TSQL" href="intro.html"/>
@@ -211,7 +211,7 @@
<div class="section" id="executing-a-single-command">
<h1>Executing a single command<a class="headerlink" href="#executing-a-single-command" title="Permalink to this headline">¶</a></h1>
-<p>You may want to run more queries without entering tsql prompt. Tsql provides the <code class="docutils literal"><span class="pre">-c</span></code> argument for above requirement. And Tajo assumes that queries are separated by semicolon as follows:</p>
+<p>You may want to run more queries without entering tsql prompt. Tsql provides the <tt class="docutils literal"><span class="pre">-c</span></tt> argument for above requirement. And Tajo assumes that queries are separated by semicolon as follows:</p>
<div class="highlight-sql"><div class="highlight"><pre>$ bin/tsql -c "select count(*) from table1; select sum(score) from table1;"
Progress: 0%, response time: 0.217 sec
Progress: 0%, response time: 0.218 sec
@@ -249,7 +249,7 @@ Progress: 100%, response time: 0.345 sec
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -269,7 +269,7 @@ Progress: 100%, response time: 0.345 sec
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT:'../',
- VERSION:'0.11.0',
+ VERSION:'0.11.3',
COLLAPSE_INDEX:false,
FILE_SUFFIX:'.html',
HAS_SOURCE: true
Modified: tajo/site/docs/current/tsql/variables.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/tsql/variables.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/tsql/variables.html (original)
+++ tajo/site/docs/current/tsql/variables.html Thu May 19 02:00:25 2016
@@ -7,7 +7,7 @@
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Session Variables — Apache Tajo 0.11.0 documentation</title>
+ <title>Session Variables — Apache Tajo 0.11.3 documentation</title>
@@ -28,7 +28,7 @@
- <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/>
+ <link rel="top" title="Apache Tajo 0.11.3 documentation" href="../index.html"/>
<link rel="up" title="Tajo Shell (TSQL)" href="../tsql.html"/>
<link rel="next" title="Administration Commands" href="admin_command.html"/>
<link rel="prev" title="Executing HDFS commands" href="dfs_command.html"/>
@@ -214,7 +214,7 @@
<p>Once a tajo client connects to the Tajo master, it assigns a unique session. This session is kept until the client is disconnected or it is expired.</p>
<p>For the sake of more convenient user configuration, Tajo provides <cite>session variables</cite>.
With session variables, different configurations are allowed for each session.</p>
-<p><code class="docutils literal"><span class="pre">tsql</span></code> provides the meta command <code class="docutils literal"><span class="pre">\set</span></code> to manipulate session variables. Just <code class="docutils literal"><span class="pre">\set</span></code> command shows all session variables.</p>
+<p><tt class="docutils literal"><span class="pre">tsql</span></tt> provides the meta command <tt class="docutils literal"><span class="pre">\set</span></tt> to manipulate session variables. Just <tt class="docutils literal"><span class="pre">\set</span></tt> command shows all session variables.</p>
<div class="highlight-python"><div class="highlight"><pre>default> \set
'name1'='val1'
'name2'='val2'
@@ -222,7 +222,7 @@ With session variables, different config
...
</pre></div>
</div>
-<p><code class="docutils literal"><span class="pre">\set</span> <span class="pre">key</span> <span class="pre">val</span></code> will set the session variable named <em>key</em> with the value <em>val</em>.</p>
+<p><tt class="docutils literal"><span class="pre">\set</span> <span class="pre">key</span> <span class="pre">val</span></tt> will set the session variable named <em>key</em> with the value <em>val</em>.</p>
<div class="highlight-python"><div class="highlight"><pre>default> \set
'CURRENT_DATABASE'='default'
@@ -233,17 +233,17 @@ default> \set
'key1'='val1'
</pre></div>
</div>
-<p>Also, <code class="docutils literal"><span class="pre">\unset</span> <span class="pre">key</span></code> will unset the session variable named <em>key</em>.</p>
+<p>Also, <tt class="docutils literal"><span class="pre">\unset</span> <span class="pre">key</span></tt> will unset the session variable named <em>key</em>.</p>
<p>Currently, tajo provides the following session variables.</p>
<dl class="describe">
<dt>
-<code class="descname">BROADCAST_NON_CROSS_JOIN_THRESHOLD</code></dt>
+<tt class="descname">BROADCAST_NON_CROSS_JOIN_THRESHOLD</tt></dt>
<dd></dd></dl>
<p>A threshold for non-cross joins. When a non-cross join query is executed with the broadcast join, the whole size of broadcasted tables won’t exceed this threshold.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-broadcast-non-cross-join-threshold-kb"><span>tajo.dist-query.broadcast.non-cross-join.threshold-kb</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-broadcast-non-cross-join-threshold-kb"><em>tajo.dist-query.broadcast.non-cross-join.threshold-kb</em></a></li>
<li>Property value: Integer</li>
<li>Unit: KB</li>
<li>Default value: 5120</li>
@@ -255,13 +255,13 @@ default> \set
</div>
<dl class="describe">
<dt>
-<code class="descname">BROADCAST_CROSS_JOIN_THRESHOLD</code></dt>
+<tt class="descname">BROADCAST_CROSS_JOIN_THRESHOLD</tt></dt>
<dd></dd></dl>
<p>A threshold for cross joins. When a cross join query is executed, the whole size of broadcasted tables won’t exceed this threshold.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-broadcast-cross-join-threshold-kb"><span>tajo.dist-query.broadcast.cross-join.threshold-kb</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-broadcast-cross-join-threshold-kb"><em>tajo.dist-query.broadcast.cross-join.threshold-kb</em></a></li>
<li>Property value: Integer</li>
<li>Unit: KB</li>
<li>Default value: 1024</li>
@@ -277,14 +277,14 @@ default> \set
</div>
<dl class="describe">
<dt>
-<code class="descname">JOIN_TASK_INPUT_SIZE</code></dt>
+<tt class="descname">JOIN_TASK_INPUT_SIZE</tt></dt>
<dd></dd></dl>
<p>The repartition join is executed in two stages. When a join query is executed with the repartition join, this value indicates the amount of input data processed by each task at the second stage.
As a result, it determines the degree of the parallel processing of the join query.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-join-task-volume-mb"><span>tajo.dist-query.join.task-volume-mb</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-join-task-volume-mb"><em>tajo.dist-query.join.task-volume-mb</em></a></li>
<li>Property value: Integer</li>
<li>Unit: MB</li>
<li>Default value: 64</li>
@@ -296,14 +296,14 @@ As a result, it determines the degree of
</div>
<dl class="describe">
<dt>
-<code class="descname">JOIN_PER_SHUFFLE_SIZE</code></dt>
+<tt class="descname">JOIN_PER_SHUFFLE_SIZE</tt></dt>
<dd></dd></dl>
<p>The repartition join is executed in two stages. When a join query is executed with the repartition join,
this value indicates the output size of each task at the first stage, which determines the number of partitions to be shuffled between two stages.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-join-partition-volume-mb"><span>tajo.dist-query.join.partition-volume-mb</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-join-partition-volume-mb"><em>tajo.dist-query.join.partition-volume-mb</em></a></li>
<li>Property value: Integer</li>
<li>Unit: MB</li>
<li>Default value: 128</li>
@@ -315,7 +315,7 @@ this value indicates the output size of
</div>
<dl class="describe">
<dt>
-<code class="descname">HASH_JOIN_SIZE_LIMIT</code></dt>
+<tt class="descname">HASH_JOIN_SIZE_LIMIT</tt></dt>
<dd></dd></dl>
<p>This value provides the criterion to decide the algorithm to perform a join in a task.
@@ -323,7 +323,7 @@ If the input data is smaller than this v
Otherwise, the sort-merge join is used.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-common-in-memory-hash-threshold-mb"><span>tajo.executor.join.common.in-memory-hash-threshold-mb</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-common-in-memory-hash-threshold-mb"><em>tajo.executor.join.common.in-memory-hash-threshold-mb</em></a></li>
<li>Property value: Integer</li>
<li>Unit: MB</li>
<li>Default value: 64</li>
@@ -341,7 +341,7 @@ This value should be tuned carefully.</p
</div>
<dl class="describe">
<dt>
-<code class="descname">INNER_HASH_JOIN_SIZE_LIMIT</code></dt>
+<tt class="descname">INNER_HASH_JOIN_SIZE_LIMIT</tt></dt>
<dd></dd></dl>
<p>This value provides the criterion to decide the algorithm to perform an inner join in a task.
@@ -349,7 +349,7 @@ If the input data is smaller than this v
Otherwise, the sort-merge join is used.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-inner-in-memory-hash-threshold-mb"><span>tajo.executor.join.inner.in-memory-hash-threshold-mb</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-inner-in-memory-hash-threshold-mb"><em>tajo.executor.join.inner.in-memory-hash-threshold-mb</em></a></li>
<li>Property value: Integer</li>
<li>Unit: MB</li>
<li>Default value: 64</li>
@@ -367,7 +367,7 @@ This value should be tuned carefully.</p
</div>
<dl class="describe">
<dt>
-<code class="descname">OUTER_HASH_JOIN_SIZE_LIMIT</code></dt>
+<tt class="descname">OUTER_HASH_JOIN_SIZE_LIMIT</tt></dt>
<dd></dd></dl>
<p>This value provides the criterion to decide the algorithm to perform an outer join in a task.
@@ -375,7 +375,7 @@ If the input data is smaller than this v
Otherwise, the sort-merge join is used.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-outer-in-memory-hash-threshold-mb"><span>tajo.executor.join.outer.in-memory-hash-threshold-mb</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-outer-in-memory-hash-threshold-mb"><em>tajo.executor.join.outer.in-memory-hash-threshold-mb</em></a></li>
<li>Property value: Integer</li>
<li>Unit: MB</li>
<li>Default value: 64</li>
@@ -393,13 +393,13 @@ This value should be tuned carefully.</p
</div>
<dl class="describe">
<dt>
-<code class="descname">JOIN_HASH_TABLE_SIZE</code></dt>
+<tt class="descname">JOIN_HASH_TABLE_SIZE</tt></dt>
<dd></dd></dl>
<p>The initial size of hash table for in-memory hash join.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-hash-table-size"><span>tajo.executor.join.hash-table.size</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-hash-table-size"><em>tajo.executor.join.hash-table.size</em></a></li>
<li>Property value: Integer</li>
<li>Default value: 100000</li>
<li>Example</li>
@@ -410,14 +410,14 @@ This value should be tuned carefully.</p
</div>
<dl class="describe">
<dt>
-<code class="descname">SORT_TASK_INPUT_SIZE</code></dt>
+<tt class="descname">SORT_TASK_INPUT_SIZE</tt></dt>
<dd></dd></dl>
<p>The sort operation is executed in two stages. When a sort query is executed, this value indicates the amount of input data processed by each task at the second stage.
As a result, it determines the degree of the parallel processing of the sort query.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-sort-task-volume-mb"><span>tajo.dist-query.sort.task-volume-mb</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-sort-task-volume-mb"><em>tajo.dist-query.sort.task-volume-mb</em></a></li>
<li>Property value: Integer</li>
<li>Unit: MB</li>
<li>Default value: 64</li>
@@ -429,13 +429,13 @@ As a result, it determines the degree of
</div>
<dl class="describe">
<dt>
-<code class="descname">EXTSORT_BUFFER_SIZE</code></dt>
+<tt class="descname">EXTSORT_BUFFER_SIZE</tt></dt>
<dd></dd></dl>
<p>A threshold to choose the sort algorithm. If the input data is larger than this threshold, the external sort algorithm is used.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-external-sort-buffer-mb"><span>tajo.executor.external-sort.buffer-mb</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-external-sort-buffer-mb"><em>tajo.executor.external-sort.buffer-mb</em></a></li>
<li>Property value: Integer</li>
<li>Unit: MB</li>
<li>Default value: 200</li>
@@ -447,13 +447,13 @@ As a result, it determines the degree of
</div>
<dl class="describe">
<dt>
-<code class="descname">SORT_LIST_SIZE</code></dt>
+<tt class="descname">SORT_LIST_SIZE</tt></dt>
<dd></dd></dl>
<p>The initial size of list for in-memory sort.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-sort-list-size"><span>tajo.executor.sort.list.size</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-sort-list-size"><em>tajo.executor.sort.list.size</em></a></li>
<li>Property value: Integer</li>
<li>Default value: 100000</li>
<li>Example</li>
@@ -464,14 +464,14 @@ As a result, it determines the degree of
</div>
<dl class="describe">
<dt>
-<code class="descname">GROUPBY_MULTI_LEVEL_ENABLED</code></dt>
+<tt class="descname">GROUPBY_MULTI_LEVEL_ENABLED</tt></dt>
<dd></dd></dl>
<p>A flag to enable the multi-level algorithm for distinct aggregation. If this value is set, 3-phase aggregation algorithm is used.
Otherwise, 2-phase aggregation algorithm is used.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-groupby-multi-level-aggr"><span>tajo.dist-query.groupby.multi-level-aggr</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-groupby-multi-level-aggr"><em>tajo.dist-query.groupby.multi-level-aggr</em></a></li>
<li>Property value: Boolean</li>
<li>Default value: true</li>
<li>Example</li>
@@ -482,14 +482,14 @@ Otherwise, 2-phase aggregation algorithm
</div>
<dl class="describe">
<dt>
-<code class="descname">GROUPBY_PER_SHUFFLE_SIZE</code></dt>
+<tt class="descname">GROUPBY_PER_SHUFFLE_SIZE</tt></dt>
<dd></dd></dl>
<p>The aggregation is executed in two stages. When an aggregation query is executed,
this value indicates the output size of each task at the first stage, which determines the number of partitions to be shuffled between two stages.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-groupby-partition-volume-mb"><span>tajo.dist-query.groupby.partition-volume-mb</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-groupby-partition-volume-mb"><em>tajo.dist-query.groupby.partition-volume-mb</em></a></li>
<li>Property value: Integer</li>
<li>Unit: MB</li>
<li>Default value: 256</li>
@@ -501,14 +501,14 @@ this value indicates the output size of
</div>
<dl class="describe">
<dt>
-<code class="descname">GROUPBY_TASK_INPUT_SIZE</code></dt>
+<tt class="descname">GROUPBY_TASK_INPUT_SIZE</tt></dt>
<dd></dd></dl>
<p>The aggregation operation is executed in two stages. When an aggregation query is executed, this value indicates the amount of input data processed by each task at the second stage.
As a result, it determines the degree of the parallel processing of the aggregation query.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-groupby-task-volume-mb"><span>tajo.dist-query.groupby.task-volume-mb</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-groupby-task-volume-mb"><em>tajo.dist-query.groupby.task-volume-mb</em></a></li>
<li>Property value: Integer</li>
<li>Unit: MB</li>
<li>Default value: 64</li>
@@ -520,7 +520,7 @@ As a result, it determines the degree of
</div>
<dl class="describe">
<dt>
-<code class="descname">HASH_GROUPBY_SIZE_LIMIT</code></dt>
+<tt class="descname">HASH_GROUPBY_SIZE_LIMIT</tt></dt>
<dd></dd></dl>
<p>This value provides the criterion to decide the algorithm to perform an aggregation in a task.
@@ -528,7 +528,7 @@ If the input data is smaller than this v
Otherwise, the sort-based aggregation is used.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-groupby-in-memory-hash-threshold-mb"><span>tajo.executor.groupby.in-memory-hash-threshold-mb</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-groupby-in-memory-hash-threshold-mb"><em>tajo.executor.groupby.in-memory-hash-threshold-mb</em></a></li>
<li>Property value: Integer</li>
<li>Unit: MB</li>
<li>Default value: 64</li>
@@ -546,13 +546,13 @@ This value should be tuned carefully.</p
</div>
<dl class="describe">
<dt>
-<code class="descname">AGG_HASH_TABLE_SIZE</code></dt>
+<tt class="descname">AGG_HASH_TABLE_SIZE</tt></dt>
<dd></dd></dl>
<p>The initial size of hash table for in-memory aggregation.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-aggregate-hash-table-size"><span>tajo.executor.aggregate.hash-table.size</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-aggregate-hash-table-size"><em>tajo.executor.aggregate.hash-table.size</em></a></li>
<li>Property value: Integer</li>
<li>Default value: 10000</li>
<li>Example</li>
@@ -563,13 +563,13 @@ This value should be tuned carefully.</p
</div>
<dl class="describe">
<dt>
-<code class="descname">TIMEZONE</code></dt>
+<tt class="descname">TIMEZONE</tt></dt>
<dd></dd></dl>
<p>Refer to <a class="reference internal" href="../time_zone.html"><em>Time Zone</em></a>.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-timezone"><span>tajo.timezone</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-timezone"><em>tajo.timezone</em></a></li>
<li>Property value: Time zone id</li>
<li>Default value: Default time zone of JVM</li>
<li>Example</li>
@@ -580,13 +580,13 @@ This value should be tuned carefully.</p
</div>
<dl class="describe">
<dt>
-<code class="descname">DATE_ORDER</code></dt>
+<tt class="descname">DATE_ORDER</tt></dt>
<dd></dd></dl>
<p>Date order specification.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-datetime-date-order"><span>tajo.datetime.date-order</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-datetime-date-order"><em>tajo.datetime.date-order</em></a></li>
<li>Property value: One of YMD, DMY, MDY.</li>
<li>Default value: YMD</li>
<li>Example</li>
@@ -597,13 +597,13 @@ This value should be tuned carefully.</p
</div>
<dl class="describe">
<dt>
-<code class="descname">PARTITION_NO_RESULT_OVERWRITE_ENABLED</code></dt>
+<tt class="descname">PARTITION_NO_RESULT_OVERWRITE_ENABLED</tt></dt>
<dd></dd></dl>
<p>If this value is true, a partitioned table is overwritten even if a subquery leads to no result. Otherwise, the table data will be kept if there is no result.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-partition-overwrite-even-if-no-result"><span>tajo.partition.overwrite.even-if-no-result</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-partition-overwrite-even-if-no-result"><em>tajo.partition.overwrite.even-if-no-result</em></a></li>
<li>Property value: Boolean</li>
<li>Default value: false</li>
<li>Example</li>
@@ -614,14 +614,14 @@ This value should be tuned carefully.</p
</div>
<dl class="describe">
<dt>
-<code class="descname">TABLE_PARTITION_PER_SHUFFLE_SIZE</code></dt>
+<tt class="descname">TABLE_PARTITION_PER_SHUFFLE_SIZE</tt></dt>
<dd></dd></dl>
<p>In Tajo, storing a partition table is executed in two stages.
This value indicates the output size of a task of the former stage, which determines the number of partitions to be shuffled between two stages.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-table-partition-task-volume-mb"><span>tajo.dist-query.table-partition.task-volume-mb</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-table-partition-task-volume-mb"><em>tajo.dist-query.table-partition.task-volume-mb</em></a></li>
<li>Property value: Integer</li>
<li>Unit: MB</li>
<li>Default value: 256</li>
@@ -633,13 +633,13 @@ This value indicates the output size of
</div>
<dl class="describe">
<dt>
-<code class="descname">ARITHABORT</code></dt>
+<tt class="descname">ARITHABORT</tt></dt>
<dd></dd></dl>
<p>A flag to indicate how to handle the errors caused by invalid arithmetic operations. If true, a running query will be terminated with an overflow or a divide-by-zero.</p>
<blockquote>
<div><ul class="simple">
-<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-behavior-arithmetic-abort"><span>tajo.behavior.arithmetic-abort</span></a></li>
+<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-behavior-arithmetic-abort"><em>tajo.behavior.arithmetic-abort</em></a></li>
<li>Property value: Boolean</li>
<li>Default value: false</li>
<li>Example</li>
@@ -650,7 +650,7 @@ This value indicates the output size of
</div>
<dl class="describe">
<dt>
-<code class="descname">MAX_OUTPUT_FILE_SIZE</code></dt>
+<tt class="descname">MAX_OUTPUT_FILE_SIZE</tt></dt>
<dd></dd></dl>
<p>Maximum per-output file size. 0 means infinite.</p>
@@ -667,7 +667,7 @@ This value indicates the output size of
</div>
<dl class="describe">
<dt>
-<code class="descname">SESSION_EXPIRY_TIME</code></dt>
+<tt class="descname">SESSION_EXPIRY_TIME</tt></dt>
<dd></dd></dl>
<p>Session expiry time.</p>
@@ -684,7 +684,7 @@ This value indicates the output size of
</div>
<dl class="describe">
<dt>
-<code class="descname">CLI_COLUMNS</code></dt>
+<tt class="descname">CLI_COLUMNS</tt></dt>
<dd></dd></dl>
<p>Sets the width for the wrapped format.</p>
@@ -700,7 +700,7 @@ This value indicates the output size of
</div>
<dl class="describe">
<dt>
-<code class="descname">CLI_NULL_CHAR</code></dt>
+<tt class="descname">CLI_NULL_CHAR</tt></dt>
<dd></dd></dl>
<p>Sets the string to be printed in place of a null value.</p>
@@ -716,7 +716,7 @@ This value indicates the output size of
</div>
<dl class="describe">
<dt>
-<code class="descname">CLI_PAGE_ROWS</code></dt>
+<tt class="descname">CLI_PAGE_ROWS</tt></dt>
<dd></dd></dl>
<p>Sets the number of rows for paging.</p>
@@ -732,7 +732,7 @@ This value indicates the output size of
</div>
<dl class="describe">
<dt>
-<code class="descname">CLI_PAGING_ENABLED</code></dt>
+<tt class="descname">CLI_PAGING_ENABLED</tt></dt>
<dd></dd></dl>
<p>Enable paging of result display.</p>
@@ -748,7 +748,7 @@ This value indicates the output size of
</div>
<dl class="describe">
<dt>
-<code class="descname">CLI_DISPLAY_ERROR_TRACE</code></dt>
+<tt class="descname">CLI_DISPLAY_ERROR_TRACE</tt></dt>
<dd></dd></dl>
<p>Enable display of error trace.</p>
@@ -764,7 +764,7 @@ This value indicates the output size of
</div>
<dl class="describe">
<dt>
-<code class="descname">CLI_FORMATTER_CLASS</code></dt>
+<tt class="descname">CLI_FORMATTER_CLASS</tt></dt>
<dd></dd></dl>
<p>Sets the output format class to display results.</p>
@@ -780,7 +780,7 @@ This value indicates the output size of
</div>
<dl class="describe">
<dt>
-<code class="descname">ON_ERROR_STOP</code></dt>
+<tt class="descname">ON_ERROR_STOP</tt></dt>
<dd></dd></dl>
<p>tsql will exit if an error occurs.</p>
@@ -796,7 +796,7 @@ This value indicates the output size of
</div>
<dl class="describe">
<dt>
-<code class="descname">NULL_CHAR</code></dt>
+<tt class="descname">NULL_CHAR</tt></dt>
<dd></dd></dl>
<p>Null char of text file output. This value is used when the table property <cite>text.null</cite> is not specified.</p>
@@ -812,7 +812,7 @@ This value indicates the output size of
</div>
<dl class="describe">
<dt>
-<code class="descname">DEBUG_ENABLED</code></dt>
+<tt class="descname">DEBUG_ENABLED</tt></dt>
<dd></dd></dl>
<p>A flag to enable debug mode.</p>
@@ -828,7 +828,7 @@ This value indicates the output size of
</div>
<dl class="describe">
<dt>
-<code class="descname">FETCH_ROWNUM</code></dt>
+<tt class="descname">FETCH_ROWNUM</tt></dt>
<dd></dd></dl>
<p>The number of rows to be fetched from Master each time.</p>
@@ -862,7 +862,7 @@ This value indicates the output size of
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -882,7 +882,7 @@ This value indicates the output size of
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT:'../',
- VERSION:'0.11.0',
+ VERSION:'0.11.3',
COLLAPSE_INDEX:false,
FILE_SUFFIX:'.html',
HAS_SOURCE: true