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 [41/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/sql_language/ddl.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/ddl.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/ddl.html (original)
+++ tajo/site/docs/current/sql_language/ddl.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>Data Definition Language — Apache Tajo 0.11.0 documentation</title>
+ <title>Data Definition Language — 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="SQL Language" href="../sql_language.html"/>
<link rel="next" title="INSERT (OVERWRITE) INTO" href="insert.html"/>
<link rel="prev" title="Data Model" href="data_model.html"/>
@@ -219,7 +219,7 @@
</div>
<p><em>Description</em></p>
<p>Database is the namespace in Tajo. A database can contain multiple tables which have unique name in it.
-<code class="docutils literal"><span class="pre">IF</span> <span class="pre">NOT</span> <span class="pre">EXISTS</span></code> allows <code class="docutils literal"><span class="pre">CREATE</span> <span class="pre">DATABASE</span></code> statement to avoid an error which occurs when the database exists.</p>
+<tt class="docutils literal"><span class="pre">IF</span> <span class="pre">NOT</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">CREATE</span> <span class="pre">DATABASE</span></tt> statement to avoid an error which occurs when the database exists.</p>
</div>
<div class="section" id="drop-database">
<h2>DROP DATABASE<a class="headerlink" href="#drop-database" title="Permalink to this headline">¶</a></h2>
@@ -227,7 +227,7 @@
<div class="highlight-sql"><div class="highlight"><pre><span class="k">DROP</span> <span class="k">DATABASE</span> <span class="p">[</span><span class="n">IF</span> <span class="k">EXISTS</span><span class="p">]</span> <span class="o"><</span><span class="n">database_name</span><span class="o">></span>
</pre></div>
</div>
-<p><code class="docutils literal"><span class="pre">IF</span> <span class="pre">EXISTS</span></code> allows <code class="docutils literal"><span class="pre">DROP</span> <span class="pre">DATABASE</span></code> statement to avoid an error which occurs when the database does not exist.</p>
+<p><tt class="docutils literal"><span class="pre">IF</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">DATABASE</span></tt> statement to avoid an error which occurs when the database does not exist.</p>
</div>
<div class="section" id="create-table">
<h2>CREATE TABLE<a class="headerlink" href="#create-table" title="Permalink to this headline">¶</a></h2>
@@ -241,10 +241,10 @@
</div>
<p><em>Description</em></p>
<p>In Tajo, there are two types of tables, <cite>managed table</cite> and <cite>external table</cite>.
-Managed tables are placed on some predefined tablespaces. The <code class="docutils literal"><span class="pre">TABLESPACE</span></code> clause is to specify a tablespace for this table. For external tables, Tajo allows an arbitrary table location with the <code class="docutils literal"><span class="pre">LOCATION</span></code> clause.
+Managed tables are placed on some predefined tablespaces. The <tt class="docutils literal"><span class="pre">TABLESPACE</span></tt> clause is to specify a tablespace for this table. For external tables, Tajo allows an arbitrary table location with the <tt class="docutils literal"><span class="pre">LOCATION</span></tt> clause.
For more information about tables and tablespace, please refer to <a class="reference internal" href="../table_management/table_overview.html"><em>Overview of Tajo Tables</em></a> and <a class="reference internal" href="../table_management/tablespaces.html"><em>Tablespaces</em></a>.</p>
-<p><code class="docutils literal"><span class="pre">column_list</span></code> is a sequence of the column name and its type like <code class="docutils literal"><span class="pre"><column_name></span> <span class="pre"><data_type>,</span> <span class="pre">...</span></code>. Additionally, the <cite>asterisk (*)</cite> is allowed for external tables when their data format is <cite>JSON</cite>. You can find more details at <a class="reference internal" href="../table_management/json.html"><em>JSON</em></a>.</p>
-<p><code class="docutils literal"><span class="pre">IF</span> <span class="pre">NOT</span> <span class="pre">EXISTS</span></code> allows <code class="docutils literal"><span class="pre">CREATE</span> <span class="pre">[EXTERNAL]</span> <span class="pre">TABLE</span></code> statement to avoid an error which occurs when the table does not exist.</p>
+<p><tt class="docutils literal"><span class="pre">column_list</span></tt> is a sequence of the column name and its type like <tt class="docutils literal"><span class="pre"><column_name></span> <span class="pre"><data_type>,</span> <span class="pre">...</span></tt>. Additionally, the <cite>asterisk (*)</cite> is allowed for external tables when their data format is <cite>JSON</cite>. You can find more details at <a class="reference internal" href="../table_management/json.html"><em>JSON</em></a>.</p>
+<p><tt class="docutils literal"><span class="pre">IF</span> <span class="pre">NOT</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">CREATE</span> <span class="pre">[EXTERNAL]</span> <span class="pre">TABLE</span></tt> statement to avoid an error which occurs when the table does not exist.</p>
<div class="section" id="compression">
<h3>Compression<a class="headerlink" href="#compression" title="Permalink to this headline">¶</a></h3>
<p>If you want to add an external table that contains compressed data, you should give ‘compression.code’ parameter to CREATE TABLE statement.</p>
@@ -277,7 +277,7 @@ For more information about tables and ta
</pre></div>
</div>
<p><em>Description</em></p>
-<p><code class="docutils literal"><span class="pre">IF</span> <span class="pre">EXISTS</span></code> allows <code class="docutils literal"><span class="pre">DROP</span> <span class="pre">DATABASE</span></code> statement to avoid an error which occurs when the database does not exist. <code class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></code> statement removes a table from Tajo catalog, but it does not remove the contents. If <code class="docutils literal"><span class="pre">PURGE</span></code> option is given, <code class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></code> statement will eliminate the entry in the catalog as well as the contents.</p>
+<p><tt class="docutils literal"><span class="pre">IF</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">DATABASE</span></tt> statement to avoid an error which occurs when the database does not exist. <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></tt> statement removes a table from Tajo catalog, but it does not remove the contents. If <tt class="docutils literal"><span class="pre">PURGE</span></tt> option is given, <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></tt> statement will eliminate the entry in the catalog as well as the contents.</p>
</div>
<div class="section" id="create-index">
<h2>CREATE INDEX<a class="headerlink" href="#create-index" title="Permalink to this headline">¶</a></h2>
@@ -288,7 +288,7 @@ For more information about tables and ta
</pre></div>
</div>
<p><em>Description</em></p>
-<p>Tajo supports index for fast data retrieval. Currently, index is supported for only plain <code class="docutils literal"><span class="pre">TEXT</span></code> formats stored on <code class="docutils literal"><span class="pre">HDFS</span></code>.
+<p>Tajo supports index for fast data retrieval. Currently, index is supported for only plain <tt class="docutils literal"><span class="pre">TEXT</span></tt> formats stored on <tt class="docutils literal"><span class="pre">HDFS</span></tt>.
For more information, please refer to <a class="reference internal" href="../index_overview.html"><em>Index (Experimental Feature)</em></a>.</p>
<div class="section" id="index-method">
<h3>Index method<a class="headerlink" href="#index-method" title="Permalink to this headline">¶</a></h3>
@@ -329,7 +329,7 @@ For more information, please refer to <a
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -349,7 +349,7 @@ For more information, please refer to <a
<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/sql_language/explain.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/explain.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/explain.html (original)
+++ tajo/site/docs/current/sql_language/explain.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>EXPLAIN — Apache Tajo 0.11.0 documentation</title>
+ <title>EXPLAIN — 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="SQL Language" href="../sql_language.html"/>
<link rel="next" title="Time Zone" href="../time_zone.html"/>
<link rel="prev" title="Predicates" href="predicates.html"/>
@@ -309,7 +309,7 @@ Block Id: eb_0000000000000_0000_000003 [
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -329,7 +329,7 @@ Block Id: eb_0000000000000_0000_000003 [
<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/sql_language/insert.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/insert.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/insert.html (original)
+++ tajo/site/docs/current/sql_language/insert.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>INSERT (OVERWRITE) INTO — Apache Tajo 0.11.0 documentation</title>
+ <title>INSERT (OVERWRITE) INTO — 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="SQL Language" href="../sql_language.html"/>
<link rel="next" title="ALTER TABLE" href="alter_table.html"/>
<link rel="prev" title="Data Definition Language" href="ddl.html"/>
@@ -211,7 +211,7 @@
<div class="section" id="insert-overwrite-into">
<h1>INSERT (OVERWRITE) INTO<a class="headerlink" href="#insert-overwrite-into" title="Permalink to this headline">¶</a></h1>
-<p>INSERT OVERWRITE statement overwrites a table data of an existing table or a data in a given directory. Tajo’s INSERT OVERWRITE statement follows <code class="docutils literal"><span class="pre">INSERT</span> <span class="pre">INTO</span> <span class="pre">SELECT</span></code> statement of SQL. The examples are as follows:</p>
+<p>INSERT OVERWRITE statement overwrites a table data of an existing table or a data in a given directory. Tajo’s INSERT OVERWRITE statement follows <tt class="docutils literal"><span class="pre">INSERT</span> <span class="pre">INTO</span> <span class="pre">SELECT</span></tt> statement of SQL. The examples are as follows:</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">create</span> <span class="k">table</span> <span class="n">t1</span> <span class="p">(</span><span class="n">col1</span> <span class="nb">int8</span><span class="p">,</span> <span class="n">col2</span> <span class="n">int4</span><span class="p">,</span> <span class="n">col3</span> <span class="n">float8</span><span class="p">);</span>
<span class="c1">-- when a target table schema and output schema are equivalent to each other</span>
@@ -250,7 +250,7 @@
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -270,7 +270,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/sql_language/joins.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/joins.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/joins.html (original)
+++ tajo/site/docs/current/sql_language/joins.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>Joins — Apache Tajo 0.11.0 documentation</title>
+ <title>Joins — 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="SQL Language" href="../sql_language.html"/>
<link rel="next" title="SQL Expressions" href="sql_expression.html"/>
<link rel="prev" title="Queries" href="queries.html"/>
@@ -215,21 +215,21 @@
<h2>Overview<a class="headerlink" href="#overview" title="Permalink to this headline">¶</a></h2>
<p>In Tajo, a single query can accesses multiple rows of the same or different relations at one time. This query is called <em>join</em>.
Currently, Tajo supports cross, inner, and outer joins.</p>
-<p>A join query can involve multiple relations in the <code class="docutils literal"><span class="pre">FROM</span></code> clause according to the following rule.</p>
+<p>A join query can involve multiple relations in the <tt class="docutils literal"><span class="pre">FROM</span></tt> clause according to the following rule.</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">FROM</span> <span class="n">joined_table</span> <span class="p">[,</span> <span class="n">joined_table</span> <span class="p">[,</span> <span class="p">...]</span> <span class="p">]</span>
</pre></div>
</div>
-<p>, where <code class="docutils literal"><span class="pre">joined_table</span></code> is:</p>
+<p>, where <tt class="docutils literal"><span class="pre">joined_table</span></tt> is:</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="n">table_reference</span> <span class="n">join_type</span> <span class="n">table_reference</span> <span class="p">[</span> <span class="k">ON</span> <span class="n">join_condition</span> <span class="p">]</span>
</pre></div>
</div>
-<p><code class="docutils literal"><span class="pre">join_type</span></code> can be one of the followings.</p>
+<p><tt class="docutils literal"><span class="pre">join_type</span></tt> can be one of the followings.</p>
<div class="highlight-sql"><div class="highlight"><pre>CROSS JOIN
[ NATURAL ] [ INNER ] JOIN
{ LEFT | RIGHT | FULL } OUTER JOIN
</pre></div>
</div>
-<p><code class="docutils literal"><span class="pre">join_condition</span></code> can be specified in the <code class="docutils literal"><span class="pre">WHERE</span></code> clause as well as the <code class="docutils literal"><span class="pre">ON</span></code> clause.</p>
+<p><tt class="docutils literal"><span class="pre">join_condition</span></tt> can be specified in the <tt class="docutils literal"><span class="pre">WHERE</span></tt> clause as well as the <tt class="docutils literal"><span class="pre">ON</span></tt> clause.</p>
<p>For more information, please refer to <a class="reference internal" href="predicates.html"><em>Predicates</em></a>.</p>
<div class="admonition note">
<p class="first admonition-title">Note</p>
@@ -264,7 +264,7 @@ Currently, Tajo supports cross, inner, a
<span class="k">SELECT</span> <span class="n">a</span><span class="p">.</span><span class="o">*</span> <span class="k">FROM</span> <span class="n">a</span> <span class="k">INNER</span> <span class="k">JOIN</span> <span class="n">b</span> <span class="k">ON</span> <span class="n">a</span><span class="p">.</span><span class="n">id</span> <span class="o">=</span> <span class="n">b</span><span class="p">.</span><span class="n">id</span> <span class="k">FULL</span> <span class="k">OUTER</span> <span class="k">JOIN</span> <span class="k">c</span> <span class="k">ON</span> <span class="n">b</span><span class="p">.</span><span class="n">id2</span> <span class="o">=</span> <span class="k">c</span><span class="p">.</span><span class="n">id2</span>
</pre></div>
</div>
-<p>When a query involves three or more tables, there may be a lot of possible join orders. Tajo automatically finds the best join order regardless of the input order. For example, suppose that relation <code class="docutils literal"><span class="pre">b</span></code> is larger than relation <code class="docutils literal"><span class="pre">a</span></code>, and in turn, the relation <code class="docutils literal"><span class="pre">c</span></code> is larger than relation <code class="docutils literal"><span class="pre">b</span></code>. The query</p>
+<p>When a query involves three or more tables, there may be a lot of possible join orders. Tajo automatically finds the best join order regardless of the input order. For example, suppose that relation <tt class="docutils literal"><span class="pre">b</span></tt> is larger than relation <tt class="docutils literal"><span class="pre">a</span></tt>, and in turn, the relation <tt class="docutils literal"><span class="pre">c</span></tt> is larger than relation <tt class="docutils literal"><span class="pre">b</span></tt>. The query</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">SELECT</span> <span class="n">a</span><span class="p">.</span><span class="o">*</span> <span class="k">FROM</span> <span class="k">c</span> <span class="k">INNER</span> <span class="k">JOIN</span> <span class="n">b</span> <span class="k">ON</span> <span class="n">b</span><span class="p">.</span><span class="n">id2</span> <span class="o">=</span> <span class="k">c</span><span class="p">.</span><span class="n">id2</span> <span class="k">INNER</span> <span class="k">JOIN</span> <span class="n">a</span> <span class="k">ON</span> <span class="n">a</span><span class="p">.</span><span class="n">id</span> <span class="o">=</span> <span class="n">b</span><span class="p">.</span><span class="n">id</span>
</pre></div>
</div>
@@ -294,7 +294,7 @@ Tajo adopts several optimization techniq
Basically, joining multiple relations is left-associative. However, query performance can be significantly changed according to which order is chosen for the join execution.</p>
<p>To find the best join order, Tajo’s cost-based optimizer considers join conditions, join types, and the size of input relations.
In addition, it considers the computation cost of consecutive joins so that the shape of query plan forms a bushy tree.</p>
-<p>For example, suppose that there are 4 relations <code class="docutils literal"><span class="pre">a</span></code> (10), <code class="docutils literal"><span class="pre">b</span></code> (20), <code class="docutils literal"><span class="pre">c</span></code> (30), and <code class="docutils literal"><span class="pre">d</span></code> (40) where the numbers within brackets represent the relation size.
+<p>For example, suppose that there are 4 relations <tt class="docutils literal"><span class="pre">a</span></tt> (10), <tt class="docutils literal"><span class="pre">b</span></tt> (20), <tt class="docutils literal"><span class="pre">c</span></tt> (30), and <tt class="docutils literal"><span class="pre">d</span></tt> (40) where the numbers within brackets represent the relation size.
The following query</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">SELECT</span>
<span class="o">*</span>
@@ -327,9 +327,9 @@ Here, the cost of shuffle is expensive e
Thus, they can perform join without expensive data shuffle.</p>
<p>Tajo provides a session variable for broadcast join configuration. (For more detailed information of session variables, please refer to <a class="reference internal" href="../tsql/variables.html"><em>Session Variables</em></a>.)</p>
<ul class="simple">
-<li><code class="docutils literal"><span class="pre">BROADCAST_NON_CROSS_JOIN_THRESHOLD</span></code> and <code class="docutils literal"><span class="pre">BROADCAST_CROSS_JOIN_THRESHOLD</span></code> are thresholds for broadcast join. Only the relations who are larger than this threshold can be broadcasted.</li>
+<li><tt class="docutils literal"><span class="pre">BROADCAST_NON_CROSS_JOIN_THRESHOLD</span></tt> and <tt class="docutils literal"><span class="pre">BROADCAST_CROSS_JOIN_THRESHOLD</span></tt> are thresholds for broadcast join. Only the relations who are larger than this threshold can be broadcasted.</li>
</ul>
-<p>You can also apply this configuration system widely by setting <code class="docutils literal"><span class="pre">tajo.dist-query.broadcast.non-cross-join.threshold-kb</span></code> or <code class="docutils literal"><span class="pre">tajo.dist-query.broadcast.cross-join.threshold-kb</span></code> in <code class="docutils literal"><span class="pre">${TAJO_HOME}/conf/tajo-site.xml</span></code>.</p>
+<p>You can also apply this configuration system widely by setting <tt class="docutils literal"><span class="pre">tajo.dist-query.broadcast.non-cross-join.threshold-kb</span></tt> or <tt class="docutils literal"><span class="pre">tajo.dist-query.broadcast.cross-join.threshold-kb</span></tt> in <tt class="docutils literal"><span class="pre">${TAJO_HOME}/conf/tajo-site.xml</span></tt>.</p>
</div>
</div>
</div>
@@ -352,7 +352,7 @@ Thus, they can perform join without expe
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -372,7 +372,7 @@ Thus, they can perform join without expe
<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/sql_language/predicates.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/predicates.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/predicates.html (original)
+++ tajo/site/docs/current/sql_language/predicates.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>Predicates — Apache Tajo 0.11.0 documentation</title>
+ <title>Predicates — 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="SQL Language" href="../sql_language.html"/>
<link rel="next" title="EXPLAIN" href="explain.html"/>
<link rel="prev" title="SQL Expressions" href="sql_expression.html"/>
@@ -279,7 +279,7 @@
<span class="n">string</span> <span class="k">NOT</span> <span class="k">SIMILAR</span> <span class="k">TO</span> <span class="n">pattern</span>
</pre></div>
</div>
-<p>It returns true or false depending on whether its pattern matches the given string. Also like LIKE, <code class="docutils literal"><span class="pre">SIMILAR</span> <span class="pre">TO</span></code> uses <code class="docutils literal"><span class="pre">_</span></code> and <code class="docutils literal"><span class="pre">%</span></code> as metacharacters denoting any single character and any string, respectively.</p>
+<p>It returns true or false depending on whether its pattern matches the given string. Also like LIKE, <tt class="docutils literal"><span class="pre">SIMILAR</span> <span class="pre">TO</span></tt> uses <tt class="docutils literal"><span class="pre">_</span></tt> and <tt class="docutils literal"><span class="pre">%</span></tt> as metacharacters denoting any single character and any string, respectively.</p>
<p>In addition to these metacharacters borrowed from LIKE, ‘SIMILAR TO’ supports more powerful pattern-matching metacharacters borrowed from regular expressions:</p>
<table border="1" class="docutils">
<colgroup>
@@ -327,7 +327,7 @@
</tr>
</tbody>
</table>
-<p>Note that <cite>.`</cite> is not used as a metacharacter in <code class="docutils literal"><span class="pre">SIMILAR</span> <span class="pre">TO</span></code> operator.</p>
+<p>Note that <cite>.`</cite> is not used as a metacharacter in <tt class="docutils literal"><span class="pre">SIMILAR</span> <span class="pre">TO</span></tt> operator.</p>
</div>
<div class="section" id="regular-expressions">
<h3>Regular expressions<a class="headerlink" href="#regular-expressions" title="Permalink to this headline">¶</a></h3>
@@ -405,7 +405,7 @@
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -425,7 +425,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/sql_language/queries.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/queries.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/queries.html (original)
+++ tajo/site/docs/current/sql_language/queries.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>Queries — Apache Tajo 0.11.0 documentation</title>
+ <title>Queries — 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="SQL Language" href="../sql_language.html"/>
<link rel="next" title="Joins" href="joins.html"/>
<link rel="prev" title="ALTER TABLE" href="alter_table.html"/>
@@ -229,13 +229,13 @@
<div class="highlight-sql"><div class="highlight"><pre><span class="p">[</span><span class="k">FROM</span> <span class="o"><</span><span class="k">table</span> <span class="n">reference</span><span class="o">></span> <span class="p">[[</span><span class="k">AS</span><span class="p">]</span> <span class="o"><</span><span class="k">table</span> <span class="k">alias</span> <span class="n">name</span><span class="o">></span><span class="p">]</span> <span class="p">[,</span> <span class="p">...]]</span>
</pre></div>
</div>
-<p>The <code class="docutils literal"><span class="pre">FROM</span></code> clause specifies one or more other tables given in a comma-separated table reference list.
+<p>The <tt class="docutils literal"><span class="pre">FROM</span></tt> clause specifies one or more other tables given in a comma-separated table reference list.
A table reference can be a relation name , or a subquery, a table join, or complex combinations of them.</p>
<div class="section" id="table-and-table-aliases">
<h3>Table and Table Aliases<a class="headerlink" href="#table-and-table-aliases" title="Permalink to this headline">¶</a></h3>
<p>A temporary name can be given to tables and complex table references to be used
for references to the derived table in the rest of the query. This is called a table alias.</p>
-<p>To create a a table alias, please use <code class="docutils literal"><span class="pre">AS</span></code>:</p>
+<p>To create a a table alias, please use <tt class="docutils literal"><span class="pre">AS</span></tt>:</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">FROM</span> <span class="n">table_reference</span> <span class="k">AS</span> <span class="k">alias</span>
</pre></div>
</div>
@@ -243,7 +243,7 @@ for references to the derived table in t
<div class="highlight-sql"><div class="highlight"><pre><span class="k">FROM</span> <span class="n">table_reference</span> <span class="k">alias</span>
</pre></div>
</div>
-<p>The <code class="docutils literal"><span class="pre">AS</span></code> keyword can be omitted, and <em>Alias</em> can be any identifier.</p>
+<p>The <tt class="docutils literal"><span class="pre">AS</span></tt> keyword can be omitted, and <em>Alias</em> can be any identifier.</p>
<p>A typical application of table aliases is to give short names to long table references. For example:</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">long_table_name_1234</span> <span class="n">s</span> <span class="k">JOIN</span> <span class="n">another_long_table_name_5678</span> <span class="n">a</span> <span class="k">ON</span> <span class="n">s</span><span class="p">.</span><span class="n">id</span> <span class="o">=</span> <span class="n">a</span><span class="p">.</span><span class="n">num</span><span class="p">;</span>
</pre></div>
@@ -260,25 +260,25 @@ for references to the derived table in t
</pre></div>
</div>
<p>Cross join, also called <em>Cartesian product</em>, results in every possible combination of rows from T1 and T2.</p>
-<p><code class="docutils literal"><span class="pre">FROM</span> <span class="pre">T1</span> <span class="pre">CROSS</span> <span class="pre">JOIN</span> <span class="pre">T2</span></code> is equivalent to <code class="docutils literal"><span class="pre">FROM</span> <span class="pre">T1,</span> <span class="pre">T2</span></code>.</p>
+<p><tt class="docutils literal"><span class="pre">FROM</span> <span class="pre">T1</span> <span class="pre">CROSS</span> <span class="pre">JOIN</span> <span class="pre">T2</span></tt> is equivalent to <tt class="docutils literal"><span class="pre">FROM</span> <span class="pre">T1,</span> <span class="pre">T2</span></tt>.</p>
</div>
<div class="section" id="qualified-joins">
<h5>Qualified joins<a class="headerlink" href="#qualified-joins" title="Permalink to this headline">¶</a></h5>
<p>Qualified joins implicitly or explicitly have join conditions. Inner/Outer/Natural Joins all are qualified joins.
-Except for natural join, <code class="docutils literal"><span class="pre">ON</span></code> or <code class="docutils literal"><span class="pre">USING</span></code> clause in each join is used to specify a join condition.
+Except for natural join, <tt class="docutils literal"><span class="pre">ON</span></tt> or <tt class="docutils literal"><span class="pre">USING</span></tt> clause in each join is used to specify a join condition.
A join condition must include at least one boolean expression, and it can also include just filter conditions.</p>
<p><strong>Inner Join</strong></p>
<div class="highlight-sql"><div class="highlight"><pre><span class="n">T1</span> <span class="p">[</span><span class="k">INNER</span><span class="p">]</span> <span class="k">JOIN</span> <span class="n">T2</span> <span class="k">ON</span> <span class="n">boolean_expression</span>
<span class="n">T1</span> <span class="p">[</span><span class="k">INNER</span><span class="p">]</span> <span class="k">JOIN</span> <span class="n">T2</span> <span class="k">USING</span> <span class="p">(</span><span class="k">join</span> <span class="k">column</span> <span class="n">list</span><span class="p">)</span>
</pre></div>
</div>
-<p><code class="docutils literal"><span class="pre">INNER</span></code> keyword is the default, and so <code class="docutils literal"><span class="pre">INNER</span></code> can be omitted when you use inner join.</p>
+<p><tt class="docutils literal"><span class="pre">INNER</span></tt> keyword is the default, and so <tt class="docutils literal"><span class="pre">INNER</span></tt> can be omitted when you use inner join.</p>
<p><strong>Outer Join</strong></p>
<div class="highlight-sql"><div class="highlight"><pre><span class="n">T1</span> <span class="p">(</span><span class="k">LEFT</span><span class="o">|</span><span class="k">RIGHT</span><span class="o">|</span><span class="k">FULL</span><span class="p">)</span> <span class="k">OUTER</span> <span class="k">JOIN</span> <span class="n">T2</span> <span class="k">ON</span> <span class="n">boolean_expression</span>
<span class="n">T1</span> <span class="p">(</span><span class="k">LEFT</span><span class="o">|</span><span class="k">RIGHT</span><span class="o">|</span><span class="k">FULL</span><span class="p">)</span> <span class="k">OUTER</span> <span class="k">JOIN</span> <span class="n">T2</span> <span class="k">USING</span> <span class="p">(</span><span class="k">join</span> <span class="k">column</span> <span class="n">list</span><span class="p">)</span>
</pre></div>
</div>
-<p>One of <code class="docutils literal"><span class="pre">LEFT</span></code>, <code class="docutils literal"><span class="pre">RIGHT</span></code>, or <code class="docutils literal"><span class="pre">FULL</span></code> must be specified for outer joins.
+<p>One of <tt class="docutils literal"><span class="pre">LEFT</span></tt>, <tt class="docutils literal"><span class="pre">RIGHT</span></tt>, or <tt class="docutils literal"><span class="pre">FULL</span></tt> must be specified for outer joins.
Join conditions in outer join will have different behavior according to corresponding table references of join conditions.
To know outer join behavior in more detail, please refer to
<a class="reference external" href="http://www.ibm.com/developerworks/data/library/techarticle/purcell/0201purcell.html">Advanced outer join constructs</a>.</p>
@@ -286,9 +286,9 @@ To know outer join behavior in more deta
<div class="highlight-sql"><div class="highlight"><pre><span class="n">T1</span> <span class="k">NATURAL</span> <span class="k">JOIN</span> <span class="n">T2</span>
</pre></div>
</div>
-<p><code class="docutils literal"><span class="pre">NATURAL</span></code> is a short form of <code class="docutils literal"><span class="pre">USING</span></code>. It forms a <code class="docutils literal"><span class="pre">USING</span></code> list consisting of all common column names that appear in
+<p><tt class="docutils literal"><span class="pre">NATURAL</span></tt> is a short form of <tt class="docutils literal"><span class="pre">USING</span></tt>. It forms a <tt class="docutils literal"><span class="pre">USING</span></tt> list consisting of all common column names that appear in
both join tables. These common columns appear only once in the output table. If there are no common columns,
-<code class="docutils literal"><span class="pre">NATURAL</span></code> behaves like <code class="docutils literal"><span class="pre">CROSS</span> <span class="pre">JOIN</span></code>.</p>
+<tt class="docutils literal"><span class="pre">NATURAL</span></tt> behaves like <tt class="docutils literal"><span class="pre">CROSS</span> <span class="pre">JOIN</span></tt>.</p>
<p><strong>Subqueries</strong></p>
<p>A subquery is a query that is nested inside another query. It can be embedded in the FROM and WHERE clauses.</p>
<p>Example:</p>
@@ -308,7 +308,7 @@ both join tables. These common columns a
<div class="highlight-sql"><div class="highlight"><pre><span class="k">WHERE</span> <span class="n">search_condition</span>
</pre></div>
</div>
-<p><code class="docutils literal"><span class="pre">search_condition</span></code> can be any boolean expression.
+<p><tt class="docutils literal"><span class="pre">search_condition</span></tt> can be any boolean expression.
In order to know additional predicates, please refer to <a class="reference internal" href="predicates.html"><em>Predicates</em></a>.</p>
</div>
<div class="section" id="groupby-and-having-clauses">
@@ -321,19 +321,19 @@ In order to know additional predicates,
<span class="p">[</span><span class="k">HAVING</span> <span class="n">boolean_expression</span><span class="p">]</span>
</pre></div>
</div>
-<p>The rows which passes <code class="docutils literal"><span class="pre">WHERE</span></code> filter may be subject to grouping, specified by <code class="docutils literal"><span class="pre">GROUP</span> <span class="pre">BY</span></code> clause.
-Grouping combines a set of rows having common values into one group, and then computes rows in the group with aggregation functions. <code class="docutils literal"><span class="pre">HAVING</span></code> clause can be used with only <code class="docutils literal"><span class="pre">GROUP</span> <span class="pre">BY</span></code> clause. It eliminates the unqualified result rows of grouping.</p>
-<p><code class="docutils literal"><span class="pre">grouping_column_reference</span></code> can be a column reference, a complex expression including scalar functions and arithmetic operations.</p>
+<p>The rows which passes <tt class="docutils literal"><span class="pre">WHERE</span></tt> filter may be subject to grouping, specified by <tt class="docutils literal"><span class="pre">GROUP</span> <span class="pre">BY</span></tt> clause.
+Grouping combines a set of rows having common values into one group, and then computes rows in the group with aggregation functions. <tt class="docutils literal"><span class="pre">HAVING</span></tt> clause can be used with only <tt class="docutils literal"><span class="pre">GROUP</span> <span class="pre">BY</span></tt> clause. It eliminates the unqualified result rows of grouping.</p>
+<p><tt class="docutils literal"><span class="pre">grouping_column_reference</span></tt> can be a column reference, a complex expression including scalar functions and arithmetic operations.</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">SELECT</span> <span class="n">l_orderkey</span><span class="p">,</span> <span class="k">SUM</span><span class="p">(</span><span class="n">l_quantity</span><span class="p">)</span> <span class="k">AS</span> <span class="n">quantity</span> <span class="k">FROM</span> <span class="n">lineitem</span> <span class="k">GROUP</span> <span class="k">BY</span> <span class="n">l_orderkey</span><span class="p">;</span>
<span class="k">SELECT</span> <span class="n">substr</span><span class="p">(</span><span class="n">l_shipdate</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">4</span><span class="p">)</span> <span class="k">as</span> <span class="k">year</span><span class="p">,</span> <span class="k">SUM</span><span class="p">(</span><span class="n">l_orderkey</span><span class="p">)</span> <span class="k">AS</span> <span class="n">total2</span> <span class="k">FROM</span> <span class="n">lineitem</span> <span class="k">GROUP</span> <span class="k">BY</span> <span class="n">substr</span><span class="p">(</span><span class="n">l_shipdate</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">4</span><span class="p">);</span>
</pre></div>
</div>
-<p>If a SQL statement includes <code class="docutils literal"><span class="pre">GROUP</span> <span class="pre">BY</span></code> clause, expressions in select list must be either grouping_column_reference or aggregation function. For example, the following example query is not allowed because <code class="docutils literal"><span class="pre">l_orderkey</span></code> does not occur in <code class="docutils literal"><span class="pre">GROUP</span> <span class="pre">BY</span></code> clause.</p>
+<p>If a SQL statement includes <tt class="docutils literal"><span class="pre">GROUP</span> <span class="pre">BY</span></tt> clause, expressions in select list must be either grouping_column_reference or aggregation function. For example, the following example query is not allowed because <tt class="docutils literal"><span class="pre">l_orderkey</span></tt> does not occur in <tt class="docutils literal"><span class="pre">GROUP</span> <span class="pre">BY</span></tt> clause.</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">SELECT</span> <span class="n">l_orderkey</span><span class="p">,</span> <span class="n">l_partkey</span><span class="p">,</span> <span class="k">SUM</span><span class="p">(</span><span class="n">l_orderkey</span><span class="p">)</span> <span class="k">AS</span> <span class="n">total</span> <span class="k">FROM</span> <span class="n">lineitem</span> <span class="k">GROUP</span> <span class="k">BY</span> <span class="n">l_partkey</span><span class="p">;</span>
</pre></div>
</div>
-<p>Aggregation functions can be used with <code class="docutils literal"><span class="pre">DISTINCT</span></code> keywords. It forces an individual aggregate function to take only distinct values of the argument expression. <code class="docutils literal"><span class="pre">DISTINCT</span></code> keyword is used as follows:</p>
+<p>Aggregation functions can be used with <tt class="docutils literal"><span class="pre">DISTINCT</span></tt> keywords. It forces an individual aggregate function to take only distinct values of the argument expression. <tt class="docutils literal"><span class="pre">DISTINCT</span></tt> keyword is used as follows:</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">SELECT</span> <span class="n">l_partkey</span><span class="p">,</span> <span class="k">COUNT</span><span class="p">(</span><span class="k">distinct</span> <span class="n">l_quantity</span><span class="p">),</span> <span class="k">SUM</span><span class="p">(</span><span class="k">distinct</span> <span class="n">l_extendedprice</span><span class="p">)</span> <span class="k">AS</span> <span class="n">total</span> <span class="k">FROM</span> <span class="n">lineitem</span> <span class="k">GROUP</span> <span class="k">BY</span> <span class="n">l_partkey</span><span class="p">;</span>
</pre></div>
</div>
@@ -344,12 +344,12 @@ Grouping combines a set of rows having c
<div class="highlight-sql"><div class="highlight"><pre><span class="k">FROM</span> <span class="p">...</span> <span class="k">ORDER</span> <span class="k">BY</span> <span class="o"><</span><span class="n">sort_expr</span><span class="o">></span> <span class="p">[(</span><span class="k">ASC</span><span class="o">|</span><span class="k">DESC</span><span class="p">)]</span> <span class="p">[</span><span class="n">NULLS</span> <span class="p">(</span><span class="k">FIRST</span><span class="o">|</span><span class="k">LAST</span><span class="p">)</span> <span class="p">[,...]</span>
</pre></div>
</div>
-<p><code class="docutils literal"><span class="pre">sort_expr</span></code> can be a column reference, aliased column reference, or a complex expression.
-<code class="docutils literal"><span class="pre">ASC</span></code> indicates an ascending order of <code class="docutils literal"><span class="pre">sort_expr</span></code> values. <code class="docutils literal"><span class="pre">DESC</span></code> indicates a descending order of <code class="docutils literal"><span class="pre">sort_expr</span></code> values.
-<code class="docutils literal"><span class="pre">ASC</span></code> is the default order.</p>
-<p><code class="docutils literal"><span class="pre">NULLS</span> <span class="pre">FIRST</span></code> and <code class="docutils literal"><span class="pre">NULLS</span> <span class="pre">LAST</span></code> options can be used to determine whether nulls values appear
+<p><tt class="docutils literal"><span class="pre">sort_expr</span></tt> can be a column reference, aliased column reference, or a complex expression.
+<tt class="docutils literal"><span class="pre">ASC</span></tt> indicates an ascending order of <tt class="docutils literal"><span class="pre">sort_expr</span></tt> values. <tt class="docutils literal"><span class="pre">DESC</span></tt> indicates a descending order of <tt class="docutils literal"><span class="pre">sort_expr</span></tt> values.
+<tt class="docutils literal"><span class="pre">ASC</span></tt> is the default order.</p>
+<p><tt class="docutils literal"><span class="pre">NULLS</span> <span class="pre">FIRST</span></tt> and <tt class="docutils literal"><span class="pre">NULLS</span> <span class="pre">LAST</span></tt> options can be used to determine whether nulls values appear
before or after non-null values in the sort ordering. By default, null values are dealt as if larger than any non-null value;
-that is, <code class="docutils literal"><span class="pre">NULLS</span> <span class="pre">FIRST</span></code> is the default for <code class="docutils literal"><span class="pre">DESC</span></code> order, and <code class="docutils literal"><span class="pre">NULLS</span> <span class="pre">LAST</span></code> otherwise.</p>
+that is, <tt class="docutils literal"><span class="pre">NULLS</span> <span class="pre">FIRST</span></tt> is the default for <tt class="docutils literal"><span class="pre">DESC</span></tt> order, and <tt class="docutils literal"><span class="pre">NULLS</span> <span class="pre">LAST</span></tt> otherwise.</p>
</div>
<div class="section" id="window-functions">
<h2>Window Functions<a class="headerlink" href="#window-functions" title="Permalink to this headline">¶</a></h2>
@@ -368,15 +368,15 @@ the same partition as the current row.</
<div class="highlight-sql"><div class="highlight"><pre><span class="k">SELECT</span> <span class="n">l_orderkey</span><span class="p">,</span> <span class="k">sum</span><span class="p">(</span><span class="n">l_discount</span><span class="p">)</span> <span class="n">OVER</span> <span class="p">(</span><span class="n">PARTITION</span> <span class="k">BY</span> <span class="n">l_orderkey</span><span class="p">),</span> <span class="k">sum</span><span class="p">(</span><span class="n">l_quantity</span><span class="p">)</span> <span class="n">OVER</span> <span class="p">(</span><span class="n">PARTITION</span> <span class="k">BY</span> <span class="n">l_orderkey</span><span class="p">)</span> <span class="k">FROM</span> <span class="n">LINEITEM</span><span class="p">;</span>
</pre></div>
</div>
-<p>If <code class="docutils literal"><span class="pre">OVER()</span></code> clause is empty as following, it makes all table rows into one window frame.</p>
+<p>If <tt class="docutils literal"><span class="pre">OVER()</span></tt> clause is empty as following, it makes all table rows into one window frame.</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">SELECT</span> <span class="n">salary</span><span class="p">,</span> <span class="k">sum</span><span class="p">(</span><span class="n">salary</span><span class="p">)</span> <span class="n">OVER</span> <span class="p">()</span> <span class="k">FROM</span> <span class="n">empsalary</span><span class="p">;</span>
</pre></div>
</div>
-<p>Also, <code class="docutils literal"><span class="pre">ORDER</span> <span class="pre">BY</span></code> clause can be used without <code class="docutils literal"><span class="pre">PARTITION</span> <span class="pre">BY</span></code> clause as follows:</p>
+<p>Also, <tt class="docutils literal"><span class="pre">ORDER</span> <span class="pre">BY</span></tt> clause can be used without <tt class="docutils literal"><span class="pre">PARTITION</span> <span class="pre">BY</span></tt> clause as follows:</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">SELECT</span> <span class="n">salary</span><span class="p">,</span> <span class="k">sum</span><span class="p">(</span><span class="n">salary</span><span class="p">)</span> <span class="n">OVER</span> <span class="p">(</span><span class="k">ORDER</span> <span class="k">BY</span> <span class="n">salary</span><span class="p">)</span> <span class="k">FROM</span> <span class="n">empsalary</span><span class="p">;</span>
</pre></div>
</div>
-<p>Also, all expressions and aggregation functions are allowed in <code class="docutils literal"><span class="pre">ORDER</span> <span class="pre">BY</span></code> clause as follows:</p>
+<p>Also, all expressions and aggregation functions are allowed in <tt class="docutils literal"><span class="pre">ORDER</span> <span class="pre">BY</span></tt> clause as follows:</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span>
<span class="n">l_orderkey</span><span class="p">,</span>
<span class="k">count</span><span class="p">(</span><span class="o">*</span><span class="p">)</span> <span class="k">as</span> <span class="n">cnt</span><span class="p">,</span>
@@ -414,7 +414,7 @@ the same partition as the current row.</
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -434,7 +434,7 @@ the same partition as the current row.</
<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/sql_language/sql_expression.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/sql_expression.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/sql_expression.html (original)
+++ tajo/site/docs/current/sql_language/sql_expression.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>SQL Expressions — Apache Tajo 0.11.0 documentation</title>
+ <title>SQL Expressions — 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="SQL Language" href="../sql_language.html"/>
<link rel="next" title="Predicates" href="predicates.html"/>
<link rel="prev" title="Joins" href="joins.html"/>
@@ -225,7 +225,7 @@
</div>
<div class="section" id="string-literals">
<h2>String Literals<a class="headerlink" href="#string-literals" title="Permalink to this headline">¶</a></h2>
-<p>A string constant is an arbitrary sequence of characters bounded by single quotes (<code class="docutils literal"><span class="pre">'</span></code>):</p>
+<p>A string constant is an arbitrary sequence of characters bounded by single quotes (<tt class="docutils literal"><span class="pre">'</span></tt>):</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="s1">'tajo'</span>
</pre></div>
</div>
@@ -240,7 +240,7 @@
</div>
<div class="section" id="window-function-calls">
<h2>Window Function Calls<a class="headerlink" href="#window-function-calls" title="Permalink to this headline">¶</a></h2>
-<p>A window function call performs aggregate operation across the <code class="docutils literal"><span class="pre">window</span></code> which is a set of rows that are related to the current row. An window function has the following syntax.</p>
+<p>A window function call performs aggregate operation across the <tt class="docutils literal"><span class="pre">window</span></tt> which is a set of rows that are related to the current row. An window function has the following syntax.</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="n">function_name</span> <span class="n">OVER</span> <span class="p">(</span> <span class="n">window_definition</span> <span class="p">)</span>
</pre></div>
</div>
@@ -283,7 +283,7 @@ With <em>ORDER BY</em> list, result valu
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -303,7 +303,7 @@ With <em>ORDER BY</em> list, result valu
<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/storage_plugins.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/storage_plugins.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/storage_plugins.html (original)
+++ tajo/site/docs/current/storage_plugins.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>Storage Plugin — Apache Tajo 0.11.0 documentation</title>
+ <title>Storage Plugin — 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="Storage Plugin Overview" href="storage_plugins/overview.html"/>
<link rel="prev" title="Hash Partitioning" href="partitioning/hash_partitioning.html"/>
@@ -235,7 +235,7 @@
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -255,7 +255,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/storage_plugins/overview.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/storage_plugins/overview.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/storage_plugins/overview.html (original)
+++ tajo/site/docs/current/storage_plugins/overview.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>Storage Plugin Overview — Apache Tajo 0.11.0 documentation</title>
+ <title>Storage Plugin Overview — 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="Storage Plugin" href="../storage_plugins.html"/>
<link rel="next" title="PostgreSQL Storage Handler" href="postgresql.html"/>
<link rel="prev" title="Storage Plugin" href="../storage_plugins.html"/>
@@ -217,12 +217,12 @@
</div>
<div class="section" id="register-custom-storage">
<h2>Register custom storage<a class="headerlink" href="#register-custom-storage" title="Permalink to this headline">¶</a></h2>
-<p>First of all, your storage implementation should be packed as a jar file. Then, please copy the jar file into <code class="docutils literal"><span class="pre">tajo/extlib</span></code> directory. Next, you should copy <code class="docutils literal"><span class="pre">conf/storage-site.json.template</span></code> into <code class="docutils literal"><span class="pre">conf/storage-site.json</span></code> and modify the file like the below.</p>
+<p>First of all, your storage implementation should be packed as a jar file. Then, please copy the jar file into <tt class="docutils literal"><span class="pre">tajo/extlib</span></tt> directory. Next, you should copy <tt class="docutils literal"><span class="pre">conf/storage-site.json.template</span></tt> into <tt class="docutils literal"><span class="pre">conf/storage-site.json</span></tt> and modify the file like the below.</p>
</div>
<div class="section" id="configuration">
<h2>Configuration<a class="headerlink" href="#configuration" title="Permalink to this headline">¶</a></h2>
<p>Tajo has a default configuration for builtin storages, such as HDFS, local file system, and Amazon S3. it also allows users to add custom storage plugins</p>
-<p><code class="docutils literal"><span class="pre">conf/storage-site.json</span></code> file has the following struct:</p>
+<p><tt class="docutils literal"><span class="pre">conf/storage-site.json</span></tt> file has the following struct:</p>
<div class="highlight-json"><div class="highlight"><pre><span class="p">{</span>
<span class="nt">"storages"</span><span class="p">:</span> <span class="p">{</span>
<span class="nt">"${scheme}"</span><span class="p">:</span> <span class="p">{</span>
@@ -232,8 +232,8 @@
<span class="p">}</span>
</pre></div>
</div>
-<p>Each storage instance (i.e., <a class="reference internal" href="../table_management/tablespaces.html"><em>Tablespaces</em></a>) is identified by an URI. The scheme of URI plays a role to identify storage type. For example, <code class="docutils literal"><span class="pre">hdfs://</span></code> is used for Hdfs storage, <code class="docutils literal"><span class="pre">jdbc://</span></code> is used for JDBC-based storage, and <code class="docutils literal"><span class="pre">hbase://</span></code> is used for HBase storage.</p>
-<p>You should substitute a scheme name without <code class="docutils literal"><span class="pre">://</span></code> for <code class="docutils literal"><span class="pre">${scheme}</span></code>.</p>
+<p>Each storage instance (i.e., <a class="reference internal" href="../table_management/tablespaces.html"><em>Tablespaces</em></a>) is identified by an URI. The scheme of URI plays a role to identify storage type. For example, <tt class="docutils literal"><span class="pre">hdfs://</span></tt> is used for Hdfs storage, <tt class="docutils literal"><span class="pre">jdbc://</span></tt> is used for JDBC-based storage, and <tt class="docutils literal"><span class="pre">hbase://</span></tt> is used for HBase storage.</p>
+<p>You should substitute a scheme name without <tt class="docutils literal"><span class="pre">://</span></tt> for <tt class="docutils literal"><span class="pre">${scheme}</span></tt>.</p>
<p>See an example for HBase storage.</p>
<div class="highlight-json"><div class="highlight"><pre><span class="p">{</span>
<span class="nt">"storages"</span><span class="p">:</span> <span class="p">{</span>
@@ -266,7 +266,7 @@
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -286,7 +286,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/storage_plugins/postgresql.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/storage_plugins/postgresql.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/storage_plugins/postgresql.html (original)
+++ tajo/site/docs/current/storage_plugins/postgresql.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>PostgreSQL Storage Handler — Apache Tajo 0.11.0 documentation</title>
+ <title>PostgreSQL Storage Handler — 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="Storage Plugin" href="../storage_plugins.html"/>
<link rel="next" title="Index (Experimental Feature)" href="../index_overview.html"/>
<link rel="prev" title="Storage Plugin Overview" href="overview.html"/>
@@ -217,7 +217,7 @@
</div>
<div class="section" id="configuration">
<h2>Configuration<a class="headerlink" href="#configuration" title="Permalink to this headline">¶</a></h2>
-<p>PostgreSQL storage handler is a builtin storage handler. So, you can eaisly register PostgreSQL databases to a Tajo cluster if you just add the following line to <code class="docutils literal"><span class="pre">conf/storage-site.json</span></code> file. If you want to know more information about <code class="docutils literal"><span class="pre">storage-site.json</span></code>, please refer to <a class="reference internal" href="../table_management/tablespaces.html"><em>Tablespaces</em></a>.</p>
+<p>PostgreSQL storage handler is a builtin storage handler. So, you can eaisly register PostgreSQL databases to a Tajo cluster if you just add the following line to <tt class="docutils literal"><span class="pre">conf/storage-site.json</span></tt> file. If you want to know more information about <tt class="docutils literal"><span class="pre">storage-site.json</span></tt>, please refer to <a class="reference internal" href="../table_management/tablespaces.html"><em>Tablespaces</em></a>.</p>
<div class="highlight-json"><div class="highlight"><pre><span class="p">{</span>
<span class="nt">"spaces"</span><span class="p">:</span> <span class="p">{</span>
<span class="nt">"pgsql_db1"</span><span class="p">:</span> <span class="p">{</span>
@@ -235,10 +235,10 @@
<span class="p">}</span>
</pre></div>
</div>
-<p><code class="docutils literal"><span class="pre">configs</span></code> allows users to specific additional configurations.
-<code class="docutils literal"><span class="pre">mapped_database</span></code> specifies a database name shown in Tajo. In the example, the database <code class="docutils literal"><span class="pre">db1</span></code> in PostgreSQL
-will be mapped to the database <code class="docutils literal"><span class="pre">tajo_db1</span></code> in Tajo.
-<code class="docutils literal"><span class="pre">connection_properties</span></code> allows users to set JDBC connection parameters.
+<p><tt class="docutils literal"><span class="pre">configs</span></tt> allows users to specific additional configurations.
+<tt class="docutils literal"><span class="pre">mapped_database</span></tt> specifies a database name shown in Tajo. In the example, the database <tt class="docutils literal"><span class="pre">db1</span></tt> in PostgreSQL
+will be mapped to the database <tt class="docutils literal"><span class="pre">tajo_db1</span></tt> in Tajo.
+<tt class="docutils literal"><span class="pre">connection_properties</span></tt> allows users to set JDBC connection parameters.
Please refer to <a class="reference external" href="https://jdbc.postgresql.org/documentation/head/connect.html">https://jdbc.postgresql.org/documentation/head/connect.html</a> in order to know the details of
PostgreSQL connection parameters.</p>
<p>The storage-site.json will be effective after you restart a tajo cluster.</p>
@@ -263,7 +263,7 @@ PostgreSQL connection parameters.</p>
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -283,7 +283,7 @@ PostgreSQL connection parameters.</p>
<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/swift_integration.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/swift_integration.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/swift_integration.html (original)
+++ tajo/site/docs/current/swift_integration.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>OpenStack Swift Integration — Apache Tajo 0.11.0 documentation</title>
+ <title>OpenStack Swift Integration — 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="Tajo JDBC Driver" href="jdbc_driver.html"/>
<link rel="prev" title="HBase Integration" href="hbase_integration.html"/>
@@ -215,13 +215,13 @@ You will also need to configure Swift an
<p>For details, please see the following sections.</p>
<div class="section" id="swift-configuration">
<h2>Swift configuration<a class="headerlink" href="#swift-configuration" title="Permalink to this headline">¶</a></h2>
-<p>This step is not mandatory, but is strongly recommended to configure the Swift’s proxy-server with <code class="docutils literal"><span class="pre">list_endpoints</span></code> for better performance.
+<p>This step is not mandatory, but is strongly recommended to configure the Swift’s proxy-server with <tt class="docutils literal"><span class="pre">list_endpoints</span></tt> for better performance.
More information is available <a class="reference external" href="http://docs.openstack.org/developer/swift/middleware.html#module-swift.common.middleware.list_endpoints">here</a>.</p>
</div>
<div class="section" id="hadoop-configurations">
<h2>Hadoop configurations<a class="headerlink" href="#hadoop-configurations" title="Permalink to this headline">¶</a></h2>
<p>You need to configure Hadoop to specify how to access Swift objects.
-Here is an example of <code class="docutils literal"><span class="pre">${HADOOP_HOME}/etc/hadoop/core-site.xml</span></code>.</p>
+Here is an example of <tt class="docutils literal"><span class="pre">${HADOOP_HOME}/etc/hadoop/core-site.xml</span></tt>.</p>
<div class="section" id="common-configurations">
<h3>Common configurations<a class="headerlink" href="#common-configurations" title="Permalink to this headline">¶</a></h3>
<div class="highlight-xml"><div class="highlight"><pre><span class="nt"><property></span>
@@ -283,8 +283,8 @@ Here is an example of <code class="docut
</div>
<div class="section" id="tajo-configuration">
<h2>Tajo configuration<a class="headerlink" href="#tajo-configuration" title="Permalink to this headline">¶</a></h2>
-<p>Finally, you need to configure the classpath of Tajo by adding the following line to <code class="docutils literal"><span class="pre">${TAJO_HOME}/conf/tajo-evn.sh</span></code>.</p>
-<div class="highlight-sh"><div class="highlight"><pre><span class="nb">export</span> <span class="nv">TAJO_CLASSPATH</span><span class="o">=</span>$HADOOP_HOME/share/hadoop/tools/lib/hadoop-openstack-x.x.x.jar
+<p>Finally, you need to configure the classpath of Tajo by adding the following line to <tt class="docutils literal"><span class="pre">${TAJO_HOME}/conf/tajo-evn.sh</span></tt>.</p>
+<div class="highlight-sh"><div class="highlight"><pre><span class="nb">export </span><span class="nv">TAJO_CLASSPATH</span><span class="o">=</span><span class="nv">$HADOOP_HOME</span>/share/hadoop/tools/lib/hadoop-openstack-x.x.x.jar
</pre></div>
</div>
</div>
@@ -317,7 +317,7 @@ For query execution details, please refe
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -337,7 +337,7 @@ For query execution details, please refe
<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/table_management.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/table_management.html (original)
+++ tajo/site/docs/current/table_management.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>Table Management — Apache Tajo 0.11.0 documentation</title>
+ <title>Table Management — 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="Overview of Tajo Tables" href="table_management/table_overview.html"/>
<link rel="prev" title="Python Functions" href="functions/python.html"/>
@@ -237,7 +237,7 @@
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -257,7 +257,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/table_management/compression.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management/compression.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/table_management/compression.html (original)
+++ tajo/site/docs/current/table_management/compression.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>Compression — Apache Tajo 0.11.0 documentation</title>
+ <title>Compression — 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="Table Management" href="../table_management.html"/>
<link rel="next" title="Table Partitioning" href="../table_partitioning.html"/>
<link rel="prev" title="SequenceFile" href="sequencefile.html"/>
@@ -216,8 +216,8 @@ Currently, compression configuration aff
<div class="section" id="compression-properties-for-each-data-format">
<h2>Compression Properties for each Data Format<a class="headerlink" href="#compression-properties-for-each-data-format" title="Permalink to this headline">¶</a></h2>
<blockquote>
-<div><table border="1" class="docutils" id="id3">
-<caption><span class="caption-text">Compression Properties</span><a class="headerlink" href="#id3" title="Permalink to this table">¶</a></caption>
+<div><table border="1" class="docutils">
+<caption>Compression Properties</caption>
<colgroup>
<col width="33%" />
<col width="33%" />
@@ -277,7 +277,7 @@ Currently, compression configuration aff
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -297,7 +297,7 @@ Currently, compression configuration aff
<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/table_management/data_formats.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management/data_formats.html?rev=1744489&r1=1744488&r2=1744489&view=diff
==============================================================================
--- tajo/site/docs/current/table_management/data_formats.html (original)
+++ tajo/site/docs/current/table_management/data_formats.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>Data Formats — Apache Tajo 0.11.0 documentation</title>
+ <title>Data Formats — 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="Table Management" href="../table_management.html"/>
<link rel="next" title="TEXT" href="text.html"/>
<link rel="prev" title="Tablespaces" href="tablespaces.html"/>
@@ -242,7 +242,7 @@
<div role="contentinfo">
<p>
- © Copyright 2015, Apache Tajo Team.
+ © Copyright 2016, Apache Tajo Team.
</p>
</div>
@@ -262,7 +262,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