Modified: tajo/site/docs/current/configuration/catalog_configuration.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/configuration/catalog_configuration.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/configuration/catalog_configuration.html (original) +++ tajo/site/docs/current/configuration/catalog_configuration.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"><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> @@ -207,8 +216,8 @@ </ul> <table border="1" class="docutils"> <colgroup> -<col width="42%" /> -<col width="58%" /> +<col width="44%" /> +<col width="56%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Driver Class</th> @@ -230,7 +239,7 @@ in unit tests to shorten the duration of unit tests.</td> </tr> -<tr class="row-even"><td>tajo.catalog.store.HCatalogStore</td> +<tr class="row-even"><td>tajo.catalog.store.HiveCatalogStore</td> <td>this storage class uses HiveMetaStore.</td> </tr> </tbody> @@ -344,16 +353,15 @@ Query OK, <span class="m">0</span> rows </pre></div> </div> </div> -<div class="section" id="hcatalogstore-configuration"> -<h2>HCatalogStore Configuration<a class="headerlink" href="#hcatalogstore-configuration" title="Permalink to this headline">¶</a></h2> -<p>Tajo support HCatalogStore to integrate with hive. If you want to use HCatalogStore, you just do as follows.</p> +<div class="section" id="hivecatalogstore-configuration"> +<h2>HiveCatalogStore Configuration<a class="headerlink" href="#hivecatalogstore-configuration" title="Permalink to this headline">¶</a></h2> +<p>Tajo support HiveCatalogStore to integrate with hive. If you want to use HiveCatalogStore, you just do as follows.</p> <p>First, you must compile source code and get a binary archive as follows:</p> <div class="highlight-sh"><div class="highlight"><pre><span class="nv">$ </span>git clone https://git-wip-us.apache.org/repos/asf/tajo.git tajo -<span class="nv">$ </span>mvn clean install -DskipTests -Pdist -Dtar -Phcatalog-0.1x.0 +<span class="nv">$ </span>mvn clean install -DskipTests -Pdist -Dtar <span class="nv">$ </span>ls tajo-dist/target/tajo-x.y.z-SNAPSHOT.tar.gz </pre></div> </div> -<p>Currently Tajo supports hive 0.12.0, hive 0.13.0, hive 0.13.1. If you enables HCatalogStore, you set the maven profile as <code class="docutils literal"><span class="pre">-Phcatalog-0.12.0</span></code>.</p> <p>Second, you must set your hive home directory to HIVE_HOME variable in <code class="docutils literal"><span class="pre">conf/tajo-env.sh</span></code> with it as follows:</p> <div class="highlight-sh"><div class="highlight"><pre><span class="nb">export </span><span class="nv">HIVE_HOME</span><span class="o">=</span>/path/to/your/hive/directory </pre></div> @@ -365,7 +373,7 @@ Query OK, <span class="m">0</span> rows <p>Lastly, you should add the following config to <code class="docutils literal"><span class="pre">conf/catalog-site.xml</span></code> :</p> <div class="highlight-xml"><div class="highlight"><pre><span class="nt"><property></span> <span class="nt"><name></span>tajo.catalog.store.class<span class="nt"></name></span> - <span class="nt"><value></span>org.apache.tajo.catalog.store.HCatalogStore<span class="nt"></value></span> + <span class="nt"><value></span>org.apache.tajo.catalog.store.HiveCatalogStore<span class="nt"></value></span> <span class="nt"></property></span> </pre></div> </div>
Modified: tajo/site/docs/current/configuration/cluster_setup.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/configuration/cluster_setup.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/configuration/cluster_setup.html (original) +++ tajo/site/docs/current/configuration/cluster_setup.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"><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/configuration/configuration_defaults.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/configuration/configuration_defaults.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/configuration/configuration_defaults.html (original) +++ tajo/site/docs/current/configuration/configuration_defaults.html Tue Oct 27 10:40:08 2015 @@ -106,6 +106,7 @@ </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/file_formats.html">File Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> Modified: tajo/site/docs/current/configuration/ha_configuration.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/configuration/ha_configuration.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/configuration/ha_configuration.html (original) +++ tajo/site/docs/current/configuration/ha_configuration.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"><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/configuration/preliminary.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/configuration/preliminary.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/configuration/preliminary.html (original) +++ tajo/site/docs/current/configuration/preliminary.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"><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/configuration/service_config_defaults.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/configuration/service_config_defaults.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/configuration/service_config_defaults.html (original) +++ tajo/site/docs/current/configuration/service_config_defaults.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"><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/configuration/tajo-site-xml.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/configuration/tajo-site-xml.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/configuration/tajo-site-xml.html (original) +++ tajo/site/docs/current/configuration/tajo-site-xml.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"><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/configuration/tajo_master_configuration.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/configuration/tajo_master_configuration.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/configuration/tajo_master_configuration.html (original) +++ tajo/site/docs/current/configuration/tajo_master_configuration.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"><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/configuration/worker_configuration.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/configuration/worker_configuration.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/configuration/worker_configuration.html (original) +++ tajo/site/docs/current/configuration/worker_configuration.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"><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> @@ -226,44 +235,56 @@ </div> <div class="section" id="worker-resources"> <h2>Worker Resources<a class="headerlink" href="#worker-resources" title="Permalink to this headline">¶</a></h2> -<p>Each worker can execute multiple tasks simultaneously. -In Tajo, users can specify the total size of memory and the number of disks for each worker. Available resources affect how many tasks are executed simultaneously.</p> +<p>Each worker can execute multiple tasks simultaneously.</p> +<p>In Tajo, users can specify the number of cpu cores, the total size of memory and the number of disks for each worker. Available resources affect how many tasks are executed simultaneously. +CPU cores are a unit for expressing CPU parallelism, the unit for memory is megabytes and the unit for disks is the number of disk</p> <p>In order to specify the resource capacity of each worker, you should add the following configs to <code class="docutils literal"><span class="pre">tajo-site.xml</span></code> :</p> <table border="1" class="docutils"> <colgroup> <col width="32%" /> -<col width="25%" /> -<col width="18%" /> -<col width="24%" /> +<col width="12%" /> +<col width="20%" /> +<col width="35%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">property name</th> -<th class="head">description</th> <th class="head">value type</th> <th class="head">default value</th> +<th class="head">description</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>tajo.worker.resource.cpu-cores</td> +<td>Integer</td> +<td>available cpu-cores</td> <td>the number of cpu cores</td> -<td>integer</td> -<td>1</td> </tr> <tr class="row-odd"><td>tajo.worker.resource.memory-mb</td> +<td>Integer</td> +<td>available jvm heap</td> <td>memory size (MB)</td> -<td>integer</td> -<td>1024</td> </tr> <tr class="row-even"><td>tajo.worker.resource.disks</td> -<td>the number of disks</td> -<td>integer</td> +<td>Integer</td> <td>1</td> +<td>the number of disks</td> +</tr> +<tr class="row-odd"><td>tajo.task.resource.min.memory-mb</td> +<td>Integer</td> +<td>500</td> +<td>minimum allocatable memory per task</td> +</tr> +<tr class="row-even"><td>tajo.qm.resource.min.memory-mb</td> +<td>Integer</td> +<td>500</td> +<td>minimum allocatable memory per query</td> </tr> </tbody> </table> <div class="admonition note"> <p class="first admonition-title">Note</p> -<p class="last">Currently, QueryMaster requests 512MB memory and 0.5 disk per task for the backward compatibility.</p> +<p class="last">Currently, QueryMaster requests 500MB memory and 1 cpu-core per task for the backward compatibility. +If you want to give more memory, you can set to <code class="docutils literal"><span class="pre">tajo.qm.resource.min.memory-mb</span></code></p> </div> <div class="admonition note"> <p class="first admonition-title">Note</p> @@ -272,57 +293,66 @@ In other words, <code class="docutils li </div> <div class="section" id="example"> <h3>Example<a class="headerlink" href="#example" title="Permalink to this headline">¶</a></h3> -<p>Assume that you want to give 5120 MB memory, 4 disks, and 24 cores on each worker. The example configuration is as follows:</p> +<p>Assume that you want to give 15GB Jvm heap, 1GB memory per task, 4 disks, and 12 cores on each worker. The example configuration is as follows:</p> +<p><code class="docutils literal"><span class="pre">tajo-env.sh</span></code></p> +<div class="highlight-bash"><div class="highlight"><pre><span class="nb">export </span><span class="nv">TAJO_WORKER_HEAPSIZE</span><span class="o">=</span>15000 +</pre></div> +</div> <p><code class="docutils literal"><span class="pre">tajo-site.xml</span></code></p> <div class="highlight-xml"><div class="highlight"><pre><span class="nt"><property></span> <span class="nt"><name></span>tajo.worker.resource.tajo.worker.resource.cpu-cores<span class="nt"></name></span> - <span class="nt"><value></span>24<span class="nt"></value></span> + <span class="nt"><value></span>12<span class="nt"></value></span> <span class="nt"></property></span> <span class="nt"><property></span> - <span class="nt"><name></span>tajo.worker.resource.memory-mb<span class="nt"></name></span> - <span class="nt"><value></span>5120<span class="nt"></value></span> + <span class="nt"><name></span>tajo.task.resource.min.memory-mb<span class="nt"></name></span> + <span class="nt"><value></span>1000<span class="nt"></value></span> <span class="nt"></property></span> <span class="nt"><property></span> - <span class="nt"><name></span>tajo.worker.resource.tajo.worker.resource.disks<span class="nt"></name></span> - <span class="nt"><value></span>4.0<span class="nt"></value></span> + <span class="nt"><name></span>tajo.worker.resource.disks<span class="nt"></name></span> + <span class="nt"><value></span>4<span class="nt"></value></span> <span class="nt"></property></span> </pre></div> </div> +<ul class="simple"> +<li>Example with HDFS</li> +</ul> +<p><code class="docutils literal"><span class="pre">tajo-env.sh</span></code></p> +<div class="highlight-bash"><div class="highlight"><pre><span class="nb">export </span><span class="nv">TAJO_WORKER_HEAPSIZE</span><span class="o">=</span>15000 +</pre></div> </div> -<div class="section" id="dedicated-mode"> -<h3>Dedicated Mode<a class="headerlink" href="#dedicated-mode" title="Permalink to this headline">¶</a></h3> -<p>Tajo provides a dedicated mode that allows each worker in a Tajo cluster to use whole available system resources including cpu-cores, memory, and disks. For this mode, a user should add the following config to <code class="docutils literal"><span class="pre">tajo-site.xml</span></code> :</p> -<div class="highlight-xml"><div class="highlight"><pre><span class="nt"><property></span> - <span class="nt"><name></span>tajo.worker.resource.dedicated<span class="nt"></name></span> +<p><code class="docutils literal"><span class="pre">tajo-site.xml</span></code></p> +<div class="highlight-xml"><div class="highlight"><pre> <span class="nt"><property></span> + <span class="nt"><name></span>tajo.task.resource.min.memory-mb<span class="nt"></name></span> + <span class="nt"><value></span>1000<span class="nt"></value></span> +<span class="nt"></property></span> + +<span class="nt"><property></span> + <span class="nt"><name></span>tajo.worker.resource.dfs-dir-aware<span class="nt"></name></span> <span class="nt"><value></span>true<span class="nt"></value></span> <span class="nt"></property></span> </pre></div> </div> -<p>In addition, it can limit the memory capacity used for Tajo worker as follows:</p> -<table border="1" class="docutils"> -<colgroup> -<col width="34%" /> -<col width="35%" /> -<col width="14%" /> -<col width="17%" /> -</colgroup> -<thead valign="bottom"> -<tr class="row-odd"><th class="head">property name</th> -<th class="head">description</th> -<th class="head">value type</th> -<th class="head">default value</th> -</tr> -</thead> -<tbody valign="top"> -<tr class="row-even"><td>tajo.worker.resource.dedicated-memory-ratio</td> -<td>how much memory to be used in whole memory</td> -<td>float</td> -<td>0.8</td> -</tr> -</tbody> -</table> +<ul class="simple"> +<li>Example with S3</li> +</ul> +<p><code class="docutils literal"><span class="pre">tajo-env.sh</span></code></p> +<div class="highlight-bash"><div class="highlight"><pre><span class="nb">export </span><span class="nv">TAJO_WORKER_HEAPSIZE</span><span class="o">=</span>15000 +</pre></div> +</div> +<p><code class="docutils literal"><span class="pre">tajo-site.xml</span></code></p> +<div class="highlight-xml"><div class="highlight"><pre> <span class="nt"><property></span> + <span class="nt"><name></span>tajo.task.resource.min.memory-mb<span class="nt"></name></span> + <span class="nt"><value></span>1000<span class="nt"></value></span> +<span class="nt"></property></span> + +<span class="nt"><property></span> + <span class="nt"><name></span>tajo.worker.resource.disk.parallel-execution.num<span class="nt"></name></span> + <span class="nt"><value></span>4<span class="nt"></value></span> +<span class="nt"></property></span> +</pre></div> +</div> </div> </div> </div> Modified: tajo/site/docs/current/faq.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/faq.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/faq.html (original) +++ tajo/site/docs/current/faq.html Tue Oct 27 10:40:08 2015 @@ -93,7 +93,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> @@ -107,15 +109,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> @@ -127,6 +129,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> @@ -137,7 +144,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> @@ -155,6 +162,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/functions.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/functions.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/functions.html (original) +++ tajo/site/docs/current/functions.html Tue Oct 27 10:40:08 2015 @@ -29,7 +29,7 @@ <link rel="top" title="Apache Tajo 0.11.0 documentation" href="index.html"/> - <link rel="next" title="Math Functions and Operators" href="functions/math_func_and_operators.html"/> + <link rel="next" title="Data Type Functions and Operators" href="functions/data_type_func_and_operators.html"/> <link rel="prev" title="Time Zone" href="time_zone.html"/> @@ -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 current"><a class="current reference internal" href="">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="#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="#built-in-window-functions">Built-in Window Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="#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> @@ -197,8 +206,12 @@ <div class="section" id="functions"> <h1>Functions<a class="headerlink" href="#functions" title="Permalink to this headline">¶</a></h1> +<p>Tajo provides extensive supports for functions. It includes a lot of built-in functions and user-defined functions which is implemented in Python.</p> +<div class="section" id="built-in-scalar-functions"> +<h2>Built-in Scalar Functions<a class="headerlink" href="#built-in-scalar-functions" title="Permalink to this headline">¶</a></h2> <div class="toctree-wrapper compound"> <ul> +<li class="toctree-l1"><a class="reference internal" href="functions/data_type_func_and_operators.html">Data Type Functions and Operators</a></li> <li class="toctree-l1"><a class="reference internal" href="functions/math_func_and_operators.html">Math Functions and Operators</a></li> <li class="toctree-l1"><a class="reference internal" href="functions/string_func_and_operators.html">String Functions and Operators</a></li> <li class="toctree-l1"><a class="reference internal" href="functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li> @@ -207,6 +220,31 @@ </ul> </div> </div> +<div class="section" id="built-in-aggregation-functions"> +<h2>Built-in Aggregation Functions<a class="headerlink" href="#built-in-aggregation-functions" title="Permalink to this headline">¶</a></h2> +<div class="toctree-wrapper compound"> +<ul> +<li class="toctree-l1"><a class="reference internal" href="functions/agg_func.html">Aggregation Functions</a></li> +</ul> +</div> +</div> +<div class="section" id="built-in-window-functions"> +<h2>Built-in Window Functions<a class="headerlink" href="#built-in-window-functions" title="Permalink to this headline">¶</a></h2> +<div class="toctree-wrapper compound"> +<ul> +<li class="toctree-l1"><a class="reference internal" href="functions/window_func.html">Window Functions</a></li> +</ul> +</div> +</div> +<div class="section" id="user-defined-functions"> +<h2>User-defined Functions<a class="headerlink" href="#user-defined-functions" title="Permalink to this headline">¶</a></h2> +<div class="toctree-wrapper compound"> +<ul> +<li class="toctree-l1"><a class="reference internal" href="functions/python.html">Python Functions</a></li> +</ul> +</div> +</div> +</div> </div> @@ -214,7 +252,7 @@ <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation"> - <a href="functions/math_func_and_operators.html" class="btn btn-neutral float-right" title="Math Functions and Operators"/>Next <span class="fa fa-arrow-circle-right"></span></a> + <a href="functions/data_type_func_and_operators.html" class="btn btn-neutral float-right" title="Data Type Functions and Operators"/>Next <span class="fa fa-arrow-circle-right"></span></a> <a href="time_zone.html" class="btn btn-neutral" title="Time Zone"><span class="fa fa-arrow-circle-left"></span> Previous</a> Modified: tajo/site/docs/current/functions/datetime_func_and_operators.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/functions/datetime_func_and_operators.html?rev=1710762&r1=1710761&r2=1710762&view=diff ============================================================================== --- tajo/site/docs/current/functions/datetime_func_and_operators.html (original) +++ tajo/site/docs/current/functions/datetime_func_and_operators.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 current"><a class="reference internal" href="../functions.html">Functions</a><ul class="current"> -<li class="toctree-l2"><a class="reference internal" href="math_func_and_operators.html">Math Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="string_func_and_operators.html">String Functions and Operators</a></li> -<li class="toctree-l2 current"><a class="current reference internal" href="">DateTime Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="network_func_and_operators.html">Network Functions and Operators</a></li> -<li class="toctree-l2"><a class="reference internal" href="json_func.html">JSON Functions</a></li> +<li class="toctree-l2 current"><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> @@ -265,7 +274,7 @@ <dl class="function"> <dt id="current_date"> <code class="descname">current_date</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#current_date" title="Permalink to this definition">¶</a></dt> -<dd><p>Returns current date</p> +<dd><p>Returns current date.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> <col class="field-body" /> @@ -283,7 +292,7 @@ <dl class="function"> <dt id="current_time"> <code class="descname">current_time</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#current_time" title="Permalink to this definition">¶</a></dt> -<dd><p>Returns current time</p> +<dd><p>Returns current time.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> <col class="field-body" /> @@ -300,8 +309,23 @@ <dl class="function"> <dt id="extract"> -<code class="descname">extract</code><span class="sig-paren">(</span><em>field FROM source</em><span class="sig-paren">)</span><a class="headerlink" href="#extract" title="Permalink to this definition">¶</a></dt> +<code class="descname">extract</code><span class="sig-paren">(</span><em>field FROM source date|timestamp|time</em><span class="sig-paren">)</span><a class="headerlink" href="#extract" title="Permalink to this definition">¶</a></dt> <dd><p>The extract function retrieves subfields such as year or hour from date/time values. <em>source</em> must be a value expression of type <em>timestamp</em>, or <em>time</em>. (Expressions of type <em>date</em> are cast to <em>timestamp</em> and can therefore be used as well.) <em>field</em> is an identifier that selects what field to extract from the source value. The extract function returns values of type double precision. The following are valid field names:</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> +<li><strong>field</strong> – extract field</li> +<li><strong>source</strong> – source value</li> +</ul> +</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body"><p class="first last">float8</p> +</td> +</tr> +</tbody> +</table> <p><strong>century</strong></p> <p>The century</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="k">extract</span><span class="p">(</span><span class="n">century</span> <span class="k">from</span> <span class="k">timestamp</span> <span class="s1">'2001-12-16 12:21:13'</span><span class="p">);</span> @@ -416,8 +440,23 @@ <dl class="function"> <dt id="date_part"> -<code class="descname">date_part</code><span class="sig-paren">(</span><em>'field'</em>, <em>source</em><span class="sig-paren">)</span><a class="headerlink" href="#date_part" title="Permalink to this definition">¶</a></dt> +<code class="descname">date_part</code><span class="sig-paren">(</span><em>field text</em>, <em>source date|timestamp|time</em><span class="sig-paren">)</span><a class="headerlink" href="#date_part" title="Permalink to this definition">¶</a></dt> <dd><p>Note that here the field parameter needs to be a string value, not a name. The valid field names for date_part are the same as for extract.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> +<li><strong>field</strong> – extract field</li> +<li><strong>source</strong> – source value</li> +</ul> +</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body"><p class="first last">float8</p> +</td> +</tr> +</tbody> +</table> <div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">date_part</span><span class="p">(</span><span class="s1">'day'</span><span class="p">,</span> <span class="k">timestamp</span> <span class="s1">'2001-02-16 20:38:40'</span><span class="p">);</span> <span class="o">></span> <span class="mi">16</span><span class="p">.</span><span class="mi">0</span> </pre></div> @@ -541,7 +580,7 @@ <dl class="function"> <dt id="utc_usec_to"> -<code class="descname">utc_usec_to</code><span class="sig-paren">(</span><em>string text</em>, <em>long timestamp</em>, <em>int dayOfWeek</em><span class="sig-paren">)</span><a class="headerlink" href="#utc_usec_to" title="Permalink to this definition">¶</a></dt> +<code class="descname">utc_usec_to</code><span class="sig-paren">(</span><em>string text</em>, <em>timestamp long</em>, <em>dayOfWeek int</em><span class="sig-paren">)</span><a class="headerlink" href="#utc_usec_to" title="Permalink to this definition">¶</a></dt> <dd><ul> <li><p class="first">If the <strong>first parameter</strong> is ‘day’.</p> <p>Shifts and return a UNIX timestamp in microseconds to the beginning of the day it occurs in.
