You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@tajo.apache.org by hy...@apache.org on 2015/05/28 14:22:20 UTC
svn commit: r1682226 [5/5] - in /tajo/site/docs/devel: ./
_sources/table_management/ _static/ configuration/ functions/ index/
partitioning/ sql_language/ table_management/ tsql/
Modified: tajo/site/docs/devel/tsql/execute_file.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/execute_file.html?rev=1682226&r1=1682225&r2=1682226&view=diff
==============================================================================
--- tajo/site/docs/devel/tsql/execute_file.html (original)
+++ tajo/site/docs/devel/tsql/execute_file.html Thu May 28 12:22:19 2015
@@ -199,7 +199,7 @@
<h1>Executing Queries from Files<a class="headerlink" href="#executing-queries-from-files" title="Permalink to this headline">¶</a></h1>
<div class="section" id="basic-usages">
<h2>Basic usages<a class="headerlink" href="#basic-usages" title="Permalink to this headline">¶</a></h2>
-<p><tt class="docutils literal"><span class="pre">-f</span></tt> command allows tsql to execute more than one SQL statements stored in a text file as follows:</p>
+<p><code class="docutils literal"><span class="pre">-f</span></code> command allows tsql to execute more than one SQL statements stored in a text file as follows:</p>
<div class="highlight-sql"><div class="highlight"><pre>$ cat aggregation.sql
select count(*) from table1;
select sum(score) from table1;
Modified: tajo/site/docs/devel/tsql/intro.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/intro.html?rev=1682226&r1=1682225&r2=1682226&view=diff
==============================================================================
--- tajo/site/docs/devel/tsql/intro.html (original)
+++ tajo/site/docs/devel/tsql/intro.html Thu May 28 12:22:19 2015
@@ -202,16 +202,16 @@
<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 <tt class="docutils literal"><span class="pre">default</span></tt> database.</p>
+<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><tt class="docutils literal"><span class="pre">-c</span> <span class="pre">"quoted</span> <span class="pre">sql"</span></tt> : Execute quoted sql statements, and then the shell will exist.</li>
-<li><tt class="docutils literal"><span class="pre">-f</span> <span class="pre">filename</span> <span class="pre">(--file</span> <span class="pre">filename)</span></tt> : Use the file named filename as the source of commands instead of interactive shell.</li>
-<li><tt class="docutils literal"><span class="pre">-h</span> <span class="pre">hostname</span> <span class="pre">(--host</span> <span class="pre">hostname)</span></tt> : Specifies the host name of the machine on which the Tajo master is running.</li>
-<li><tt class="docutils literal"><span class="pre">-p</span> <span class="pre">port</span> <span class="pre">(--port</span> <span class="pre">port)</span></tt> : Specifies the TCP port. If it is not set, the port will be 26002 by default.</li>
-<li><tt class="docutils literal"><span class="pre">-conf</span> <span class="pre">configuration</span> <span class="pre">(--conf</span> <span class="pre">configuration)</span></tt> : Setting Tajo configuration value.</li>
-<li><tt class="docutils literal"><span class="pre">-param</span> <span class="pre">parameter</span> <span class="pre">(--param</span> <span class="pre">parameter)</span></tt> : Use a parameter value in SQL file.</li>
-<li><tt class="docutils literal"><span class="pre">-B</span> <span class="pre">(--background)</span></tt> : Execute as background process.</li>
+<li><code class="docutils literal"><span class="pre">-c</span> <span class="pre">"quoted</span> <span class="pre">sql"</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">
Modified: tajo/site/docs/devel/tsql/meta_command.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/meta_command.html?rev=1682226&r1=1682225&r2=1682226&view=diff
==============================================================================
--- tajo/site/docs/devel/tsql/meta_command.html (original)
+++ tajo/site/docs/devel/tsql/meta_command.html Thu May 28 12:22:19 2015
@@ -242,7 +242,7 @@ Documentations
</div>
<div class="section" id="basic-usages">
<h2>Basic usages<a class="headerlink" href="#basic-usages" title="Permalink to this headline">¶</a></h2>
-<p><tt class="docutils literal"><span class="pre">\l</span></tt> command shows a list of all databases as follows:</p>
+<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
@@ -250,7 +250,7 @@ work1
default>
</pre></div>
</div>
-<p><tt class="docutils literal"><span class="pre">\d</span></tt> command shows a list of tables in the current database as follows:</p>
+<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
@@ -262,7 +262,7 @@ region
supplier
</pre></div>
</div>
-<p><tt class="docutils literal"><span class="pre">\d</span> <span class="pre">[table</span> <span class="pre">name]</span></tt> command also shows a table description as follows:</p>
+<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
table name: orders
@@ -282,13 +282,13 @@ o_shippriority INT4
o_comment TEXT
</pre></div>
</div>
-<p>The prompt <tt class="docutils literal"><span class="pre">default></span></tt> indicates the current database. Basically, all SQL statements and meta commands work in the current database. Also, you can change the current database with <tt class="docutils literal"><span class="pre">\c</span></tt> command.</p>
+<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>
<div class="highlight-sql"><div class="highlight"><pre>default> \c work1
You are now connected to database "test" as user "hyunsik".
work1>
</pre></div>
</div>
-<p><tt class="docutils literal"><span class="pre">\df</span></tt> command shows a list of all built-in functions as follows:</p>
+<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
-----------------+-----------------+-----------------------+-----------------------------------------------+-----------
@@ -306,7 +306,7 @@ work1>
For Reference, many details have been omitted in order to present a clear picture of the process.
</pre></div>
</div>
-<p><tt class="docutils literal"><span class="pre">\df</span> <span class="pre">[function</span> <span class="pre">name]</span></tt> command also shows a function description as follows:</p>
+<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
-----------------+-----------------+-----------------------+-----------------------------------------------+-----------
Modified: tajo/site/docs/devel/tsql/single_command.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/single_command.html?rev=1682226&r1=1682225&r2=1682226&view=diff
==============================================================================
--- tajo/site/docs/devel/tsql/single_command.html (original)
+++ tajo/site/docs/devel/tsql/single_command.html Thu May 28 12:22:19 2015
@@ -197,7 +197,7 @@
<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 <tt class="docutils literal"><span class="pre">-c</span></tt> argument for above requirement. And Tajo assumes that queries are separated by semicolon as follows:</p>
+<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 "select count(*) from table1; select sum(score) from table1;"
Progress: 0%, response time: 0.217 sec
Progress: 0%, response time: 0.218 sec
Modified: tajo/site/docs/devel/tsql/variables.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/variables.html?rev=1682226&r1=1682225&r2=1682226&view=diff
==============================================================================
--- tajo/site/docs/devel/tsql/variables.html (original)
+++ tajo/site/docs/devel/tsql/variables.html Thu May 28 12:22:19 2015
@@ -198,7 +198,7 @@
<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><tt class="docutils literal"><span class="pre">tsql</span></tt> provides the meta command <tt class="docutils literal"><span class="pre">\set</span></tt> to manipulate session variables. Just <tt class="docutils literal"><span class="pre">\set</span></tt> command shows all session variables.</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'
@@ -206,7 +206,7 @@
...
</pre></div>
</div>
-<p><tt class="docutils literal"><span class="pre">\set</span> <span class="pre">key</span> <span class="pre">val</span></tt> will set the session variable named <em>key</em> with the value <em>val</em>.</p>
+<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'
@@ -217,41 +217,41 @@ default> \set
'key1'='val1'
</pre></div>
</div>
-<p>Also, <tt class="docutils literal"><span class="pre">\unset</span> <span class="pre">key</span></tt> will unset the session variable named <em>key</em>.</p>
+<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><tt class="docutils literal"><span class="pre">DIST_QUERY_BROADCAST_JOIN_THRESHOLD</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">DIST_QUERY_JOIN_TASK_VOLUME</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">DIST_QUERY_SORT_TASK_VOLUME</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">DIST_QUERY_GROUPBY_TASK_VOLUME</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">DIST_QUERY_JOIN_PARTITION_VOLUME</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">DIST_QUERY_GROUPBY_PARTITION_VOLUME</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">DIST_QUERY_TABLE_PARTITION_VOLUME</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">EXECUTOR_EXTERNAL_SORT_BUFFER_SIZE</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">EXECUTOR_HASH_JOIN_SIZE_THRESHOLD</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">EXECUTOR_INNER_HASH_JOIN_SIZE_THRESHOLD</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">EXECUTOR_OUTER_HASH_JOIN_SIZE_THRESHOLD</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">EXECUTOR_GROUPBY_INMEMORY_HASH_THRESHOLD</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">MAX_OUTPUT_FILE_SIZE</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">CODEGEN</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">CLIENT_SESSION_EXPIRY_TIME</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">CLI_MAX_COLUMN</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">CLI_NULL_CHAR</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">CLI_PRINT_PAUSE_NUM_RECORDS</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">CLI_PRINT_PAUSE</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">CLI_PRINT_ERROR_TRACE</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">CLI_OUTPUT_FORMATTER_CLASS</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">CLI_ERROR_STOP</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">TIMEZONE</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">DATE_ORDER</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">TEXT_NULL</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">DEBUG_ENABLED</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">TEST_BROADCAST_JOIN_ENABLED</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">TEST_JOIN_OPT_ENABLED</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">TEST_FILTER_PUSHDOWN_ENABLED</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">TEST_MIN_TASK_NUM</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">BEHAVIOR_ARITHMETIC_ABORT</span></tt></li>
-<li><tt class="docutils literal"><span class="pre">RESULT_SET_FETCH_ROWNUM</span></tt></li>
+<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>