Modified: tajo/site/docs/current/sql_language/ddl.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/ddl.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/sql_language/ddl.html (original) +++ tajo/site/docs/current/sql_language/ddl.html Tue Oct 27 10:40:08 2015 @@ -95,7 +95,9 @@ <li class="toctree-l2"><a class="reference internal" href="data_model.html">Data Model</a></li> <li class="toctree-l2 current"><a class="current reference internal" href="">Data Definition Language</a></li> <li class="toctree-l2"><a class="reference internal" href="insert.html">INSERT (OVERWRITE) INTO</a></li> +<li class="toctree-l2"><a class="reference internal" href="alter_table.html">ALTER TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="queries.html">Queries</a></li> +<li class="toctree-l2"><a class="reference internal" href="joins.html">Joins</a></li> <li class="toctree-l2"><a class="reference internal" href="sql_expression.html">SQL Expressions</a></li> <li class="toctree-l2"><a class="reference internal" href="predicates.html">Predicates</a></li> </ul> @@ -109,15 +111,15 @@ </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../functions.html">Functions</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../functions/math_func_and_operators.html">Math Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/string_func_and_operators.html">String Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/network_func_and_operators.html">Network Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/json_func.html">JSON Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-window-functions">Built-in Window Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#user-defined-functions">User-defined Functions</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> @@ -129,6 +131,11 @@ <li class="toctree-l2"><a class="reference internal" href="../partitioning/hash_partitioning.html">Hash Partitioning</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="../storage_plugins.html">Storage Plugin</a><ul> +<li class="toctree-l2"><a class="reference internal" href="../storage_plugins/overview.html">Storage Plugin Overview</a></li> +<li class="toctree-l2"><a class="reference internal" href="../storage_plugins/postgresql.html">PostgreSQL Storage Handler</a></li> +</ul> +</li> <li class="toctree-l1"><a class="reference internal" href="../index_overview.html">Index (Experimental Feature)</a><ul> <li class="toctree-l2"><a class="reference internal" href="../index/types.html">Index Types</a></li> <li class="toctree-l2"><a class="reference internal" href="../index/how_to_use.html">How to use index?</a></li> @@ -139,7 +146,7 @@ <li class="toctree-l2"><a class="reference internal" href="../backup_and_restore/catalog.html">Backup and Restore Catalog</a></li> </ul> </li> -<li class="toctree-l1"><a class="reference internal" href="../hcatalog_integration.html">HCatalog Integration</a></li> +<li class="toctree-l1"><a class="reference internal" href="../hive_integration.html">Hive Integration</a></li> <li class="toctree-l1"><a class="reference internal" href="../hbase_integration.html">HBase Integration</a><ul> <li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#create-table">CREATE TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#drop-table">DROP TABLE</a></li> @@ -157,6 +164,8 @@ <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -206,7 +215,9 @@ <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">DATABASE</span> <span class="p">[</span><span class="n">IF</span> <span class="k">NOT</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">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> +<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> </div> <div class="section" id="drop-database"> <h2>DROP DATABASE<a class="headerlink" href="#drop-database" title="Permalink to this headline">¶</a></h2> @@ -219,13 +230,18 @@ <div class="section" id="create-table"> <h2>CREATE TABLE<a class="headerlink" href="#create-table" title="Permalink to this headline">¶</a></h2> <p><em>Synopsis</em></p> -<div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="p">[</span><span class="n">IF</span> <span class="k">NOT</span> <span class="k">EXISTS</span><span class="p">]</span> <span class="o"><</span><span class="k">table_name</span><span class="o">></span> <span class="p">[(</span><span class="o"><</span><span class="k">column_name</span><span class="o">></span> <span class="o"><</span><span class="n">data_type</span><span class="o">></span><span class="p">,</span> <span class="p">...</span> <span class="p">)]</span> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="p">[</span><span class="n">IF</span> <span class="k">NOT</span> <span class="k">EXISTS</span><span class="p">]</span> <span class="o"><</span><span class="k">table_name</span><span class="o">></span> <span class="p">[(</span><span class="n">column_list</span><span class="p">)]</span> <span class="p">[</span><span class="n">TABLESPACE</span> <span class="n">tablespace_name</span><span class="p">]</span> <span class="p">[</span><span class="k">using</span> <span class="o"><</span><span class="n">storage_type</span><span class="o">></span> <span class="p">[</span><span class="k">with</span> <span class="p">(</span><span class="o"><</span><span class="k">key</span><span class="o">></span> <span class="o">=</span> <span class="o"><</span><span class="n">value</span><span class="o">></span><span class="p">,</span> <span class="p">...)]]</span> <span class="p">[</span><span class="k">AS</span> <span class="o"><</span><span class="n">select_statement</span><span class="o">></span><span class="p">]</span> -<span class="k">CREATE</span> <span class="k">EXTERNAL</span> <span class="k">TABLE</span> <span class="p">[</span><span class="n">IF</span> <span class="k">NOT</span> <span class="k">EXISTS</span><span class="p">]</span> <span class="o"><</span><span class="k">table_name</span><span class="o">></span> <span class="p">(</span><span class="o"><</span><span class="k">column_name</span><span class="o">></span> <span class="o"><</span><span class="n">data_type</span><span class="o">></span><span class="p">,</span> <span class="p">...</span> <span class="p">)</span> +<span class="k">CREATE</span> <span class="k">EXTERNAL</span> <span class="k">TABLE</span> <span class="p">[</span><span class="n">IF</span> <span class="k">NOT</span> <span class="k">EXISTS</span><span class="p">]</span> <span class="o"><</span><span class="k">table_name</span><span class="o">></span> <span class="p">(</span><span class="n">column_list</span><span class="p">)</span> <span class="k">using</span> <span class="o"><</span><span class="n">storage_type</span><span class="o">></span> <span class="p">[</span><span class="k">with</span> <span class="p">(</span><span class="o"><</span><span class="k">key</span><span class="o">></span> <span class="o">=</span> <span class="o"><</span><span class="n">value</span><span class="o">></span><span class="p">,</span> <span class="p">...)]</span> <span class="k">LOCATION</span> <span class="s1">'<path>'</span> </pre></div> </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. +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> <div class="section" id="compression"> <h3>Compression<a class="headerlink" href="#compression" title="Permalink to this headline">¶</a></h3> @@ -236,7 +252,7 @@ <span class="p">...</span> <span class="n">L_COMMENT</span> <span class="nb">text</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">'compression.codec'</span><span class="o">=</span><span class="s1">'org.apache.hadoop.io.compress.DeflateCodec'</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">'compression.codec'</span><span class="o">=</span><span class="s1">'org.apache.hadoop.io.compress.SnappyCodec'</span><span class="p">)</span> <span class="k">LOCATION</span> <span class="s1">'hdfs://localhost:9010/tajo/warehouse/lineitem_100_snappy'</span><span class="p">;</span> </pre></div> </div> @@ -258,6 +274,7 @@ <div class="highlight-sql"><div class="highlight"><pre><span class="k">DROP</span> <span class="k">TABLE</span> <span class="p">[</span><span class="n">IF</span> <span class="k">EXISTS</span><span class="p">]</span> <span class="o"><</span><span class="k">table_name</span><span class="o">></span> <span class="p">[</span><span class="n">PURGE</span><span class="p">]</span> </pre></div> </div> +<p><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> </div> <div class="section" id="create-index"> @@ -268,6 +285,9 @@ [ WHERE predicate ] </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>. +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> <p>Currently, Tajo supports only one type of index.</p>
Modified: tajo/site/docs/current/sql_language/insert.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/insert.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/sql_language/insert.html (original) +++ tajo/site/docs/current/sql_language/insert.html Tue Oct 27 10:40:08 2015 @@ -30,7 +30,7 @@ <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> <link rel="up" title="SQL Language" href="../sql_language.html"/> - <link rel="next" title="Queries" href="queries.html"/> + <link rel="next" title="ALTER TABLE" href="alter_table.html"/> <link rel="prev" title="Data Definition Language" href="ddl.html"/> @@ -95,7 +95,9 @@ <li class="toctree-l2"><a class="reference internal" href="data_model.html">Data Model</a></li> <li class="toctree-l2"><a class="reference internal" href="ddl.html">Data Definition Language</a></li> <li class="toctree-l2 current"><a class="current reference internal" href="">INSERT (OVERWRITE) INTO</a></li> +<li class="toctree-l2"><a class="reference internal" href="alter_table.html">ALTER TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="queries.html">Queries</a></li> +<li class="toctree-l2"><a class="reference internal" href="joins.html">Joins</a></li> <li class="toctree-l2"><a class="reference internal" href="sql_expression.html">SQL Expressions</a></li> <li class="toctree-l2"><a class="reference internal" href="predicates.html">Predicates</a></li> </ul> @@ -109,15 +111,15 @@ </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../functions.html">Functions</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../functions/math_func_and_operators.html">Math Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/string_func_and_operators.html">String Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/network_func_and_operators.html">Network Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/json_func.html">JSON Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-window-functions">Built-in Window Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#user-defined-functions">User-defined Functions</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> @@ -129,6 +131,11 @@ <li class="toctree-l2"><a class="reference internal" href="../partitioning/hash_partitioning.html">Hash Partitioning</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="../storage_plugins.html">Storage Plugin</a><ul> +<li class="toctree-l2"><a class="reference internal" href="../storage_plugins/overview.html">Storage Plugin Overview</a></li> +<li class="toctree-l2"><a class="reference internal" href="../storage_plugins/postgresql.html">PostgreSQL Storage Handler</a></li> +</ul> +</li> <li class="toctree-l1"><a class="reference internal" href="../index_overview.html">Index (Experimental Feature)</a><ul> <li class="toctree-l2"><a class="reference internal" href="../index/types.html">Index Types</a></li> <li class="toctree-l2"><a class="reference internal" href="../index/how_to_use.html">How to use index?</a></li> @@ -139,7 +146,7 @@ <li class="toctree-l2"><a class="reference internal" href="../backup_and_restore/catalog.html">Backup and Restore Catalog</a></li> </ul> </li> -<li class="toctree-l1"><a class="reference internal" href="../hcatalog_integration.html">HCatalog Integration</a></li> +<li class="toctree-l1"><a class="reference internal" href="../hive_integration.html">Hive Integration</a></li> <li class="toctree-l1"><a class="reference internal" href="../hbase_integration.html">HBase Integration</a><ul> <li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#create-table">CREATE TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#drop-table">DROP TABLE</a></li> @@ -157,6 +164,8 @@ <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -227,7 +236,7 @@ <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation"> - <a href="queries.html" class="btn btn-neutral float-right" title="Queries"/>Next <span class="fa fa-arrow-circle-right"></span></a> + <a href="alter_table.html" class="btn btn-neutral float-right" title="ALTER TABLE"/>Next <span class="fa fa-arrow-circle-right"></span></a> <a href="ddl.html" class="btn btn-neutral" title="Data Definition Language"><span class="fa fa-arrow-circle-left"></span> Previous</a> Modified: tajo/site/docs/current/sql_language/predicates.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/predicates.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/sql_language/predicates.html (original) +++ tajo/site/docs/current/sql_language/predicates.html Tue Oct 27 10:40:08 2015 @@ -95,7 +95,9 @@ <li class="toctree-l2"><a class="reference internal" href="data_model.html">Data Model</a></li> <li class="toctree-l2"><a class="reference internal" href="ddl.html">Data Definition Language</a></li> <li class="toctree-l2"><a class="reference internal" href="insert.html">INSERT (OVERWRITE) INTO</a></li> +<li class="toctree-l2"><a class="reference internal" href="alter_table.html">ALTER TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="queries.html">Queries</a></li> +<li class="toctree-l2"><a class="reference internal" href="joins.html">Joins</a></li> <li class="toctree-l2"><a class="reference internal" href="sql_expression.html">SQL Expressions</a></li> <li class="toctree-l2 current"><a class="current reference internal" href="">Predicates</a></li> </ul> @@ -109,15 +111,15 @@ </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../functions.html">Functions</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../functions/math_func_and_operators.html">Math Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/string_func_and_operators.html">String Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/network_func_and_operators.html">Network Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/json_func.html">JSON Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-window-functions">Built-in Window Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#user-defined-functions">User-defined Functions</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> @@ -129,6 +131,11 @@ <li class="toctree-l2"><a class="reference internal" href="../partitioning/hash_partitioning.html">Hash Partitioning</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="../storage_plugins.html">Storage Plugin</a><ul> +<li class="toctree-l2"><a class="reference internal" href="../storage_plugins/overview.html">Storage Plugin Overview</a></li> +<li class="toctree-l2"><a class="reference internal" href="../storage_plugins/postgresql.html">PostgreSQL Storage Handler</a></li> +</ul> +</li> <li class="toctree-l1"><a class="reference internal" href="../index_overview.html">Index (Experimental Feature)</a><ul> <li class="toctree-l2"><a class="reference internal" href="../index/types.html">Index Types</a></li> <li class="toctree-l2"><a class="reference internal" href="../index/how_to_use.html">How to use index?</a></li> @@ -139,7 +146,7 @@ <li class="toctree-l2"><a class="reference internal" href="../backup_and_restore/catalog.html">Backup and Restore Catalog</a></li> </ul> </li> -<li class="toctree-l1"><a class="reference internal" href="../hcatalog_integration.html">HCatalog Integration</a></li> +<li class="toctree-l1"><a class="reference internal" href="../hive_integration.html">Hive Integration</a></li> <li class="toctree-l1"><a class="reference internal" href="../hbase_integration.html">HBase Integration</a><ul> <li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#create-table">CREATE TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#drop-table">DROP TABLE</a></li> @@ -157,6 +164,8 @@ <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> Modified: tajo/site/docs/current/sql_language/queries.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/queries.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/sql_language/queries.html (original) +++ tajo/site/docs/current/sql_language/queries.html Tue Oct 27 10:40:08 2015 @@ -30,8 +30,8 @@ <link rel="top" title="Apache Tajo 0.11.0 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="INSERT (OVERWRITE) INTO" href="insert.html"/> + <link rel="next" title="Joins" href="joins.html"/> + <link rel="prev" title="ALTER TABLE" href="alter_table.html"/> <script src="https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js";></script> @@ -95,7 +95,9 @@ <li class="toctree-l2"><a class="reference internal" href="data_model.html">Data Model</a></li> <li class="toctree-l2"><a class="reference internal" href="ddl.html">Data Definition Language</a></li> <li class="toctree-l2"><a class="reference internal" href="insert.html">INSERT (OVERWRITE) INTO</a></li> +<li class="toctree-l2"><a class="reference internal" href="alter_table.html">ALTER TABLE</a></li> <li class="toctree-l2 current"><a class="current reference internal" href="">Queries</a></li> +<li class="toctree-l2"><a class="reference internal" href="joins.html">Joins</a></li> <li class="toctree-l2"><a class="reference internal" href="sql_expression.html">SQL Expressions</a></li> <li class="toctree-l2"><a class="reference internal" href="predicates.html">Predicates</a></li> </ul> @@ -109,15 +111,15 @@ </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../functions.html">Functions</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../functions/math_func_and_operators.html">Math Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/string_func_and_operators.html">String Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/network_func_and_operators.html">Network Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/json_func.html">JSON Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-window-functions">Built-in Window Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#user-defined-functions">User-defined Functions</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> @@ -129,6 +131,11 @@ <li class="toctree-l2"><a class="reference internal" href="../partitioning/hash_partitioning.html">Hash Partitioning</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="../storage_plugins.html">Storage Plugin</a><ul> +<li class="toctree-l2"><a class="reference internal" href="../storage_plugins/overview.html">Storage Plugin Overview</a></li> +<li class="toctree-l2"><a class="reference internal" href="../storage_plugins/postgresql.html">PostgreSQL Storage Handler</a></li> +</ul> +</li> <li class="toctree-l1"><a class="reference internal" href="../index_overview.html">Index (Experimental Feature)</a><ul> <li class="toctree-l2"><a class="reference internal" href="../index/types.html">Index Types</a></li> <li class="toctree-l2"><a class="reference internal" href="../index/how_to_use.html">How to use index?</a></li> @@ -139,7 +146,7 @@ <li class="toctree-l2"><a class="reference internal" href="../backup_and_restore/catalog.html">Backup and Restore Catalog</a></li> </ul> </li> -<li class="toctree-l1"><a class="reference internal" href="../hcatalog_integration.html">HCatalog Integration</a></li> +<li class="toctree-l1"><a class="reference internal" href="../hive_integration.html">Hive Integration</a></li> <li class="toctree-l1"><a class="reference internal" href="../hbase_integration.html">HBase Integration</a><ul> <li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#create-table">CREATE TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#drop-table">DROP TABLE</a></li> @@ -157,6 +164,8 @@ <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -284,6 +293,7 @@ For example:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">FROM</span> <span class="p">(</span><span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">table1</span><span class="p">)</span> <span class="k">AS</span> <span class="n">alias_name</span> </pre></div> </div> +<p>For more detailed information, please refer to <a class="reference internal" href="joins.html"><em>Joins</em></a>.</p> </div> </div> </div> @@ -389,10 +399,10 @@ the same partition as the current row.</ <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation"> - <a href="sql_expression.html" class="btn btn-neutral float-right" title="SQL Expressions"/>Next <span class="fa fa-arrow-circle-right"></span></a> + <a href="joins.html" class="btn btn-neutral float-right" title="Joins"/>Next <span class="fa fa-arrow-circle-right"></span></a> - <a href="insert.html" class="btn btn-neutral" title="INSERT (OVERWRITE) INTO"><span class="fa fa-arrow-circle-left"></span> Previous</a> + <a href="alter_table.html" class="btn btn-neutral" title="ALTER TABLE"><span class="fa fa-arrow-circle-left"></span> Previous</a> </div> 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=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/sql_language/sql_expression.html (original) +++ tajo/site/docs/current/sql_language/sql_expression.html Tue Oct 27 10:40:08 2015 @@ -31,7 +31,7 @@ <link rel="top" title="Apache Tajo 0.11.0 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="Queries" href="queries.html"/> + <link rel="prev" title="Joins" href="joins.html"/> <script src="https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js";></script> @@ -95,7 +95,9 @@ <li class="toctree-l2"><a class="reference internal" href="data_model.html">Data Model</a></li> <li class="toctree-l2"><a class="reference internal" href="ddl.html">Data Definition Language</a></li> <li class="toctree-l2"><a class="reference internal" href="insert.html">INSERT (OVERWRITE) INTO</a></li> +<li class="toctree-l2"><a class="reference internal" href="alter_table.html">ALTER TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="queries.html">Queries</a></li> +<li class="toctree-l2"><a class="reference internal" href="joins.html">Joins</a></li> <li class="toctree-l2 current"><a class="current reference internal" href="">SQL Expressions</a></li> <li class="toctree-l2"><a class="reference internal" href="predicates.html">Predicates</a></li> </ul> @@ -109,15 +111,15 @@ </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../functions.html">Functions</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../functions/math_func_and_operators.html">Math Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/string_func_and_operators.html">String Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/network_func_and_operators.html">Network Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/json_func.html">JSON Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-window-functions">Built-in Window Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#user-defined-functions">User-defined Functions</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> @@ -129,6 +131,11 @@ <li class="toctree-l2"><a class="reference internal" href="../partitioning/hash_partitioning.html">Hash Partitioning</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="../storage_plugins.html">Storage Plugin</a><ul> +<li class="toctree-l2"><a class="reference internal" href="../storage_plugins/overview.html">Storage Plugin Overview</a></li> +<li class="toctree-l2"><a class="reference internal" href="../storage_plugins/postgresql.html">PostgreSQL Storage Handler</a></li> +</ul> +</li> <li class="toctree-l1"><a class="reference internal" href="../index_overview.html">Index (Experimental Feature)</a><ul> <li class="toctree-l2"><a class="reference internal" href="../index/types.html">Index Types</a></li> <li class="toctree-l2"><a class="reference internal" href="../index/how_to_use.html">How to use index?</a></li> @@ -139,7 +146,7 @@ <li class="toctree-l2"><a class="reference internal" href="../backup_and_restore/catalog.html">Backup and Restore Catalog</a></li> </ul> </li> -<li class="toctree-l1"><a class="reference internal" href="../hcatalog_integration.html">HCatalog Integration</a></li> +<li class="toctree-l1"><a class="reference internal" href="../hive_integration.html">Hive Integration</a></li> <li class="toctree-l1"><a class="reference internal" href="../hbase_integration.html">HBase Integration</a><ul> <li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#create-table">CREATE TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#drop-table">DROP TABLE</a></li> @@ -157,6 +164,8 @@ <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -210,15 +219,47 @@ <span class="n">expression</span><span class="p">::</span><span class="k">type</span> </pre></div> </div> +<p>In addition, several functions are provided for type conversion. Please refer to <a class="reference internal" href="../functions/data_type_func_and_operators.html"><em>Data Type Functions and Operators</em></a> and <a class="reference internal" href="../functions/datetime_func_and_operators.html"><em>DateTime Functions and Operators</em></a>.</p> +</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> +<div class="highlight-sql"><div class="highlight"><pre><span class="s1">'tajo'</span> +</pre></div> </div> -<div class="section" id="string-expressions"> -<h2>String Expressions<a class="headerlink" href="#string-expressions" title="Permalink to this headline">¶</a></h2> </div> -<div class="section" id="function-call"> -<h2>Function Call<a class="headerlink" href="#function-call" title="Permalink to this headline">¶</a></h2> +<div class="section" id="function-calls"> +<h2>Function Calls<a class="headerlink" href="#function-calls" title="Permalink to this headline">¶</a></h2> +<p>The syntax for a function call consists of the name of a function and its argument list enclosed in parentheses:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="n">function_name</span> <span class="p">([</span><span class="n">expression</span> <span class="p">[,</span> <span class="n">expression</span> <span class="p">...</span> <span class="p">]]</span> <span class="p">)</span> </pre></div> </div> +<p>For more information about functions, please refer to <a class="reference internal" href="../functions.html"><em>Functions</em></a>.</p> +</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> +<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> +<p>where <em>function_name</em> is the name of aggregation function. Any aggregation function or window function can be used. For built-in aggregation functions and window functions, please refer to <a class="reference internal" href="../functions/agg_func.html"><em>Aggregation Functions</em></a> and <a class="reference internal" href="../functions/window_func.html"><em>Window Functions</em></a>.</p> +<p><em>window_definition</em> has the following syntax.</p> +<div class="highlight-sql"><div class="highlight"><pre>[ PARTITION BY expression [, ...] ] +[ ORDER BY expression [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] ] +</pre></div> +</div> +<p>In the above syntax, <em>expression</em> can be any expression except window function call itself. +<em>PARTITION BY</em> and <em>ORDER BY</em> lists have the same syntax and semantics as <em>GROUP BY</em> and <em>ORDER BY</em> clauses. +That is, <em>PARTITION BY</em> list describes how the output result will be partitioned like <em>GROUP BY</em> clause creates multiple partitions according to the value of its expression. +With <em>ORDER BY</em> list, result values are sorted in each partition.</p> +<p>Here are some examples.</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> <span class="n">row_number</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="k">count</span><span class="p">(</span><span class="o">*</span><span class="p">)</span> <span class="k">desc</span><span class="p">)</span> <span class="n">row_num</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="k">order</span> <span class="k">by</span> <span class="n">l_orderkey</span><span class="p">;</span> + +<span class="k">select</span> <span class="n">o_custkey</span><span class="p">,</span> <span class="n">o_orderstatus</span><span class="p">,</span> <span class="k">sum</span><span class="p">(</span><span class="n">o_totalprice</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">o_custkey</span><span class="p">)</span> <span class="k">as</span> <span class="n">price</span> <span class="k">from</span> <span class="n">orders</span><span class="p">;</span> + +<span class="k">select</span> <span class="n">l_linenumber</span><span class="p">,</span> <span class="n">l_tax</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_linenumber</span> <span class="k">order</span> <span class="k">by</span> <span class="n">l_tax</span> <span class="k">desc</span><span class="p">)</span> <span class="k">as</span> <span class="n">quantity</span><span class="p">,</span> <span class="k">avg</span><span class="p">(</span><span class="n">l_extendedprice</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_shipdate</span><span class="p">)</span> <span class="k">from</span> <span class="n">lineitem</span> <span class="k">order</span> <span clas s="k">by</span> <span class="n">l_tax</span><span class="p">;</span> +</pre></div> +</div> </div> </div> @@ -231,7 +272,7 @@ <a href="predicates.html" class="btn btn-neutral float-right" title="Predicates"/>Next <span class="fa fa-arrow-circle-right"></span></a> - <a href="queries.html" class="btn btn-neutral" title="Queries"><span class="fa fa-arrow-circle-left"></span> Previous</a> + <a href="joins.html" class="btn btn-neutral" title="Joins"><span class="fa fa-arrow-circle-left"></span> Previous</a> </div> Modified: tajo/site/docs/current/swift_integration.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/swift_integration.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/swift_integration.html (original) +++ tajo/site/docs/current/swift_integration.html Tue Oct 27 10:40:08 2015 @@ -94,7 +94,9 @@ <li class="toctree-l2"><a class="reference internal" href="sql_language/data_model.html">Data Model</a></li> <li class="toctree-l2"><a class="reference internal" href="sql_language/ddl.html">Data Definition Language</a></li> <li class="toctree-l2"><a class="reference internal" href="sql_language/insert.html">INSERT (OVERWRITE) INTO</a></li> +<li class="toctree-l2"><a class="reference internal" href="sql_language/alter_table.html">ALTER TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="sql_language/queries.html">Queries</a></li> +<li class="toctree-l2"><a class="reference internal" href="sql_language/joins.html">Joins</a></li> <li class="toctree-l2"><a class="reference internal" href="sql_language/sql_expression.html">SQL Expressions</a></li> <li class="toctree-l2"><a class="reference internal" href="sql_language/predicates.html">Predicates</a></li> </ul> @@ -108,15 +110,15 @@ </ul> </li> <li class="toctree-l1"><a class="reference internal" href="functions.html">Functions</a><ul> -<li class="toctree-l2"><a class="reference internal" href="functions/math_func_and_operators.html">Math Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="functions/string_func_and_operators.html">String Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="functions/network_func_and_operators.html">Network Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="functions/json_func.html">JSON Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-window-functions">Built-in Window Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#user-defined-functions">User-defined Functions</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="table_management/table_overview.html">Overview of Tajo Tables</a></li> +<li class="toctree-l2"><a class="reference internal" href="table_management/tablespaces.html">Tablespaces</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/file_formats.html">File Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/compression.html">Compression</a></li> </ul> @@ -128,6 +130,11 @@ <li class="toctree-l2"><a class="reference internal" href="partitioning/hash_partitioning.html">Hash Partitioning</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="storage_plugins.html">Storage Plugin</a><ul> +<li class="toctree-l2"><a class="reference internal" href="storage_plugins/overview.html">Storage Plugin Overview</a></li> +<li class="toctree-l2"><a class="reference internal" href="storage_plugins/postgresql.html">PostgreSQL Storage Handler</a></li> +</ul> +</li> <li class="toctree-l1"><a class="reference internal" href="index_overview.html">Index (Experimental Feature)</a><ul> <li class="toctree-l2"><a class="reference internal" href="index/types.html">Index Types</a></li> <li class="toctree-l2"><a class="reference internal" href="index/how_to_use.html">How to use index?</a></li> @@ -138,7 +145,7 @@ <li class="toctree-l2"><a class="reference internal" href="backup_and_restore/catalog.html">Backup and Restore Catalog</a></li> </ul> </li> -<li class="toctree-l1"><a class="reference internal" href="hcatalog_integration.html">HCatalog Integration</a></li> +<li class="toctree-l1"><a class="reference internal" href="hive_integration.html">Hive Integration</a></li> <li class="toctree-l1"><a class="reference internal" href="hbase_integration.html">HBase Integration</a><ul> <li class="toctree-l2"><a class="reference internal" href="hbase_integration.html#create-table">CREATE TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="hbase_integration.html#drop-table">DROP TABLE</a></li> @@ -156,6 +163,8 @@ <li class="toctree-l1"><a class="reference internal" href="jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> Modified: tajo/site/docs/current/table_management.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/table_management.html (original) +++ tajo/site/docs/current/table_management.html Tue Oct 27 10:40:08 2015 @@ -30,7 +30,7 @@ <link rel="top" title="Apache Tajo 0.11.0 documentation" href="index.html"/> <link rel="next" title="Overview of Tajo Tables" href="table_management/table_overview.html"/> - <link rel="prev" title="JSON Functions" href="functions/json_func.html"/> + <link rel="prev" title="Python Functions" href="functions/python.html"/> <script src="https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js";></script> @@ -94,7 +94,9 @@ <li class="toctree-l2"><a class="reference internal" href="sql_language/data_model.html">Data Model</a></li> <li class="toctree-l2"><a class="reference internal" href="sql_language/ddl.html">Data Definition Language</a></li> <li class="toctree-l2"><a class="reference internal" href="sql_language/insert.html">INSERT (OVERWRITE) INTO</a></li> +<li class="toctree-l2"><a class="reference internal" href="sql_language/alter_table.html">ALTER TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="sql_language/queries.html">Queries</a></li> +<li class="toctree-l2"><a class="reference internal" href="sql_language/joins.html">Joins</a></li> <li class="toctree-l2"><a class="reference internal" href="sql_language/sql_expression.html">SQL Expressions</a></li> <li class="toctree-l2"><a class="reference internal" href="sql_language/predicates.html">Predicates</a></li> </ul> @@ -108,15 +110,15 @@ </ul> </li> <li class="toctree-l1"><a class="reference internal" href="functions.html">Functions</a><ul> -<li class="toctree-l2"><a class="reference internal" href="functions/math_func_and_operators.html">Math Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="functions/string_func_and_operators.html">String Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="functions/network_func_and_operators.html">Network Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="functions/json_func.html">JSON Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-window-functions">Built-in Window Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#user-defined-functions">User-defined Functions</a></li> </ul> </li> <li class="toctree-l1 current"><a class="current reference internal" href="">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="table_management/table_overview.html">Overview of Tajo Tables</a></li> +<li class="toctree-l2"><a class="reference internal" href="table_management/tablespaces.html">Tablespaces</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/file_formats.html">File Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/compression.html">Compression</a></li> </ul> @@ -128,6 +130,11 @@ <li class="toctree-l2"><a class="reference internal" href="partitioning/hash_partitioning.html">Hash Partitioning</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="storage_plugins.html">Storage Plugin</a><ul> +<li class="toctree-l2"><a class="reference internal" href="storage_plugins/overview.html">Storage Plugin Overview</a></li> +<li class="toctree-l2"><a class="reference internal" href="storage_plugins/postgresql.html">PostgreSQL Storage Handler</a></li> +</ul> +</li> <li class="toctree-l1"><a class="reference internal" href="index_overview.html">Index (Experimental Feature)</a><ul> <li class="toctree-l2"><a class="reference internal" href="index/types.html">Index Types</a></li> <li class="toctree-l2"><a class="reference internal" href="index/how_to_use.html">How to use index?</a></li> @@ -138,7 +145,7 @@ <li class="toctree-l2"><a class="reference internal" href="backup_and_restore/catalog.html">Backup and Restore Catalog</a></li> </ul> </li> -<li class="toctree-l1"><a class="reference internal" href="hcatalog_integration.html">HCatalog Integration</a></li> +<li class="toctree-l1"><a class="reference internal" href="hive_integration.html">Hive Integration</a></li> <li class="toctree-l1"><a class="reference internal" href="hbase_integration.html">HBase Integration</a><ul> <li class="toctree-l2"><a class="reference internal" href="hbase_integration.html#create-table">CREATE TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="hbase_integration.html#drop-table">DROP TABLE</a></li> @@ -156,6 +163,8 @@ <li class="toctree-l1"><a class="reference internal" href="jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -201,6 +210,7 @@ <div class="toctree-wrapper compound"> <ul> <li class="toctree-l1"><a class="reference internal" href="table_management/table_overview.html">Overview of Tajo Tables</a></li> +<li class="toctree-l1"><a class="reference internal" href="table_management/tablespaces.html">Tablespaces</a></li> <li class="toctree-l1"><a class="reference internal" href="table_management/file_formats.html">File Formats</a></li> <li class="toctree-l1"><a class="reference internal" href="table_management/compression.html">Compression</a></li> </ul> @@ -216,7 +226,7 @@ <a href="table_management/table_overview.html" class="btn btn-neutral float-right" title="Overview of Tajo Tables"/>Next <span class="fa fa-arrow-circle-right"></span></a> - <a href="functions/json_func.html" class="btn btn-neutral" title="JSON Functions"><span class="fa fa-arrow-circle-left"></span> Previous</a> + <a href="functions/python.html" class="btn btn-neutral" title="Python Functions"><span class="fa fa-arrow-circle-left"></span> Previous</a> </div> Modified: tajo/site/docs/current/table_management/compression.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management/compression.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/table_management/compression.html (original) +++ tajo/site/docs/current/table_management/compression.html Tue Oct 27 10:40:08 2015 @@ -95,7 +95,9 @@ <li class="toctree-l2"><a class="reference internal" href="../sql_language/data_model.html">Data Model</a></li> <li class="toctree-l2"><a class="reference internal" href="../sql_language/ddl.html">Data Definition Language</a></li> <li class="toctree-l2"><a class="reference internal" href="../sql_language/insert.html">INSERT (OVERWRITE) INTO</a></li> +<li class="toctree-l2"><a class="reference internal" href="../sql_language/alter_table.html">ALTER TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="../sql_language/queries.html">Queries</a></li> +<li class="toctree-l2"><a class="reference internal" href="../sql_language/joins.html">Joins</a></li> <li class="toctree-l2"><a class="reference internal" href="../sql_language/sql_expression.html">SQL Expressions</a></li> <li class="toctree-l2"><a class="reference internal" href="../sql_language/predicates.html">Predicates</a></li> </ul> @@ -109,15 +111,15 @@ </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../functions.html">Functions</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../functions/math_func_and_operators.html">Math Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/string_func_and_operators.html">String Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/network_func_and_operators.html">Network Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/json_func.html">JSON Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-window-functions">Built-in Window Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#user-defined-functions">User-defined Functions</a></li> </ul> </li> <li class="toctree-l1 current"><a class="reference internal" href="../table_management.html">Table Management</a><ul class="current"> <li class="toctree-l2"><a class="reference internal" href="table_overview.html">Overview of Tajo Tables</a></li> +<li class="toctree-l2"><a class="reference internal" href="tablespaces.html">Tablespaces</a></li> <li class="toctree-l2"><a class="reference internal" href="file_formats.html">File Formats</a></li> <li class="toctree-l2 current"><a class="current reference internal" href="">Compression</a></li> </ul> @@ -129,6 +131,11 @@ <li class="toctree-l2"><a class="reference internal" href="../partitioning/hash_partitioning.html">Hash Partitioning</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="../storage_plugins.html">Storage Plugin</a><ul> +<li class="toctree-l2"><a class="reference internal" href="../storage_plugins/overview.html">Storage Plugin Overview</a></li> +<li class="toctree-l2"><a class="reference internal" href="../storage_plugins/postgresql.html">PostgreSQL Storage Handler</a></li> +</ul> +</li> <li class="toctree-l1"><a class="reference internal" href="../index_overview.html">Index (Experimental Feature)</a><ul> <li class="toctree-l2"><a class="reference internal" href="../index/types.html">Index Types</a></li> <li class="toctree-l2"><a class="reference internal" href="../index/how_to_use.html">How to use index?</a></li> @@ -139,7 +146,7 @@ <li class="toctree-l2"><a class="reference internal" href="../backup_and_restore/catalog.html">Backup and Restore Catalog</a></li> </ul> </li> -<li class="toctree-l1"><a class="reference internal" href="../hcatalog_integration.html">HCatalog Integration</a></li> +<li class="toctree-l1"><a class="reference internal" href="../hive_integration.html">Hive Integration</a></li> <li class="toctree-l1"><a class="reference internal" href="../hbase_integration.html">HBase Integration</a><ul> <li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#create-table">CREATE TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#drop-table">DROP TABLE</a></li> @@ -157,6 +164,8 @@ <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> Modified: tajo/site/docs/current/table_management/csv.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management/csv.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/table_management/csv.html (original) +++ tajo/site/docs/current/table_management/csv.html Tue Oct 27 10:40:08 2015 @@ -7,7 +7,7 @@ <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> - <title>CSV (TextFile) — Apache Tajo 0.10.0 documentation</title> + <title>CSV (TextFile) — Apache Tajo 0.11.0 documentation</title> @@ -28,7 +28,7 @@ - <link rel="top" title="Apache Tajo 0.10.0 documentation" href="../index.html"/> + <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> <link rel="up" title="File Formats" href="file_formats.html"/> <link rel="next" title="RCFile" href="rcfile.html"/> <link rel="prev" title="File Formats" href="file_formats.html"/> @@ -146,11 +146,17 @@ <li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#usage">Usage</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="../swift_integration.html">OpenStack Swift Integration</a><ul> +<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#swift-configuration">Swift configuration</a></li> +<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#hadoop-configurations">Hadoop configurations</a></li> +<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#tajo-configuration">Tajo configuration</a></li> +<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#querying-on-swift">Querying on Swift</a></li> +</ul> +</li> <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> -<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../tajo_client_api.html">Tajo Client API</a></li> @@ -326,7 +332,7 @@ clause in a Hive’s <tt class="docu <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT:'../', - VERSION:'0.10.0', + VERSION:'0.11.0', COLLAPSE_INDEX:false, FILE_SUFFIX:'.html', HAS_SOURCE: true Modified: tajo/site/docs/current/table_management/file_formats.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management/file_formats.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/table_management/file_formats.html (original) +++ tajo/site/docs/current/table_management/file_formats.html Tue Oct 27 10:40:08 2015 @@ -31,7 +31,7 @@ <link rel="top" title="Apache Tajo 0.11.0 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="Overview of Tajo Tables" href="table_overview.html"/> + <link rel="prev" title="Tablespaces" href="tablespaces.html"/> <script src="https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js";></script> @@ -95,7 +95,9 @@ <li class="toctree-l2"><a class="reference internal" href="../sql_language/data_model.html">Data Model</a></li> <li class="toctree-l2"><a class="reference internal" href="../sql_language/ddl.html">Data Definition Language</a></li> <li class="toctree-l2"><a class="reference internal" href="../sql_language/insert.html">INSERT (OVERWRITE) INTO</a></li> +<li class="toctree-l2"><a class="reference internal" href="../sql_language/alter_table.html">ALTER TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="../sql_language/queries.html">Queries</a></li> +<li class="toctree-l2"><a class="reference internal" href="../sql_language/joins.html">Joins</a></li> <li class="toctree-l2"><a class="reference internal" href="../sql_language/sql_expression.html">SQL Expressions</a></li> <li class="toctree-l2"><a class="reference internal" href="../sql_language/predicates.html">Predicates</a></li> </ul> @@ -109,15 +111,15 @@ </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../functions.html">Functions</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../functions/math_func_and_operators.html">Math Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/string_func_and_operators.html">String Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/network_func_and_operators.html">Network Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/json_func.html">JSON Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-window-functions">Built-in Window Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#user-defined-functions">User-defined Functions</a></li> </ul> </li> <li class="toctree-l1 current"><a class="reference internal" href="../table_management.html">Table Management</a><ul class="current"> <li class="toctree-l2"><a class="reference internal" href="table_overview.html">Overview of Tajo Tables</a></li> +<li class="toctree-l2"><a class="reference internal" href="tablespaces.html">Tablespaces</a></li> <li class="toctree-l2 current"><a class="current reference internal" href="">File Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="compression.html">Compression</a></li> </ul> @@ -129,6 +131,11 @@ <li class="toctree-l2"><a class="reference internal" href="../partitioning/hash_partitioning.html">Hash Partitioning</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="../storage_plugins.html">Storage Plugin</a><ul> +<li class="toctree-l2"><a class="reference internal" href="../storage_plugins/overview.html">Storage Plugin Overview</a></li> +<li class="toctree-l2"><a class="reference internal" href="../storage_plugins/postgresql.html">PostgreSQL Storage Handler</a></li> +</ul> +</li> <li class="toctree-l1"><a class="reference internal" href="../index_overview.html">Index (Experimental Feature)</a><ul> <li class="toctree-l2"><a class="reference internal" href="../index/types.html">Index Types</a></li> <li class="toctree-l2"><a class="reference internal" href="../index/how_to_use.html">How to use index?</a></li> @@ -139,7 +146,7 @@ <li class="toctree-l2"><a class="reference internal" href="../backup_and_restore/catalog.html">Backup and Restore Catalog</a></li> </ul> </li> -<li class="toctree-l1"><a class="reference internal" href="../hcatalog_integration.html">HCatalog Integration</a></li> +<li class="toctree-l1"><a class="reference internal" href="../hive_integration.html">Hive Integration</a></li> <li class="toctree-l1"><a class="reference internal" href="../hbase_integration.html">HBase Integration</a><ul> <li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#create-table">CREATE TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#drop-table">DROP TABLE</a></li> @@ -157,6 +164,8 @@ <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -200,12 +209,14 @@ <div class="section" id="file-formats"> <h1>File Formats<a class="headerlink" href="#file-formats" title="Permalink to this headline">¶</a></h1> -<p>Currently, Tajo provides four file formats as follows:</p> +<p>Currently, Tajo provides following file formats:</p> <div class="toctree-wrapper compound"> <ul> <li class="toctree-l1"><a class="reference internal" href="text.html">TEXT</a></li> +<li class="toctree-l1"><a class="reference internal" href="json.html">JSON</a></li> <li class="toctree-l1"><a class="reference internal" href="rcfile.html">RCFile</a></li> <li class="toctree-l1"><a class="reference internal" href="parquet.html">Parquet</a></li> +<li class="toctree-l1"><a class="reference internal" href="orc.html">ORC</a></li> <li class="toctree-l1"><a class="reference internal" href="sequencefile.html">SequenceFile</a></li> </ul> </div> @@ -220,7 +231,7 @@ <a href="text.html" class="btn btn-neutral float-right" title="TEXT"/>Next <span class="fa fa-arrow-circle-right"></span></a> - <a href="table_overview.html" class="btn btn-neutral" title="Overview of Tajo Tables"><span class="fa fa-arrow-circle-left"></span> Previous</a> + <a href="tablespaces.html" class="btn btn-neutral" title="Tablespaces"><span class="fa fa-arrow-circle-left"></span> Previous</a> </div> Modified: tajo/site/docs/current/table_management/parquet.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management/parquet.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/table_management/parquet.html (original) +++ tajo/site/docs/current/table_management/parquet.html Tue Oct 27 10:40:08 2015 @@ -30,7 +30,7 @@ <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> <link rel="up" title="File Formats" href="file_formats.html"/> - <link rel="next" title="SequenceFile" href="sequencefile.html"/> + <link rel="next" title="ORC" href="orc.html"/> <link rel="prev" title="RCFile" href="rcfile.html"/> @@ -95,7 +95,9 @@ <li class="toctree-l2"><a class="reference internal" href="../sql_language/data_model.html">Data Model</a></li> <li class="toctree-l2"><a class="reference internal" href="../sql_language/ddl.html">Data Definition Language</a></li> <li class="toctree-l2"><a class="reference internal" href="../sql_language/insert.html">INSERT (OVERWRITE) INTO</a></li> +<li class="toctree-l2"><a class="reference internal" href="../sql_language/alter_table.html">ALTER TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="../sql_language/queries.html">Queries</a></li> +<li class="toctree-l2"><a class="reference internal" href="../sql_language/joins.html">Joins</a></li> <li class="toctree-l2"><a class="reference internal" href="../sql_language/sql_expression.html">SQL Expressions</a></li> <li class="toctree-l2"><a class="reference internal" href="../sql_language/predicates.html">Predicates</a></li> </ul> @@ -109,15 +111,15 @@ </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../functions.html">Functions</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../functions/math_func_and_operators.html">Math Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/string_func_and_operators.html">String Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/network_func_and_operators.html">Network Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="../functions/json_func.html">JSON Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-window-functions">Built-in Window Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#user-defined-functions">User-defined Functions</a></li> </ul> </li> <li class="toctree-l1 current"><a class="reference internal" href="../table_management.html">Table Management</a><ul class="current"> <li class="toctree-l2"><a class="reference internal" href="table_overview.html">Overview of Tajo Tables</a></li> +<li class="toctree-l2"><a class="reference internal" href="tablespaces.html">Tablespaces</a></li> <li class="toctree-l2 current"><a class="reference internal" href="file_formats.html">File Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="compression.html">Compression</a></li> </ul> @@ -129,6 +131,11 @@ <li class="toctree-l2"><a class="reference internal" href="../partitioning/hash_partitioning.html">Hash Partitioning</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="../storage_plugins.html">Storage Plugin</a><ul> +<li class="toctree-l2"><a class="reference internal" href="../storage_plugins/overview.html">Storage Plugin Overview</a></li> +<li class="toctree-l2"><a class="reference internal" href="../storage_plugins/postgresql.html">PostgreSQL Storage Handler</a></li> +</ul> +</li> <li class="toctree-l1"><a class="reference internal" href="../index_overview.html">Index (Experimental Feature)</a><ul> <li class="toctree-l2"><a class="reference internal" href="../index/types.html">Index Types</a></li> <li class="toctree-l2"><a class="reference internal" href="../index/how_to_use.html">How to use index?</a></li> @@ -139,7 +146,7 @@ <li class="toctree-l2"><a class="reference internal" href="../backup_and_restore/catalog.html">Backup and Restore Catalog</a></li> </ul> </li> -<li class="toctree-l1"><a class="reference internal" href="../hcatalog_integration.html">HCatalog Integration</a></li> +<li class="toctree-l1"><a class="reference internal" href="../hive_integration.html">Hive Integration</a></li> <li class="toctree-l1"><a class="reference internal" href="../hbase_integration.html">HBase Integration</a><ul> <li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#create-table">CREATE TABLE</a></li> <li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#drop-table">DROP TABLE</a></li> @@ -157,6 +164,8 @@ <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -246,7 +255,7 @@ However, we are currently working on add <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation"> - <a href="sequencefile.html" class="btn btn-neutral float-right" title="SequenceFile"/>Next <span class="fa fa-arrow-circle-right"></span></a> + <a href="orc.html" class="btn btn-neutral float-right" title="ORC"/>Next <span class="fa fa-arrow-circle-right"></span></a> <a href="rcfile.html" class="btn btn-neutral" title="RCFile"><span class="fa fa-arrow-circle-left"></span> Previous</a>
