Modified: tajo/site/docs/current/getting_started/first_query.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/getting_started/first_query.html?rev=1665114&r1=1665113&r2=1665114&view=diff ============================================================================== --- tajo/site/docs/current/getting_started/first_query.html (original) +++ tajo/site/docs/current/getting_started/first_query.html Mon Mar 9 02:35:26 2015 @@ -74,8 +74,9 @@ <li class="toctree-l2"><a class="reference internal" href="../configuration/tajo_master_configuration.html">Tajo Master Configuration</a></li> <li class="toctree-l2"><a class="reference internal" href="../configuration/worker_configuration.html">Worker Configuration</a></li> <li class="toctree-l2"><a class="reference internal" href="../configuration/catalog_configuration.html">Catalog Configuration</a></li> -<li class="toctree-l2"><a class="reference internal" href="../configuration/configuration_defaults.html">Configuration Defaults</a></li> <li class="toctree-l2"><a class="reference internal" href="../configuration/ha_configuration.html">High Availability for TajoMaster</a></li> +<li class="toctree-l2"><a class="reference internal" href="../configuration/tajo-site-xml.html">The tajo-site.xml File</a></li> +<li class="toctree-l2"><a class="reference internal" href="../configuration/catalog-site-xml.html">The catalog-site.xml File</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../tsql.html">Tajo Shell (TSQL)</a><ul> @@ -98,6 +99,14 @@ <li class="toctree-l2"><a class="reference internal" href="../sql_language/predicates.html">Predicates</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="../time_zone.html">Time Zone</a><ul> +<li class="toctree-l2"><a class="reference internal" href="../time_zone.html#server-cluster-time-zone">Server Cluster Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="../time_zone.html#table-time-zone">Table Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="../time_zone.html#client-time-zone">Client Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="../time_zone.html#time-zone-id">Time Zone ID</a></li> +<li class="toctree-l2"><a class="reference internal" href="../time_zone.html#examples-of-time-zone">Examples of Time Zone</a></li> +</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> @@ -106,6 +115,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> @@ -173,11 +183,11 @@ <div class="highlight-bash"><div class="highlight"><pre><span class="nv">$ </span>mkdir /home/x/table1 <span class="nv">$ </span><span class="nb">cd</span> /home/x/table1 <span class="nv">$ </span>cat > data.csv -1<span class="p">|</span>abc<span class="p">|</span>1.1<span class="p">|</span>a -2<span class="p">|</span>def<span class="p">|</span>2.3<span class="p">|</span>b -3<span class="p">|</span>ghi<span class="p">|</span>3.4<span class="p">|</span>c -4<span class="p">|</span>jkl<span class="p">|</span>4.5<span class="p">|</span>d -5<span class="p">|</span>mno<span class="p">|</span>5.6<span class="p">|</span>e +1|abc|1.1|a +2|def|2.3|b +3|ghi|3.4|c +4|jkl|4.5|d +5|mno|5.6|e <CTRL + D> </pre></div> </div> @@ -194,7 +204,7 @@ tajo> create external table table1 ( name text, score float, type text) - using csv with ('csvfile.delimiter'='|') location 'file:/home/x/table1'; + using csv with ('text.delimiter'='|') location 'file:/home/x/table1'; </pre></div> </div> <p>To load an external table, you need to use âcreate external tableâ statement.
Modified: tajo/site/docs/current/getting_started/local_setup.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/getting_started/local_setup.html?rev=1665114&r1=1665113&r2=1665114&view=diff ============================================================================== --- tajo/site/docs/current/getting_started/local_setup.html (original) +++ tajo/site/docs/current/getting_started/local_setup.html Mon Mar 9 02:35:26 2015 @@ -74,8 +74,9 @@ <li class="toctree-l2"><a class="reference internal" href="../configuration/tajo_master_configuration.html">Tajo Master Configuration</a></li> <li class="toctree-l2"><a class="reference internal" href="../configuration/worker_configuration.html">Worker Configuration</a></li> <li class="toctree-l2"><a class="reference internal" href="../configuration/catalog_configuration.html">Catalog Configuration</a></li> -<li class="toctree-l2"><a class="reference internal" href="../configuration/configuration_defaults.html">Configuration Defaults</a></li> <li class="toctree-l2"><a class="reference internal" href="../configuration/ha_configuration.html">High Availability for TajoMaster</a></li> +<li class="toctree-l2"><a class="reference internal" href="../configuration/tajo-site-xml.html">The tajo-site.xml File</a></li> +<li class="toctree-l2"><a class="reference internal" href="../configuration/catalog-site-xml.html">The catalog-site.xml File</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../tsql.html">Tajo Shell (TSQL)</a><ul> @@ -98,6 +99,14 @@ <li class="toctree-l2"><a class="reference internal" href="../sql_language/predicates.html">Predicates</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="../time_zone.html">Time Zone</a><ul> +<li class="toctree-l2"><a class="reference internal" href="../time_zone.html#server-cluster-time-zone">Server Cluster Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="../time_zone.html#table-time-zone">Table Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="../time_zone.html#client-time-zone">Client Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="../time_zone.html#time-zone-id">Time Zone ID</a></li> +<li class="toctree-l2"><a class="reference internal" href="../time_zone.html#examples-of-time-zone">Examples of Time Zone</a></li> +</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> @@ -106,6 +115,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/getting_started/prerequisites.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/getting_started/prerequisites.html?rev=1665114&r1=1665113&r2=1665114&view=diff ============================================================================== --- tajo/site/docs/current/getting_started/prerequisites.html (original) +++ tajo/site/docs/current/getting_started/prerequisites.html Mon Mar 9 02:35:26 2015 @@ -74,8 +74,9 @@ <li class="toctree-l2"><a class="reference internal" href="../configuration/tajo_master_configuration.html">Tajo Master Configuration</a></li> <li class="toctree-l2"><a class="reference internal" href="../configuration/worker_configuration.html">Worker Configuration</a></li> <li class="toctree-l2"><a class="reference internal" href="../configuration/catalog_configuration.html">Catalog Configuration</a></li> -<li class="toctree-l2"><a class="reference internal" href="../configuration/configuration_defaults.html">Configuration Defaults</a></li> <li class="toctree-l2"><a class="reference internal" href="../configuration/ha_configuration.html">High Availability for TajoMaster</a></li> +<li class="toctree-l2"><a class="reference internal" href="../configuration/tajo-site-xml.html">The tajo-site.xml File</a></li> +<li class="toctree-l2"><a class="reference internal" href="../configuration/catalog-site-xml.html">The catalog-site.xml File</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../tsql.html">Tajo Shell (TSQL)</a><ul> @@ -98,6 +99,14 @@ <li class="toctree-l2"><a class="reference internal" href="../sql_language/predicates.html">Predicates</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="../time_zone.html">Time Zone</a><ul> +<li class="toctree-l2"><a class="reference internal" href="../time_zone.html#server-cluster-time-zone">Server Cluster Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="../time_zone.html#table-time-zone">Table Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="../time_zone.html#client-time-zone">Client Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="../time_zone.html#time-zone-id">Time Zone ID</a></li> +<li class="toctree-l2"><a class="reference internal" href="../time_zone.html#examples-of-time-zone">Examples of Time Zone</a></li> +</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> @@ -106,6 +115,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> @@ -171,8 +181,8 @@ <h1>Prerequisites<a class="headerlink" href="#prerequisites" title="Permalink to this headline">¶</a></h1> <blockquote> <div><ul class="simple"> -<li>Hadoop 2.2.0, 2.3.0, or 2.4.0</li> -<li>Java 1.6 or higher</li> +<li>Hadoop 2.3.0 or higher (up to 2.5.1)</li> +<li>Java 1.6 or 1.7</li> <li>Protocol buffer 2.5.0</li> </ul> </div></blockquote> Added: tajo/site/docs/current/hbase_integration.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/hbase_integration.html?rev=1665114&view=auto ============================================================================== --- tajo/site/docs/current/hbase_integration.html (added) +++ tajo/site/docs/current/hbase_integration.html Mon Mar 9 02:35:26 2015 @@ -0,0 +1,399 @@ + + +<!DOCTYPE html> +<!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]--> +<!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]--> +<head> + <meta charset="utf-8"> + <meta name="viewport" content="width=device-width, initial-scale=1.0"> + + <title>HBase Integration — Apache Tajo 0.8.0 documentation</title> + + + + + + + <link href='https://fonts.googleapis.com/css?family=Lato:400,700|Roboto+Slab:400,700|Inconsolata:400,700' rel='stylesheet' type='text/css'> + + + + + + + + + + <link rel="stylesheet" href="_static/css/theme.css" type="text/css" /> + + + + <link rel="top" title="Apache Tajo 0.8.0 documentation" href="index.html"/> + <link rel="next" title="Tajo JDBC Driver" href="jdbc_driver.html"/> + <link rel="prev" title="HCatalog Integration" href="hcatalog_integration.html"/> + + + <script src="https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js";></script> + +</head> + +<body class="wy-body-for-nav" role="document"> + + <div class="wy-grid-for-nav"> + + + <nav data-toggle="wy-nav-shift" class="wy-nav-side"> + <div class="wy-side-nav-search"> + <a href="index.html" class="fa fa-home"> Apache Tajo</a> + <div role="search"> + <form id ="rtd-search-form" class="wy-form" action="search.html" method="get"> + <input type="text" name="q" placeholder="Search docs" /> + <input type="hidden" name="check_keywords" value="yes" /> + <input type="hidden" name="area" value="default" /> + </form> +</div> + </div> + + <div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation" aria-label="main navigation"> + + + <ul class="current"> +<li class="toctree-l1"><a class="reference internal" href="introduction.html">Introduction</a></li> +<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a><ul> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#first-query-execution">First query execution</a></li> +</ul> +</li> +<li class="toctree-l1"><a class="reference internal" href="configuration.html">Configuration</a><ul> +<li class="toctree-l2"><a class="reference internal" href="configuration/preliminary.html">Preliminary</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/cluster_setup.html">Cluster Setup</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/tajo_master_configuration.html">Tajo Master Configuration</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/worker_configuration.html">Worker Configuration</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/catalog_configuration.html">Catalog Configuration</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/ha_configuration.html">High Availability for TajoMaster</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/service_config_defaults.html">Cluster Service Configuration Defaults</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/tajo-site-xml.html">The tajo-site.xml File</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/catalog-site-xml.html">The catalog-site.xml File</a></li> +</ul> +</li> +<li class="toctree-l1"><a class="reference internal" href="tsql.html">Tajo Shell (TSQL)</a><ul> +<li class="toctree-l2"><a class="reference internal" href="tsql/meta_command.html">Meta Commands</a></li> +<li class="toctree-l2"><a class="reference internal" href="tsql/dfs_command.html">Executing HDFS commands</a></li> +<li class="toctree-l2"><a class="reference internal" href="tsql/variables.html">Session Variables</a></li> +<li class="toctree-l2"><a class="reference internal" href="tsql/admin_command.html">Administration Commands</a></li> +<li class="toctree-l2"><a class="reference internal" href="tsql/intro.html">Introducing to TSQL</a></li> +<li class="toctree-l2"><a class="reference internal" href="tsql/single_command.html">Executing a single command</a></li> +<li class="toctree-l2"><a class="reference internal" href="tsql/execute_file.html">Executing Queries from Files</a></li> +<li class="toctree-l2"><a class="reference internal" href="tsql/background_command.html">Executing as background process</a></li> +</ul> +</li> +<li class="toctree-l1"><a class="reference internal" href="sql_language.html">SQL Language</a><ul> +<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/queries.html">Queries</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> +</li> +<li class="toctree-l1"><a class="reference internal" href="time_zone.html">Time Zone</a><ul> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#server-cluster-time-zone">Server Cluster Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#table-time-zone">Table Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#client-time-zone">Client Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#time-zone-id">Time Zone ID</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#examples-of-time-zone">Examples of Time Zone</a></li> +</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> +</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> +</li> +<li class="toctree-l1"><a class="reference internal" href="table_partitioning.html">Table Partitioning</a><ul> +<li class="toctree-l2"><a class="reference internal" href="partitioning/intro_to_partitioning.html">Introduction to Partitioning</a></li> +<li class="toctree-l2"><a class="reference internal" href="partitioning/column_partitioning.html">Column Partitioning</a></li> +<li class="toctree-l2"><a class="reference internal" href="partitioning/range_partitioning.html">Range Partitioning</a></li> +<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="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> +<li class="toctree-l2"><a class="reference internal" href="index/future_work.html">Future Works</a></li> +</ul> +</li> +<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a><ul> +<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 current"><a class="current reference internal" href="">HBase Integration</a><ul> +<li class="toctree-l2"><a class="reference internal" href="#create-table">CREATE TABLE</a></li> +<li class="toctree-l2"><a class="reference internal" href="#drop-table">DROP TABLE</a></li> +<li class="toctree-l2"><a class="reference internal" href="#insert-overwrite-into">INSERT (OVERWRITE) INTO</a></li> +<li class="toctree-l2"><a class="reference internal" href="#usage">Usage</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> +<li class="toctree-l1"><a class="reference internal" href="faq.html">FAQ</a></li> +</ul> + + + </div> + + </nav> + + <section data-toggle="wy-nav-shift" class="wy-nav-content-wrap"> + + + <nav class="wy-nav-top" role="navigation" aria-label="top navigation"> + <i data-toggle="wy-nav-top" class="fa fa-bars"></i> + <a href="index.html">Apache Tajo</a> + </nav> + + + + <div class="wy-nav-content"> + <div class="rst-content"> + <div role="navigation" aria-label="breadcrumbs navigation"> + <ul class="wy-breadcrumbs"> + <li><a href="index.html">Docs</a> »</li> + + <li>HBase Integration</li> + <li class="wy-breadcrumbs-aside"> + + <a href="_sources/hbase_integration.txt" rel="nofollow"> View page source</a> + + </li> + </ul> + <hr/> +</div> + <div role="main"> + + <div class="section" id="hbase-integration"> +<h1>HBase Integration<a class="headerlink" href="#hbase-integration" title="Permalink to this headline">¶</a></h1> +<p>Apache Tajo⢠storage supports integration with Apache HBaseâ¢. +This integration allows Tajo to access all tables used in Apache HBase.</p> +<p>In order to use this feature, you need to build add some configs into <tt class="docutils literal"><span class="pre">conf/tajo-env.sh</span></tt> and then add some properties into a table create statement.</p> +<p>This section describes how to setup HBase integration.</p> +<p>First, you need to set your HBase home directory to the environment variable <tt class="docutils literal"><span class="pre">HBASE_HOME</span></tt> in conf/tajo-env.sh as follows:</p> +<div class="highlight-python"><div class="highlight"><pre>export HBASE_HOME=/path/to/your/hbase/directory +</pre></div> +</div> +<p>If you set the directory, Tajo will add HBase library file to classpath.</p> +<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="p">[</span><span class="k">EXTERNAL</span><span class="p">]</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">USING</span> <span class="n">hbase</span> +<span class="k">WITH</span> <span class="p">(</span><span class="s1">'table'</span><span class="o">=</span><span class="s1">'<hbase_table_name>'</span> +<span class="p">,</span> <span class="s1">'columns'</span><span class="o">=</span><span class="s1">':key,<column_family_name>:<qualifier_name>, ...'</span> +<span class="p">,</span> <span class="s1">'hbase.zookeeper.quorum'</span><span class="o">=</span><span class="s1">'<zookeeper_address>'</span> +<span class="p">,</span> <span class="s1">'hbase.zookeeper.property.clientPort'</span><span class="o">=</span><span class="s1">'<zookeeper_client_port>'</span> +<span class="p">)</span> +</pre></div> +</div> +<p>Options</p> +<ul class="simple"> +<li><tt class="docutils literal"><span class="pre">table</span></tt> : Set hbase origin table name. If you want to create an external table, the table must exists on HBase. The other way, if you want to create a managed table, the table must doesn’t exist on HBase.</li> +<li><tt class="docutils literal"><span class="pre">columns</span></tt> : :key means HBase row key. The number of columns entry need to equals to the number of Tajo table column</li> +<li><tt class="docutils literal"><span class="pre">hbase.zookeeper.quorum</span></tt> : Set zookeeper quorum address. You can use different zookeeper cluster on the same Tajo database. If you don’t set the zookeeper address, Tajo will refer the property of hbase-site.xml file.</li> +<li><tt class="docutils literal"><span class="pre">hbase.zookeeper.property.clientPort</span></tt> : Set zookeeper client port. If you don’t set the port, Tajo will refer the property of hbase-site.xml file.</li> +</ul> +<p><tt class="docutils literal"><span class="pre">IF</span> <span class="pre">NOT</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">CREATE</span> <span class="pre">[EXTERNAL]</span> <span class="pre">TABLE</span></tt> statement to avoid an error which occurs when the table does not exist.</p> +</div> +<div class="section" id="drop-table"> +<h2>DROP TABLE<a class="headerlink" href="#drop-table" title="Permalink to this headline">¶</a></h2> +<p><em>Synopsis</em></p> +<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><tt class="docutils literal"><span class="pre">IF</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></tt> statement to avoid an error which occurs when the table does not exist. <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></tt> statement removes a table from Tajo catalog, but it does not remove the contents on HBase cluster. If <tt class="docutils literal"><span class="pre">PURGE</span></tt> option is given, <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></tt> statement will eliminate the entry in the catalog as well as the contents on HBase cluster.</p> +</div> +<div class="section" id="insert-overwrite-into"> +<h2>INSERT (OVERWRITE) INTO<a class="headerlink" href="#insert-overwrite-into" title="Permalink to this headline">¶</a></h2> +<p>INSERT OVERWRITE statement overwrites a table data of an existing table. Tajo’s INSERT OVERWRITE statement follows <tt class="docutils literal"><span class="pre">INSERT</span> <span class="pre">INTO</span> <span class="pre">SELECT</span></tt> statement of SQL. The examples are as follows:</p> +<div class="highlight-sql"><div class="highlight"><pre><span class="c1">-- when a target table schema and output schema are equivalent to each other</span> +<span class="k">INSERT</span> <span class="n">OVERWRITE</span> <span class="k">INTO</span> <span class="n">t1</span> <span class="k">SELECT</span> <span class="n">l_orderkey</span><span class="p">,</span> <span class="n">l_partkey</span><span class="p">,</span> <span class="n">l_quantity</span> <span class="k">FROM</span> <span class="n">lineitem</span><span class="p">;</span> +<span class="c1">-- or</span> +<span class="k">INSERT</span> <span class="n">OVERWRITE</span> <span class="k">INTO</span> <span class="n">t1</span> <span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">lineitem</span><span class="p">;</span> + +<span class="c1">-- when the output schema are smaller than the target table schema</span> +<span class="k">INSERT</span> <span class="n">OVERWRITE</span> <span class="k">INTO</span> <span class="n">t1</span> <span class="k">SELECT</span> <span class="n">l_orderkey</span> <span class="k">FROM</span> <span class="n">lineitem</span><span class="p">;</span> + +<span class="c1">-- when you want to specify certain target columns</span> +<span class="k">INSERT</span> <span class="n">OVERWRITE</span> <span class="k">INTO</span> <span class="n">t1</span> <span class="p">(</span><span class="n">col1</span><span class="p">,</span> <span class="n">col3</span><span class="p">)</span> <span class="k">SELECT</span> <span class="n">l_orderkey</span><span class="p">,</span> <span class="n">l_quantity</span> <span class="k">FROM</span> <span class="n">lineitem</span><span class="p">;</span> +</pre></div> +</div> +<div class="admonition note"> +<p class="first admonition-title">Note</p> +<p class="last">If you don’t set row key option, You are never able to use your table data. Because Tajo need to have some key columns for sorting before creating result data.</p> +</div> +</div> +<div class="section" id="usage"> +<h2>Usage<a class="headerlink" href="#usage" title="Permalink to this headline">¶</a></h2> +<p>In order to create a new HBase table which is to be managed by Tajo, use the USING clause on CREATE TABLE:</p> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">EXTERNAL</span> <span class="k">TABLE</span> <span class="n">blog</span> <span class="p">(</span><span class="n">rowkey</span> <span class="nb">text</span><span class="p">,</span> <span class="n">author</span> <span class="nb">text</span><span class="p">,</span> <span class="n">register_date</span> <span class="nb">text</span><span class="p">,</span> <span class="n">title</span> <span class="nb">text</span><span class="p">)</span> +<span class="k">USING</span> <span class="n">hbase</span> <span class="k">WITH</span> <span class="p">(</span> + <span class="s1">'table'</span><span class="o">=</span><span class="s1">'blog'</span> + <span class="p">,</span> <span class="s1">'columns'</span><span class="o">=</span><span class="s1">':key,info:author,info:date,content:title'</span><span class="p">);</span> +</pre></div> +</div> +<p>After executing the command above, you should be able to see the new table in the HBase shell:</p> +<div class="highlight-sql"><div class="highlight"><pre>$ hbase shell +create 'blog', {NAME=>'info'}, {NAME=>'content'} +put 'blog', 'hyunsik-02', 'content:title', 'Getting started with Tajo on your desktop' +put 'blog', 'hyunsik-02', 'info:author', 'Hyunsik Choi' +put 'blog', 'hyunsik-02', 'info:date', '2014-12-03' +put 'blog', 'blrunner-01', 'content:title', 'Apache Tajo: A Big Data Warehouse System on Hadoop' +put 'blog', 'blrunner-01', 'info:author', 'Jaehwa Jung' +put 'blog', 'blrunner-01', 'info:date', '2014-10-31' +put 'blog', 'jhkim-01', 'content:title', 'APACHE TAJO⢠v0.9 HAS ARRIVED!' +put 'blog', 'jhkim-01', 'info:author', 'Jinho Kim' +put 'blog', 'jhkim-01', 'info:date', '2014-10-22' +</pre></div> +</div> +<p>And then create the table and query the table meta data with <tt class="docutils literal"><span class="pre">\d</span></tt> option:</p> +<div class="highlight-sql"><div class="highlight"><pre>default> \d blog; + +table name: default.blog +table path: +store type: HBASE +number of rows: unknown +volume: 0 B +Options: + 'columns'=':key,info:author,info:date,content:title' + 'table'='blog' + +schema: +rowkey TEXT +author TEXT +register_date TEXT +title TEXT +</pre></div> +</div> +<p>And then query the table as follows:</p> +<div class="highlight-sql"><div class="highlight"><pre>default> SELECT * FROM blog; +rowkey, author, register_date, title +------------------------------- +blrunner-01, Jaehwa Jung, 2014-10-31, Apache Tajo: A Big Data Warehouse System on Hadoop +hyunsik-02, Hyunsik Choi, 2014-12-03, Getting started with Tajo on your desktop +jhkim-01, Jinho Kim, 2014-10-22, APACHE TAJO⢠v0.9 HAS ARRIVED! + +default> SELECT * FROM blog WHERE rowkey = 'blrunner-01'; +Progress: 100%, response time: 2.043 sec +rowkey, author, register_date, title +------------------------------- +blrunner-01, Jaehwa Jung, 2014-10-31, Apache Tajo: A Big Data Warehouse System on Hadoop +</pre></div> +</div> +<p>Here’s how to insert data the HBase table:</p> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">blog_backup</span><span class="p">(</span><span class="n">rowkey</span> <span class="nb">text</span><span class="p">,</span> <span class="n">author</span> <span class="nb">text</span><span class="p">,</span> <span class="n">register_date</span> <span class="nb">text</span><span class="p">,</span> <span class="n">title</span> <span class="nb">text</span><span class="p">)</span> +<span class="k">USING</span> <span class="n">hbase</span> <span class="k">WITH</span> <span class="p">(</span> + <span class="s1">'table'</span><span class="o">=</span><span class="s1">'blog_backup'</span> + <span class="p">,</span> <span class="s1">'columns'</span><span class="o">=</span><span class="s1">':key,info:author,info:date,content:title'</span><span class="p">);</span> +<span class="k">INSERT</span> <span class="n">OVERWRITE</span> <span class="k">INTO</span> <span class="n">blog_backup</span> <span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">blog</span><span class="p">;</span> +</pre></div> +</div> +<p>Use HBase shell to verify that the data actually got loaded:</p> +<div class="highlight-sql"><div class="highlight"><pre>hbase(main):004:0> scan 'blog_backup' + ROW COLUMN+CELL + blrunner-01 column=content:title, timestamp=1421227531054, value=Apache Tajo: A Big Data Warehouse System on Hadoop + blrunner-01 column=info:author, timestamp=1421227531054, value=Jaehwa Jung + blrunner-01 column=info:date, timestamp=1421227531054, value=2014-10-31 + hyunsik-02 column=content:title, timestamp=1421227531054, value=Getting started with Tajo on your desktop + hyunsik-02 column=info:author, timestamp=1421227531054, value=Hyunsik Choi + hyunsik-02 column=info:date, timestamp=1421227531054, value=2014-12-03 + jhkim-01 column=content:title, timestamp=1421227531054, value=APACHE TAJO\xE2\x84\xA2 v0.9 HAS ARRIVED! + jhkim-01 column=info:author, timestamp=1421227531054, value=Jinho Kim + jhkim-01 column=info:date, timestamp=1421227531054, value=2014-10-22 +3 row(s) in 0.0470 seconds +</pre></div> +</div> +</div> +</div> + + + </div> + <footer> + + <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation"> + + <a href="jdbc_driver.html" class="btn btn-neutral float-right" title="Tajo JDBC Driver"/>Next <span class="fa fa-arrow-circle-right"></span></a> + + + <a href="hcatalog_integration.html" class="btn btn-neutral" title="HCatalog Integration"><span class="fa fa-arrow-circle-left"></span> Previous</a> + + </div> + + + <hr/> + + <div role="contentinfo"> + <p> + © Copyright 2014, Apache Tajo Team. + </p> + </div> + + <a href="https://github.com/snide/sphinx_rtd_theme";>Sphinx theme</a> provided by <a href="https://readthedocs.org";>Read the Docs</a> +</footer> + </div> + </div> + + </section> + + </div> + + + + + + <script type="text/javascript"> + var DOCUMENTATION_OPTIONS = { + URL_ROOT:'./', + VERSION:'0.8.0', + COLLAPSE_INDEX:false, + FILE_SUFFIX:'.html', + HAS_SOURCE: true + }; + </script> + <script type="text/javascript" src="_static/jquery.js"></script> + <script type="text/javascript" src="_static/underscore.js"></script> + <script type="text/javascript" src="_static/doctools.js"></script> + + + + + + <script type="text/javascript" src="_static/js/theme.js"></script> + + + + + <script type="text/javascript"> + jQuery(function () { + SphinxRtdTheme.StickyNav.enable(); + }); + </script> + + +</body> +</html> \ No newline at end of file Modified: tajo/site/docs/current/hcatalog_integration.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/hcatalog_integration.html?rev=1665114&r1=1665113&r2=1665114&view=diff ============================================================================== --- tajo/site/docs/current/hcatalog_integration.html (original) +++ tajo/site/docs/current/hcatalog_integration.html Mon Mar 9 02:35:26 2015 @@ -29,7 +29,7 @@ <link rel="top" title="Apache Tajo 0.8.0 documentation" href="index.html"/> - <link rel="next" title="Tajo JDBC Driver" href="jdbc_driver.html"/> + <link rel="next" title="HBase Integration" href="hbase_integration.html"/> <link rel="prev" title="Backup and Restore Catalog" href="backup_and_restore/catalog.html"/> @@ -60,11 +60,11 @@ <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="configuration.html">Configuration</a><ul> @@ -73,8 +73,10 @@ <li class="toctree-l2"><a class="reference internal" href="configuration/tajo_master_configuration.html">Tajo Master Configuration</a></li> <li class="toctree-l2"><a class="reference internal" href="configuration/worker_configuration.html">Worker Configuration</a></li> <li class="toctree-l2"><a class="reference internal" href="configuration/catalog_configuration.html">Catalog Configuration</a></li> -<li class="toctree-l2"><a class="reference internal" href="configuration/configuration_defaults.html">Configuration Defaults</a></li> <li class="toctree-l2"><a class="reference internal" href="configuration/ha_configuration.html">High Availability for TajoMaster</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/service_config_defaults.html">Cluster Service Configuration Defaults</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/tajo-site-xml.html">The tajo-site.xml File</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/catalog-site-xml.html">The catalog-site.xml File</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="tsql.html">Tajo Shell (TSQL)</a><ul> @@ -97,6 +99,14 @@ <li class="toctree-l2"><a class="reference internal" href="sql_language/predicates.html">Predicates</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="time_zone.html">Time Zone</a><ul> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#server-cluster-time-zone">Server Cluster Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#table-time-zone">Table Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#client-time-zone">Client Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#time-zone-id">Time Zone ID</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#examples-of-time-zone">Examples of Time Zone</a></li> +</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> @@ -105,6 +115,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> @@ -116,11 +127,24 @@ <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="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> +<li class="toctree-l2"><a class="reference internal" href="index/future_work.html">Future Works</a></li> +</ul> +</li> <li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a><ul> <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 current"><a class="current reference internal" href="">HCatalog 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> +<li class="toctree-l2"><a class="reference internal" href="hbase_integration.html#insert-overwrite-into">INSERT (OVERWRITE) INTO</a></li> +<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="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> @@ -200,6 +224,19 @@ Next, you should set the path of MySQL J </property> </pre></div> </div> +<div class="admonition note"> +<p class="first admonition-title">Note</p> +<p>Hive stores a list of partitions for each table in its metastore. If new partitions are +directly added to HDFS, HiveMetastore will not able aware of these partitions unless the user +<tt class="docutils literal"><span class="pre">ALTER</span> <span class="pre">TABLE</span> <span class="pre">table_name</span> <span class="pre">ADD</span> <span class="pre">PARTITION</span></tt> commands on each of the newly added partitions or +<tt class="docutils literal"><span class="pre">MSCK</span> <span class="pre">REPAIR</span> <span class="pre">TABLE</span> <span class="pre">table_name</span></tt> command.</p> +<p>But current tajo doesn’t provide <tt class="docutils literal"><span class="pre">ADD</span> <span class="pre">PARTITION</span></tt> command and hive doesn’t provide an api for +responding to <tt class="docutils literal"><span class="pre">MSK</span> <span class="pre">REPAIR</span> <span class="pre">TABLE</span></tt> command. Thus, if you insert data to hive partitioned +table and you want to scan the updated partitions through Tajo, you must run following command on hive</p> +<div class="last highlight-python"><div class="highlight"><pre>$ MSCK REPAIR TABLE [table_name]; +</pre></div> +</div> +</div> </div> @@ -208,7 +245,7 @@ Next, you should set the path of MySQL J <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation"> - <a href="jdbc_driver.html" class="btn btn-neutral float-right" title="Tajo JDBC Driver"/>Next <span class="fa fa-arrow-circle-right"></span></a> + <a href="hbase_integration.html" class="btn btn-neutral float-right" title="HBase Integration"/>Next <span class="fa fa-arrow-circle-right"></span></a> <a href="backup_and_restore/catalog.html" class="btn btn-neutral" title="Backup and Restore Catalog"><span class="fa fa-arrow-circle-left"></span> Previous</a> Modified: tajo/site/docs/current/index.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/index.html?rev=1665114&r1=1665113&r2=1665114&view=diff ============================================================================== --- tajo/site/docs/current/index.html (original) +++ tajo/site/docs/current/index.html Mon Mar 9 02:35:26 2015 @@ -7,7 +7,7 @@ <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> - <title>Apache Tajo⢠0.9.0 Release Documentation — Apache Tajo 0.8.0 documentation</title> + <title>Apache Tajo⢠0.10.0 - User documentation — Apache Tajo 0.8.0 documentation</title> @@ -59,11 +59,11 @@ <ul> <li class="toctree-l1"><a class="reference internal" href="introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="configuration.html">Configuration</a><ul> @@ -72,8 +72,10 @@ <li class="toctree-l2"><a class="reference internal" href="configuration/tajo_master_configuration.html">Tajo Master Configuration</a></li> <li class="toctree-l2"><a class="reference internal" href="configuration/worker_configuration.html">Worker Configuration</a></li> <li class="toctree-l2"><a class="reference internal" href="configuration/catalog_configuration.html">Catalog Configuration</a></li> -<li class="toctree-l2"><a class="reference internal" href="configuration/configuration_defaults.html">Configuration Defaults</a></li> <li class="toctree-l2"><a class="reference internal" href="configuration/ha_configuration.html">High Availability for TajoMaster</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/service_config_defaults.html">Cluster Service Configuration Defaults</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/tajo-site-xml.html">The tajo-site.xml File</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/catalog-site-xml.html">The catalog-site.xml File</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="tsql.html">Tajo Shell (TSQL)</a><ul> @@ -96,6 +98,14 @@ <li class="toctree-l2"><a class="reference internal" href="sql_language/predicates.html">Predicates</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="time_zone.html">Time Zone</a><ul> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#server-cluster-time-zone">Server Cluster Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#table-time-zone">Table Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#client-time-zone">Client Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#time-zone-id">Time Zone ID</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#examples-of-time-zone">Examples of Time Zone</a></li> +</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> @@ -104,6 +114,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> @@ -115,11 +126,24 @@ <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="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> +<li class="toctree-l2"><a class="reference internal" href="index/future_work.html">Future Works</a></li> +</ul> +</li> <li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a><ul> <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="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> +<li class="toctree-l2"><a class="reference internal" href="hbase_integration.html#insert-overwrite-into">INSERT (OVERWRITE) INTO</a></li> +<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="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> @@ -152,7 +176,7 @@ <ul class="wy-breadcrumbs"> <li><a href="#">Docs</a> »</li> - <li>Apache Tajo⢠0.9.0 Release Documentation</li> + <li>Apache Tajo⢠0.10.0 - User documentation</li> <li class="wy-breadcrumbs-aside"> <a href="_sources/index.txt" rel="nofollow"> View page source</a> @@ -163,22 +187,27 @@ </div> <div role="main"> - <div class="section" id="apache-tajo-0-9-0-release-documentation"> -<h1>Apache Tajo⢠0.9.0 Release Documentation<a class="headerlink" href="#apache-tajo-0-9-0-release-documentation" title="Permalink to this headline">¶</a></h1> + <div class="section" id="apache-tajo-0-10-0-user-documentation"> +<h1>Apache Tajo⢠0.10.0 - User documentation<a class="headerlink" href="#apache-tajo-0-10-0-user-documentation" title="Permalink to this headline">¶</a></h1> +<div class="admonition warning"> +<p class="first admonition-title">Warning</p> +<p class="last">This documentation is based on the development branch (master). +As a result, some contents can be mismatched to the actual implementation.</p> +</div> <p>Table of Contents:</p> <div class="toctree-wrapper compound"> <ul> <li class="toctree-l1"><a class="reference internal" href="introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/downloading_source.html">Dowload and unpack the source code</a><ul> -<li class="toctree-l3"><a class="reference internal" href="getting_started/downloading_source.html#download-the-latest-source-release">Download the latest source release</a></li> -<li class="toctree-l3"><a class="reference internal" href="getting_started/downloading_source.html#check-out-the-source-code-via-git">Check out the source code via Git</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a><ul> +<li class="toctree-l3"><a class="reference internal" href="getting_started.html#download-the-latest-source-release">Download the latest source release</a></li> +<li class="toctree-l3"><a class="reference internal" href="getting_started.html#check-out-the-source-code-via-git">Check out the source code via Git</a></li> </ul> </li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="configuration.html">Configuration</a><ul> @@ -205,12 +234,8 @@ </li> <li class="toctree-l2"><a class="reference internal" href="configuration/catalog_configuration.html">Catalog Configuration</a><ul> <li class="toctree-l3"><a class="reference internal" href="configuration/catalog_configuration.html#derby-configuration">Derby Configuration</a></li> -<li class="toctree-l3"><a class="reference internal" href="configuration/catalog_configuration.html#mysqlstore-configuration">MySQLStore Configuration</a></li> -<li class="toctree-l3"><a class="reference internal" href="configuration/catalog_configuration.html#mariadbstore-configuration">MariaDBStore Configuration</a></li> -</ul> -</li> -<li class="toctree-l2"><a class="reference internal" href="configuration/configuration_defaults.html">Configuration Defaults</a><ul> -<li class="toctree-l3"><a class="reference internal" href="configuration/configuration_defaults.html#tajo-master-configuration-defaults">Tajo Master Configuration Defaults</a></li> +<li class="toctree-l3"><a class="reference internal" href="configuration/catalog_configuration.html#mysql-mariadb-postgresql-oracle-configuration">MySQL/MariaDB/PostgreSQL/Oracle Configuration</a></li> +<li class="toctree-l3"><a class="reference internal" href="configuration/catalog_configuration.html#hcatalogstore-configuration">HCatalogStore Configuration</a></li> </ul> </li> <li class="toctree-l2"><a class="reference internal" href="configuration/ha_configuration.html">High Availability for TajoMaster</a><ul> @@ -222,6 +247,16 @@ <li class="toctree-l3"><a class="reference internal" href="configuration/ha_configuration.html#how-to-test-automatic-failover">How to Test Automatic Failover</a></li> </ul> </li> +<li class="toctree-l2"><a class="reference internal" href="configuration/service_config_defaults.html">Cluster Service Configuration Defaults</a><ul> +<li class="toctree-l3"><a class="reference internal" href="configuration/service_config_defaults.html#tajo-master-configuration-defaults">Tajo Master Configuration Defaults</a></li> +</ul> +</li> +<li class="toctree-l2"><a class="reference internal" href="configuration/tajo-site-xml.html">The tajo-site.xml File</a><ul> +<li class="toctree-l3"><a class="reference internal" href="configuration/tajo-site-xml.html#system-config">System Config</a></li> +<li class="toctree-l3"><a class="reference internal" href="configuration/tajo-site-xml.html#date-time-settings">Date/Time Settings</a></li> +</ul> +</li> +<li class="toctree-l2"><a class="reference internal" href="configuration/catalog-site-xml.html">The catalog-site.xml File</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="tsql.html">Tajo Shell (TSQL)</a><ul> @@ -259,6 +294,8 @@ <li class="toctree-l3"><a class="reference internal" href="sql_language/ddl.html#drop-database">DROP DATABASE</a></li> <li class="toctree-l3"><a class="reference internal" href="sql_language/ddl.html#create-table">CREATE TABLE</a></li> <li class="toctree-l3"><a class="reference internal" href="sql_language/ddl.html#drop-table">DROP TABLE</a></li> +<li class="toctree-l3"><a class="reference internal" href="sql_language/ddl.html#create-index">CREATE INDEX</a></li> +<li class="toctree-l3"><a class="reference internal" href="sql_language/ddl.html#drop-index">DROP INDEX</a></li> </ul> </li> <li class="toctree-l2"><a class="reference internal" href="sql_language/insert.html">INSERT (OVERWRITE) INTO</a></li> @@ -285,6 +322,14 @@ </li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="time_zone.html">Time Zone</a><ul> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#server-cluster-time-zone">Server Cluster Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#table-time-zone">Table Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#client-time-zone">Client Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#time-zone-id">Time Zone ID</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#examples-of-time-zone">Examples of Time Zone</a></li> +</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> @@ -300,6 +345,14 @@ </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><ul> +<li class="toctree-l3"><a class="reference internal" href="table_management/table_overview.html#overview">Overview</a></li> +<li class="toctree-l3"><a class="reference internal" href="table_management/table_overview.html#managed-table">Managed Table</a></li> +<li class="toctree-l3"><a class="reference internal" href="table_management/table_overview.html#external-table">External Table</a></li> +<li class="toctree-l3"><a class="reference internal" href="table_management/table_overview.html#table-properties">Table Properties</a></li> +<li class="toctree-l3"><a class="reference internal" href="table_management/table_overview.html#common-table-properties">Common Table Properties</a></li> +</ul> +</li> <li class="toctree-l2"><a class="reference internal" href="table_management/file_formats.html">File Formats</a><ul> <li class="toctree-l3"><a class="reference internal" href="table_management/csv.html">CSV (TextFile)</a></li> <li class="toctree-l3"><a class="reference internal" href="table_management/rcfile.html">RCFile</a></li> @@ -325,6 +378,16 @@ <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="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><ul> +<li class="toctree-l3"><a class="reference internal" href="index/how_to_use.html#create-index">1. Create index</a></li> +<li class="toctree-l3"><a class="reference internal" href="index/how_to_use.html#enable-disable-index-scans">2. Enable/disable index scans</a></li> +</ul> +</li> +<li class="toctree-l2"><a class="reference internal" href="index/future_work.html">Future Works</a></li> +</ul> +</li> <li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a><ul> <li class="toctree-l2"><a class="reference internal" href="backup_and_restore/catalog.html">Backup and Restore Catalog</a><ul> <li class="toctree-l3"><a class="reference internal" href="backup_and_restore/catalog.html#sql-dump">SQL dump</a></li> @@ -334,6 +397,13 @@ </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="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> +<li class="toctree-l2"><a class="reference internal" href="hbase_integration.html#insert-overwrite-into">INSERT (OVERWRITE) INTO</a></li> +<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="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><ul> <li class="toctree-l3"><a class="reference internal" href="jdbc_driver.html#from-binary-distribution">From Binary Distribution</a></li> Modified: tajo/site/docs/current/index/future_work.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/index/future_work.html?rev=1665114&r1=1665113&r2=1665114&view=diff ============================================================================== --- tajo/site/docs/current/index/future_work.html (original) +++ tajo/site/docs/current/index/future_work.html Mon Mar 9 02:35:26 2015 @@ -139,6 +139,13 @@ </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="../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> +<li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#insert-overwrite-into">INSERT (OVERWRITE) INTO</a></li> +<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="../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> Modified: tajo/site/docs/current/index/how_to_use.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/index/how_to_use.html?rev=1665114&r1=1665113&r2=1665114&view=diff ============================================================================== --- tajo/site/docs/current/index/how_to_use.html (original) +++ tajo/site/docs/current/index/how_to_use.html Mon Mar 9 02:35:26 2015 @@ -139,6 +139,13 @@ </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="../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> +<li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#insert-overwrite-into">INSERT (OVERWRITE) INTO</a></li> +<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="../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> @@ -189,7 +196,7 @@ <div class="section" id="create-index"> <h2>1. Create index<a class="headerlink" href="#create-index" title="Permalink to this headline">¶</a></h2> <p>The first step for utilizing index is index creation. You can create index using SQL (<a class="reference internal" href="../sql_language/ddl.html"><em>Data Definition Language</em></a>) or Tajo API (<a class="reference internal" href="../tajo_client_api.html"><em>Tajo Client API</em></a>). For example, you can create a BST index on the lineitem table by submitting the following SQL to Tajo.</p> -<div class="highlight-sql"><div class="highlight"><pre><span class="k">create</span> <span class="k">index</span> <span class="n">l_orderkey_idx</span> <span class="k">on</span> <span class="n">lineitem</span> <span class="p">(</span><span class="n">l_orderkey</span><span class="p">);</span> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">default</span><span class="o">></span> <span class="k">create</span> <span class="k">index</span> <span class="n">l_orderkey_idx</span> <span class="k">on</span> <span class="n">lineitem</span> <span class="p">(</span><span class="n">l_orderkey</span><span class="p">);</span> </pre></div> </div> <p>If the index is created successfully, you can see the information about that index as follows:</p> @@ -231,16 +238,16 @@ Indexes: <div class="section" id="enable-disable-index-scans"> <h2>2. Enable/disable index scans<a class="headerlink" href="#enable-disable-index-scans" title="Permalink to this headline">¶</a></h2> <p>When an index is successfully created, you must enable the index scan feature as follows:</p> -<div class="highlight-sql"><div class="highlight"><pre>\set INDEX_ENABLED true +<div class="highlight-sql"><div class="highlight"><pre>default> \set INDEX_ENABLED true </pre></div> </div> <p>If you don’t want to use the index scan feature anymore, you can simply disable it as follows:</p> -<div class="highlight-sql"><div class="highlight"><pre>\set INDEX_ENABLED false +<div class="highlight-sql"><div class="highlight"><pre>default> \set INDEX_ENABLED false </pre></div> </div> <div class="admonition note"> <p class="first admonition-title">Note</p> -<p class="last">If the index scan feature is enabled, Tajo currently always performs index scan regardless of its efficiency. You should set this option when the expected number of retrieved tuples is sufficiently small.</p> +<p class="last">Once the index scan feature is enabled, Tajo currently always performs the index scan regardless of its efficiency. You should set this option when the expected number of retrieved tuples is sufficiently small.</p> </div> </div> </div> Modified: tajo/site/docs/current/index/types.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/index/types.html?rev=1665114&r1=1665113&r2=1665114&view=diff ============================================================================== --- tajo/site/docs/current/index/types.html (original) +++ tajo/site/docs/current/index/types.html Mon Mar 9 02:35:26 2015 @@ -139,6 +139,13 @@ </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="../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> +<li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#insert-overwrite-into">INSERT (OVERWRITE) INTO</a></li> +<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="../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> Modified: tajo/site/docs/current/index_overview.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/index_overview.html?rev=1665114&r1=1665113&r2=1665114&view=diff ============================================================================== --- tajo/site/docs/current/index_overview.html (original) +++ tajo/site/docs/current/index_overview.html Mon Mar 9 02:35:26 2015 @@ -138,6 +138,13 @@ </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="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> +<li class="toctree-l2"><a class="reference internal" href="hbase_integration.html#insert-overwrite-into">INSERT (OVERWRITE) INTO</a></li> +<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="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> Modified: tajo/site/docs/current/introduction.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/introduction.html?rev=1665114&r1=1665113&r2=1665114&view=diff ============================================================================== --- tajo/site/docs/current/introduction.html (original) +++ tajo/site/docs/current/introduction.html Mon Mar 9 02:35:26 2015 @@ -30,7 +30,7 @@ <link rel="top" title="Apache Tajo 0.8.0 documentation" href="index.html"/> <link rel="next" title="Getting Started" href="getting_started.html"/> - <link rel="prev" title="Apache Tajo⢠0.9.0 Release Documentation" href="index.html"/> + <link rel="prev" title="Apache Tajo⢠(dev) - User documentation" href="index.html"/> <script src="https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js";></script> @@ -73,8 +73,9 @@ <li class="toctree-l2"><a class="reference internal" href="configuration/tajo_master_configuration.html">Tajo Master Configuration</a></li> <li class="toctree-l2"><a class="reference internal" href="configuration/worker_configuration.html">Worker Configuration</a></li> <li class="toctree-l2"><a class="reference internal" href="configuration/catalog_configuration.html">Catalog Configuration</a></li> -<li class="toctree-l2"><a class="reference internal" href="configuration/configuration_defaults.html">Configuration Defaults</a></li> <li class="toctree-l2"><a class="reference internal" href="configuration/ha_configuration.html">High Availability for TajoMaster</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/tajo-site-xml.html">The tajo-site.xml File</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/catalog-site-xml.html">The catalog-site.xml File</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="tsql.html">Tajo Shell (TSQL)</a><ul> @@ -97,6 +98,14 @@ <li class="toctree-l2"><a class="reference internal" href="sql_language/predicates.html">Predicates</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="time_zone.html">Time Zone</a><ul> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#server-cluster-time-zone">Server Cluster Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#table-time-zone">Table Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#client-time-zone">Client Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#time-zone-id">Time Zone ID</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#examples-of-time-zone">Examples of Time Zone</a></li> +</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> @@ -105,6 +114,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> @@ -186,7 +196,7 @@ queries in order to avoid the worst quer <a href="getting_started.html" class="btn btn-neutral float-right" title="Getting Started"/>Next <span class="fa fa-arrow-circle-right"></span></a> - <a href="index.html" class="btn btn-neutral" title="Apache Tajo⢠0.9.0 Release Documentation"><span class="fa fa-arrow-circle-left"></span> Previous</a> + <a href="index.html" class="btn btn-neutral" title="Apache Tajo⢠(dev) - User documentation"><span class="fa fa-arrow-circle-left"></span> Previous</a> </div> Modified: tajo/site/docs/current/jdbc_driver.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/jdbc_driver.html?rev=1665114&r1=1665113&r2=1665114&view=diff ============================================================================== --- tajo/site/docs/current/jdbc_driver.html (original) +++ tajo/site/docs/current/jdbc_driver.html Mon Mar 9 02:35:26 2015 @@ -30,7 +30,7 @@ <link rel="top" title="Apache Tajo 0.8.0 documentation" href="index.html"/> <link rel="next" title="Tajo Client API" href="tajo_client_api.html"/> - <link rel="prev" title="HCatalog Integration" href="hcatalog_integration.html"/> + <link rel="prev" title="HBase Integration" href="hbase_integration.html"/> <script src="https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js";></script> @@ -60,11 +60,11 @@ <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="configuration.html">Configuration</a><ul> @@ -73,8 +73,10 @@ <li class="toctree-l2"><a class="reference internal" href="configuration/tajo_master_configuration.html">Tajo Master Configuration</a></li> <li class="toctree-l2"><a class="reference internal" href="configuration/worker_configuration.html">Worker Configuration</a></li> <li class="toctree-l2"><a class="reference internal" href="configuration/catalog_configuration.html">Catalog Configuration</a></li> -<li class="toctree-l2"><a class="reference internal" href="configuration/configuration_defaults.html">Configuration Defaults</a></li> <li class="toctree-l2"><a class="reference internal" href="configuration/ha_configuration.html">High Availability for TajoMaster</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/service_config_defaults.html">Cluster Service Configuration Defaults</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/tajo-site-xml.html">The tajo-site.xml File</a></li> +<li class="toctree-l2"><a class="reference internal" href="configuration/catalog-site-xml.html">The catalog-site.xml File</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="tsql.html">Tajo Shell (TSQL)</a><ul> @@ -97,6 +99,14 @@ <li class="toctree-l2"><a class="reference internal" href="sql_language/predicates.html">Predicates</a></li> </ul> </li> +<li class="toctree-l1"><a class="reference internal" href="time_zone.html">Time Zone</a><ul> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#server-cluster-time-zone">Server Cluster Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#table-time-zone">Table Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#client-time-zone">Client Time Zone</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#time-zone-id">Time Zone ID</a></li> +<li class="toctree-l2"><a class="reference internal" href="time_zone.html#examples-of-time-zone">Examples of Time Zone</a></li> +</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> @@ -105,6 +115,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> @@ -116,11 +127,24 @@ <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="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> +<li class="toctree-l2"><a class="reference internal" href="index/future_work.html">Future Works</a></li> +</ul> +</li> <li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a><ul> <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="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> +<li class="toctree-l2"><a class="reference internal" href="hbase_integration.html#insert-overwrite-into">INSERT (OVERWRITE) INTO</a></li> +<li class="toctree-l2"><a class="reference internal" href="hbase_integration.html#usage">Usage</a></li> +</ul> +</li> <li class="toctree-l1 current"><a class="current reference internal" href="">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="#setting-the-classpath">Setting the CLASSPATH</a></li> @@ -207,7 +231,7 @@ Hadoop config files (i.e., <tt class="do You can get the driver <tt class="docutils literal"><span class="pre">Class.forName("org.apache.tajo.jdbc.TajoDriver")</span></tt>. The connection url should be <tt class="docutils literal"><span class="pre">jdbc:tajo://<TajoMaster</span> <span class="pre">hostname>:<TajoMaster</span> <span class="pre">client</span> <span class="pre">rpc</span> <span class="pre">port>/<database</span> <span class="pre">name></span></tt>. The default TajoMaster client rpc port is <tt class="docutils literal"><span class="pre">26002</span></tt>. -If you want to change the listening port, please refer <a class="reference internal" href="configuration/configuration_defaults.html"><em>Configuration Defaults</em></a>.</p> +If you want to change the listening port, please refer <a class="reference internal" href="configuration/cluster_setup.html"><em>Cluster Setup</em></a>.</p> <div class="admonition note"> <p class="first admonition-title">Note</p> <p class="last">Currently, Tajo does not support the concept of database and namespace. @@ -272,7 +296,7 @@ So, the host names must be shared with t <a href="tajo_client_api.html" class="btn btn-neutral float-right" title="Tajo Client API"/>Next <span class="fa fa-arrow-circle-right"></span></a> - <a href="hcatalog_integration.html" class="btn btn-neutral" title="HCatalog Integration"><span class="fa fa-arrow-circle-left"></span> Previous</a> + <a href="hbase_integration.html" class="btn btn-neutral" title="HBase Integration"><span class="fa fa-arrow-circle-left"></span> Previous</a> </div> Modified: tajo/site/docs/current/objects.inv URL: http://svn.apache.org/viewvc/tajo/site/docs/current/objects.inv?rev=1665114&r1=1665113&r2=1665114&view=diff ============================================================================== Binary files - no diff available.
