Modified: tajo/site/docs/devel/tsql/admin_command.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/admin_command.html?rev=1739720&r1=1739719&r2=1739720&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/admin_command.html (original) +++ tajo/site/docs/devel/tsql/admin_command.html Mon Apr 18 09:40:18 2016 @@ -7,7 +7,7 @@ <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> - <title>Administration Commands — Apache Tajo 0.11.0 documentation</title> + <title>Administration Commands — Apache Tajo 0.12.0-SNAPSHOT documentation</title> @@ -28,7 +28,7 @@ - <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> + <link rel="top" title="Apache Tajo 0.12.0-SNAPSHOT documentation" href="../index.html"/> <link rel="up" title="Tajo Shell (TSQL)" href="../tsql.html"/> <link rel="next" title="Introducing to TSQL" href="intro.html"/> <link rel="prev" title="Session Variables" href="variables.html"/> @@ -85,7 +85,7 @@ <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 current"><a class="current reference internal" href="">Administration Commands</a></li> +<li class="toctree-l2 current"><a class="current reference internal" href="#">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> @@ -228,32 +228,32 @@ usage: admin [options] <div class="section" id="basic-usages"> <h3>Basic usages<a class="headerlink" href="#basic-usages" title="Permalink to this headline">¶</a></h3> <p><code class="docutils literal"><span class="pre">-list</span></code> option shows a list of all running queries as follows:</p> -<div class="highlight-python"><div class="highlight"><pre>default> \admin -list -QueryId State StartTime Query --------------------- ------------------- ------------------- ----------------------------- -q_1411357607375_0006 QUERY_RUNNING 2014-09-23 07:19:40 select count(*) from lineitem +<div class="highlight-default"><div class="highlight"><pre><span class="n">default</span><span class="o">></span> \<span class="n">admin</span> <span class="o">-</span><span class="nb">list</span> +<span class="n">QueryId</span> <span class="n">State</span> <span class="n">StartTime</span> <span class="n">Query</span> +<span class="o">--------------------</span> <span class="o">-------------------</span> <span class="o">-------------------</span> <span class="o">-----------------------------</span> +<span class="n">q_1411357607375_0006</span> <span class="n">QUERY_RUNNING</span> <span class="mi">2014</span><span class="o">-</span><span class="mi">09</span><span class="o">-</span><span class="mi">23</span> <span class="mi">07</span><span class="p">:</span><span class="mi">19</span><span class="p">:</span><span class="mi">40</span> <span class="n">select</span> <span class="n">count</span><span class="p">(</span><span class="o">*</span><span class="p">)</span> <span class="kn">from</span> <span class="nn">lineitem</span> </pre></div> </div> <p><code class="docutils literal"><span class="pre">-desc</span></code> option shows a detailed description of a specified running query as follows:</p> -<div class="highlight-python"><div class="highlight"><pre>default> \admin -desc q_1411357607375_0006 -Id: 1 -Query Id: q_1411357607375_0006 -Started Time: 2014-09-23 07:19:40 -Query State: QUERY_RUNNING -Execution Time: 20.0 sec -Query Progress: 0.249 -Query Statement: -select count(*) from lineitem +<div class="highlight-default"><div class="highlight"><pre><span class="n">default</span><span class="o">></span> \<span class="n">admin</span> <span class="o">-</span><span class="n">desc</span> <span class="n">q_1411357607375_0006</span> +<span class="n">Id</span><span class="p">:</span> <span class="mi">1</span> +<span class="n">Query</span> <span class="n">Id</span><span class="p">:</span> <span class="n">q_1411357607375_0006</span> +<span class="n">Started</span> <span class="n">Time</span><span class="p">:</span> <span class="mi">2014</span><span class="o">-</span><span class="mi">09</span><span class="o">-</span><span class="mi">23</span> <span class="mi">07</span><span class="p">:</span><span class="mi">19</span><span class="p">:</span><span class="mi">40</span> +<span class="n">Query</span> <span class="n">State</span><span class="p">:</span> <span class="n">QUERY_RUNNING</span> +<span class="n">Execution</span> <span class="n">Time</span><span class="p">:</span> <span class="mf">20.0</span> <span class="n">sec</span> +<span class="n">Query</span> <span class="n">Progress</span><span class="p">:</span> <span class="mf">0.249</span> +<span class="n">Query</span> <span class="n">Statement</span><span class="p">:</span> +<span class="n">select</span> <span class="n">count</span><span class="p">(</span><span class="o">*</span><span class="p">)</span> <span class="kn">from</span> <span class="nn">lineitem</span> </pre></div> </div> <p><code class="docutils literal"><span class="pre">-kill</span></code> option kills a specified running query as follows:</p> -<div class="highlight-python"><div class="highlight"><pre>default> \admin -kill q_1411357607375_0007 -q_1411357607375_0007 is killed successfully. +<div class="highlight-default"><div class="highlight"><pre><span class="n">default</span><span class="o">></span> \<span class="n">admin</span> <span class="o">-</span><span class="n">kill</span> <span class="n">q_1411357607375_0007</span> +<span class="n">q_1411357607375_0007</span> <span class="ow">is</span> <span class="n">killed</span> <span class="n">successfully</span><span class="o">.</span> </pre></div> </div> <p><code class="docutils literal"><span class="pre">-showmasters</span></code> option shows a list of all tajo masters as follows:</p> -<div class="highlight-python"><div class="highlight"><pre>default> \admin -showmasters -grtajo01 +<div class="highlight-default"><div class="highlight"><pre><span class="n">default</span><span class="o">></span> \<span class="n">admin</span> <span class="o">-</span><span class="n">showmasters</span> +<span class="n">grtajo01</span> </pre></div> </div> </div> @@ -278,7 +278,7 @@ grtajo01 <div role="contentinfo"> <p> - © Copyright 2015, Apache Tajo Team. + © Copyright 2016, Apache Tajo Team. </p> </div> @@ -298,7 +298,7 @@ grtajo01 <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT:'../', - VERSION:'0.11.0', + VERSION:'0.12.0-SNAPSHOT', COLLAPSE_INDEX:false, FILE_SUFFIX:'.html', HAS_SOURCE: true
Modified: tajo/site/docs/devel/tsql/background_command.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/background_command.html?rev=1739720&r1=1739719&r2=1739720&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/background_command.html (original) +++ tajo/site/docs/devel/tsql/background_command.html Mon Apr 18 09:40:18 2016 @@ -7,7 +7,7 @@ <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> - <title>Executing as background process — Apache Tajo 0.11.0 documentation</title> + <title>Executing as background process — Apache Tajo 0.12.0-SNAPSHOT documentation</title> @@ -28,7 +28,7 @@ - <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> + <link rel="top" title="Apache Tajo 0.12.0-SNAPSHOT documentation" href="../index.html"/> <link rel="up" title="Tajo Shell (TSQL)" href="../tsql.html"/> <link rel="next" title="SQL Language" href="../sql_language.html"/> <link rel="prev" title="Executing Queries from Files" href="execute_file.html"/> @@ -89,7 +89,7 @@ <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 current"><a class="current reference internal" href="">Executing as background process</a></li> +<li class="toctree-l2 current"><a class="current reference internal" href="#">Executing as background process</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../sql_language.html">SQL Language</a><ul> @@ -252,7 +252,7 @@ $ <div role="contentinfo"> <p> - © Copyright 2015, Apache Tajo Team. + © Copyright 2016, Apache Tajo Team. </p> </div> @@ -272,7 +272,7 @@ $ <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT:'../', - VERSION:'0.11.0', + VERSION:'0.12.0-SNAPSHOT', COLLAPSE_INDEX:false, FILE_SUFFIX:'.html', HAS_SOURCE: true Modified: tajo/site/docs/devel/tsql/dfs_command.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/dfs_command.html?rev=1739720&r1=1739719&r2=1739720&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/dfs_command.html (original) +++ tajo/site/docs/devel/tsql/dfs_command.html Mon Apr 18 09:40:18 2016 @@ -7,7 +7,7 @@ <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> - <title>Executing HDFS commands — Apache Tajo 0.11.0 documentation</title> + <title>Executing HDFS commands — Apache Tajo 0.12.0-SNAPSHOT documentation</title> @@ -28,7 +28,7 @@ - <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> + <link rel="top" title="Apache Tajo 0.12.0-SNAPSHOT documentation" href="../index.html"/> <link rel="up" title="Tajo Shell (TSQL)" href="../tsql.html"/> <link rel="next" title="Session Variables" href="variables.html"/> <link rel="prev" title="Meta Commands" href="meta_command.html"/> @@ -83,7 +83,7 @@ </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 current"><a class="current reference internal" href="">Executing HDFS commands</a></li> +<li class="toctree-l2 current"><a class="current reference internal" href="#">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> @@ -252,7 +252,7 @@ drwxr-xr-x - tajo supergroup <div role="contentinfo"> <p> - © Copyright 2015, Apache Tajo Team. + © Copyright 2016, Apache Tajo Team. </p> </div> @@ -272,7 +272,7 @@ drwxr-xr-x - tajo supergroup <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT:'../', - VERSION:'0.11.0', + VERSION:'0.12.0-SNAPSHOT', COLLAPSE_INDEX:false, FILE_SUFFIX:'.html', HAS_SOURCE: true Modified: tajo/site/docs/devel/tsql/execute_file.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/execute_file.html?rev=1739720&r1=1739719&r2=1739720&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/execute_file.html (original) +++ tajo/site/docs/devel/tsql/execute_file.html Mon Apr 18 09:40:18 2016 @@ -7,7 +7,7 @@ <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> - <title>Executing Queries from Files — Apache Tajo 0.11.0 documentation</title> + <title>Executing Queries from Files — Apache Tajo 0.12.0-SNAPSHOT documentation</title> @@ -28,7 +28,7 @@ - <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> + <link rel="top" title="Apache Tajo 0.12.0-SNAPSHOT documentation" href="../index.html"/> <link rel="up" title="Tajo Shell (TSQL)" href="../tsql.html"/> <link rel="next" title="Executing as background process" href="background_command.html"/> <link rel="prev" title="Executing a single command" href="single_command.html"/> @@ -88,7 +88,7 @@ <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 current"><a class="current reference internal" href="">Executing Queries from Files</a></li> +<li class="toctree-l2 current"><a class="current reference internal" href="#">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> @@ -278,7 +278,7 @@ Progress: 100%, response time: 0.331 sec <div role="contentinfo"> <p> - © Copyright 2015, Apache Tajo Team. + © Copyright 2016, Apache Tajo Team. </p> </div> @@ -298,7 +298,7 @@ Progress: 100%, response time: 0.331 sec <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT:'../', - VERSION:'0.11.0', + VERSION:'0.12.0-SNAPSHOT', COLLAPSE_INDEX:false, FILE_SUFFIX:'.html', HAS_SOURCE: true Modified: tajo/site/docs/devel/tsql/intro.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/intro.html?rev=1739720&r1=1739719&r2=1739720&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/intro.html (original) +++ tajo/site/docs/devel/tsql/intro.html Mon Apr 18 09:40:18 2016 @@ -7,7 +7,7 @@ <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> - <title>Introducing to TSQL — Apache Tajo 0.11.0 documentation</title> + <title>Introducing to TSQL — Apache Tajo 0.12.0-SNAPSHOT documentation</title> @@ -28,7 +28,7 @@ - <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> + <link rel="top" title="Apache Tajo 0.12.0-SNAPSHOT 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"/> @@ -86,7 +86,7 @@ <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 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> @@ -231,15 +231,15 @@ <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 +<div class="highlight-default"><div class="highlight"><pre><span class="nb">bin</span><span class="o">/</span><span class="n">tsql</span> -default> +<span class="n">default</span><span class="o">></span> </pre></div> </div> <p>If you want to connect a specified TajoMaster, you should use ‘-h’ and (or) ‘p’ options as follows:</p> -<div class="highlight-python"><div class="highlight"><pre>bin/tsql -h localhost -p 9004 +<div class="highlight-default"><div class="highlight"><pre><span class="nb">bin</span><span class="o">/</span><span class="n">tsql</span> <span class="o">-</span><span class="n">h</span> <span class="n">localhost</span> <span class="o">-</span><span class="n">p</span> <span class="mi">9004</span> -default> +<span class="n">default</span><span class="o">></span> </pre></div> </div> <p>The prompt indicates the current database.</p> @@ -264,7 +264,7 @@ default> <div role="contentinfo"> <p> - © Copyright 2015, Apache Tajo Team. + © Copyright 2016, Apache Tajo Team. </p> </div> @@ -284,7 +284,7 @@ default> <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT:'../', - VERSION:'0.11.0', + VERSION:'0.12.0-SNAPSHOT', COLLAPSE_INDEX:false, FILE_SUFFIX:'.html', HAS_SOURCE: true Modified: tajo/site/docs/devel/tsql/meta_command.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/meta_command.html?rev=1739720&r1=1739719&r2=1739720&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/meta_command.html (original) +++ tajo/site/docs/devel/tsql/meta_command.html Mon Apr 18 09:40:18 2016 @@ -7,7 +7,7 @@ <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> - <title>Meta Commands — Apache Tajo 0.11.0 documentation</title> + <title>Meta Commands — Apache Tajo 0.12.0-SNAPSHOT documentation</title> @@ -28,7 +28,7 @@ - <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> + <link rel="top" title="Apache Tajo 0.12.0-SNAPSHOT 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"/> @@ -82,7 +82,7 @@ </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 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> @@ -213,7 +213,7 @@ <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 (‘\’) 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> \? +<div class="highlight-default"><div class="highlight"><pre>default> \? General @@ -257,43 +257,43 @@ Documentations <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> \l -default -tpch -work1 -default> +<div class="highlight-default"><div class="highlight"><pre><span class="n">default</span><span class="o">></span> \<span class="n">l</span> +<span class="n">default</span> +<span class="n">tpch</span> +<span class="n">work1</span> +<span class="n">default</span><span class="o">></span> </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> \d -customer -lineitem -nation -orders -part -partsupp -region -supplier +<div class="highlight-default"><div class="highlight"><pre><span class="n">default</span><span class="o">></span> \<span class="n">d</span> +<span class="n">customer</span> +<span class="n">lineitem</span> +<span class="n">nation</span> +<span class="n">orders</span> +<span class="n">part</span> +<span class="n">partsupp</span> +<span class="n">region</span> +<span class="n">supplier</span> </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> \d orders +<div class="highlight-default"><div class="highlight"><pre><span class="n">default</span><span class="o">></span> \<span class="n">d</span> <span class="n">orders</span> -table name: orders -table path: hdfs:/xxx/xxx/tpch/orders -store type: TEXT -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 +<span class="n">table</span> <span class="n">name</span><span class="p">:</span> <span class="n">orders</span> +<span class="n">table</span> <span class="n">path</span><span class="p">:</span> <span class="n">hdfs</span><span class="p">:</span><span class="o">/</span><span class="n">xxx</span><span class="o">/</span><span class="n">xxx</span><span class="o">/</span><span class="n">tpch</span><span class="o">/</span><span class="n">orders</span> +<span class="n">store</span> <span class="nb">type</span><span class="p">:</span> <span class="n">TEXT</span> +<span class="n">number</span> <span class="n">of</span> <span class="n">rows</span><span class="p">:</span> <span class="mi">0</span> +<span class="n">volume</span> <span class="p">(</span><span class="nb">bytes</span><span class="p">):</span> <span class="mf">172.0</span> <span class="n">MB</span> +<span class="n">schema</span><span class="p">:</span> +<span class="n">o_orderkey</span> <span class="n">INT8</span> +<span class="n">o_custkey</span> <span class="n">INT8</span> +<span class="n">o_orderstatus</span> <span class="n">TEXT</span> +<span class="n">o_totalprice</span> <span class="n">FLOAT8</span> +<span class="n">o_orderdate</span> <span class="n">TEXT</span> +<span class="n">o_orderpriority</span> <span class="n">TEXT</span> +<span class="n">o_clerk</span> <span class="n">TEXT</span> +<span class="n">o_shippriority</span> <span class="n">INT4</span> +<span class="n">o_comment</span> <span class="n">TEXT</span> </pre></div> </div> <p>The prompt <code class="docutils literal"><span class="pre">default></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> @@ -303,47 +303,47 @@ work1> </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> \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 +<div class="highlight-default"><div class="highlight"><pre><span class="n">default</span><span class="o">></span> \<span class="n">df</span> + <span class="n">Name</span> <span class="o">|</span> <span class="n">Result</span> <span class="nb">type</span> <span class="o">|</span> <span class="n">Argument</span> <span class="n">types</span> <span class="o">|</span> <span class="n">Description</span> <span class="o">|</span> <span class="n">Type</span> +<span class="o">-----------------+-----------------+-----------------------+-----------------------------------------------+-----------</span> + <span class="nb">abs</span> <span class="o">|</span> <span class="n">INT4</span> <span class="o">|</span> <span class="n">INT4</span> <span class="o">|</span> <span class="n">Absolute</span> <span class="n">value</span> <span class="o">|</span> <span class="n">GENERAL</span> + <span class="nb">abs</span> <span class="o">|</span> <span class="n">INT8</span> <span class="o">|</span> <span class="n">INT8</span> <span class="o">|</span> <span class="n">Absolute</span> <span class="n">value</span> <span class="o">|</span> <span class="n">GENERAL</span> + <span class="nb">abs</span> <span class="o">|</span> <span class="n">FLOAT4</span> <span class="o">|</span> <span class="n">FLOAT4</span> <span class="o">|</span> <span class="n">Absolute</span> <span class="n">value</span> <span class="o">|</span> <span class="n">GENERAL</span> + <span class="nb">abs</span> <span class="o">|</span> <span class="n">FLOAT8</span> <span class="o">|</span> <span class="n">FLOAT8</span> <span class="o">|</span> <span class="n">Absolute</span> <span class="n">value</span> <span class="o">|</span> <span class="n">GENERAL</span> + <span class="n">acos</span> <span class="o">|</span> <span class="n">FLOAT8</span> <span class="o">|</span> <span class="n">FLOAT4</span> <span class="o">|</span> <span class="n">Inverse</span> <span class="n">cosine</span><span class="o">.</span> <span class="o">|</span> <span class="n">GENERAL</span> + <span class="n">acos</span> <span class="o">|</span> <span class="n">FLOAT8</span> <span class="o">|</span> <span class="n">FLOAT8</span> <span class="o">|</span> <span class="n">Inverse</span> <span class="n">cosine</span><span class="o">.</span> <span class="o">|</span> <span class="n">GENERAL</span> + <span class="n">utc_usec_to</span> <span class="o">|</span> <span class="n">INT8</span> <span class="o">|</span> <span class="n">TEXT</span><span class="p">,</span><span class="n">INT8</span> <span class="o">|</span> <span class="n">Extract</span> <span class="n">field</span> <span class="kn">from</span> <span class="nn">time</span> <span class="o">|</span> <span class="n">GENERAL</span> + <span class="n">utc_usec_to</span> <span class="o">|</span> <span class="n">INT8</span> <span class="o">|</span> <span class="n">TEXT</span><span class="p">,</span><span class="n">INT8</span><span class="p">,</span><span class="n">INT4</span> <span class="o">|</span> <span class="n">Extract</span> <span class="n">field</span> <span class="kn">from</span> <span class="nn">time</span> <span class="o">|</span> <span class="n">GENERAL</span> -(181) rows +<span class="p">(</span><span class="mi">181</span><span class="p">)</span> <span class="n">rows</span> -For Reference, many details have been omitted in order to present a clear picture of the process. +<span class="n">For</span> <span class="n">Reference</span><span class="p">,</span> <span class="n">many</span> <span class="n">details</span> <span class="n">have</span> <span class="n">been</span> <span class="n">omitted</span> <span class="ow">in</span> <span class="n">order</span> <span class="n">to</span> <span class="n">present</span> <span class="n">a</span> <span class="n">clear</span> <span class="n">picture</span> <span class="n">of</span> <span class="n">the</span> <span class="n">process</span><span class="o">.</span> </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> \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: -> SELECT round(42.4) -42 - -Function: FLOAT8 round(float8,int4) -Description: Round to s decimalN places. -Example: -> SELECT round(42.4382, 2) -42.44 +<div class="highlight-default"><div class="highlight"><pre><span class="n">default</span><span class="o">></span> \<span class="n">df</span> <span class="nb">round</span><span class="p">;</span> + <span class="n">Name</span> <span class="o">|</span> <span class="n">Result</span> <span class="nb">type</span> <span class="o">|</span> <span class="n">Argument</span> <span class="n">types</span> <span class="o">|</span> <span class="n">Description</span> <span class="o">|</span> <span class="n">Type</span> +<span class="o">-----------------+-----------------+-----------------------+-----------------------------------------------+-----------</span> + <span class="nb">round</span> <span class="o">|</span> <span class="n">INT8</span> <span class="o">|</span> <span class="n">FLOAT4</span> <span class="o">|</span> <span class="n">Round</span> <span class="n">to</span> <span class="n">nearest</span> <span class="n">integer</span><span class="o">.</span> <span class="o">|</span> <span class="n">GENERAL</span> + <span class="nb">round</span> <span class="o">|</span> <span class="n">INT8</span> <span class="o">|</span> <span class="n">FLOAT8</span> <span class="o">|</span> <span class="n">Round</span> <span class="n">to</span> <span class="n">nearest</span> <span class="n">integer</span><span class="o">.</span> <span class="o">|</span> <span class="n">GENERAL</span> + <span class="nb">round</span> <span class="o">|</span> <span class="n">INT8</span> <span class="o">|</span> <span class="n">INT4</span> <span class="o">|</span> <span class="n">Round</span> <span class="n">to</span> <span class="n">nearest</span> <span class="n">integer</span><span class="o">.</span> <span class="o">|</span> <span class="n">GENERAL</span> + <span class="nb">round</span> <span class="o">|</span> <span class="n">INT8</span> <span class="o">|</span> <span class="n">INT8</span> <span class="o">|</span> <span class="n">Round</span> <span class="n">to</span> <span class="n">nearest</span> <span class="n">integer</span><span class="o">.</span> <span class="o">|</span> <span class="n">GENERAL</span> + <span class="nb">round</span> <span class="o">|</span> <span class="n">FLOAT8</span> <span class="o">|</span> <span class="n">FLOAT8</span><span class="p">,</span><span class="n">INT4</span> <span class="o">|</span> <span class="n">Round</span> <span class="n">to</span> <span class="n">s</span> <span class="n">decimalN</span> <span class="n">places</span><span class="o">.</span> <span class="o">|</span> <span class="n">GENERAL</span> + <span class="nb">round</span> <span class="o">|</span> <span class="n">FLOAT8</span> <span class="o">|</span> <span class="n">INT8</span><span class="p">,</span><span class="n">INT4</span> <span class="o">|</span> <span class="n">Round</span> <span class="n">to</span> <span class="n">s</span> <span class="n">decimalN</span> <span class="n">places</span><span class="o">.</span> <span class="o">|</span> <span class="n">GENERAL</span> + +<span class="p">(</span><span class="mi">6</span><span class="p">)</span> <span class="n">rows</span> + +<span class="n">Function</span><span class="p">:</span> <span class="n">INT8</span> <span class="nb">round</span><span class="p">(</span><span class="n">float4</span><span class="p">)</span> +<span class="n">Description</span><span class="p">:</span> <span class="n">Round</span> <span class="n">to</span> <span class="n">nearest</span> <span class="n">integer</span><span class="o">.</span> +<span class="n">Example</span><span class="p">:</span> +<span class="o">></span> <span class="n">SELECT</span> <span class="nb">round</span><span class="p">(</span><span class="mf">42.4</span><span class="p">)</span> +<span class="mi">42</span> + +<span class="n">Function</span><span class="p">:</span> <span class="n">FLOAT8</span> <span class="nb">round</span><span class="p">(</span><span class="n">float8</span><span class="p">,</span><span class="n">int4</span><span class="p">)</span> +<span class="n">Description</span><span class="p">:</span> <span class="n">Round</span> <span class="n">to</span> <span class="n">s</span> <span class="n">decimalN</span> <span class="n">places</span><span class="o">.</span> +<span class="n">Example</span><span class="p">:</span> +<span class="o">></span> <span class="n">SELECT</span> <span class="nb">round</span><span class="p">(</span><span class="mf">42.4382</span><span class="p">,</span> <span class="mi">2</span><span class="p">)</span> +<span class="mf">42.44</span> </pre></div> </div> </div> @@ -367,7 +367,7 @@ Example: <div role="contentinfo"> <p> - © Copyright 2015, Apache Tajo Team. + © Copyright 2016, Apache Tajo Team. </p> </div> @@ -387,7 +387,7 @@ Example: <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT:'../', - VERSION:'0.11.0', + VERSION:'0.12.0-SNAPSHOT', COLLAPSE_INDEX:false, FILE_SUFFIX:'.html', HAS_SOURCE: true Modified: tajo/site/docs/devel/tsql/single_command.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/single_command.html?rev=1739720&r1=1739719&r2=1739720&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/single_command.html (original) +++ tajo/site/docs/devel/tsql/single_command.html Mon Apr 18 09:40:18 2016 @@ -7,7 +7,7 @@ <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> - <title>Executing a single command — Apache Tajo 0.11.0 documentation</title> + <title>Executing a single command — Apache Tajo 0.12.0-SNAPSHOT documentation</title> @@ -28,7 +28,7 @@ - <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> + <link rel="top" title="Apache Tajo 0.12.0-SNAPSHOT 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"/> @@ -87,7 +87,7 @@ <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 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> @@ -249,7 +249,7 @@ Progress: 100%, response time: 0.345 sec <div role="contentinfo"> <p> - © Copyright 2015, Apache Tajo Team. + © Copyright 2016, Apache Tajo Team. </p> </div> @@ -269,7 +269,7 @@ Progress: 100%, response time: 0.345 sec <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT:'../', - VERSION:'0.11.0', + VERSION:'0.12.0-SNAPSHOT', COLLAPSE_INDEX:false, FILE_SUFFIX:'.html', HAS_SOURCE: true Modified: tajo/site/docs/devel/tsql/variables.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/variables.html?rev=1739720&r1=1739719&r2=1739720&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/variables.html (original) +++ tajo/site/docs/devel/tsql/variables.html Mon Apr 18 09:40:18 2016 @@ -7,7 +7,7 @@ <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> - <title>Session Variables — Apache Tajo 0.11.0 documentation</title> + <title>Session Variables — Apache Tajo 0.12.0-SNAPSHOT documentation</title> @@ -28,7 +28,7 @@ - <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> + <link rel="top" title="Apache Tajo 0.12.0-SNAPSHOT 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"/> @@ -84,7 +84,7 @@ <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 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> @@ -215,22 +215,22 @@ <p>For the sake of more convenient user configuration, Tajo provides <cite>session variables</cite>. With session variables, different configurations are allowed for each 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> \set -'name1'='val1' -'name2'='val2' -'name3'='val3' - ... +<div class="highlight-default"><div class="highlight"><pre><span class="n">default</span><span class="o">></span> \<span class="nb">set</span> +<span class="s">'name1'</span><span class="o">=</span><span class="s">'val1'</span> +<span class="s">'name2'</span><span class="o">=</span><span class="s">'val2'</span> +<span class="s">'name3'</span><span class="o">=</span><span class="s">'val3'</span> + <span class="o">...</span> </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> \set -'CURRENT_DATABASE'='default' +<div class="highlight-default"><div class="highlight"><pre><span class="n">default</span><span class="o">></span> \<span class="nb">set</span> +<span class="s">'CURRENT_DATABASE'</span><span class="o">=</span><span class="s">'default'</span> -default> \set key1 val1 +<span class="n">default</span><span class="o">></span> \<span class="nb">set</span> <span class="n">key1</span> <span class="n">val1</span> -default> \set -'CURRENT_DATABASE'='default' -'key1'='val1' +<span class="n">default</span><span class="o">></span> \<span class="nb">set</span> +<span class="s">'CURRENT_DATABASE'</span><span class="o">=</span><span class="s">'default'</span> +<span class="s">'key1'</span><span class="o">=</span><span class="s">'val1'</span> </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> @@ -243,7 +243,7 @@ default> \set <p>A threshold for non-cross joins. When a non-cross join query is executed with the broadcast join, the whole size of broadcasted tables won’t exceed this threshold.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-broadcast-non-cross-join-threshold-kb"><span>tajo.dist-query.broadcast.non-cross-join.threshold-kb</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-broadcast-non-cross-join-threshold-kb"><span class="std std-ref">tajo.dist-query.broadcast.non-cross-join.threshold-kb</span></a></li> <li>Property value: Integer</li> <li>Unit: KB</li> <li>Default value: 5120</li> @@ -261,7 +261,7 @@ default> \set <p>A threshold for cross joins. When a cross join query is executed, the whole size of broadcasted tables won’t exceed this threshold.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-broadcast-cross-join-threshold-kb"><span>tajo.dist-query.broadcast.cross-join.threshold-kb</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-broadcast-cross-join-threshold-kb"><span class="std std-ref">tajo.dist-query.broadcast.cross-join.threshold-kb</span></a></li> <li>Property value: Integer</li> <li>Unit: KB</li> <li>Default value: 1024</li> @@ -284,7 +284,7 @@ default> \set As a result, it determines the degree of the parallel processing of the join query.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-join-task-volume-mb"><span>tajo.dist-query.join.task-volume-mb</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-join-task-volume-mb"><span class="std std-ref">tajo.dist-query.join.task-volume-mb</span></a></li> <li>Property value: Integer</li> <li>Unit: MB</li> <li>Default value: 64</li> @@ -303,7 +303,7 @@ As a result, it determines the degree of this value indicates the output size of each task at the first stage, which determines the number of partitions to be shuffled between two stages.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-join-partition-volume-mb"><span>tajo.dist-query.join.partition-volume-mb</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-join-partition-volume-mb"><span class="std std-ref">tajo.dist-query.join.partition-volume-mb</span></a></li> <li>Property value: Integer</li> <li>Unit: MB</li> <li>Default value: 128</li> @@ -323,7 +323,7 @@ If the input data is smaller than this v Otherwise, the sort-merge join is used.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-common-in-memory-hash-threshold-mb"><span>tajo.executor.join.common.in-memory-hash-threshold-mb</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-common-in-memory-hash-threshold-mb"><span class="std std-ref">tajo.executor.join.common.in-memory-hash-threshold-mb</span></a></li> <li>Property value: Integer</li> <li>Unit: MB</li> <li>Default value: 64</li> @@ -349,7 +349,7 @@ If the input data is smaller than this v Otherwise, the sort-merge join is used.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-inner-in-memory-hash-threshold-mb"><span>tajo.executor.join.inner.in-memory-hash-threshold-mb</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-inner-in-memory-hash-threshold-mb"><span class="std std-ref">tajo.executor.join.inner.in-memory-hash-threshold-mb</span></a></li> <li>Property value: Integer</li> <li>Unit: MB</li> <li>Default value: 64</li> @@ -375,7 +375,7 @@ If the input data is smaller than this v Otherwise, the sort-merge join is used.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-outer-in-memory-hash-threshold-mb"><span>tajo.executor.join.outer.in-memory-hash-threshold-mb</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-outer-in-memory-hash-threshold-mb"><span class="std std-ref">tajo.executor.join.outer.in-memory-hash-threshold-mb</span></a></li> <li>Property value: Integer</li> <li>Unit: MB</li> <li>Default value: 64</li> @@ -399,7 +399,7 @@ This value should be tuned carefully.</p <p>The initial size of hash table for in-memory hash join.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-hash-table-size"><span>tajo.executor.join.hash-table.size</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-hash-table-size"><span class="std std-ref">tajo.executor.join.hash-table.size</span></a></li> <li>Property value: Integer</li> <li>Default value: 100000</li> <li>Example</li> @@ -417,7 +417,7 @@ This value should be tuned carefully.</p As a result, it determines the degree of the parallel processing of the sort query.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-sort-task-volume-mb"><span>tajo.dist-query.sort.task-volume-mb</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-sort-task-volume-mb"><span class="std std-ref">tajo.dist-query.sort.task-volume-mb</span></a></li> <li>Property value: Integer</li> <li>Unit: MB</li> <li>Default value: 64</li> @@ -435,7 +435,7 @@ As a result, it determines the degree of <p>A threshold to choose the sort algorithm. If the input data is larger than this threshold, the external sort algorithm is used.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-external-sort-buffer-mb"><span>tajo.executor.external-sort.buffer-mb</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-external-sort-buffer-mb"><span class="std std-ref">tajo.executor.external-sort.buffer-mb</span></a></li> <li>Property value: Integer</li> <li>Unit: MB</li> <li>Default value: 200</li> @@ -453,7 +453,7 @@ As a result, it determines the degree of <p>The initial size of list for in-memory sort.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-sort-list-size"><span>tajo.executor.sort.list.size</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-sort-list-size"><span class="std std-ref">tajo.executor.sort.list.size</span></a></li> <li>Property value: Integer</li> <li>Default value: 100000</li> <li>Example</li> @@ -471,7 +471,7 @@ As a result, it determines the degree of Otherwise, 2-phase aggregation algorithm is used.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-groupby-multi-level-aggr"><span>tajo.dist-query.groupby.multi-level-aggr</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-groupby-multi-level-aggr"><span class="std std-ref">tajo.dist-query.groupby.multi-level-aggr</span></a></li> <li>Property value: Boolean</li> <li>Default value: true</li> <li>Example</li> @@ -489,7 +489,7 @@ Otherwise, 2-phase aggregation algorithm this value indicates the output size of each task at the first stage, which determines the number of partitions to be shuffled between two stages.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-groupby-partition-volume-mb"><span>tajo.dist-query.groupby.partition-volume-mb</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-groupby-partition-volume-mb"><span class="std std-ref">tajo.dist-query.groupby.partition-volume-mb</span></a></li> <li>Property value: Integer</li> <li>Unit: MB</li> <li>Default value: 256</li> @@ -508,7 +508,7 @@ this value indicates the output size of As a result, it determines the degree of the parallel processing of the aggregation query.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-groupby-task-volume-mb"><span>tajo.dist-query.groupby.task-volume-mb</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-groupby-task-volume-mb"><span class="std std-ref">tajo.dist-query.groupby.task-volume-mb</span></a></li> <li>Property value: Integer</li> <li>Unit: MB</li> <li>Default value: 64</li> @@ -528,7 +528,7 @@ If the input data is smaller than this v Otherwise, the sort-based aggregation is used.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-groupby-in-memory-hash-threshold-mb"><span>tajo.executor.groupby.in-memory-hash-threshold-mb</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-groupby-in-memory-hash-threshold-mb"><span class="std std-ref">tajo.executor.groupby.in-memory-hash-threshold-mb</span></a></li> <li>Property value: Integer</li> <li>Unit: MB</li> <li>Default value: 64</li> @@ -552,7 +552,7 @@ This value should be tuned carefully.</p <p>The initial size of hash table for in-memory aggregation.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-aggregate-hash-table-size"><span>tajo.executor.aggregate.hash-table.size</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-aggregate-hash-table-size"><span class="std std-ref">tajo.executor.aggregate.hash-table.size</span></a></li> <li>Property value: Integer</li> <li>Default value: 10000</li> <li>Example</li> @@ -566,10 +566,10 @@ This value should be tuned carefully.</p <code class="descname">TIMEZONE</code></dt> <dd></dd></dl> -<p>Refer to <a class="reference internal" href="../time_zone.html"><em>Time Zone</em></a>.</p> +<p>Refer to <a class="reference internal" href="../time_zone.html"><span class="doc">Time Zone</span></a>.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-timezone"><span>tajo.timezone</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-timezone"><span class="std std-ref">tajo.timezone</span></a></li> <li>Property value: Time zone id</li> <li>Default value: Default time zone of JVM</li> <li>Example</li> @@ -586,7 +586,7 @@ This value should be tuned carefully.</p <p>Date order specification.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-datetime-date-order"><span>tajo.datetime.date-order</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-datetime-date-order"><span class="std std-ref">tajo.datetime.date-order</span></a></li> <li>Property value: One of YMD, DMY, MDY.</li> <li>Default value: YMD</li> <li>Example</li> @@ -603,7 +603,7 @@ This value should be tuned carefully.</p <p>If this value is true, a partitioned table is overwritten even if a subquery leads to no result. Otherwise, the table data will be kept if there is no result.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-partition-overwrite-even-if-no-result"><span>tajo.partition.overwrite.even-if-no-result</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-partition-overwrite-even-if-no-result"><span class="std std-ref">tajo.partition.overwrite.even-if-no-result</span></a></li> <li>Property value: Boolean</li> <li>Default value: false</li> <li>Example</li> @@ -621,7 +621,7 @@ This value should be tuned carefully.</p This value indicates the output size of a task of the former stage, which determines the number of partitions to be shuffled between two stages.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-table-partition-task-volume-mb"><span>tajo.dist-query.table-partition.task-volume-mb</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-table-partition-task-volume-mb"><span class="std std-ref">tajo.dist-query.table-partition.task-volume-mb</span></a></li> <li>Property value: Integer</li> <li>Unit: MB</li> <li>Default value: 256</li> @@ -639,7 +639,7 @@ This value indicates the output size of <p>A flag to indicate how to handle the errors caused by invalid arithmetic operations. If true, a running query will be terminated with an overflow or a divide-by-zero.</p> <blockquote> <div><ul class="simple"> -<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-behavior-arithmetic-abort"><span>tajo.behavior.arithmetic-abort</span></a></li> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-behavior-arithmetic-abort"><span class="std std-ref">tajo.behavior.arithmetic-abort</span></a></li> <li>Property value: Boolean</li> <li>Default value: false</li> <li>Example</li> @@ -862,7 +862,7 @@ This value indicates the output size of <div role="contentinfo"> <p> - © Copyright 2015, Apache Tajo Team. + © Copyright 2016, Apache Tajo Team. </p> </div> @@ -882,7 +882,7 @@ This value indicates the output size of <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT:'../', - VERSION:'0.11.0', + VERSION:'0.12.0-SNAPSHOT', COLLAPSE_INDEX:false, FILE_SUFFIX:'.html', HAS_SOURCE: true Modified: tajo/site/index.html URL: http://svn.apache.org/viewvc/tajo/site/index.html?rev=1739720&r1=1739719&r2=1739720&view=diff ============================================================================== --- tajo/site/index.html (original) +++ tajo/site/index.html Mon Apr 18 09:40:18 2016 @@ -1,13 +1,13 @@ <!DOCTYPE html> <!-- - | Generated by Apache Maven Doxia at 2016-04-07 + | Generated by Apache Maven Doxia at 2016-04-18 | Rendered using Apache Maven Fluido Skin 1.3.0 --> <html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en"> <head> <meta charset="UTF-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> - <meta name="Date-Revision-yyyymmdd" content="20160407" /> + <meta name="Date-Revision-yyyymmdd" content="20160418" /> <meta http-equiv="Content-Language" content="en" /> <title>Tajo - A Big Data Warehouse System on Hadoop - </title> <link rel="stylesheet" href="./css/apache-maven-fluido-1.3.0.min.css" /> @@ -187,10 +187,10 @@ window.onload = ga_event_load;</script> <a href="#" class="dropdown-toggle" data-toggle="dropdown">Documentation <b class="caret"></b></a> <ul class="dropdown-menu"> - <li> <a href="http://tajo.apache.org/docs/devel/index.html"; title="Devel">Devel</a> + <li> <a href="../docs/devel/index.html" title="Devel">Devel</a> </li> - <li> <a href="http://tajo.apache.org/docs/current/index.html"; title="Current (0.11.1)">Current (0.11.1)</a> + <li> <a href="../docs/current/index.html" title="Current (0.11.1)">Current (0.11.1)</a> </li> </ul> </li> @@ -201,7 +201,7 @@ window.onload = ga_event_load;</script> <li> <a href="source-code.html" title="Source Code">Source Code</a> </li> - <li> <a href="../../foundation/getinvolved.html" title="Get Involved">Get Involved</a> + <li> <a href="http://www.apache.org/foundation/getinvolved.html"; title="Get Involved">Get Involved</a> </li> <li> <a href="https://cwiki.apache.org/confluence/display/TAJO/How+to+Contribute+Codes+to+Tajo"; title="How To Contribute">How To Contribute</a> @@ -221,16 +221,16 @@ window.onload = ga_event_load;</script> <a href="#" class="dropdown-toggle" data-toggle="dropdown">Apache <b class="caret"></b></a> <ul class="dropdown-menu"> - <li> <a href="../../" title="Web Site">Web Site</a> + <li> <a href="http://www.apache.org/"; title="Web Site">Web Site</a> </li> - <li> <a href="../../foundation/sponsorship.html" title="Sponsorship">Sponsorship</a> + <li> <a href="http://www.apache.org/foundation/sponsorship.html"; title="Sponsorship">Sponsorship</a> </li> - <li> <a href="../../foundation/thanks.html" title="Thanks">Thanks</a> + <li> <a href="http://www.apache.org/foundation/thanks.html"; title="Thanks">Thanks</a> </li> - <li> <a href="../../security/" title="Security">Security</a> + <li> <a href="http://www.apache.org/security/"; title="Security">Security</a> </li> </ul> </li> @@ -257,7 +257,7 @@ window.onload = ga_event_load;</script> <div class="container-fluid"> <div id="banner"> <div class="pull-left"> - <a href="http://tajo.apache.org"; id="bannerLeft"> + <a href=".." id="bannerLeft"> <img src="images/tajo_logo.png" alt="Apache Tajo" width="240"/> </a> </div> @@ -273,7 +273,7 @@ window.onload = ga_event_load;</script> <li class=""> - <a href="../.." title="Apache"> + <a href="http://www.apache.org"; class="externalLink" title="Apache"> Apache</a> </li> <li class="divider ">/</li> @@ -286,7 +286,7 @@ window.onload = ga_event_load;</script> - <li id="publishDate" class="pull-right">Last Published: 2016-04-07</li> <li class="divider pull-right">|</li> + <li id="publishDate" class="pull-right">Last Published: 2016-04-18</li> <li class="divider pull-right">|</li> <li id="projectVersion" class="pull-right">Version: 0.12.0-SNAPSHOT</li> </ul> @@ -380,14 +380,14 @@ window.onload = ga_event_load;</script> <li> - <a href="http://tajo.apache.org/docs/devel/index.html"; class="externalLink" title="Devel"> + <a href="../docs/devel/index.html" title="Devel"> <i class="none"></i> Devel</a> </li> <li> - <a href="http://tajo.apache.org/docs/current/index.html"; class="externalLink" title="Current (0.11.1)"> + <a href="../docs/current/index.html" title="Current (0.11.1)"> <i class="none"></i> Current (0.11.1)</a> </li> @@ -402,7 +402,7 @@ window.onload = ga_event_load;</script> <li> - <a href="../../foundation/getinvolved.html" title="Get Involved"> + <a href="http://www.apache.org/foundation/getinvolved.html"; class="externalLink" title="Get Involved"> <i class="none"></i> Get Involved</a> </li> @@ -438,28 +438,28 @@ window.onload = ga_event_load;</script> <li> - <a href="../../" title="Web Site"> + <a href="http://www.apache.org/"; class="externalLink" title="Web Site"> <i class="none"></i> Web Site</a> </li> <li> - <a href="../../foundation/sponsorship.html" title="Sponsorship"> + <a href="http://www.apache.org/foundation/sponsorship.html"; class="externalLink" title="Sponsorship"> <i class="none"></i> Sponsorship</a> </li> <li> - <a href="../../foundation/thanks.html" title="Thanks"> + <a href="http://www.apache.org/foundation/thanks.html"; class="externalLink" title="Thanks"> <i class="none"></i> Thanks</a> </li> <li> - <a href="../../security/" title="Security"> + <a href="http://www.apache.org/security/"; class="externalLink" title="Security"> <i class="none"></i> Security</a> </li>
