Added: tajo/site/docs/current/partitioning/column_partitioning.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/partitioning/column_partitioning.html?rev=1644658&view=auto ============================================================================== --- tajo/site/docs/current/partitioning/column_partitioning.html (added) +++ tajo/site/docs/current/partitioning/column_partitioning.html Thu Dec 11 14:43:31 2014 @@ -0,0 +1,280 @@ + + +<!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>Column Partitioning — 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="up" title="Table Partitioning" href="../table_partitioning.html"/> + <link rel="next" title="Range Partitioning" href="range_partitioning.html"/> + <link rel="prev" title="Introduction to Partitioning" href="intro_to_partitioning.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/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> +</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/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> +</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="../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/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 current"><a class="reference internal" href="../table_partitioning.html">Table Partitioning</a><ul class="current"> +<li class="toctree-l2"><a class="reference internal" href="intro_to_partitioning.html">Introduction to Partitioning</a></li> +<li class="toctree-l2 current"><a class="current reference internal" href="">Column Partitioning</a></li> +<li class="toctree-l2"><a class="reference internal" href="range_partitioning.html">Range Partitioning</a></li> +<li class="toctree-l2"><a class="reference internal" href="hash_partitioning.html">Hash Partitioning</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="../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><a href="../table_partitioning.html">Table Partitioning</a> »</li> + + <li>Column Partitioning</li> + <li class="wy-breadcrumbs-aside"> + + <a href="../_sources/partitioning/column_partitioning.txt" rel="nofollow"> View page source</a> + + </li> + </ul> + <hr/> +</div> + <div role="main"> + + <div class="section" id="column-partitioning"> +<h1>Column Partitioning<a class="headerlink" href="#column-partitioning" title="Permalink to this headline">¶</a></h1> +<p>The column table partition is designed to support the partition of Apache Hiveâ¢.</p> +<div class="section" id="how-to-create-a-column-partitioned-table"> +<h2>How to Create a Column Partitioned Table<a class="headerlink" href="#how-to-create-a-column-partitioned-table" title="Permalink to this headline">¶</a></h2> +<p>You can create a partitioned table by using the <tt class="docutils literal"><span class="pre">PARTITION</span> <span class="pre">BY</span></tt> clause. For a column partitioned table, you should use +the <tt class="docutils literal"><span class="pre">PARTITION</span> <span class="pre">BY</span> <span class="pre">COLUMN</span></tt> clause with partition keys.</p> +<p>For example, assume there is a table <tt class="docutils literal"><span class="pre">orders</span></tt> composed of the following schema.</p> +<div class="highlight-python"><div class="highlight"><pre>id INT, +item_name TEXT, +price FLOAT +</pre></div> +</div> +<p>Also, assume that you want to use <tt class="docutils literal"><span class="pre">order_date</span> <span class="pre">TEXT</span></tt> and <tt class="docutils literal"><span class="pre">ship_date</span> <span class="pre">TEXT</span></tt> as the partition keys. +Then, you should create a table as follows:</p> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">orders</span> <span class="p">(</span> + <span class="n">id</span> <span class="nb">INT</span><span class="p">,</span> + <span class="n">item_name</span> <span class="nb">TEXT</span><span class="p">,</span> + <span class="n">price</span> +<span class="p">)</span> <span class="n">PARTITION</span> <span class="k">BY</span> <span class="k">COLUMN</span> <span class="p">(</span><span class="n">order_date</span> <span class="nb">TEXT</span><span class="p">,</span> <span class="n">ship_date</span> <span class="nb">TEXT</span><span class="p">);</span> +</pre></div> +</div> +</div> +<div class="section" id="partition-pruning-on-column-partitioned-tables"> +<h2>Partition Pruning on Column Partitioned Tables<a class="headerlink" href="#partition-pruning-on-column-partitioned-tables" title="Permalink to this headline">¶</a></h2> +<p>The following predicates in the <tt class="docutils literal"><span class="pre">WHERE</span></tt> clause can be used to prune unqualified column partitions without processing +during query planning phase.</p> +<ul class="simple"> +<li><tt class="docutils literal"><span class="pre">=</span></tt></li> +<li><tt class="docutils literal"><span class="pre"><></span></tt></li> +<li><tt class="docutils literal"><span class="pre">></span></tt></li> +<li><tt class="docutils literal"><span class="pre"><</span></tt></li> +<li><tt class="docutils literal"><span class="pre">>=</span></tt></li> +<li><tt class="docutils literal"><span class="pre"><=</span></tt></li> +<li>LIKE predicates with a leading wild-card character</li> +<li>IN list predicates</li> +</ul> +</div> +<div class="section" id="compatibility-issues-with-apache-hive"> +<h2>Compatibility Issues with Apache Hiveâ¢<a class="headerlink" href="#compatibility-issues-with-apache-hive" title="Permalink to this headline">¶</a></h2> +<p>If partitioned tables of Hive are created as external tables in Tajo, Tajo can process the Hive partitioned tables directly. +There haven’t known compatibility issues yet.</p> +</div> +</div> + + + </div> + <footer> + + <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation"> + + <a href="range_partitioning.html" class="btn btn-neutral float-right" title="Range Partitioning"/>Next <span class="fa fa-arrow-circle-right"></span></a> + + + <a href="intro_to_partitioning.html" class="btn btn-neutral" title="Introduction to Partitioning"><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
Added: tajo/site/docs/current/partitioning/hash_partitioning.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/partitioning/hash_partitioning.html?rev=1644658&view=auto ============================================================================== --- tajo/site/docs/current/partitioning/hash_partitioning.html (added) +++ tajo/site/docs/current/partitioning/hash_partitioning.html Thu Dec 11 14:43:31 2014 @@ -0,0 +1,242 @@ + + +<!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>Hash Partitioning — 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="up" title="Table Partitioning" href="../table_partitioning.html"/> + <link rel="next" title="Backup and Restore" href="../backup_and_restore.html"/> + <link rel="prev" title="Range Partitioning" href="range_partitioning.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/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> +</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/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> +</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="../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/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 current"><a class="reference internal" href="../table_partitioning.html">Table Partitioning</a><ul class="current"> +<li class="toctree-l2"><a class="reference internal" href="intro_to_partitioning.html">Introduction to Partitioning</a></li> +<li class="toctree-l2"><a class="reference internal" href="column_partitioning.html">Column Partitioning</a></li> +<li class="toctree-l2"><a class="reference internal" href="range_partitioning.html">Range Partitioning</a></li> +<li class="toctree-l2 current"><a class="current reference internal" href="">Hash Partitioning</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="../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><a href="../table_partitioning.html">Table Partitioning</a> »</li> + + <li>Hash Partitioning</li> + <li class="wy-breadcrumbs-aside"> + + <a href="../_sources/partitioning/hash_partitioning.txt" rel="nofollow"> View page source</a> + + </li> + </ul> + <hr/> +</div> + <div role="main"> + + <div class="section" id="hash-partitioning"> +<h1>Hash Partitioning<a class="headerlink" href="#hash-partitioning" title="Permalink to this headline">¶</a></h1> +<div class="admonition-todo admonition" id="index-0"> +<p class="first last admonition-title">Todo</p> +</div> +</div> + + + </div> + <footer> + + <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation"> + + <a href="../backup_and_restore.html" class="btn btn-neutral float-right" title="Backup and Restore"/>Next <span class="fa fa-arrow-circle-right"></span></a> + + + <a href="range_partitioning.html" class="btn btn-neutral" title="Range Partitioning"><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 Added: tajo/site/docs/current/partitioning/intro_to_partitioning.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/partitioning/intro_to_partitioning.html?rev=1644658&view=auto ============================================================================== --- tajo/site/docs/current/partitioning/intro_to_partitioning.html (added) +++ tajo/site/docs/current/partitioning/intro_to_partitioning.html Thu Dec 11 14:43:31 2014 @@ -0,0 +1,253 @@ + + +<!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>Introduction to Partitioning — 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="up" title="Table Partitioning" href="../table_partitioning.html"/> + <link rel="next" title="Column Partitioning" href="column_partitioning.html"/> + <link rel="prev" title="Table Partitioning" href="../table_partitioning.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/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> +</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/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> +</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="../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/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 current"><a class="reference internal" href="../table_partitioning.html">Table Partitioning</a><ul class="current"> +<li class="toctree-l2 current"><a class="current reference internal" href="">Introduction to Partitioning</a></li> +<li class="toctree-l2"><a class="reference internal" href="column_partitioning.html">Column Partitioning</a></li> +<li class="toctree-l2"><a class="reference internal" href="range_partitioning.html">Range Partitioning</a></li> +<li class="toctree-l2"><a class="reference internal" href="hash_partitioning.html">Hash Partitioning</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="../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><a href="../table_partitioning.html">Table Partitioning</a> »</li> + + <li>Introduction to Partitioning</li> + <li class="wy-breadcrumbs-aside"> + + <a href="../_sources/partitioning/intro_to_partitioning.txt" rel="nofollow"> View page source</a> + + </li> + </ul> + <hr/> +</div> + <div role="main"> + + <div class="section" id="introduction-to-partitioning"> +<h1>Introduction to Partitioning<a class="headerlink" href="#introduction-to-partitioning" title="Permalink to this headline">¶</a></h1> +<p>Table partitioning provides two benefits: easy table management and data pruning by partition keys. +Currently, Apache Tajo only provides Apache Hive-compatible column partitioning.</p> +<div class="section" id="partitioning-methods"> +<h2>Partitioning Methods<a class="headerlink" href="#partitioning-methods" title="Permalink to this headline">¶</a></h2> +<dl class="docutils"> +<dt>Tajo provides the following partitioning methods:</dt> +<dd><ul class="first last simple"> +<li>Column Partitioning</li> +<li>Range Partitioning (TODO)</li> +<li>Hash Partitioning (TODO)</li> +</ul> +</dd> +</dl> +</div> +</div> + + + </div> + <footer> + + <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation"> + + <a href="column_partitioning.html" class="btn btn-neutral float-right" title="Column Partitioning"/>Next <span class="fa fa-arrow-circle-right"></span></a> + + + <a href="../table_partitioning.html" class="btn btn-neutral" title="Table Partitioning"><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 Added: tajo/site/docs/current/partitioning/range_partitioning.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/partitioning/range_partitioning.html?rev=1644658&view=auto ============================================================================== --- tajo/site/docs/current/partitioning/range_partitioning.html (added) +++ tajo/site/docs/current/partitioning/range_partitioning.html Thu Dec 11 14:43:31 2014 @@ -0,0 +1,242 @@ + + +<!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>Range Partitioning — 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="up" title="Table Partitioning" href="../table_partitioning.html"/> + <link rel="next" title="Hash Partitioning" href="hash_partitioning.html"/> + <link rel="prev" title="Column Partitioning" href="column_partitioning.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/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> +</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/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> +</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="../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/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 current"><a class="reference internal" href="../table_partitioning.html">Table Partitioning</a><ul class="current"> +<li class="toctree-l2"><a class="reference internal" href="intro_to_partitioning.html">Introduction to Partitioning</a></li> +<li class="toctree-l2"><a class="reference internal" href="column_partitioning.html">Column Partitioning</a></li> +<li class="toctree-l2 current"><a class="current reference internal" href="">Range Partitioning</a></li> +<li class="toctree-l2"><a class="reference internal" href="hash_partitioning.html">Hash Partitioning</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="../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><a href="../table_partitioning.html">Table Partitioning</a> »</li> + + <li>Range Partitioning</li> + <li class="wy-breadcrumbs-aside"> + + <a href="../_sources/partitioning/range_partitioning.txt" rel="nofollow"> View page source</a> + + </li> + </ul> + <hr/> +</div> + <div role="main"> + + <div class="section" id="range-partitioning"> +<h1>Range Partitioning<a class="headerlink" href="#range-partitioning" title="Permalink to this headline">¶</a></h1> +<div class="admonition-todo admonition" id="index-0"> +<p class="first last admonition-title">Todo</p> +</div> +</div> + + + </div> + <footer> + + <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation"> + + <a href="hash_partitioning.html" class="btn btn-neutral float-right" title="Hash Partitioning"/>Next <span class="fa fa-arrow-circle-right"></span></a> + + + <a href="column_partitioning.html" class="btn btn-neutral" title="Column Partitioning"><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 Added: tajo/site/docs/current/search.html URL: http://svn.apache.org/viewvc/tajo/site/docs/current/search.html?rev=1644658&view=auto ============================================================================== --- tajo/site/docs/current/search.html (added) +++ tajo/site/docs/current/search.html Thu Dec 11 14:43:31 2014 @@ -0,0 +1,240 @@ + + +<!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>Search — 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"/> + + + <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="#" 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> +<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> +</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/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> +</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="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/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="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="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></li> + <li class="wy-breadcrumbs-aside"> + + </li> + </ul> + <hr/> +</div> + <div role="main"> + + <noscript> + <div id="fallback" class="admonition warning"> + <p class="last"> + Please activate JavaScript to enable the search + functionality. + </p> + </div> + </noscript> + + + <div id="search-results"> + + </div> + + </div> + <footer> + + + <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/searchtools.js"></script> + + + + + + <script type="text/javascript" src="_static/js/theme.js"></script> + + + + + <script type="text/javascript"> + jQuery(function () { + SphinxRtdTheme.StickyNav.enable(); + }); + </script> + + <script type="text/javascript"> + jQuery(function() { Search.loadIndex("searchindex.js"); }); + </script> + + <script type="text/javascript" id="searchindexloader"></script> + + + +</body> +</html> \ No newline at end of file Added: tajo/site/docs/current/searchindex.js URL: http://svn.apache.org/viewvc/tajo/site/docs/current/searchindex.js?rev=1644658&view=auto ============================================================================== --- tajo/site/docs/current/searchindex.js (added) +++ tajo/site/docs/current/searchindex.js Thu Dec 11 14:43:31 2014 @@ -0,0 +1 @@ +Search.setIndex({envversion:42,terms:{"1st":18,represent:[37,18],all:[43,46,42,3,44,4,18,33,7,8,49,9,51,53,50],code:[4,49,40],dist:[43,17,49],c_name:53,rdbm:43,queri:[33,40,10,49],global:18,concern:[53,28],month:18,four:[45,18],prefix:[11,18],concept:[43,18],per:[51,33,44,10],abil:33,mno:50,follow:[2,4,6,7,8,9,10,11,31,14,46,17,18,19,20,21,22,23,24,27,28,32,33,35,37,53,41,42,43,44,45,49,50,51],disk:[4,10],row:[11,31,50,6,19,7,8,49,9,37,21],millisecond:18,content:[12,3,35,49],privat:43,complet:33,depend:[33,42,43,8],zone:[23,18],getconnect:43,dist_query_join_task_volum:51,decim:[23,18],executor_external_sort_buffer_s:51,init:50,hadmin:33,present:[40,9],jvm:33,skip:18,sql_languag:9,thursdai:18,"case":[28,15,43,18,19,8,49,21],digit:[23,18],sourc:[40,49,18],everi:[33,7],string:[13,4,28,18],fals:[23,37,4,8],"void":43,ddl:[53,50],csvfile:[50,35,6],varchar:23,util:39,volum:[50,9],failur:33,veri:[3,44,8],affect:[49,10,18],implicitli:7,hdfs_locat:19,exact:23,dbname:9,tri:43,recordcompresswri t:21,did:18,"12th":18,list:[46,9,44,33,20,8,22,7,50],scalar:[7,37],hive:[12,42,49],"try":[33,43,41],date_part:18,interfac:[33,39,6],adjust:[27,18,19,37,6,10],form:[19,27,7],cosin:[26,9],vertic:6,dealt:7,println:43,tmmonth:18,tajo_src:17,locat:[43,14,3,4,19,35,49,50,53,10],tajo_hom:[43,28,41,3,44,33,49,50],dir:[44,14,10],pleas:[43,3,44,4,18,19,7,50,37,6,53,10],prevent:33,templet:28,smaller:14,boolean_express:7,ten:[42,40],natur:7,sign:[26,8],past:18,dowload:40,long_table_name_1234:7,cost:16,design:[16,20,28,37],aggreg:[11,2,7],pass:7,download:4,val2:[51,8],val1:[51,8],histori:33,port:[27,41,46,43,44,33,49],tmpdir:10,even:[33,18],asin:26,what:18,abc:[8,50],addr:[4,49],compar:23,clock:18,section:[42,43,44,18,19,6,40,10],xtajoxx:15,calcul:7,current:[27,41,42,43,32,18,33,7,8,49,9,37,45,10],c_phone:53,"19th":18,version:[17,49,9],directori:49,decompress:[37,22],ab_bc_cd:15,supplier:9,"new":[33,18,9],to_dat:18,method:[12,53],era:18,showmast:46,ongo:33,elimin:[35,7],full:[7,18],hash:12,deriv :7,pow:26,gener:[33,6],never:33,onli:[27,28,3,32,18,19,7,21,49,22,37,6],here:[21,3,8,50,18],tangent:26,address:[44,4,33,47,49,23],path:[27,42,43,4,35,49,9,53,50],o_orderprior:9,sine:26,modifi:18,sinc:[19,49,18],valu:[26,12,27,28,42,44,4,18,33,49,10],wait:33,convert:[26,33,4,54,18],aaabc:8,deterior:37,weekdai:18,haadmin:33,shift:18,cli_print_error_trac:51,larger:[23,7,37],table_backup:53,later:40,precis:[23,18],datetim:13,amount:33,behavior_arithmetic_abort:51,behav:7,codebas:22,character_length:15,chang:[44,22,43,49,9],commonli:6,sequencefil:[12,45,19],dayofweek:18,via:[33,44,40],regardless:[19,37],starttim:46,data_typ:35,appli:[33,18],transit:33,substr:[7,15,18],unix:18,"boolean":[23,7,4,37],namenode_hostnam:27,wip:[49,22],instal:[4,49,17],total:[7,10],unit:[49,37],num1:26,from:[26,12,15,50,18,33,22,53],describ:[42,9],would:[42,17,18],memori:[33,49],distinct:[7,18],doubl:18,two:[3,32,18,19,8,28,53,54,21],next:[42,43,18],connector:[42,49],few:28,program:[28,37],call:[12,7],usr:49,re commend:[17,18],stage:50,type:[26,12,15,4,18,28,50,53,10],until:51,tajo_pid_dir:33,more:[11,31,42,37,44,18,7,8,49,50,40,10],sort:7,flat:[19,21,37],capit:18,discompress:17,hiveql:42,claus:[12,50,20,8,23],supergroup:24,hurt:16,function_nam:54,rootdir:44,exce:18,name2:51,indic:18,name1:51,known:20,central:33,editor:[33,44],unpack:40,must:[11,27,43,18,33,7,49,37,23],tabular:6,word:[19,18,10,6],hour:18,grant:49,formatha:33,alia:[23,7,15,9],setup:38,work:[23,37,18,9],timestamptz:23,dev:4,cat:[11,33,44,53,50],orderbi:12,column:12,itself:[33,9],can:[3,6,7,8,9,10,11,18,19,20,21,22,24,49,33,35,37,39,17,42,43,44,28,50],learn:3,field:[18,9,15,6],purpos:[42,28],root:[26,44],fmss:18,def:50,bewtween:23,control:33,nearest:[26,18,9],prompt:[41,31,9],to_char:18,tar:[43,17,49,22],give:[35,7,10],process:[12,16,18,19,20,37,6,39],fmdd:18,share:[19,43,7],backslash:[18,9],templat:[49,18],high:38,liter:[18,28,6],want:[27,43,14,28,41,42,3,44,31,18,33,20,21,49,50,35,24,53,10],tarbal:33,tan:26,keep:18,occur:[3 5,19,7,18],tinyint:23,unresolvedaddressexcept:12,alwai:18,sundai:18,isoyear:18,multipl:[33,18,7,10,6],goal:16,divid:[26,7,18],anoth:[33,54],ordinari:18,hdf:[12,27,16,43,44,35,50,39,40,10],mapr:21,how:44,yyyymondd:18,purg:35,consist:[18,19,7,21,28,6],env:[33,49],c_address:53,main:[16,43,8,28],instead:[18,41,8,49,50,6],csv:[12,35,53,50],config:[28,42,43,44,33,47,49,51,10],sin:26,blockcompresswrit:21,updat:33,jline2:2,transitiontoact:33,product:7,resourc:[33,47,44],ltrim:15,atan:26,client_session_expiry_tim:51,clone:[49,22],after:[7,17,18],resultset:43,concatnen:15,cli_error_stop:51,befor:[33,2,7,44],catalog:1,"4th":18,floor:26,date:53,end:[24,15,22],underscor:8,mariadb:49,data:[33,44,49],parallel:44,physic:44,subsequ:18,github:22,essenti:33,third:[49,18],read:[37,22,44,6],cli_print_paus:51,quot:[41,18],favorit:[33,44],correspond:[19,7],element:[33,28],caus:[33,18],inform:[33,18,49,9],preced:[4,18],environ:[28,27,3,42,10],block:[21,37],allow:[11,27,42,37,44,18,19,7,50,35,6,10],enter:[1 2,17],worst:16,first:[15,40,28,18,17,49],item:[24,8,18],order:[43,16,42,3,44,6,19,7,49,9,20,37,23,10,50],quantiti:7,includ:[43,7,10,18],oper:[33,13,49],help:9,shorten:49,over:7,fall:[7,18],midnight:18,becaus:[33,2,18,7,6],comma:[18,7,6],same:[26,42,4,18,33,7,8],equival:[14,7,18],still:33,vari:[23,18],dynam:16,entiti:33,smallint:23,write:[19,37,18,21,6],style:8,outer:7,cli:[39,9],overwrit:[12,52,33],fix:18,defin:6,late:18,window:12,complex:[7,18],persist:[3,49],decad:18,therefor:[33,18],isodow:18,non:[37,7,18],"float":[26,37,6,19,20,21,50,23,10],synopsi:[35,12,7,8],greater:26,thei:[19,8,33,18],add_month:18,handl:43,timestamp:[23,18],"1gb":[27,10],spell:18,col2:[14,8],dai:18,initi:33,col1:[14,8],ssss:18,framework:37,lzo:37,verifi:33,item_nam:20,now:[37,17,18,19,9,51,6,53],utc_usec_to:[18,9],nor:8,introduct:12,tajo_worker_heaps:10,choic:37,subqueri:7,hive_jdbc_driver_dir:[42,49],name:[4,6,7,9,10,11,18,19,21,23,27,49,33,37,39,53,41,42,43,44,47,28,50,51],reoptim:16,simpl:[3,50],drop:12,r egexp_replac:15,instruct:[42,4],lazybinaryserd:21,separ:[31,18,7,21,6],easili:[33,43,44],submit:[33,40,50],mode:49,each:[44,28],januari:18,clsspath:43,quarter:18,compatibl:53,side:[43,15],truncat:26,mean:[8,18],compil:[42,17,49],domain:[33,44,8,6],map:23,unequ:33,individu:7,saturdai:18,procedur:17,group:[7,8,37],resut:26,meta:[12,3,39,49],"static":43,connect:[42,43,41,49,9,51],year:[7,18],our:6,extract:[18,9],special:6,out:10,variabl:[12,27,28,42,3,49,9,23,39,10],unquot:9,shown:18,o_com:9,network:[33,13],space:[15,18],although:18,storag:[27,3,6,19,21,49,37,53],access:[33,42,43,44,37],o_orderkei:9,xxtajo:15,profil:[42,49],millennium:18,hivemetastor:[42,49],print:18,roma:18,math:13,integr:49,bye:50,shut:40,parquet:[12,45],partit:12,advanc:[16,7],lastli:49,manipul:51,given:[14,15,41,50,4,18,23,7,8,9,35],free:50,standard:[16,23,50,8,18],asc:7,standalon:40,base:49,asf:[49,22],dictionari:37,usual:[28,6],put:[11,18],org:[43,42,9,6,19,35,21,49,22],"byte":[23,37,50,9],fridai:18,div:26,card:2 0,care:[18,6],str2:15,recogn:6,launch:49,angl:26,real:26,could:18,omit:[19,18,7,9],p_id:11,retriv:43,round:[26,9],filter:[7,8],length:[23,18],iso:18,rcfile:[12,45],fxyyyi:18,umbil:[33,47,44],timezon:51,think:50,mvn:[42,43,17,49],str1:15,feed:6,schema:[9,14,37,20,50,39],meridiem:18,l_comment:35,suffix:18,directli:[20,6],resourceconfigur:10,feel:50,onc:[33,7,4],arrai:8,independ:37,applciat:43,number:44,system:[43,28,33,16,3,44,19,49,24,17,10],restrict:18,mai:[31,28,3,18,33,7,49,17],o_orderd:9,alreadi:33,done:[17,18],unhealthi:33,blank:18,tpch:[53,9],open:16,primari:[33,27],differ:[7,8,18],cartesian:7,script:[17,28],xii:18,interact:[16,41,50],mkdir:[24,44,50],capac:[44,10],least:[7,8],getstat:33,paramt:11,l_partkei:[35,14,7],too:37,saint:18,termin:6,scheme:[27,50],boot:[3,49],"final":[42,43,49,50],store:[11,33,16,42,3,6,19,21,49,9,10,50],q_1411357607375_0006:46,mysql_jdbc_driv:[42,49],shell:[12,40,28,50],option:[11,46,17,41,35,7,18,53],inspect:39,especi:23,namespac:43,tool:9,copi:[28,4 9],inexact:23,grouping_column_refer:7,radian:26,"short":[19,7],enclos:7,mostli:19,twenti:18,fsshell:24,attempt:18,exactli:8,geoip_country_cod:4,serv:33,enjoi:50,kind:7,target:[26,14,43,33,49,17],keyword:[7,21],provid:[46,31,43,33,16,2,3,4,32,6,19,8,49,50,51,24,45,39,37,10,21],expr:7,remov:[3,35,15,49],tree:17,second:[33,15,49,18],mmdd:18,charact:[15,18,19,20,8,23,6],project:[16,37],serd:[19,6],arc:26,posix:8,balanc:16,becom:[33,18],tajoresourcemanag:33,float8:[26,23,14,53,9],minut:[42,40,18],listen:[43,44],codegen:51,unix_timestamp:18,comput:[7,18],abov:[19,2,31,21,50],textserd:21,ran:49,julian:18,respons:[11,16,2,31,50],mind:18,ani:[43,6,33,7,8,49,9,37],"return":[26,15,4,18,8,6],packag:[42,43],chmod:44,manner:43,have:[12,27,42,18,35,49],further:6,need:[43,33,42,3,18,19,21,49,50,37,6,53],maxmind:4,predic:[12,20,52],calendar:18,test_min_task_num:51,cli_null_char:51,tajocli:33,catalogstor:33,squar:26,zero:[8,18],partsupp:9,statement:[11,14,41,46,43,50,6,19,7,8,9,35,37,21],click:22,not e:[8,49,18],also:[22,50,18,33,20,8,49,9,51,7,6,21],without:[31,16,18,20,49,7,6],take:[42,7,40,22],which:[43,33,16,3,41,18,19,7,21,49,50,51,35],techniqu:16,combin:7,subject:7,brace:11,prepar:[42,17,49,50],singl:[12,44,18,33,8,37,39],compat:[12,49,10],lineitem_100_snappi:35,c_nationkei:53,unless:18,distribut:49,preliminari:38,buffer:[25,37],price:20,previou:[8,18],compress:12,deflatecodec:35,untar:22,most:[49,6],microsecond:18,specifi:[27,14,41,46,42,43,4,6,19,54,7,8,49,37,23,24,18,17,10,21],deploi:33,phase:20,metacharact:8,choos:[17,22],cbrt:26,"class":[42,43,6,19,8,49,21],appear:7,other:[14,33,16,18,19,7,28,6,10],doi:18,don:[43,53,28,17],url:[27,43],doc:9,clear:9,binaryserd:21,request:10,uri:[33,49],ghi:50,salari:7,part:[18,9],snapshot:[17,49],classnotfoundexcept:43,determin:[7,10],pattern:[12,15,18],link:22,querymast:[33,10],axi:26,remot:44,dow:18,pope:18,show:[46,43,50,51,9,40],text:[11,15,23,33,50,44,4,6,19,20,8,9,35,37,18,53,21],hostnam:[41,27,43,44,49],rtrim:15,syntax:[7,54],co lumn_refer:8,session:[12,39,9],l_discount:7,identifi:[7,49,18],rang:[12,32],ship_dat:20,find:33,xml:[33,44,49],absolut:[26,50,49,9],row_num:7,explicitli:[7,28],ratio:10,just:[33,7,8,49,51,24,53],copyright:9,much:10,explain:[3,43,44,6,19,7,40],apach:[42,3,4,49,22,40,50],abbrevi:18,than:[11,26,14,42,18,7,8,40],jan:18,fmhh:18,l_quantiti:[14,7],tbname:9,search_condit:7,local:[4,18,49,22,40,10],test_filter_pushdown_en:51,ddsp:18,info:[46,33,47],"53rd":18,cube:26,variou:[51,18],get:[33,49,18],fmmonth:18,familiar:[19,37,6],express:[12,52,15,18],disagre:18,ceil:26,repo:[49,22],cannot:6,java_hom:3,progress:[11,16,2,46,31],increas:44,score:[11,31,37,6,19,21,50],requir:[33,31,3,7,18],prune:12,table_refer:7,bar:6,enabl:[33,43,44,6,19,49,37],tajodriv:43,upper:[15,18],grtajo01:46,borrow:8,"public":43,ddth:18,current_timestamp:18,common:7,dist_query_sort_task_volum:51,contain:[33,43,35,44,18],clean:[42,43,17,49],metadata:19,where:[12,3,44,20,8,49,50,23,10],valid:18,bytea:23,dhadoop:17,set:49,frame :7,knowledg:6,startup:41,memstor:49,c_custkei:53,see:[3,44,18,49,50,10],num:[41,7],sec:[11,31,46,2,49,50],result:[43,18,33,7,50,37,9],arg:[46,43],float4:[23,9],close:43,rlike:8,unqualifi:[20,7],improv:37,o_orderstatu:9,valn:8,awar:10,statu:33,detect:33,kei:[11,32,18,19,20,21,51,35],correctli:[23,17],down:[8,40],ieee:23,char_length:15,below:[40,18,19,37,6,53],yet:20,cli_print_pause_num_record:51,smallest:[26,37],subdir:14,between:[43,8],"\u02c6ab":15,l_orderkei:[35,14,7],neither:8,paramet:[26,12,15,4,18,19,35,37,6],approach:53,across:[44,7],altern:8,accord:[23,7],parent:17,numer:18,executor_groupby_inmemory_hash_threshold:51,vatican:18,hadoop_hom:[3,44],add_dai:18,o_totalpric:9,remaind:26,snappi:37,gregorian:18,outfil:53,disconnect:[51,33],argument:[26,31,18,7,9,24],problem:[33,2],monitor:33,both:[15,33,16,6,19,7,21],last:[7,18],"85e7":18,admin:[46,9],fault:16,howev:37,gzipcodec:35,c_comment:53,groupbi:12,against:40,etc:39,roman:18,instanc:[27,3,44,40],compressioncodec:[19,6],context :18,logic:8,let:21,whole:10,fmyyyi:18,load:[16,50],english:18,simpli:17,point:[19,33,18],overview:12,format:33,period:[33,18],split_part:15,hh12:18,header:19,rpc:[33,47,43,44],written:[19,21],param:[11,41,7],shutdown:33,toler:16,respect:[23,8],tuesdai:18,guid:9,assum:[31,50,20,10,18],transitiontobackup:33,abscissa:26,cathedr:18,quit:9,xzvf:[43,17,22],strong:53,java:[12,28,42,3,49,25],creat:[12,44,53,49,50,40],nonsens:18,invers:9,empti:[19,7,6],otherwis:[41,18,7,4,8],compon:33,"int":[26,15,37,18,19,20,21,50,23,6],json:6,trigger:33,besid:6,interpret:18,basic:[16,12,53,21,6],addit:[14,43,7,8,10],c_mktsegment:53,multipli:18,host2:[33,44],derbystor:[33,49],o_custkei:9,legaci:4,exercis:40,num2:26,decimaln:9,suppress:18,xxx:9,worker:38,search:12,cli_output_formatter_class:51,wish:11,tajojdbccli:43,coordin:26,togeth:18,func:7,input:[26,15,18],"catch":43,repetit:8,countri:[4,18],due:10,those:[19,37,43,6],statist:33,emploi:16,ident:18,implementaion:27,plain:[19,21],servic:[47,49],properti:[27 ,28,42,44,4,33,47,49,10],iyi:18,batch:16,rectangular:26,cli_max_column:51,cast:[12,18],"while":[43,18],uniqu:51,behavior:7,error:[35,18],wild:20,exist:[35,19,14,41],region:9,lazybinarycolumnarserd:19,textserializerdeseri:[19,21,6],bin:[11,31,41,42,2,3,44,33,49,50,53],layer:27,relat:[7,37],advantag:37,ctrl:[33,44,50],key1:51,tabl:[42,3,53,49,50,40],them:7,activ:33,cluster:[38,49],"default":[38,44,49],archiv:[17,49],warehous:[16,24,35],textfil:12,conf:[27,28,41,42,3,44,4,33,49,10],centuri:18,crash:33,mod:26,abcdef:15,primit:23,conn:43,"null":[43,7],develop:22,"35b":50,csvfile_nul:51,perform:7,suggest:22,belong:7,classpath:12,hadoop:[43,16,3,44,17,6,19,35,8,28,50,37,24,25,40,21],sqrt:26,binari:[12,17,49],epoch:18,html:9,pad:18,split:15,largest:26,dtar:[42,43,17,49],start:[33,44,15,18],conflict:33,higher:25,week:18,varbit:23,lineitem:[35,14,46,7,9],http:[9,4,33,47,49,22],nio:12,denot:8,optim:16,nest:37,driver:[12,42,49],geoip_in_countri:4,col3:14,jkl:50,column_nam:35,moment:[37,6],rais: 26,dskiptest:[42,43,17,49],user:[27,33,50,18,19,7,49,9,24,6,39,37,10],tajo_classpath:49,mani:[19,43,10,9],extern:[35,19,20,53,50],nation:9,tsql:[12,53,50],typic:7,built:[19,43,9],lower:[15,18],appropri:[28,50],off:18,lib:49,mention:19,com:[33,44,4],thu:17,page:[12,44,37],well:[35,14,23,18],parenthes:[7,8],inherit:[19,6],to_numb:18,exampl:[33,44,53,49],command:[12,50,39,53,17],thi:[11,53,37,28,42,43,44,17,6,33,7,8,49,22,50,24,18,40,10,21],filesystem:[40,22],gzip:37,fmmm:18,lc_time:18,createdatabaseifnotexist:49,fmmi:18,left:7,explan:50,construct:[7,18],protocol:25,entri:[33,35,44],execut:[33,44,40,10],less:[26,18],when:[43,14,3,18,33,7,49,37,35,6],dist_query_groupby_task_volum:51,ordin:[26,18],tcp:41,jar:[42,43,49],q_1363768615503_0001_000001:50,kill:[46,33],mysql:[42,49],rest:7,simultan:10,bit:23,languag:[16,12,50],inet4:[23,4],move:17,web:[16,33],binaryserializerdeseri:[19,21],all_backup:53,easi:[53,32],mix:18,disk1:10,disk2:10,disk3:10,except:[43,7,49,18],shortcut:24,date_ord:51,a dd:[43,28,42,3,44,33,35,49,24,10],divis:26,blob:23,versa:19,backup_and_restor:9,work1:9,expon:26,disrupt:33,modul:[12,28],euler:26,build:40,earli:18,applic:7,complaint:18,march:18,littl:44,serde2:[19,21],preserv:33,wai:[33,18,53,6],subfield:18,host1:[33,44],bzip2codec:35,"4028235e":23,iyyi:18,workload:10,phcatalog:[42,49],mon:18,background:[12,39],insert:[12,52,33],database_nam:[41,35],password:49,licens:9,desc:[46,7],linux:9,u0001:6,storage_typ:35,table1:[11,31,43,6,19,7,8,50,37,21],resid:50,like:[27,43,20,17,18],specif:[33,27,14,23,18],filenam:41,should:[27,37,41,42,43,44,4,18,19,20,49,50,35,53,6,40,10],manual:[19,49],integ:[26,23,18,10,9],server:[46,33,3,28,49],pdist:[42,43,17,49],collect:21,benefit:32,api:12,necessari:16,either:[42,22,7,8,37,23],descend:7,output:[14,7,21,18],timetz:23,tajo:[38,53,49],result_set_fetch_rownum:51,another_long_table_name_5678:7,geoip:4,yyyi:18,right:7,peter:18,who:6,order_d:20,createstat:43,interv:[33,18],suppli:18,some:[28,42,2,3,18,19,7,49,50,23,3 7,6,17],begin:[18,9],tajowork:[33,28,10],certain:[19,37,14,6],arithmet:[12,7],intern:28,current_d:18,queryid:46,test_broadcast_join_en:51,yyyymmdd:18,mirror:22,proper:[27,3,49,10,17],home:[42,3,53,49,50],"52nd":18,row_numb:7,tmp:[24,3,27,49,50],query_succeed:50,cnt:7,scale:16,tajo_master_heaps:27,lead:[20,15,18],channel:12,"512mb":10,been:9,avoid:[16,33,2,35,18],exec:21,definit:[12,52,18],best:6,usernam:[3,49],alias_nam:7,tracker:[33,47,44],exit:2,select:[11,26,31,14,15,46,43,4,18,7,8,9,50],bigint:[23,35],xxxxxx:49,condit:7,fornam:43,three:[21,49,18],localhost:[41,44,33,47,35,49],ddd:18,machin:[33,49,41],core:[43,10],o_shipprior:9,run:[33,44],power:[26,8],uncompress:[21,37],oracl:18,executor_hash_join_size_threshold:51,dist_query_table_partition_volum:51,usag:[12,37,53,18],mixtur:18,maven:[42,17,49],broken:6,step:17,atan2:26,durat:49,repositori:22,found:24,peer:47,l_extendedpric:7,subtract:18,unicod:23,c_acctbal:53,comparison:[23,8],ascend:7,repeat:18,postgresql:8,dist_query_groupby _partition_volum:51,dist_query_join_partition_volum:51,varbinari:23,aco:[26,9],total2:7,simul:33,degre:[26,44],regular:15,sequecnefil:21,issu:12,table_nam:[35,53],approxim:23,disabl:[19,37,6],hive_hom:[42,49],plan:[16,20,6],executor_outer_hash_join_size_threshold:51,columnarserd:19,client:[12,47,44,49,33],own:6,effici:37,consid:33,primarili:18,within:[33,24,7,18],encod:37,lazybinari:21,compos:[20,37],stop:[33,2],pair:[19,21,28],master:[38,44,49],refer:[43,3,44,4,6,19,7,21,9,37,50],val3:51,ensur:[3,49],"import":43,yyi:18,your:[27,43,28,33,42,3,44,17,18,19,49,22,37,53,6,40],manag:[12,42,3,32,49],git:49,val:51,pictur:9,hh24:18,support:[27,53,49,18],"long":[16,7,18],custom:[53,49],avail:38,width:18,drivermanag:43,current_databas:51,q_1411357607375_0007:46,inner:7,fraction:18,replac:[15,18],"var":49,datanod:10,ipv4:[23,4],snappycodec:[19,35,21,6],enough:49,forc:[7,18],test_join_opt_en:51,drwxr:24,compressiontyp:21,jun:18,tajoxx:15,back:33,query_run:46,int4:[23,14,15,9],jdbc:[12,42,49],ma x_output_file_s:51,translat:18,select_stat:35,int2:23,l_shipdat:7,line:[33,39,44,6],"true":[4,33,21,49,37,23,10,8],int8:[26,23,14,53,9],stmt:43,count:[11,31,15,46,18,7],utc:18,"throw":43,dist_query_broadcast_join_threshold:51,theta:26,temp:24,possibl:[7,10,18],whether:[19,7,8],ecosystem:37,vice:19,standbi:33,day_of_week:18,record:[19,37,8,21,6],to_timestamp:18,current_tim:18,limit:[12,10],toggl:18,sum:[11,31,7],site:[33,44,49],"export":[42,3,49],embed:49,executequeri:43,defaultport:49,delimit:[50,35,15,6],expect:18,trim:15,model:[12,52],featur:[11,19,42,37,6],constant:26,semicolon:[24,31],btrim:15,host:[41,46,43,44,33,49],retriev:18,dure:20,pid:33,repres:[18,6],"char":[23,18],novemb:18,executor_inner_hash_join_size_threshold:51,implement:[18,3,9],"20000nov31":18,file:[44,53,49],guarante:33,doe:[43,18,33,35,37,7,6],match:[12,23,15,18],fill:[43,18],incorrect:33,tab:6,consum:37,successfulli:[46,33],codec:[19,35,21,6],know:[44,50,7,18],sort_expr:7,index:12,percent:8,detail:[46,50,44,18, 7,49,9,37],getstr:43,debug_en:51,finish:33,bracket:8,bool:23,o_clerk:9,varieti:28,test:49,you:[2,3,4,6,7,8,9,10,11,31,14,17,18,19,20,21,22,40,24,27,28,33,35,37,53,41,42,43,44,49,50],node:[33,43,44,10],polar:26,iddd:18,intend:18,exp:26,highli:17,customserializerdeseri:6,sequenc:8,symbol:11,introduc:12,briefli:7,insensit:8,mondai:18,tajomast:[38,44,49],columnar:[19,37],src:[22,43,18],empsalari:7,haven:20,algorithm:[19,37,10,6],trail:[15,18],hyunsik:[53,9],regexp:8,descript:[46,50,18,33,47,8,49,9,23,10],cpu:10,select_list:7,carriag:6,place:9,ignor:[10,18],invok:33,time:33,decemb:18,backward:10,small:[23,37],hello:18,unset:[51,9],name3:51},objtypes:{"0":"py:function"},objnames:{"0":["py","function","Python function"]},filenames:["partitioning/hash_partitioning","backup_and_restore","tsql/background_command","getting_started/local_setup","functions/network_func_and_operators","partitioning/range_partitioning","table_management/csv","sql_language/queries","sql_language/predicates","tsql/m eta_command","configuration/worker_configuration","tsql/execute_file","index","functions","sql_language/insert","functions/string_func_and_operators","introduction","getting_started/building","functions/datetime_func_and_operators","table_management/rcfile","partitioning/column_partitioning","table_management/sequencefile","getting_started/downloading_source","sql_language/data_model","tsql/dfs_command","getting_started/prerequisites","functions/math_func_and_operators","configuration/tajo_master_configuration","configuration/preliminary","table_management/compression","faq","tsql/single_command","partitioning/intro_to_partitioning","configuration/ha_configuration","table_partitioning","sql_language/ddl","table_management","table_management/parquet","configuration","tsql","getting_started","tsql/intro","hcatalog_integration","jdbc_driver","configuration/cluster_setup","table_management/file_formats","tsql/admin_command","configuration/configuration_defaults","tajo_client_api","confi guration/catalog_configuration","getting_started/first_query","tsql/variables","sql_language","backup_and_restore/catalog","sql_language/sql_expression"],titles:["Hash Partitioning","Backup and Restore","Executing as background process","Setting up a local Tajo cluster","Network Functions and Operators","Range Partitioning","CSV (TextFile)","Queries","Predicates","Meta Commands","Worker Configuration","Executing Queries from Files","Apache Tajo\u2122 0.9.0 Release Documentation","Functions","INSERT (OVERWRITE) INTO","String Functions and Operators","Introduction","Build source code","DateTime Functions and Operators","RCFile","Column Partitioning","SequenceFile","Dowload and unpack the source code","Data Model","Executing HDFS commands","Prerequisites","Math Functions and Operators","Tajo Master Configuration","Preliminary","Compression","FAQ","Executing a single command","Introduction to Partitioning","High Availability for TajoMaster","Table Partitioning","Data Definition Language ","Table Management","Parquet","Configuration","Tajo Shell (TSQL)","Getting Started","Introducing to TSQL","HCatalog Integration","Tajo JDBC Driver","Cluster Setup","File Formats","Administration Commands","Configuration Defaults","Tajo Client API","Catalog Configuration","First query execution","Session Variables","SQL Language","Backup and Restore Catalog","SQL Expressions"],objects:{"":{trim:[15,0,1,""],upper:[15,0,1,""],to_char:[18,0,1,""],btrim:[15,0,1,""],regexp_replace:[15,0,1,""],cbrt:[26,0,1,""],split_part:[15,0,1,""],sign:[26,0,1,""],add_months:[18,0,1,""],to_date:[18,0,1,""],tan:[26,0,1,""],extract:[18,0,1,""],current_time:[18,0,1,""],floor:[26,0,1,""],sqrt:[26,0,1,""],acos:[26,0,1,""],char_length:[15,0,1,""],current_date:[18,0,1,""],abs:[26,0,1,""],degrees:[26,0,1,""],pow:[26,0,1,""],pi:[26,0,1,""],sin:[26,0,1,""],ltrim:[15,0,1,""],atan:[26,0,1,""],asin:[26,0,1,""],cos:[26,0,1,""],ceil:[26,0,1,""],atan2:[26,0,1,""],rtrim:[15,0,1,""],now:[18,0,1,""],utc_usec_to:[18,0,1,"" ],geoip_in_country:[4,0,1,""],mod:[26,0,1,""],lower:[15,0,1,""],radians:[26,0,1,""],date_part:[18,0,1,""],to_timestamp:[18,0,1,""],geoip_country_code:[4,0,1,""],add_days:[18,0,1,""],exp:[26,0,1,""],div:[26,0,1,""],round:[26,0,1,""]}},titleterms:{code:[43,17,22],execut:[11,2,31,24,50],queri:[11,7,50],session:51,permiss:44,hcatalogstor:49,languag:[52,35],paramet:11,xml:28,how:[33,43,6,19,20,37],configur:[27,33,47,49,38,10],apach:[19,12,37,20,6],window:7,local:3,match:8,real:23,sourc:[43,17,22],synopsi:[46,41],string:[8,54,15],format:[45,18],handl:6,faq:[30,43],terminolog:33,background:2,insert:14,introduct:[16,32],mysqlstor:49,document:12,like:8,administr:[46,33],level:53,drop:35,hive:[19,37,20,6],integr:42,partit:[0,34,20,32,5],each:10,fulli:44,where:7,manag:36,failov:33,set:[11,33,3,43,44],hcatalog:42,dump:53,dowload:22,meta:9,download:22,run:10,todo:[0,29,30,5,48,53],time:18,out:22,compat:[19,37,20,6],network:4,cast:54,databas:[35,53],preliminari:28,definit:35,state:33,directori:[4 4,10],channel:43,get:[43,40],method:32,math:26,mode:[44,10],qualifi:7,hash:0,driver:43,gener:19,usag:[11,46,9],serializerdeseri:21,base:44,prerequisit:[25,4],releas:[12,22],from:[11,43,7],rcfile:19,valu:[11,23,6],convers:18,launch:[33,44],column:20,tajo:[12,27,43,19,3,44,33,47,48,28,39],groupbi:7,datetim:18,backup:[33,1,53],first:50,oper:[26,18,4,15],rang:5,via:22,overview:7,tajomast:[33,27],number:[23,10],automat:33,api:48,size:[27,10],writer:21,git:22,java:43,memori:[27,10],data:[23,35,10],support:4,doubl:23,overwrit:14,custom:6,avail:33,start:40,call:54,basic:[11,46,9],master:[33,27,47],type:[23,7,54],"function":[26,13,15,4,18,7,54],shell:[41,39],claus:7,worker:[47,44,10],rootdir:27,heap:[27,10],jdbc:43,unpack:22,join:7,prune:20,restor:[1,53],"default":47,setup:44,properti:[19,37,6],maximum:10,orderbi:7,hdf:24,serd:21,limit:7,introduc:[41,21],parquet:37,similar:8,file:[11,33,45],creat:[35,19,37,20,6],process:2,site:28,indic:12,high:33,cluster:[33,3,44],unresolvedaddressexcept:43, textfil:6,have:7,tabl:[12,6,19,34,20,36,37,35,7],serial:[19,6],"null":6,dedic:10,issu:[19,37,20,6],make:44,ilik:8,when:19,cross:7,check:22,binari:43,exampl:[43,7,10],build:[43,17],env:28,test:33,distribut:[43,44],csv:6,singl:31,variabl:51,express:[8,54],resourc:10,nio:43,classpath:43,enter:41,compress:[29,35],catalog:[28,53,49],regular:8,temporari:10,sql:[11,52,53,54],date:18,tsql:[41,39],parallel:10,physic:[19,37,6],derbi:49,task:10,read:19,predic:8,arithmet:54,alias:7,client:[43,48],command:[46,24,31,9],pattern:8,model:23,sequencefil:21,mariadbstor:49,latest:22}}) \ No newline at end of file
