tajo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hyun...@apache.org
Subject svn commit: r1688350 [25/34] - in /tajo/site/docs: 0.10.1/ 0.10.1/_sources/ 0.10.1/_sources/backup_and_restore/ 0.10.1/_sources/configuration/ 0.10.1/_sources/functions/ 0.10.1/_sources/index/ 0.10.1/_sources/partitioning/ 0.10.1/_sources/sql_language/...
Date Tue, 30 Jun 2015 04:16:55 GMT
Added: tajo/site/docs/0.10.1/tsql/intro.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/0.10.1/tsql/intro.html?rev=1688350&view=auto
==============================================================================
--- tajo/site/docs/0.10.1/tsql/intro.html (added)
+++ tajo/site/docs/0.10.1/tsql/intro.html Tue Jun 30 04:16:52 2015
@@ -0,0 +1,303 @@
+
+
+<!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>Introducing to TSQL &mdash; Apache Tajo 0.11.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.11.0 documentation" href="../index.html"/>
+        <link rel="up" title="Tajo Shell (TSQL)" href="../tsql.html"/>
+        <link rel="next" title="Executing a single command" href="single_command.html"/>
+        <link rel="prev" title="Administration Commands" href="admin_command.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 current"><a class="reference internal" href="../tsql.html">Tajo Shell (TSQL)</a><ul class="current">
+<li class="toctree-l2"><a class="reference internal" href="meta_command.html">Meta Commands</a></li>
+<li class="toctree-l2"><a class="reference internal" href="dfs_command.html">Executing HDFS commands</a></li>
+<li class="toctree-l2"><a class="reference internal" href="variables.html">Session Variables</a></li>
+<li class="toctree-l2"><a class="reference internal" href="admin_command.html">Administration Commands</a></li>
+<li class="toctree-l2 current"><a class="current reference internal" href="">Introducing to TSQL</a></li>
+<li class="toctree-l2"><a class="reference internal" href="single_command.html">Executing a single command</a></li>
+<li class="toctree-l2"><a class="reference internal" href="execute_file.html">Executing Queries from Files</a></li>
+<li class="toctree-l2"><a class="reference internal" href="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>
+<li class="toctree-l2"><a class="reference internal" href="../functions/json_func.html">JSON Functions</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../table_management/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"><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="../swift_integration.html">OpenStack Swift Integration</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#swift-configuration">Swift configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#hadoop-configurations">Hadoop configurations</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#tajo-configuration">Tajo configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#querying-on-swift">Querying on Swift</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li>
+</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>
+      &nbsp;
+    </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> &raquo;</li>
+      
+          <li><a href="../tsql.html">Tajo Shell (TSQL)</a> &raquo;</li>
+      
+    <li>Introducing to TSQL</li>
+      <li class="wy-breadcrumbs-aside">
+        
+          <a href="../_sources/tsql/intro.txt" rel="nofollow"> View page source</a>
+        
+      </li>
+  </ul>
+  <hr/>
+</div>
+          <div role="main">
+            
+  <div class="section" id="introducing-to-tsql">
+<h1>Introducing to TSQL<a class="headerlink" href="#introducing-to-tsql" title="Permalink to this headline">¶</a></h1>
+<div class="section" id="synopsis">
+<h2>Synopsis<a class="headerlink" href="#synopsis" title="Permalink to this headline">¶</a></h2>
+<div class="highlight-bash"><div class="highlight"><pre>bin/tsql <span class="o">[</span>options<span class="o">]</span> <span class="o">[</span>database name<span class="o">]</span>
+</pre></div>
+</div>
+<p>If a <em>database_name</em> is given, tsql connects to the database at startup time. Otherwise, tsql connects to <code class="docutils literal"><span class="pre">default</span></code> database.</p>
+<p>Options</p>
+<ul class="simple">
+<li><code class="docutils literal"><span class="pre">-c</span> <span class="pre">&quot;quoted</span> <span class="pre">sql&quot;</span></code> : Execute quoted sql statements, and then the shell will exist.</li>
+<li><code class="docutils literal"><span class="pre">-f</span> <span class="pre">filename</span> <span class="pre">(--file</span> <span class="pre">filename)</span></code> : Use the file named filename as the source of commands instead of interactive shell.</li>
+<li><code class="docutils literal"><span class="pre">-h</span> <span class="pre">hostname</span> <span class="pre">(--host</span> <span class="pre">hostname)</span></code> : Specifies the host name of the machine on which the Tajo master is running.</li>
+<li><code class="docutils literal"><span class="pre">-p</span> <span class="pre">port</span> <span class="pre">(--port</span> <span class="pre">port)</span></code> : Specifies the TCP port. If it is not set, the port will be 26002 by default.</li>
+<li><code class="docutils literal"><span class="pre">-conf</span> <span class="pre">configuration</span> <span class="pre">(--conf</span> <span class="pre">configuration)</span></code> : Setting Tajo configuration value.</li>
+<li><code class="docutils literal"><span class="pre">-param</span> <span class="pre">parameter</span> <span class="pre">(--param</span> <span class="pre">parameter)</span></code> : Use a parameter value in SQL file.</li>
+<li><code class="docutils literal"><span class="pre">-B</span> <span class="pre">(--background)</span></code> : Execute as background process.</li>
+</ul>
+</div>
+<div class="section" id="entering-tsql-shell">
+<h2>Entering tsql shell<a class="headerlink" href="#entering-tsql-shell" title="Permalink to this headline">¶</a></h2>
+<p>If the hostname and the port num are not given, tsql will try to connect the Tajo master specified in ${TAJO_HOME}/conf/tajo-site.xml.</p>
+<div class="highlight-python"><div class="highlight"><pre>bin/tsql
+
+default&gt;
+</pre></div>
+</div>
+<p>If you want to connect a specified TajoMaster, you should use &#8216;-h&#8217; and (or) &#8216;p&#8217; options as follows:</p>
+<div class="highlight-python"><div class="highlight"><pre>bin/tsql -h localhost -p 9004
+
+default&gt;
+</pre></div>
+</div>
+<p>The prompt indicates the current database.</p>
+</div>
+</div>
+
+
+          </div>
+          <footer>
+  
+    <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
+      
+        <a href="single_command.html" class="btn btn-neutral float-right" title="Executing a single command"/>Next <span class="fa fa-arrow-circle-right"></span></a>
+      
+      
+        <a href="admin_command.html" class="btn btn-neutral" title="Administration Commands"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+      
+    </div>
+  
+
+  <hr/>
+
+  <div role="contentinfo">
+    <p>
+        &copy; 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.11.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/0.10.1/tsql/meta_command.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/0.10.1/tsql/meta_command.html?rev=1688350&view=auto
==============================================================================
--- tajo/site/docs/0.10.1/tsql/meta_command.html (added)
+++ tajo/site/docs/0.10.1/tsql/meta_command.html Tue Jun 30 04:16:52 2015
@@ -0,0 +1,406 @@
+
+
+<!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>Meta Commands &mdash; Apache Tajo 0.11.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.11.0 documentation" href="../index.html"/>
+        <link rel="up" title="Tajo Shell (TSQL)" href="../tsql.html"/>
+        <link rel="next" title="Executing HDFS commands" href="dfs_command.html"/>
+        <link rel="prev" title="Tajo Shell (TSQL)" href="../tsql.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 current"><a class="reference internal" href="../tsql.html">Tajo Shell (TSQL)</a><ul class="current">
+<li class="toctree-l2 current"><a class="current reference internal" href="">Meta Commands</a></li>
+<li class="toctree-l2"><a class="reference internal" href="dfs_command.html">Executing HDFS commands</a></li>
+<li class="toctree-l2"><a class="reference internal" href="variables.html">Session Variables</a></li>
+<li class="toctree-l2"><a class="reference internal" href="admin_command.html">Administration Commands</a></li>
+<li class="toctree-l2"><a class="reference internal" href="intro.html">Introducing to TSQL</a></li>
+<li class="toctree-l2"><a class="reference internal" href="single_command.html">Executing a single command</a></li>
+<li class="toctree-l2"><a class="reference internal" href="execute_file.html">Executing Queries from Files</a></li>
+<li class="toctree-l2"><a class="reference internal" href="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>
+<li class="toctree-l2"><a class="reference internal" href="../functions/json_func.html">JSON Functions</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../table_management/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"><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="../swift_integration.html">OpenStack Swift Integration</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#swift-configuration">Swift configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#hadoop-configurations">Hadoop configurations</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#tajo-configuration">Tajo configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#querying-on-swift">Querying on Swift</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li>
+</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>
+      &nbsp;
+    </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> &raquo;</li>
+      
+          <li><a href="../tsql.html">Tajo Shell (TSQL)</a> &raquo;</li>
+      
+    <li>Meta Commands</li>
+      <li class="wy-breadcrumbs-aside">
+        
+          <a href="../_sources/tsql/meta_command.txt" rel="nofollow"> View page source</a>
+        
+      </li>
+  </ul>
+  <hr/>
+</div>
+          <div role="main">
+            
+  <div class="section" id="meta-commands">
+<h1>Meta Commands<a class="headerlink" href="#meta-commands" title="Permalink to this headline">¶</a></h1>
+<p>In tsql, any command that begins with an unquoted backslash (&#8216;\&#8217;) is a tsql meta-command that is processed by tsql itself.</p>
+<p>In the current implementation, there are meta commands as follows:</p>
+<div class="highlight-python"><div class="highlight"><pre>default&gt; \?
+
+
+General
+  \copyright    show Apache License 2.0
+  \version      show Tajo version
+  \?            show help
+  \? [COMMAND]  show help of a given command
+  \help         alias of \?
+  \q            quit tsql
+
+
+Informational
+  \l           list databases
+  \c           show current database
+  \c [DBNAME]  connect to new database
+  \d           list tables
+  \d [TBNAME]  describe table
+  \df          list functions
+  \df NAME     describe function
+
+
+Tool
+  \!           execute a linux shell command
+  \dfs         execute a dfs command
+  \admin       execute Tajo admin command
+
+
+Variables
+  \set [[NAME] [VALUE]  set session variable or list session variables
+  \unset NAME           unset session variable
+
+
+Documentations
+  tsql guide        http://tajo.apache.org/docs/current/tsql.html
+  Query language    http://tajo.apache.org/docs/current/sql_language.html
+  Functions         http://tajo.apache.org/docs/current/functions.html
+  Backup &amp; restore  http://tajo.apache.org/docs/current/backup_and_restore.html
+  Configuration     http://tajo.apache.org/docs/current/configuration.html
+</pre></div>
+</div>
+<div class="section" id="basic-usages">
+<h2>Basic usages<a class="headerlink" href="#basic-usages" title="Permalink to this headline">¶</a></h2>
+<p><code class="docutils literal"><span class="pre">\l</span></code> command shows a list of all databases as follows:</p>
+<div class="highlight-python"><div class="highlight"><pre>default&gt; \l
+default
+tpch
+work1
+default&gt;
+</pre></div>
+</div>
+<p><code class="docutils literal"><span class="pre">\d</span></code> command shows a list of tables in the current database as follows:</p>
+<div class="highlight-python"><div class="highlight"><pre>default&gt; \d
+customer
+lineitem
+nation
+orders
+part
+partsupp
+region
+supplier
+</pre></div>
+</div>
+<p><code class="docutils literal"><span class="pre">\d</span> <span class="pre">[table</span> <span class="pre">name]</span></code> command also shows a table description as follows:</p>
+<div class="highlight-python"><div class="highlight"><pre>default&gt; \d orders
+
+table name: orders
+table path: hdfs:/xxx/xxx/tpch/orders
+store type: CSV
+number of rows: 0
+volume (bytes): 172.0 MB
+schema:
+o_orderkey      INT8
+o_custkey       INT8
+o_orderstatus   TEXT
+o_totalprice    FLOAT8
+o_orderdate     TEXT
+o_orderpriority TEXT
+o_clerk TEXT
+o_shippriority  INT4
+o_comment       TEXT
+</pre></div>
+</div>
+<p>The prompt <code class="docutils literal"><span class="pre">default&gt;</span></code> indicates the current database. Basically, all SQL statements and meta commands work in the current database. Also, you can change the current database with <code class="docutils literal"><span class="pre">\c</span></code> command.</p>
+<div class="highlight-sql"><div class="highlight"><pre>default&gt; \c work1
+You are now connected to database &quot;test&quot; as user &quot;hyunsik&quot;.
+work1&gt;
+</pre></div>
+</div>
+<p><code class="docutils literal"><span class="pre">\df</span></code> command shows a list of all built-in functions as follows:</p>
+<div class="highlight-python"><div class="highlight"><pre>default&gt; \df
+ Name            | Result type     | Argument types        | Description                                   | Type
+-----------------+-----------------+-----------------------+-----------------------------------------------+-----------
+ abs             | INT4            | INT4                  | Absolute value                                | GENERAL
+ abs             | INT8            | INT8                  | Absolute value                                | GENERAL
+ abs             | FLOAT4          | FLOAT4                | Absolute value                                | GENERAL
+ abs             | FLOAT8          | FLOAT8                | Absolute value                                | GENERAL
+ acos            | FLOAT8          | FLOAT4                | Inverse cosine.                               | GENERAL
+ acos            | FLOAT8          | FLOAT8                | Inverse cosine.                               | GENERAL
+ utc_usec_to     | INT8            | TEXT,INT8             | Extract field from time                       | GENERAL
+ utc_usec_to     | INT8            | TEXT,INT8,INT4        | Extract field from time                       | GENERAL
+
+(181) rows
+
+For Reference, many details have been omitted in order to present a clear picture of the process.
+</pre></div>
+</div>
+<p><code class="docutils literal"><span class="pre">\df</span> <span class="pre">[function</span> <span class="pre">name]</span></code> command also shows a function description as follows:</p>
+<div class="highlight-python"><div class="highlight"><pre>default&gt; \df round;
+ Name            | Result type     | Argument types        | Description                                   | Type
+-----------------+-----------------+-----------------------+-----------------------------------------------+-----------
+ round           | INT8            | FLOAT4                | Round to nearest integer.                     | GENERAL
+ round           | INT8            | FLOAT8                | Round to nearest integer.                     | GENERAL
+ round           | INT8            | INT4                  | Round to nearest integer.                     | GENERAL
+ round           | INT8            | INT8                  | Round to nearest integer.                     | GENERAL
+ round           | FLOAT8          | FLOAT8,INT4           | Round to s decimalN places.                   | GENERAL
+ round           | FLOAT8          | INT8,INT4             | Round to s decimalN places.                   | GENERAL
+
+(6) rows
+
+Function:    INT8 round(float4)
+Description: Round to nearest integer.
+Example:
+&gt; SELECT round(42.4)
+42
+
+Function:    FLOAT8 round(float8,int4)
+Description: Round to s decimalN places.
+Example:
+&gt; SELECT round(42.4382, 2)
+42.44
+</pre></div>
+</div>
+</div>
+</div>
+
+
+          </div>
+          <footer>
+  
+    <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
+      
+        <a href="dfs_command.html" class="btn btn-neutral float-right" title="Executing HDFS commands"/>Next <span class="fa fa-arrow-circle-right"></span></a>
+      
+      
+        <a href="../tsql.html" class="btn btn-neutral" title="Tajo Shell (TSQL)"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+      
+    </div>
+  
+
+  <hr/>
+
+  <div role="contentinfo">
+    <p>
+        &copy; 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.11.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/0.10.1/tsql/single_command.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/0.10.1/tsql/single_command.html?rev=1688350&view=auto
==============================================================================
--- tajo/site/docs/0.10.1/tsql/single_command.html (added)
+++ tajo/site/docs/0.10.1/tsql/single_command.html Tue Jun 30 04:16:52 2015
@@ -0,0 +1,288 @@
+
+
+<!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>Executing a single command &mdash; Apache Tajo 0.11.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.11.0 documentation" href="../index.html"/>
+        <link rel="up" title="Tajo Shell (TSQL)" href="../tsql.html"/>
+        <link rel="next" title="Executing Queries from Files" href="execute_file.html"/>
+        <link rel="prev" title="Introducing to TSQL" href="intro.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 current"><a class="reference internal" href="../tsql.html">Tajo Shell (TSQL)</a><ul class="current">
+<li class="toctree-l2"><a class="reference internal" href="meta_command.html">Meta Commands</a></li>
+<li class="toctree-l2"><a class="reference internal" href="dfs_command.html">Executing HDFS commands</a></li>
+<li class="toctree-l2"><a class="reference internal" href="variables.html">Session Variables</a></li>
+<li class="toctree-l2"><a class="reference internal" href="admin_command.html">Administration Commands</a></li>
+<li class="toctree-l2"><a class="reference internal" href="intro.html">Introducing to TSQL</a></li>
+<li class="toctree-l2 current"><a class="current reference internal" href="">Executing a single command</a></li>
+<li class="toctree-l2"><a class="reference internal" href="execute_file.html">Executing Queries from Files</a></li>
+<li class="toctree-l2"><a class="reference internal" href="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>
+<li class="toctree-l2"><a class="reference internal" href="../functions/json_func.html">JSON Functions</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../table_management/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"><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="../swift_integration.html">OpenStack Swift Integration</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#swift-configuration">Swift configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#hadoop-configurations">Hadoop configurations</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#tajo-configuration">Tajo configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#querying-on-swift">Querying on Swift</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li>
+</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>
+      &nbsp;
+    </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> &raquo;</li>
+      
+          <li><a href="../tsql.html">Tajo Shell (TSQL)</a> &raquo;</li>
+      
+    <li>Executing a single command</li>
+      <li class="wy-breadcrumbs-aside">
+        
+          <a href="../_sources/tsql/single_command.txt" rel="nofollow"> View page source</a>
+        
+      </li>
+  </ul>
+  <hr/>
+</div>
+          <div role="main">
+            
+  <div class="section" id="executing-a-single-command">
+<h1>Executing a single command<a class="headerlink" href="#executing-a-single-command" title="Permalink to this headline">¶</a></h1>
+<p>You may want to run more queries without entering tsql prompt. Tsql provides the <code class="docutils literal"><span class="pre">-c</span></code> argument for above requirement. And Tajo assumes that queries are separated by semicolon as follows:</p>
+<div class="highlight-sql"><div class="highlight"><pre>$ bin/tsql  -c &quot;select count(*) from table1; select sum(score) from table1;&quot;
+Progress: 0%, response time: 0.217 sec
+Progress: 0%, response time: 0.218 sec
+Progress: 100%, response time: 0.317 sec
+?count
+-------------------------------
+5
+(1 rows, 0.317 sec, 2 B selected)
+Progress: 0%, response time: 0.202 sec
+Progress: 0%, response time: 0.204 sec
+Progress: 100%, response time: 0.345 sec
+?sum
+-------------------------------
+15.0
+(1 rows, 0.345 sec, 5 B selected)
+</pre></div>
+</div>
+</div>
+
+
+          </div>
+          <footer>
+  
+    <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
+      
+        <a href="execute_file.html" class="btn btn-neutral float-right" title="Executing Queries from Files"/>Next <span class="fa fa-arrow-circle-right"></span></a>
+      
+      
+        <a href="intro.html" class="btn btn-neutral" title="Introducing to TSQL"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+      
+    </div>
+  
+
+  <hr/>
+
+  <div role="contentinfo">
+    <p>
+        &copy; 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.11.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/0.10.1/tsql/variables.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/0.10.1/tsql/variables.html?rev=1688350&view=auto
==============================================================================
--- tajo/site/docs/0.10.1/tsql/variables.html (added)
+++ tajo/site/docs/0.10.1/tsql/variables.html Tue Jun 30 04:16:52 2015
@@ -0,0 +1,326 @@
+
+
+<!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>Session Variables &mdash; Apache Tajo 0.11.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.11.0 documentation" href="../index.html"/>
+        <link rel="up" title="Tajo Shell (TSQL)" href="../tsql.html"/>
+        <link rel="next" title="Administration Commands" href="admin_command.html"/>
+        <link rel="prev" title="Executing HDFS commands" href="dfs_command.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 current"><a class="reference internal" href="../tsql.html">Tajo Shell (TSQL)</a><ul class="current">
+<li class="toctree-l2"><a class="reference internal" href="meta_command.html">Meta Commands</a></li>
+<li class="toctree-l2"><a class="reference internal" href="dfs_command.html">Executing HDFS commands</a></li>
+<li class="toctree-l2 current"><a class="current reference internal" href="">Session Variables</a></li>
+<li class="toctree-l2"><a class="reference internal" href="admin_command.html">Administration Commands</a></li>
+<li class="toctree-l2"><a class="reference internal" href="intro.html">Introducing to TSQL</a></li>
+<li class="toctree-l2"><a class="reference internal" href="single_command.html">Executing a single command</a></li>
+<li class="toctree-l2"><a class="reference internal" href="execute_file.html">Executing Queries from Files</a></li>
+<li class="toctree-l2"><a class="reference internal" href="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>
+<li class="toctree-l2"><a class="reference internal" href="../functions/json_func.html">JSON Functions</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../table_management/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"><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="../swift_integration.html">OpenStack Swift Integration</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#swift-configuration">Swift configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#hadoop-configurations">Hadoop configurations</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#tajo-configuration">Tajo configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#querying-on-swift">Querying on Swift</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li>
+</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>
+      &nbsp;
+    </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> &raquo;</li>
+      
+          <li><a href="../tsql.html">Tajo Shell (TSQL)</a> &raquo;</li>
+      
+    <li>Session Variables</li>
+      <li class="wy-breadcrumbs-aside">
+        
+          <a href="../_sources/tsql/variables.txt" rel="nofollow"> View page source</a>
+        
+      </li>
+  </ul>
+  <hr/>
+</div>
+          <div role="main">
+            
+  <div class="section" id="session-variables">
+<h1>Session Variables<a class="headerlink" href="#session-variables" title="Permalink to this headline">¶</a></h1>
+<p>Each client connection to TajoMaster creates a unique session, and the client and TajoMaster uses the session until disconnect. A session provides session variables which are used for various configs per session.</p>
+<p><code class="docutils literal"><span class="pre">tsql</span></code> provides the meta command <code class="docutils literal"><span class="pre">\set</span></code> to manipulate session variables. Just <code class="docutils literal"><span class="pre">\set</span></code> command shows all session variables.</p>
+<div class="highlight-python"><div class="highlight"><pre>default&gt; \set
+&#39;name1&#39;=&#39;val1&#39;
+&#39;name2&#39;=&#39;val2&#39;
+&#39;name3&#39;=&#39;val3&#39;
+     ...
+</pre></div>
+</div>
+<p><code class="docutils literal"><span class="pre">\set</span> <span class="pre">key</span> <span class="pre">val</span></code> will set the session variable named <em>key</em> with the value <em>val</em>.</p>
+<div class="highlight-python"><div class="highlight"><pre>default&gt; \set
+&#39;CURRENT_DATABASE&#39;=&#39;default&#39;
+
+default&gt; \set key1 val1
+
+default&gt; \set
+&#39;CURRENT_DATABASE&#39;=&#39;default&#39;
+&#39;key1&#39;=&#39;val1&#39;
+</pre></div>
+</div>
+<p>Also, <code class="docutils literal"><span class="pre">\unset</span> <span class="pre">key</span></code> will unset the session variable named <em>key</em>.</p>
+<p>Now, tajo provides the following session variables.</p>
+<ul class="simple">
+<li><code class="docutils literal"><span class="pre">DIST_QUERY_BROADCAST_JOIN_THRESHOLD</span></code></li>
+<li><code class="docutils literal"><span class="pre">DIST_QUERY_JOIN_TASK_VOLUME</span></code></li>
+<li><code class="docutils literal"><span class="pre">DIST_QUERY_SORT_TASK_VOLUME</span></code></li>
+<li><code class="docutils literal"><span class="pre">DIST_QUERY_GROUPBY_TASK_VOLUME</span></code></li>
+<li><code class="docutils literal"><span class="pre">DIST_QUERY_JOIN_PARTITION_VOLUME</span></code></li>
+<li><code class="docutils literal"><span class="pre">DIST_QUERY_GROUPBY_PARTITION_VOLUME</span></code></li>
+<li><code class="docutils literal"><span class="pre">DIST_QUERY_TABLE_PARTITION_VOLUME</span></code></li>
+<li><code class="docutils literal"><span class="pre">EXECUTOR_EXTERNAL_SORT_BUFFER_SIZE</span></code></li>
+<li><code class="docutils literal"><span class="pre">EXECUTOR_HASH_JOIN_SIZE_THRESHOLD</span></code></li>
+<li><code class="docutils literal"><span class="pre">EXECUTOR_INNER_HASH_JOIN_SIZE_THRESHOLD</span></code></li>
+<li><code class="docutils literal"><span class="pre">EXECUTOR_OUTER_HASH_JOIN_SIZE_THRESHOLD</span></code></li>
+<li><code class="docutils literal"><span class="pre">EXECUTOR_GROUPBY_INMEMORY_HASH_THRESHOLD</span></code></li>
+<li><code class="docutils literal"><span class="pre">MAX_OUTPUT_FILE_SIZE</span></code></li>
+<li><code class="docutils literal"><span class="pre">CODEGEN</span></code></li>
+<li><code class="docutils literal"><span class="pre">CLIENT_SESSION_EXPIRY_TIME</span></code></li>
+<li><code class="docutils literal"><span class="pre">CLI_MAX_COLUMN</span></code></li>
+<li><code class="docutils literal"><span class="pre">CLI_NULL_CHAR</span></code></li>
+<li><code class="docutils literal"><span class="pre">CLI_PRINT_PAUSE_NUM_RECORDS</span></code></li>
+<li><code class="docutils literal"><span class="pre">CLI_PRINT_PAUSE</span></code></li>
+<li><code class="docutils literal"><span class="pre">CLI_PRINT_ERROR_TRACE</span></code></li>
+<li><code class="docutils literal"><span class="pre">CLI_OUTPUT_FORMATTER_CLASS</span></code></li>
+<li><code class="docutils literal"><span class="pre">CLI_ERROR_STOP</span></code></li>
+<li><code class="docutils literal"><span class="pre">TIMEZONE</span></code></li>
+<li><code class="docutils literal"><span class="pre">DATE_ORDER</span></code></li>
+<li><code class="docutils literal"><span class="pre">TEXT_NULL</span></code></li>
+<li><code class="docutils literal"><span class="pre">DEBUG_ENABLED</span></code></li>
+<li><code class="docutils literal"><span class="pre">TEST_BROADCAST_JOIN_ENABLED</span></code></li>
+<li><code class="docutils literal"><span class="pre">TEST_JOIN_OPT_ENABLED</span></code></li>
+<li><code class="docutils literal"><span class="pre">TEST_FILTER_PUSHDOWN_ENABLED</span></code></li>
+<li><code class="docutils literal"><span class="pre">TEST_MIN_TASK_NUM</span></code></li>
+<li><code class="docutils literal"><span class="pre">BEHAVIOR_ARITHMETIC_ABORT</span></code></li>
+<li><code class="docutils literal"><span class="pre">RESULT_SET_FETCH_ROWNUM</span></code></li>
+</ul>
+</div>
+
+
+          </div>
+          <footer>
+  
+    <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
+      
+        <a href="admin_command.html" class="btn btn-neutral float-right" title="Administration Commands"/>Next <span class="fa fa-arrow-circle-right"></span></a>
+      
+      
+        <a href="dfs_command.html" class="btn btn-neutral" title="Executing HDFS commands"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+      
+    </div>
+  
+
+  <hr/>
+
+  <div role="contentinfo">
+    <p>
+        &copy; 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.11.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/_sources/backup_and_restore/catalog.txt
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/backup_and_restore/catalog.txt?rev=1688350&r1=1688349&r2=1688350&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/backup_and_restore/catalog.txt (original)
+++ tajo/site/docs/current/_sources/backup_and_restore/catalog.txt Tue Jun 30 04:16:52 2015
@@ -28,7 +28,7 @@ For example, if you want to backup a tab
   -- Name: customer; Type: TABLE; Storage: CSV
   -- Path: file:/home/hyunsik/tpch/customer
   --
-  CREATE EXTERNAL TABLE customer (c_custkey INT8, c_name TEXT, c_address TEXT, c_nationkey INT8, c_phone TEXT, c_acctbal FLOAT8, c_mktsegment TEXT, c_comment TEXT) USING CSV LOCATION 'file:/home/hyunsik/tpch/customer';
+  CREATE EXTERNAL TABLE customer (c_custkey INT8, c_name TEXT, c_address TEXT, c_nationkey INT8, c_phone TEXT, c_acctbal FLOAT8, c_mktsegment TEXT, c_comment TEXT) USING TEXT LOCATION 'file:/home/hyunsik/tpch/customer';
   
 
 If you want to restore the catalog from the SQL dump file, please type the below command: ::

Modified: tajo/site/docs/current/_sources/functions.txt
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/functions.txt?rev=1688350&r1=1688349&r2=1688350&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/functions.txt (original)
+++ tajo/site/docs/current/_sources/functions.txt Tue Jun 30 04:16:52 2015
@@ -8,4 +8,5 @@ Functions
     functions/math_func_and_operators
     functions/string_func_and_operators
     functions/datetime_func_and_operators
-    functions/network_func_and_operators
\ No newline at end of file
+    functions/network_func_and_operators
+    functions/json_func
\ No newline at end of file

Added: tajo/site/docs/current/_sources/functions/json_func.txt
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/functions/json_func.txt?rev=1688350&view=auto
==============================================================================
--- tajo/site/docs/current/_sources/functions/json_func.txt (added)
+++ tajo/site/docs/current/_sources/functions/json_func.txt Tue Jun 30 04:16:52 2015
@@ -0,0 +1,16 @@
+*******************************
+JSON Functions
+*******************************
+
+.. function:: json_extract_path_text (string json, string xpath)
+  Extracts JSON string from a JSON string based on json path specified and returns JSON string pointed to by xPath
+
+  :param string:
+  :param string:
+  :rtype: text
+  :example:
+
+  .. code-block:: sql
+
+    json_extract_path_text('{"test" : {"key" : "tajo"}}','$.test.key');
+    > tajo

Modified: tajo/site/docs/current/_sources/getting_started.txt
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/getting_started.txt?rev=1688350&r1=1688349&r2=1688350&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/getting_started.txt (original)
+++ tajo/site/docs/current/_sources/getting_started.txt Tue Jun 30 04:16:52 2015
@@ -8,7 +8,7 @@ In this section, we explain setup of a s
 Prerequisites
 ======================
 
- * Hadoop 2.3.0 or higher (up to 2.5.1)
+ * Hadoop 2.3.0 or higher (up to 2.6.0)
  * Java 1.6 or 1.7
  * Protocol buffer 2.5.0
 
@@ -135,7 +135,7 @@ Here, we assume the schema as (int, text
         name text, 
         score float, 
         type text) 
-        using csv with ('text.delimiter'='|') location 'file:/home/x/table1';
+        using text with ('text.delimiter'='|') location 'file:/home/x/table1';
 
 To load an external table, you need to use ‘create external table’ statement. 
 In the location clause, you should use the absolute directory path with an appropriate scheme. 

Modified: tajo/site/docs/current/_sources/index.txt
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/index.txt?rev=1688350&r1=1688349&r2=1688350&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/index.txt (original)
+++ tajo/site/docs/current/_sources/index.txt Tue Jun 30 04:16:52 2015
@@ -15,7 +15,7 @@
    You can adapt this file completely to your liking, but it should at least
    contain the root `toctree` directive.
 
-Apache Tajo™ 0.10.0 - User documentation
+Apache Tajo™ 0.10.1 Release - User documentation
 ===========================================================================
 
 Table of Contents:
@@ -36,6 +36,7 @@ Table of Contents:
    backup_and_restore
    hcatalog_integration
    hbase_integration
+   swift_integration
    jdbc_driver
    tajo_client_api
    faq

Modified: tajo/site/docs/current/_sources/jdbc_driver.txt
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/jdbc_driver.txt?rev=1688350&r1=1688349&r2=1688350&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/jdbc_driver.txt (original)
+++ tajo/site/docs/current/_sources/jdbc_driver.txt Tue Jun 30 04:16:52 2015
@@ -9,11 +9,15 @@ In this section, we explain how to get J
 How to get JDBC driver
 =======================
 
+Direct Download
+--------------------------------
+
+You can directly download a JDBC driver jar file (``tajo-jdbc-x.y.z.jar``) from `Downloads <http://tajo.apache.org/downloads.html>`_.
+
 From Binary Distribution
 --------------------------------
 
-Tajo binary distribution provides JDBC jar file and its dependent JAR files.
-Those files are located in ``${TAJO_HOME}/share/jdbc-dist/``.
+Tajo binary distribution provides JDBC jar file located in ``${TAJO_HOME}/share/jdbc-dist/tajo-jdbc-x.y.z.jar``.
 
 
 From Building Source Code
@@ -25,25 +29,17 @@ You can build Tajo from the source code
 
   $ tar xzvf tajo-x.y.z-src.tar.gz
   $ mvn clean package -DskipTests -Pdist -Dtar
-  $ ls -l tajo-dist/target/tajo-x.y.z/share/jdbc-dist
+  $ ls -l tajo-dist/target/tajo-x.y.z/share/jdbc-dist/tajo-jdbc-x.y.z.jar
 
 
 Setting the CLASSPATH
 =======================
 
-In order to use the JDBC driver, you should set the jar files included in 
-``tajo-dist/target/tajo-x.y.z/share/jdbc-dist`` to your ``CLASSPATH``.
-In addition, you should add hadoop clsspath into your ``CLASSPATH``.
-So, ``CLASSPATH`` will be set as follows:
+In order to use the JDBC driver, you should add ``tajo-jdbc-x.y.z.jar`` in your ``CLASSPATH``.
 
 .. code-block:: bash
 
-  CLASSPATH=path/to/tajo-jdbc/*:path/to/tajo-site.xml:path/to/core-site.xml:path/to/hdfs-site.xml
-
-.. note::
-
-  You must add the locations which include Tajo config files (i.e., ``tajo-site.xml``) and
-  Hadoop config files (i.e., ``core-site.xml`` and ``hdfs-site.xml``) to your ``CLASSPATH``.
+  CLASSPATH=path/to/tajo-jdbc-x.y.z.jar:$CLASSPATH
 
 
 An Example JDBC Client
@@ -99,15 +95,3 @@ The following shows an example of JDBC C
     }
   }
 
-
-FAQ
-===========================================
-
-java.nio.channels.UnresolvedAddressException
---------------------------------------------
-
-When retriving the final result, Tajo JDBC Driver tries to access HDFS data nodes.
-So, the network access between JDBC client and HDFS data nodes must be available.
-In many cases, a HDFS cluster is built in a private network which use private hostnames.
-So, the host names must be shared with the JDBC client side.
-

Modified: tajo/site/docs/current/_sources/sql_language/data_model.txt
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/sql_language/data_model.txt?rev=1688350&r1=1688349&r2=1688350&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/sql_language/data_model.txt (original)
+++ tajo/site/docs/current/_sources/sql_language/data_model.txt Tue Jun 30 04:16:52 2015
@@ -15,7 +15,9 @@ Data Types
 +-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
 |           | varbit         |  bit varying               |             |                                                   |                                                                          |
 +-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
-| O         | smallint       |  tinyint, int2             |  2          | small-range integer value                         | -2^15 (-32,768) to 2^15 (32,767)                                         |
+| O         | tinyint        |  int1                      |  1          | tiny-range integer value                          | -2^7 (-128) to 2^7-1 (127)                                               |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| O         | smallint       |  int2                      |  2          | small-range integer value                         | -2^15 (-32,768) to 2^15-1 (32,767)                                       |
 +-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
 | O         | integer        |  int, int4                 |  4          | integer value                                     | -2^31 (-2,147,483,648) to 2^31 - 1 (2,147,483,647)                       |
 +-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 

Modified: tajo/site/docs/current/_sources/sql_language/ddl.txt
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/sql_language/ddl.txt?rev=1688350&r1=1688349&r2=1688350&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/sql_language/ddl.txt (original)
+++ tajo/site/docs/current/_sources/sql_language/ddl.txt Tue Jun 30 04:16:52 2015
@@ -56,7 +56,7 @@ If you want to add an external table tha
   ...
   L_COMMENT text) 
 
-  USING csv WITH ('text.delimiter'='|','compression.codec'='org.apache.hadoop.io.compress.DeflateCodec')
+  USING TEXT WITH ('text.delimiter'='|','compression.codec'='org.apache.hadoop.io.compress.DeflateCodec')
   LOCATION 'hdfs://localhost:9010/tajo/warehouse/lineitem_100_snappy';
 
 `compression.codec` parameter can have one of the following compression codecs:

Added: tajo/site/docs/current/_sources/swift_integration.txt
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/swift_integration.txt?rev=1688350&view=auto
==============================================================================
--- tajo/site/docs/current/_sources/swift_integration.txt (added)
+++ tajo/site/docs/current/_sources/swift_integration.txt Tue Jun 30 04:16:52 2015
@@ -0,0 +1,110 @@
+*************************************
+OpenStack Swift Integration
+*************************************
+
+Tajo supports OpenStack Swift as one of the underlying storage types.
+In Tajo, Swift objects are represented and recognized by the same URI format as in Hadoop.
+
+You don't need to run Hadoop to run Tajo on Swift, but need to configure it.
+You will also need to configure Swift and Tajo.
+
+For details, please see the following sections.
+
+======================
+Swift configuration
+======================
+
+This step is not mandatory, but is strongly recommended to configure the Swift's proxy-server with ``list_endpoints`` for better performance.
+More information is available `here <http://docs.openstack.org/developer/swift/middleware.html#module-swift.common.middleware.list_endpoints>`_.
+
+======================
+Hadoop configurations
+======================
+
+You need to configure Hadoop to specify how to access Swift objects.
+Here is an example of ``${HADOOP_HOME}/etc/hadoop/core-site.xml``.
+
+-----------------------
+Common configurations
+-----------------------
+
+.. code-block:: xml
+
+  <property>
+    <name>fs.swift.impl</name>
+    <value>org.apache.hadoop.fs.swift.snative.SwiftNativeFileSystem</value>
+    <description>File system implementation for Swift</description>
+  </property>
+  <property>
+    <name>fs.swift.blocksize</name>
+    <value>131072</value>
+    <description>Split size in KB</description>
+  </property>
+
+----------------------------
+Configurations per provider
+----------------------------
+
+.. code-block:: xml
+
+  <property>
+    <name>fs.swift.service.${PROVIDER}.auth.url</name>
+    <value>http://127.0.0.1/v2.0/tokens</value>
+    <description>Keystone authenticaiton URL</description>
+  </property>
+  <property>
+    <name>fs.swift.service.${PROVIDER}.auth.endpoint.prefix</name>
+    <value>/endpoints/AUTH_</value>
+    <description>Keystone endpoints prefix</description>
+  </property>
+  <property>
+    <name>fs.swift.service.${PROVIDER}.http.port</name>
+    <value>8080</value>
+    <description>HTTP port</description>
+  </property>
+  <property>
+    <name>fs.swift.service.${PROVIDER}.region</name>
+    <value>regionOne</value>
+    <description>Region name</description>
+  </property>
+  <property>
+    <name>fs.swift.service.${PROVIDER}.tenant</name>
+    <value>demo</value>
+    <description>Tenant name</description>
+  </property>
+  <property>
+    <name>fs.swift.service.${PROVIDER}.username</name>
+    <value>tajo</value>
+  </property>
+  <property>
+    <name>fs.swift.service.${PROVIDER}.password</name>
+    <value>tajo_password</value>
+  </property>
+  <property>
+    <name>fs.swift.service.${PROVIDER}.location-aware</name>
+    <value>true</value>
+    <description>Flag to enable the location-aware computing</description>
+  </property>
+
+======================
+Tajo configuration
+======================
+
+Finally, you need to configure the classpath of Tajo by adding the following line to ``${TAJO_HOME}/conf/tajo-evn.sh``.
+
+.. code-block:: sh
+
+  export TAJO_CLASSPATH=$HADOOP_HOME/share/hadoop/tools/lib/hadoop-openstack-x.x.x.jar
+
+======================
+Querying on Swift
+======================
+
+Given a provider name *tajo* and a Swift container name *demo*, you can create a Tajo table with data on Swift as follows.
+
+.. code-block:: sql
+
+  default> create external table swift_table (id int32, name text, score float, type text) using text with ('text.delimiter'='|') location 'swift://demo.tajo/test.tbl';
+
+Once a table is created, you can execute any SQL queries on that table as other tables stored on HDFS.
+For query execution details, please refer to :doc:`sql_language`.
\ No newline at end of file

Modified: tajo/site/docs/current/_sources/table_management/file_formats.txt
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/table_management/file_formats.txt?rev=1688350&r1=1688349&r2=1688350&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/table_management/file_formats.txt (original)
+++ tajo/site/docs/current/_sources/table_management/file_formats.txt Tue Jun 30 04:16:52 2015
@@ -7,7 +7,7 @@ Currently, Tajo provides four file forma
 .. toctree::
     :maxdepth: 1
 
-    csv
+    text
     rcfile
     parquet
     sequencefile
\ No newline at end of file

Modified: tajo/site/docs/current/_sources/table_management/table_overview.txt
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/table_management/table_overview.txt?rev=1688350&r1=1688349&r2=1688350&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/table_management/table_overview.txt (original)
+++ tajo/site/docs/current/_sources/table_management/table_overview.txt Tue Jun 30 04:16:52 2015
@@ -29,9 +29,9 @@ The following example is to set a custom
   name text,
   score float,
   type text
- ) USING CSV WITH('text.delimiter'='\u0001',
-                  'text.null'='\\N',
-                  'compression.codec'='org.apache.hadoop.io.compress.SnappyCodec');
+ ) USING TEXT WITH('text.delimiter'='\u0001',
+                   'text.null'='\\N',
+                   'compression.codec'='org.apache.hadoop.io.compress.SnappyCodec');
 
 Each physical table layout has its own specialized properties. They will be addressed in :doc:`/table_management/file_formats`.
 



Mime
View raw message