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>
