Modified: tajo/site/docs/devel/table_management/rcfile.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/table_management/rcfile.html?rev=1649478&r1=1649477&r2=1649478&view=diff ============================================================================== --- tajo/site/docs/devel/table_management/rcfile.html (original) +++ tajo/site/docs/devel/table_management/rcfile.html Mon Jan 5 08:43:18 2015 @@ -61,11 +61,11 @@ <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="../introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="../getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../configuration.html">Configuration</a><ul> @@ -186,8 +186,8 @@ which shares many similarities with SequenceFile.</p> <div class="section" id="how-to-create-a-rcfile-table"> <h2>How to Create a RCFile Table?<a class="headerlink" href="#how-to-create-a-rcfile-table" title="Permalink to this headline">¶</a></h2> -<p>If you are not familiar with the <tt class="docutils literal"><span class="pre">CREATE</span> <span class="pre">TABLE</span></tt> statement, please refer to the Data Definition Language <a class="reference internal" href="../sql_language/ddl.html"><em>Data Definition Language</em></a>.</p> -<p>In order to specify a certain file format for your table, you need to use the <tt class="docutils literal"><span class="pre">USING</span></tt> clause in your <tt class="docutils literal"><span class="pre">CREATE</span> <span class="pre">TABLE</span></tt> +<p>If you are not familiar with the <code class="docutils literal"><span class="pre">CREATE</span> <span class="pre">TABLE</span></code> statement, please refer to the Data Definition Language <a class="reference internal" href="../sql_language/ddl.html"><em>Data Definition Language</em></a>.</p> +<p>In order to specify a certain file format for your table, you need to use the <code class="docutils literal"><span class="pre">USING</span></code> clause in your <code class="docutils literal"><span class="pre">CREATE</span> <span class="pre">TABLE</span></code> statement. Below is an example statement for creating a table using RCFile.</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">table1</span> <span class="p">(</span> <span class="n">id</span> <span class="nb">int</span><span class="p">,</span> @@ -201,12 +201,12 @@ statement. Below is an example statement <div class="section" id="physical-properties"> <h2>Physical Properties<a class="headerlink" href="#physical-properties" title="Permalink to this headline">¶</a></h2> <p>Some table storage formats provide parameters for enabling or disabling features and adjusting physical parameters. -The <tt class="docutils literal"><span class="pre">WITH</span></tt> clause in the CREATE TABLE statement allows users to set those parameters.</p> +The <code class="docutils literal"><span class="pre">WITH</span></code> clause in the CREATE TABLE statement allows users to set those parameters.</p> <p>Now, the RCFile storage type provides the following physical properties.</p> <ul class="simple"> -<li><tt class="docutils literal"><span class="pre">rcfile.serde</span></tt> : custom (De)serializer class. <tt class="docutils literal"><span class="pre">org.apache.tajo.storage.BinarySerializerDeserializer</span></tt> is the default (de)serializer class.</li> -<li><tt class="docutils literal"><span class="pre">rcfile.null</span></tt> : NULL character. It is only used when a table uses <tt class="docutils literal"><span class="pre">org.apache.tajo.storage.TextSerializerDeserializer</span></tt>. The default NULL character is an empty string <tt class="docutils literal"><span class="pre">''</span></tt>. Hive’s default NULL character is <tt class="docutils literal"><span class="pre">'\\N'</span></tt>.</li> -<li><tt class="docutils literal"><span class="pre">compression.codec</span></tt> : Compression codec. You can enable compression feature and set specified compression algorithm. The compression algorithm used to compress files. The compression codec name should be the fully qualified class name inherited from <a class="reference external" href="https://hadoop.apache.org/docs/current/api/org/apache/hadoop/io/compress/CompressionCodec.html";>org.apache.hadoop.io.compress.CompressionCodec</a>. By default, compression is disabled.</li> +<li><code class="docutils literal"><span class="pre">rcfile.serde</span></code> : custom (De)serializer class. <code class="docutils literal"><span class="pre">org.apache.tajo.storage.BinarySerializerDeserializer</span></code> is the default (de)serializer class.</li> +<li><code class="docutils literal"><span class="pre">rcfile.null</span></code> : NULL character. It is only used when a table uses <code class="docutils literal"><span class="pre">org.apache.tajo.storage.TextSerializerDeserializer</span></code>. The default NULL character is an empty string <code class="docutils literal"><span class="pre">''</span></code>. Hive’s default NULL character is <code class="docutils literal"><span class="pre">'\\N'</span></code>.</li> +<li><code class="docutils literal"><span class="pre">compression.codec</span></code> : Compression codec. You can enable compression feature and set specified compression algorithm. The compression algorithm used to compress files. The compression codec name should be the fully qualified class name inherited from <a class="reference external" href="https://hadoop.apache.org/docs/current/api/org/apache/hadoop/io/compress/CompressionCodec.html";>org.apache.hadoop.io.compress.CompressionCodec</a>. By default, compression is disabled.</li> </ul> <p>The following is an example for creating a table using RCFile that uses compression.</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">table1</span> <span class="p">(</span> @@ -222,14 +222,14 @@ The <tt class="docutils literal"><span c <h2>RCFile (De)serializers<a class="headerlink" href="#rcfile-de-serializers" title="Permalink to this headline">¶</a></h2> <p>Tajo provides two built-in (De)serializer for RCFile:</p> <ul class="simple"> -<li><tt class="docutils literal"><span class="pre">org.apache.tajo.storage.TextSerializerDeserializer</span></tt>: stores column values in a plain-text form.</li> -<li><tt class="docutils literal"><span class="pre">org.apache.tajo.storage.BinarySerializerDeserializer</span></tt>: stores column values in a binary file format.</li> +<li><code class="docutils literal"><span class="pre">org.apache.tajo.storage.TextSerializerDeserializer</span></code>: stores column values in a plain-text form.</li> +<li><code class="docutils literal"><span class="pre">org.apache.tajo.storage.BinarySerializerDeserializer</span></code>: stores column values in a binary file format.</li> </ul> <p>The RCFile format can store some metadata in the RCFile header. Tajo writes the (de)serializer class name into the metadata header of each RCFile when the RCFile is created in Tajo.</p> <div class="admonition note"> <p class="first admonition-title">Note</p> -<p class="last"><tt class="docutils literal"><span class="pre">org.apache.tajo.storage.BinarySerializerDeserializer</span></tt> is the default (de) serializer for RCFile.</p> +<p class="last"><code class="docutils literal"><span class="pre">org.apache.tajo.storage.BinarySerializerDeserializer</span></code> is the default (de) serializer for RCFile.</p> </div> </div> <div class="section" id="compatibility-issues-with-apache-hive"> @@ -240,16 +240,16 @@ In other words, Tajo can process RCFiles by setting a physical property.</p> <p>In Hive, there are two SerDe, and they correspond to the following (de)serializer in Tajo.</p> <ul class="simple"> -<li><tt class="docutils literal"><span class="pre">org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe</span></tt>: corresponds to <tt class="docutils literal"><span class="pre">TextSerializerDeserializer</span></tt> in Tajo.</li> -<li><tt class="docutils literal"><span class="pre">org.apache.hadoop.hive.serde2.columnar.LazyBinaryColumnarSerDe</span></tt>: corresponds to <tt class="docutils literal"><span class="pre">BinarySerializerDeserializer</span></tt> in Tajo.</li> +<li><code class="docutils literal"><span class="pre">org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe</span></code>: corresponds to <code class="docutils literal"><span class="pre">TextSerializerDeserializer</span></code> in Tajo.</li> +<li><code class="docutils literal"><span class="pre">org.apache.hadoop.hive.serde2.columnar.LazyBinaryColumnarSerDe</span></code>: corresponds to <code class="docutils literal"><span class="pre">BinarySerializerDeserializer</span></code> in Tajo.</li> </ul> <p>The compatibility issue mostly occurs when a user creates an external table pointing to data of an existing table. The following section explains two cases: 1) the case where Tajo reads RCFile written by Hive, and 2) the case where Hive reads RCFile written by Tajo.</p> <div class="section" id="when-tajo-reads-rcfile-generated-in-hive"> <h3>When Tajo reads RCFile generated in Hive<a class="headerlink" href="#when-tajo-reads-rcfile-generated-in-hive" title="Permalink to this headline">¶</a></h3> -<p>To create an external RCFile table generated with <tt class="docutils literal"><span class="pre">ColumnarSerDe</span></tt> in Hive, -you should set the physical property <tt class="docutils literal"><span class="pre">rcfile.serde</span></tt> in Tajo as follows:</p> +<p>To create an external RCFile table generated with <code class="docutils literal"><span class="pre">ColumnarSerDe</span></code> in Hive, +you should set the physical property <code class="docutils literal"><span class="pre">rcfile.serde</span></code> in Tajo as follows:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">EXTERNAL</span> <span class="k">TABLE</span> <span class="n">table1</span> <span class="p">(</span> <span class="n">id</span> <span class="nb">int</span><span class="p">,</span> <span class="n">name</span> <span class="nb">text</span><span class="p">,</span> @@ -259,8 +259,8 @@ you should set the physical property <tt <span class="k">LOCATION</span> <span class="s1">'....'</span><span class="p">;</span> </pre></div> </div> -<p>To create an external RCFile table generated with <tt class="docutils literal"><span class="pre">LazyBinaryColumnarSerDe</span></tt> in Hive, -you should set the physical property <tt class="docutils literal"><span class="pre">rcfile.serde</span></tt> in Tajo as follows:</p> +<p>To create an external RCFile table generated with <code class="docutils literal"><span class="pre">LazyBinaryColumnarSerDe</span></code> in Hive, +you should set the physical property <code class="docutils literal"><span class="pre">rcfile.serde</span></code> in Tajo as follows:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">EXTERNAL</span> <span class="k">TABLE</span> <span class="n">table1</span> <span class="p">(</span> <span class="n">id</span> <span class="nb">int</span><span class="p">,</span> <span class="n">name</span> <span class="nb">text</span><span class="p">,</span> @@ -272,14 +272,14 @@ you should set the physical property <tt </div> <div class="admonition note"> <p class="first admonition-title">Note</p> -<p class="last">As we mentioned above, <tt class="docutils literal"><span class="pre">BinarySerializerDeserializer</span></tt> is the default (de) serializer for RCFile. -So, you can omit the <tt class="docutils literal"><span class="pre">rcfile.serde</span></tt> only for <tt class="docutils literal"><span class="pre">org.apache.tajo.storage.BinarySerializerDeserializer</span></tt>.</p> +<p class="last">As we mentioned above, <code class="docutils literal"><span class="pre">BinarySerializerDeserializer</span></code> is the default (de) serializer for RCFile. +So, you can omit the <code class="docutils literal"><span class="pre">rcfile.serde</span></code> only for <code class="docutils literal"><span class="pre">org.apache.tajo.storage.BinarySerializerDeserializer</span></code>.</p> </div> </div> <div class="section" id="when-hive-reads-rcfile-generated-in-tajo"> <h3>When Hive reads RCFile generated in Tajo<a class="headerlink" href="#when-hive-reads-rcfile-generated-in-tajo" title="Permalink to this headline">¶</a></h3> -<p>To create an external RCFile table written by Tajo with <tt class="docutils literal"><span class="pre">TextSerializerDeserializer</span></tt>, -you should set the <tt class="docutils literal"><span class="pre">SERDE</span></tt> as follows:</p> +<p>To create an external RCFile table written by Tajo with <code class="docutils literal"><span class="pre">TextSerializerDeserializer</span></code>, +you should set the <code class="docutils literal"><span class="pre">SERDE</span></code> as follows:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">table1</span> <span class="p">(</span> <span class="n">id</span> <span class="nb">int</span><span class="p">,</span> <span class="n">name</span> <span class="n">string</span><span class="p">,</span> @@ -289,8 +289,8 @@ you should set the <tt class="docutils l <span class="k">LOCATION</span> <span class="s1">'<hdfs_location>'</span><span class="p">;</span> </pre></div> </div> -<p>To create an external RCFile table written by Tajo with <tt class="docutils literal"><span class="pre">BinarySerializerDeserializer</span></tt>, -you should set the <tt class="docutils literal"><span class="pre">SERDE</span></tt> as follows:</p> +<p>To create an external RCFile table written by Tajo with <code class="docutils literal"><span class="pre">BinarySerializerDeserializer</span></code>, +you should set the <code class="docutils literal"><span class="pre">SERDE</span></code> as follows:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">table1</span> <span class="p">(</span> <span class="n">id</span> <span class="nb">int</span><span class="p">,</span> <span class="n">name</span> <span class="n">string</span><span class="p">,</span>
Modified: tajo/site/docs/devel/table_management/sequencefile.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/table_management/sequencefile.html?rev=1649478&r1=1649477&r2=1649478&view=diff ============================================================================== --- tajo/site/docs/devel/table_management/sequencefile.html (original) +++ tajo/site/docs/devel/table_management/sequencefile.html Mon Jan 5 08:43:18 2015 @@ -61,11 +61,11 @@ <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="../introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="../getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../configuration.html">Configuration</a><ul> @@ -186,7 +186,7 @@ <h2>Introduce<a class="headerlink" href="#introduce" title="Permalink to this headline">¶</a></h2> <p>SequenceFiles are flat files consisting of binary key/value pairs. SequenceFile is basic file format which provided by Hadoop, and Hive also provides it to create a table.</p> -<p>The <tt class="docutils literal"><span class="pre">USING</span> <span class="pre">sequencefile</span></tt> keywords let you create a SequecneFile. Here is an example statement to create a table using <tt class="docutils literal"><span class="pre">SequecneFile</span></tt>:</p> +<p>The <code class="docutils literal"><span class="pre">USING</span> <span class="pre">sequencefile</span></code> keywords let you create a SequecneFile. Here is an example statement to create a table using <code class="docutils literal"><span class="pre">SequecneFile</span></code>:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">table1</span> <span class="p">(</span><span class="n">id</span> <span class="nb">int</span><span class="p">,</span> <span class="n">name</span> <span class="nb">text</span><span class="p">,</span> <span class="n">score</span> <span class="nb">float</span><span class="p">,</span> <span class="k">type</span> <span class="nb">text</span><span class="p">)</span> <span class="k">USING</span> <span class="n">sequencefile</span><span class="p">;</span> </pre></div> @@ -206,7 +206,7 @@ SequenceFile is basic file format which <li>BinarySerializerDeserializer: This class can read and write data in binary file format.</li> </ul> </div></blockquote> -<p>The default is the SerDe for plain text file in Tajo. The above example statement created the table using TextSerializerDeserializer.If you want to use BinarySerializerDeserializer, you can specify it by <tt class="docutils literal"><span class="pre">sequencefile.serde</span></tt> keywords:</p> +<p>The default is the SerDe for plain text file in Tajo. The above example statement created the table using TextSerializerDeserializer.If you want to use BinarySerializerDeserializer, you can specify it by <code class="docutils literal"><span class="pre">sequencefile.serde</span></code> keywords:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">table1</span> <span class="p">(</span><span class="n">id</span> <span class="nb">int</span><span class="p">,</span> <span class="n">name</span> <span class="nb">text</span><span class="p">,</span> <span class="n">score</span> <span class="nb">float</span><span class="p">,</span> <span class="k">type</span> <span class="nb">text</span><span class="p">)</span> <span class="k">USING</span> <span class="n">sequencefile</span> <span class="k">with</span> <span class="p">(</span><span class="s1">'sequencefile.serde'</span><span class="o">=</span><span class="s1">'org.apache.tajo.storage.BinarySerializerDeserializer'</span><span class="p">)</span> </pre></div> @@ -229,7 +229,7 @@ SequenceFile is basic file format which <li>BlockCompressWriter : Block-compressed files, both keys & values are collected in ‘blocks’ separately and compressed. The size of the ‘block’ is configurable.</li> </ul> </div></blockquote> -<p>The default is Uncompressed Writer in Tajo. If you want to use RecordCompressWriter, you can specify it by <tt class="docutils literal"><span class="pre">compression.type</span></tt> keywords and <tt class="docutils literal"><span class="pre">compression.codec</span></tt> keywords:</p> +<p>The default is Uncompressed Writer in Tajo. If you want to use RecordCompressWriter, you can specify it by <code class="docutils literal"><span class="pre">compression.type</span></code> keywords and <code class="docutils literal"><span class="pre">compression.codec</span></code> keywords:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">table1</span> <span class="p">(</span><span class="n">id</span> <span class="nb">int</span><span class="p">,</span> <span class="n">name</span> <span class="nb">text</span><span class="p">,</span> <span class="n">score</span> <span class="nb">float</span><span class="p">,</span> <span class="k">type</span> <span class="nb">text</span><span class="p">)</span> <span class="k">USING</span> <span class="n">sequencefile</span> <span class="k">with</span> <span class="p">(</span><span class="s1">'compression.type'</span><span class="o">=</span><span class="s1">'RECORD'</span><span class="p">,</span><span class="s1">'compression.codec'</span><span class="o">=</span><span class="s1">'org.apache.hadoop.io.compress.SnappyCodec'</span><span class="p">)</span> </pre></div> @@ -241,7 +241,7 @@ SequenceFile is basic file format which <span class="n">hive</span><span class="o">></span> <span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">table1</span> <span class="p">(</span><span class="n">id</span> <span class="nb">int</span><span class="p">,</span> <span class="n">name</span> <span class="n">string</span><span class="p">,</span> <span class="n">score</span> <span class="nb">float</span><span class="p">,</span> <span class="k">type</span> <span class="n">string</span><span class="p">)</span> <span class="n">STORED</span> <span class="k">AS</span> <span class="n">sequencefile</span><span class="p">;;</span> </pre></div> </div> -<p>And if you want to use BlockCompressWriter, you can specify it by <tt class="docutils literal"><span class="pre">compression.type</span></tt> keywords and <tt class="docutils literal"><span class="pre">compression.codec</span></tt> keywords:</p> +<p>And if you want to use BlockCompressWriter, you can specify it by <code class="docutils literal"><span class="pre">compression.type</span></code> keywords and <code class="docutils literal"><span class="pre">compression.codec</span></code> keywords:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">table1</span> <span class="p">(</span><span class="n">id</span> <span class="nb">int</span><span class="p">,</span> <span class="n">name</span> <span class="nb">text</span><span class="p">,</span> <span class="n">score</span> <span class="nb">float</span><span class="p">,</span> <span class="k">type</span> <span class="nb">text</span><span class="p">)</span> <span class="k">USING</span> <span class="n">sequencefile</span> <span class="k">with</span> <span class="p">(</span><span class="s1">'compression.type'</span><span class="o">=</span><span class="s1">'BLOCK'</span><span class="p">,</span><span class="s1">'compression.codec'</span><span class="o">=</span><span class="s1">'org.apache.hadoop.io.compress.SnappyCodec'</span><span class="p">)</span> </pre></div> Modified: tajo/site/docs/devel/table_management/table_overview.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/table_management/table_overview.html?rev=1649478&r1=1649477&r2=1649478&view=diff ============================================================================== --- tajo/site/docs/devel/table_management/table_overview.html (original) +++ tajo/site/docs/devel/table_management/table_overview.html Mon Jan 5 08:43:18 2015 @@ -61,11 +61,11 @@ <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="../introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="../getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../configuration.html">Configuration</a><ul> @@ -198,7 +198,7 @@ <div class="section" id="table-properties"> <h2>Table Properties<a class="headerlink" href="#table-properties" title="Permalink to this headline">¶</a></h2> <p>All table formats provide parameters for enabling or disabling features and adjusting physical parameters. -The <tt class="docutils literal"><span class="pre">WITH</span></tt> clause in the CREATE TABLE statement allows users to set those properties.</p> +The <code class="docutils literal"><span class="pre">WITH</span></code> clause in the CREATE TABLE statement allows users to set those properties.</p> <p>The following example is to set a custom field delimiter, NULL character, and compression codec:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">table1</span> <span class="p">(</span> <span class="n">id</span> <span class="nb">int</span><span class="p">,</span> @@ -223,12 +223,12 @@ The <tt class="docutils literal"><span c </div> <div class="section" id="time-zone"> <h3>Time zone<a class="headerlink" href="#time-zone" title="Permalink to this headline">¶</a></h3> -<p>In Tajo, a table property <tt class="docutils literal"><span class="pre">timezone</span></tt> allows users to specify a time zone that the table uses for reading or writing.</p> +<p>In Tajo, a table property <code class="docutils literal"><span class="pre">timezone</span></code> allows users to specify a time zone that the table uses for reading or writing.</p> <p>You can specify a table time zone as follows:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">EXTERNAL</span> <span class="k">TABLE</span> <span class="n">table1</span> <span class="p">(</span> <span class="n">t_timestamp</span> <span class="k">TIMESTAMP</span><span class="p">,</span> <span class="n">t_date</span> <span class="nb">DATE</span> -<span class="p">)</span> <span class="k">USING</span> <span class="n">TEXTFILE</span> <span class="k">WITH</span><span class="p">(</span><span class="s1">'timezone'</span><span class="o">=</span><span class="s1">'ASIA/Seoul'</span><span class="p">)</span> <span class="k">LOCATION</span> <span class="s1">'/path-to-table/'</span> +<span class="p">)</span> <span class="k">USING</span> <span class="nb">TEXT</span> <span class="k">WITH</span><span class="p">(</span><span class="s1">'timezone'</span><span class="o">=</span><span class="s1">'ASIA/Seoul'</span><span class="p">)</span> <span class="k">LOCATION</span> <span class="s1">'/path-to-table/'</span> </pre></div> </div> <p>In order to learn time zone, please refer to <a class="reference internal" href="../time_zone.html"><em>Time Zone</em></a>.</p> Modified: tajo/site/docs/devel/table_partitioning.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/table_partitioning.html?rev=1649478&r1=1649477&r2=1649478&view=diff ============================================================================== --- tajo/site/docs/devel/table_partitioning.html (original) +++ tajo/site/docs/devel/table_partitioning.html Mon Jan 5 08:43:18 2015 @@ -60,11 +60,11 @@ <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="configuration.html">Configuration</a><ul> Modified: tajo/site/docs/devel/tajo_client_api.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tajo_client_api.html?rev=1649478&r1=1649477&r2=1649478&view=diff ============================================================================== --- tajo/site/docs/devel/tajo_client_api.html (original) +++ tajo/site/docs/devel/tajo_client_api.html Mon Jan 5 08:43:18 2015 @@ -60,11 +60,11 @@ <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="configuration.html">Configuration</a><ul> Modified: tajo/site/docs/devel/time_zone.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/time_zone.html?rev=1649478&r1=1649477&r2=1649478&view=diff ============================================================================== --- tajo/site/docs/devel/time_zone.html (original) +++ tajo/site/docs/devel/time_zone.html Mon Jan 5 08:43:18 2015 @@ -60,11 +60,11 @@ <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="configuration.html">Configuration</a><ul> @@ -177,7 +177,7 @@ <div class="section" id="time-zone"> <h1>Time Zone<a class="headerlink" href="#time-zone" title="Permalink to this headline">¶</a></h1> -<p>Time zone affects some data types (e.g., <tt class="docutils literal"><span class="pre">Timestamp</span></tt> and <tt class="docutils literal"><span class="pre">Time</span></tt>) and operations (e.g., <tt class="docutils literal"><span class="pre">to_char</span></tt>). Tables can have different time zones. Internally, Tajo translates all table rows to UTC values and processes them. It becomes easier for Tajo to handle multiple different time zones.</p> +<p>Time zone affects some data types (e.g., <code class="docutils literal"><span class="pre">Timestamp</span></code> and <code class="docutils literal"><span class="pre">Time</span></code>) and operations (e.g., <code class="docutils literal"><span class="pre">to_char</span></code>). Tables can have different time zones. Internally, Tajo translates all table rows to UTC values and processes them. It becomes easier for Tajo to handle multiple different time zones.</p> <p>In Tajo, there are some time zong settings.</p> <div class="section" id="server-cluster-time-zone"> <h2>Server Cluster Time Zone<a class="headerlink" href="#server-cluster-time-zone" title="Permalink to this headline">¶</a></h2> @@ -191,26 +191,26 @@ </div> <div class="section" id="table-time-zone"> <h2>Table Time Zone<a class="headerlink" href="#table-time-zone" title="Permalink to this headline">¶</a></h2> -<p>In Tajo, a table property <tt class="docutils literal"><span class="pre">timezone</span></tt> allows users to specify a time zone that the table uses for reading or writing. -When each table row are read or written, <tt class="docutils literal"><span class="pre">`timestamp`</span></tt> and <tt class="docutils literal"><span class="pre">`time`</span></tt> column values are adjusted by a given time zone if it is set.</p> +<p>In Tajo, a table property <code class="docutils literal"><span class="pre">timezone</span></code> allows users to specify a time zone that the table uses for reading or writing. +When each table row are read or written, <code class="docutils literal"><span class="pre">`timestamp`</span></code> and <code class="docutils literal"><span class="pre">`time`</span></code> column values are adjusted by a given time zone if it is set.</p> <p>You can specify a table time zone as follows:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">EXTERNAL</span> <span class="k">TABLE</span> <span class="n">table1</span> <span class="p">(</span> <span class="n">t_timestamp</span> <span class="k">TIMESTAMP</span><span class="p">,</span> <span class="n">t_date</span> <span class="nb">DATE</span> -<span class="p">)</span> <span class="k">USING</span> <span class="n">TEXTFILE</span> <span class="k">WITH</span><span class="p">(</span><span class="s1">'timezone'</span><span class="o">=</span><span class="s1">'ASIA/Seoul'</span><span class="p">)</span> <span class="k">LOCATION</span> <span class="s1">'/path-to-table/'</span> +<span class="p">)</span> <span class="k">USING</span> <span class="nb">TEXT</span> <span class="k">WITH</span><span class="p">(</span><span class="s1">'timezone'</span><span class="o">=</span><span class="s1">'ASIA/Seoul'</span><span class="p">)</span> <span class="k">LOCATION</span> <span class="s1">'/path-to-table/'</span> </pre></div> </div> <p>In order to learn table properties, please refer to <a class="reference internal" href="table_management/table_overview.html"><em>Overview of Tajo Tables</em></a>.</p> </div> <div class="section" id="client-time-zone"> <h2>Client Time Zone<a class="headerlink" href="#client-time-zone" title="Permalink to this headline">¶</a></h2> -<p>Each client has its own time zone setting. It translates retrieved timestamp and time values by time zone. In order to set client time zone, you should set the session variable <tt class="docutils literal"><span class="pre">TIMEZONE</span></tt>. There are some ways to set this session variable.</p> -<p>In <tt class="docutils literal"><span class="pre">tsql</span></tt>, you can use <tt class="docutils literal"><span class="pre">\set</span> <span class="pre">timezone</span></tt> meta command as follows:</p> +<p>Each client has its own time zone setting. It translates retrieved timestamp and time values by time zone. In order to set client time zone, you should set the session variable <code class="docutils literal"><span class="pre">TIMEZONE</span></code>. There are some ways to set this session variable.</p> +<p>In <code class="docutils literal"><span class="pre">tsql</span></code>, you can use <code class="docutils literal"><span class="pre">\set</span> <span class="pre">timezone</span></code> meta command as follows:</p> <p><strong>tsql</strong></p> <div class="highlight-sh"><div class="highlight"><pre>default> <span class="se">\s</span>et timezone GMT+9 </pre></div> </div> -<p>The following ways use SQL statements. So, this way is available in <tt class="docutils literal"><span class="pre">tsql</span></tt>, JDBC, and Tajo Java API.</p> +<p>The following ways use SQL statements. So, this way is available in <code class="docutils literal"><span class="pre">tsql</span></code>, JDBC, and Tajo Java API.</p> <p><strong>SQL</strong></p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">SET</span> <span class="n">TIME</span> <span class="k">ZONE</span> <span class="s1">'GMT+9'</span><span class="p">;</span> @@ -234,20 +234,20 @@ When each table row are read or written, </div> <div class="section" id="examples-of-time-zone"> <h2>Examples of Time Zone<a class="headerlink" href="#examples-of-time-zone" title="Permalink to this headline">¶</a></h2> -<p>For example, consider that there is a list of delimited text lines where each rows are written with <tt class="docutils literal"><span class="pre">Asia/Seoul</span></tt> time zone (i.e., GMT + 9).</p> +<p>For example, consider that there is a list of delimited text lines where each rows are written with <code class="docutils literal"><span class="pre">Asia/Seoul</span></code> time zone (i.e., GMT + 9).</p> <div class="highlight-text"><div class="highlight"><pre>1980-4-1 01:50:30.010|1980-04-01 80/4/1 1:50:30 AM|80/4/1 1980 April 1 1:50:30|1980-04-01 </pre></div> </div> -<p>In order to register the table, we should put a table property <tt class="docutils literal"><span class="pre">'timezone'='Asia/Seoul'</span></tt> in <tt class="docutils literal"><span class="pre">CREATE</span> <span class="pre">TABLE</span></tt> statement as follows:</p> +<p>In order to register the table, we should put a table property <code class="docutils literal"><span class="pre">'timezone'='Asia/Seoul'</span></code> in <code class="docutils literal"><span class="pre">CREATE</span> <span class="pre">TABLE</span></code> statement as follows:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">EXTERNAL</span> <span class="k">TABLE</span> <span class="n">table1</span> <span class="p">(</span> <span class="n">t_timestamp</span> <span class="k">TIMESTAMP</span><span class="p">,</span> <span class="n">t_date</span> <span class="nb">DATE</span> -<span class="p">)</span> <span class="k">USING</span> <span class="n">TEXTFILE</span> <span class="k">WITH</span><span class="p">(</span><span class="s1">'text.delimiter'</span><span class="o">=</span><span class="s1">'|'</span><span class="p">,</span> <span class="s1">'timezone'</span><span class="o">=</span><span class="s1">'ASIA/Seoul'</span><span class="p">)</span> <span class="k">LOCATION</span> <span class="s1">'/path-to-table/'</span> +<span class="p">)</span> <span class="k">USING</span> <span class="nb">TEXT</span> <span class="k">WITH</span><span class="p">(</span><span class="s1">'text.delimiter'</span><span class="o">=</span><span class="s1">'|'</span><span class="p">,</span> <span class="s1">'timezone'</span><span class="o">=</span><span class="s1">'ASIA/Seoul'</span><span class="p">)</span> <span class="k">LOCATION</span> <span class="s1">'/path-to-table/'</span> </pre></div> </div> -<p>By default, <tt class="docutils literal"><span class="pre">tsql</span></tt> and <tt class="docutils literal"><span class="pre">TajoClient</span></tt> API use UTC time zone. So, timestamp values in the result are adjusted by the time zone offset. But, date is not adjusted because date type does not consider time zone.</p> +<p>By default, <code class="docutils literal"><span class="pre">tsql</span></code> and <code class="docutils literal"><span class="pre">TajoClient</span></code> API use UTC time zone. So, timestamp values in the result are adjusted by the time zone offset. But, date is not adjusted because date type does not consider time zone.</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">default</span><span class="o">></span> <span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">table1</span> <span class="n">t_timestamp</span><span class="p">,</span> <span class="n">t_date</span> <span class="c1">----------------------------------</span> Modified: tajo/site/docs/devel/tsql.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql.html?rev=1649478&r1=1649477&r2=1649478&view=diff ============================================================================== --- tajo/site/docs/devel/tsql.html (original) +++ tajo/site/docs/devel/tsql.html Mon Jan 5 08:43:18 2015 @@ -60,11 +60,11 @@ <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="configuration.html">Configuration</a><ul> Modified: tajo/site/docs/devel/tsql/admin_command.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/admin_command.html?rev=1649478&r1=1649477&r2=1649478&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/admin_command.html (original) +++ tajo/site/docs/devel/tsql/admin_command.html Mon Jan 5 08:43:18 2015 @@ -61,11 +61,11 @@ <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="../introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="../getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../configuration.html">Configuration</a><ul> @@ -196,14 +196,14 @@ usage: admin [options] </div> <div class="section" id="basic-usages"> <h3>Basic usages<a class="headerlink" href="#basic-usages" title="Permalink to this headline">¶</a></h3> -<p><tt class="docutils literal"><span class="pre">-list</span></tt> option shows a list of all running queries as follows:</p> +<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 </pre></div> </div> -<p><tt class="docutils literal"><span class="pre">-desc</span></tt> option shows a detailed description of a specified running query as follows:</p> +<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 @@ -215,12 +215,12 @@ Query Statement: select count(*) from lineitem </pre></div> </div> -<p><tt class="docutils literal"><span class="pre">-kill</span></tt> option kills a specified running query as follows:</p> +<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. </pre></div> </div> -<p><tt class="docutils literal"><span class="pre">-showmasters</span></tt> option shows a list of all tajo masters as follows:</p> +<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 </pre></div> Modified: tajo/site/docs/devel/tsql/background_command.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/background_command.html?rev=1649478&r1=1649477&r2=1649478&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/background_command.html (original) +++ tajo/site/docs/devel/tsql/background_command.html Mon Jan 5 08:43:18 2015 @@ -61,11 +61,11 @@ <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="../introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="../getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../configuration.html">Configuration</a><ul> Modified: tajo/site/docs/devel/tsql/dfs_command.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/dfs_command.html?rev=1649478&r1=1649477&r2=1649478&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/dfs_command.html (original) +++ tajo/site/docs/devel/tsql/dfs_command.html Mon Jan 5 08:43:18 2015 @@ -61,11 +61,11 @@ <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="../introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="../getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../configuration.html">Configuration</a><ul> @@ -180,7 +180,7 @@ <div class="section" id="executing-hdfs-commands"> <h1>Executing HDFS commands<a class="headerlink" href="#executing-hdfs-commands" title="Permalink to this headline">¶</a></h1> -<p>You can run the hadoop dfs command (FsShell) within tsql. <tt class="docutils literal"><span class="pre">\dfs</span></tt> command provides a shortcut to the hadoop dfs commands. If you want to use this command, just specify FsShell arguments and add the semicolon at the end as follows:</p> +<p>You can run the hadoop dfs command (FsShell) within tsql. <code class="docutils literal"><span class="pre">\dfs</span></code> command provides a shortcut to the hadoop dfs commands. If you want to use this command, just specify FsShell arguments and add the semicolon at the end as follows:</p> <div class="highlight-sql"><div class="highlight"><pre>default> \dfs -ls / Found 3 items drwxr-xr-x - tajo supergroup 0 2014-08-14 04:04 /tajo Modified: tajo/site/docs/devel/tsql/execute_file.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/execute_file.html?rev=1649478&r1=1649477&r2=1649478&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/execute_file.html (original) +++ tajo/site/docs/devel/tsql/execute_file.html Mon Jan 5 08:43:18 2015 @@ -61,11 +61,11 @@ <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="../introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="../getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../configuration.html">Configuration</a><ul> @@ -182,7 +182,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=1649478&r1=1649477&r2=1649478&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/intro.html (original) +++ tajo/site/docs/devel/tsql/intro.html Mon Jan 5 08:43:18 2015 @@ -61,11 +61,11 @@ <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="../introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="../getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../configuration.html">Configuration</a><ul> @@ -185,16 +185,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=1649478&r1=1649477&r2=1649478&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/meta_command.html (original) +++ tajo/site/docs/devel/tsql/meta_command.html Mon Jan 5 08:43:18 2015 @@ -61,11 +61,11 @@ <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="../introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="../getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../configuration.html">Configuration</a><ul> @@ -216,7 +216,7 @@ Variables Documentations - tsql guide http://tajo.apache.org/docs/current/cli.html + tsql guide http://tajo.apache.org/docs/current/tsql.html Query language http://tajo.apache.org/docs/current/sql_language.html Functions http://tajo.apache.org/docs/current/functions.html Backup & restore http://tajo.apache.org/docs/current/backup_and_restore.html @@ -225,7 +225,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 @@ -233,7 +233,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 @@ -245,7 +245,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 @@ -265,13 +265,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 -----------------+-----------------+-----------------------+-----------------------------------------------+----------- @@ -289,7 +289,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=1649478&r1=1649477&r2=1649478&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/single_command.html (original) +++ tajo/site/docs/devel/tsql/single_command.html Mon Jan 5 08:43:18 2015 @@ -61,11 +61,11 @@ <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="../introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="../getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../configuration.html">Configuration</a><ul> @@ -180,7 +180,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=1649478&r1=1649477&r2=1649478&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/variables.html (original) +++ tajo/site/docs/devel/tsql/variables.html Mon Jan 5 08:43:18 2015 @@ -61,11 +61,11 @@ <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="../introduction.html">Introduction</a></li> <li class="toctree-l1"><a class="reference internal" href="../getting_started.html">Getting Started</a><ul> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/prerequisites.html">Prerequisites</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/downloading_source.html">Dowload and unpack the source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/building.html">Build source code</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/local_setup.html">Setting up a local Tajo cluster</a></li> -<li class="toctree-l2"><a class="reference internal" href="../getting_started/first_query.html">First query execution</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#prerequisites">Prerequisites</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and unpack the source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#build-source-code">Build source code</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li> +<li class="toctree-l2"><a class="reference internal" href="../getting_started.html#first-query-execution">First query execution</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="../configuration.html">Configuration</a><ul> @@ -181,7 +181,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' @@ -189,7 +189,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' @@ -200,41 +200,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>
