Modified: tajo/site/docs/devel/sql_language/joins.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/sql_language/joins.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/sql_language/joins.html (original) +++ tajo/site/docs/devel/sql_language/joins.html Wed Dec 2 09:38:59 2015 @@ -120,7 +120,7 @@ <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> </li>
Modified: tajo/site/docs/devel/sql_language/predicates.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/sql_language/predicates.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/sql_language/predicates.html (original) +++ tajo/site/docs/devel/sql_language/predicates.html Wed Dec 2 09:38:59 2015 @@ -120,7 +120,7 @@ <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/sql_language/queries.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/sql_language/queries.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/sql_language/queries.html (original) +++ tajo/site/docs/devel/sql_language/queries.html Wed Dec 2 09:38:59 2015 @@ -120,7 +120,7 @@ <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/sql_language/sql_expression.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/sql_language/sql_expression.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/sql_language/sql_expression.html (original) +++ tajo/site/docs/devel/sql_language/sql_expression.html Wed Dec 2 09:38:59 2015 @@ -120,7 +120,7 @@ <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/storage_plugins.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/storage_plugins.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/storage_plugins.html (original) +++ tajo/site/docs/devel/storage_plugins.html Wed Dec 2 09:38:59 2015 @@ -119,7 +119,7 @@ <li class="toctree-l1"><a class="reference internal" href="table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/storage_plugins/overview.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/storage_plugins/overview.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/storage_plugins/overview.html (original) +++ tajo/site/docs/devel/storage_plugins/overview.html Wed Dec 2 09:38:59 2015 @@ -120,7 +120,7 @@ <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/storage_plugins/postgresql.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/storage_plugins/postgresql.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/storage_plugins/postgresql.html (original) +++ tajo/site/docs/devel/storage_plugins/postgresql.html Wed Dec 2 09:38:59 2015 @@ -120,7 +120,7 @@ <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/swift_integration.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/swift_integration.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/swift_integration.html (original) +++ tajo/site/docs/devel/swift_integration.html Wed Dec 2 09:38:59 2015 @@ -119,7 +119,7 @@ <li class="toctree-l1"><a class="reference internal" href="table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/table_management.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/table_management.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/table_management.html (original) +++ tajo/site/docs/devel/table_management.html Wed Dec 2 09:38:59 2015 @@ -119,7 +119,7 @@ <li class="toctree-l1 current"><a class="current reference internal" href="">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/compression.html">Compression</a></li> </ul> </li> @@ -211,7 +211,7 @@ <ul> <li class="toctree-l1"><a class="reference internal" href="table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l1"><a class="reference internal" href="table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l1"><a class="reference internal" href="table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l1"><a class="reference internal" href="table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l1"><a class="reference internal" href="table_management/compression.html">Compression</a></li> </ul> </div> Modified: tajo/site/docs/devel/table_management/compression.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/table_management/compression.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/table_management/compression.html (original) +++ tajo/site/docs/devel/table_management/compression.html Wed Dec 2 09:38:59 2015 @@ -120,7 +120,7 @@ <li class="toctree-l1 current"><a class="reference internal" href="../table_management.html">Table Management</a><ul class="current"> <li class="toctree-l2"><a class="reference internal" href="table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="data_formats.html">Data Formats</a></li> <li class="toctree-l2 current"><a class="current reference internal" href="">Compression</a></li> </ul> </li> @@ -209,8 +209,52 @@ <div class="section" id="compression"> <h1>Compression<a class="headerlink" href="#compression" title="Permalink to this headline">¶</a></h1> -<div class="admonition-todo admonition" id="index-0"> -<p class="first last admonition-title">Todo</p> +<p>Using compression can make data size compact, thereby enabling efficient use of network bandwidth and storage. Most of Tajo data formats support data compression feature. +Currently, compression configuration affects only for stored data format and it is specified when a table is created as table meta information(See <a class="reference external" href="../sql_language/ddl.html#create-table">Create Table</a>). +Compression for intermidate data or others is not supported now.</p> +<div class="section" id="compression-properties-for-each-data-format"> +<h2>Compression Properties for each Data Format<a class="headerlink" href="#compression-properties-for-each-data-format" title="Permalink to this headline">¶</a></h2> +<blockquote> +<div><table border="1" class="docutils" id="id3"> +<caption><span class="caption-text">Compression Properties</span><a class="headerlink" href="#id3" title="Permalink to this table">¶</a></caption> +<colgroup> +<col width="33%" /> +<col width="33%" /> +<col width="33%" /> +</colgroup> +<tbody valign="top"> +<tr class="row-odd"><td><strong>Data Format</strong></td> +<td><strong>Property Name</strong></td> +<td><strong>Avaliable Values</strong></td> +</tr> +<tr class="row-even"><td><a class="reference internal" href="text.html"><em>text</em></a>/<a class="reference internal" href="json.html"><em>json</em></a>/<a class="reference internal" href="rcfile.html"><em>rcfile</em></a>/<a class="reference internal" href="sequencefile.html"><em>sequencefile</em></a> <a class="footnote-reference" href="#f1" id="id1">[1]</a></td> +<td>compression.codec</td> +<td>Fully Qualified Classname in Hadoop <a class="footnote-reference" href="#f2" id="id2">[2]</a></td> +</tr> +<tr class="row-odd"><td><a class="reference internal" href="parquet.html"><em>parquet</em></a></td> +<td>parquet.compression</td> +<td>uncompressed/snappy/gzip/lzo</td> +</tr> +<tr class="row-even"><td><a class="reference internal" href="orc.html"><em>orc</em></a></td> +<td>orc.compression.kind</td> +<td>none/snappy/zlib</td> +</tr> +</tbody> +</table> +</div></blockquote> +<p class="rubric">Footnotes</p> +<table class="docutils footnote" frame="void" id="f1" rules="none"> +<colgroup><col class="label" /><col /></colgroup> +<tbody valign="top"> +<tr><td class="label"><a class="fn-backref" href="#id1">[1]</a></td><td>For sequence file, you should specify ‘compression.type’ in addition to ‘compression.codec’. Refer to <a class="reference internal" href="sequencefile.html"><em>SequenceFile</em></a>.</td></tr> +</tbody> +</table> +<table class="docutils footnote" frame="void" id="f2" rules="none"> +<colgroup><col class="label" /><col /></colgroup> +<tbody valign="top"> +<tr><td class="label"><a class="fn-backref" href="#id2">[2]</a></td><td>All classes are available if they implement <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>.</td></tr> +</tbody> +</table> </div> </div> Modified: tajo/site/docs/devel/table_management/json.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/table_management/json.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/table_management/json.html (original) +++ tajo/site/docs/devel/table_management/json.html Wed Dec 2 09:38:59 2015 @@ -29,7 +29,7 @@ <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> - <link rel="up" title="File Formats" href="file_formats.html"/> + <link rel="up" title="Data Formats" href="data_formats.html"/> <link rel="next" title="RCFile" href="rcfile.html"/> <link rel="prev" title="TEXT" href="text.html"/> @@ -120,7 +120,7 @@ <li class="toctree-l1 current"><a class="reference internal" href="../table_management.html">Table Management</a><ul class="current"> <li class="toctree-l2"><a class="reference internal" href="table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2 current"><a class="reference internal" href="file_formats.html">File Formats</a></li> +<li class="toctree-l2 current"><a class="reference internal" href="data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="compression.html">Compression</a></li> </ul> </li> @@ -196,7 +196,7 @@ <li><a href="../table_management.html">Table Management</a> »</li> - <li><a href="file_formats.html">File Formats</a> »</li> + <li><a href="data_formats.html">Data Formats</a> »</li> <li>JSON</li> <li class="wy-breadcrumbs-aside"> Modified: tajo/site/docs/devel/table_management/orc.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/table_management/orc.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/table_management/orc.html (original) +++ tajo/site/docs/devel/table_management/orc.html Wed Dec 2 09:38:59 2015 @@ -29,7 +29,7 @@ <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> - <link rel="up" title="File Formats" href="file_formats.html"/> + <link rel="up" title="Data Formats" href="data_formats.html"/> <link rel="next" title="SequenceFile" href="sequencefile.html"/> <link rel="prev" title="Parquet" href="parquet.html"/> @@ -120,7 +120,7 @@ <li class="toctree-l1 current"><a class="reference internal" href="../table_management.html">Table Management</a><ul class="current"> <li class="toctree-l2"><a class="reference internal" href="table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2 current"><a class="reference internal" href="file_formats.html">File Formats</a></li> +<li class="toctree-l2 current"><a class="reference internal" href="data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="compression.html">Compression</a></li> </ul> </li> @@ -196,7 +196,7 @@ <li><a href="../table_management.html">Table Management</a> »</li> - <li><a href="file_formats.html">File Formats</a> »</li> + <li><a href="data_formats.html">Data Formats</a> »</li> <li>ORC</li> <li class="wy-breadcrumbs-aside"> Modified: tajo/site/docs/devel/table_management/parquet.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/table_management/parquet.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/table_management/parquet.html (original) +++ tajo/site/docs/devel/table_management/parquet.html Wed Dec 2 09:38:59 2015 @@ -29,7 +29,7 @@ <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> - <link rel="up" title="File Formats" href="file_formats.html"/> + <link rel="up" title="Data Formats" href="data_formats.html"/> <link rel="next" title="ORC" href="orc.html"/> <link rel="prev" title="RCFile" href="rcfile.html"/> @@ -120,7 +120,7 @@ <li class="toctree-l1 current"><a class="reference internal" href="../table_management.html">Table Management</a><ul class="current"> <li class="toctree-l2"><a class="reference internal" href="table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2 current"><a class="reference internal" href="file_formats.html">File Formats</a></li> +<li class="toctree-l2 current"><a class="reference internal" href="data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="compression.html">Compression</a></li> </ul> </li> @@ -196,7 +196,7 @@ <li><a href="../table_management.html">Table Management</a> »</li> - <li><a href="file_formats.html">File Formats</a> »</li> + <li><a href="data_formats.html">Data Formats</a> »</li> <li>Parquet</li> <li class="wy-breadcrumbs-aside"> Modified: tajo/site/docs/devel/table_management/rcfile.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/table_management/rcfile.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/table_management/rcfile.html (original) +++ tajo/site/docs/devel/table_management/rcfile.html Wed Dec 2 09:38:59 2015 @@ -29,7 +29,7 @@ <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> - <link rel="up" title="File Formats" href="file_formats.html"/> + <link rel="up" title="Data Formats" href="data_formats.html"/> <link rel="next" title="Parquet" href="parquet.html"/> <link rel="prev" title="JSON" href="json.html"/> @@ -120,7 +120,7 @@ <li class="toctree-l1 current"><a class="reference internal" href="../table_management.html">Table Management</a><ul class="current"> <li class="toctree-l2"><a class="reference internal" href="table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2 current"><a class="reference internal" href="file_formats.html">File Formats</a></li> +<li class="toctree-l2 current"><a class="reference internal" href="data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="compression.html">Compression</a></li> </ul> </li> @@ -196,7 +196,7 @@ <li><a href="../table_management.html">Table Management</a> »</li> - <li><a href="file_formats.html">File Formats</a> »</li> + <li><a href="data_formats.html">Data Formats</a> »</li> <li>RCFile</li> <li class="wy-breadcrumbs-aside"> Modified: tajo/site/docs/devel/table_management/sequencefile.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/table_management/sequencefile.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/table_management/sequencefile.html (original) +++ tajo/site/docs/devel/table_management/sequencefile.html Wed Dec 2 09:38:59 2015 @@ -29,7 +29,7 @@ <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> - <link rel="up" title="File Formats" href="file_formats.html"/> + <link rel="up" title="Data Formats" href="data_formats.html"/> <link rel="next" title="Compression" href="compression.html"/> <link rel="prev" title="ORC" href="orc.html"/> @@ -120,7 +120,7 @@ <li class="toctree-l1 current"><a class="reference internal" href="../table_management.html">Table Management</a><ul class="current"> <li class="toctree-l2"><a class="reference internal" href="table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2 current"><a class="reference internal" href="file_formats.html">File Formats</a></li> +<li class="toctree-l2 current"><a class="reference internal" href="data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="compression.html">Compression</a></li> </ul> </li> @@ -196,7 +196,7 @@ <li><a href="../table_management.html">Table Management</a> »</li> - <li><a href="file_formats.html">File Formats</a> »</li> + <li><a href="data_formats.html">Data Formats</a> »</li> <li>SequenceFile</li> <li class="wy-breadcrumbs-aside"> 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=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/table_management/table_overview.html (original) +++ tajo/site/docs/devel/table_management/table_overview.html Wed Dec 2 09:38:59 2015 @@ -120,7 +120,7 @@ <li class="toctree-l1 current"><a class="reference internal" href="../table_management.html">Table Management</a><ul class="current"> <li class="toctree-l2 current"><a class="current reference internal" href="">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="compression.html">Compression</a></li> </ul> </li> @@ -247,9 +247,8 @@ <li>Openstack Swift - <code class="docutils literal"><span class="pre">swift://bucket-name/table1</span></code></li> </ul> </div></blockquote> -</div> <div class="section" id="table-properties"> -<h2>Table Properties<a class="headerlink" href="#table-properties" title="Permalink to this headline">¶</a></h2> +<h3>Table Properties<a class="headerlink" href="#table-properties" title="Permalink to this headline">¶</a></h3> <p>All table formats provide parameters for enabling or disabling features and adjusting physical parameters. 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> @@ -263,19 +262,17 @@ The <code class="docutils literal"><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> </div> -<p>Each physical table layout has its own specialized properties. They will be addressed in <a class="reference internal" href="file_formats.html"><em>File Formats</em></a>.</p> +<p>Each physical table layout has its own specialized properties. They will be addressed in <a class="reference internal" href="data_formats.html"><em>Data Formats</em></a>.</p> </div> <div class="section" id="common-table-properties"> -<h2>Common Table Properties<a class="headerlink" href="#common-table-properties" title="Permalink to this headline">¶</a></h2> +<h3>Common Table Properties<a class="headerlink" href="#common-table-properties" title="Permalink to this headline">¶</a></h3> <p>There are some common table properties which are used in most tables.</p> <div class="section" id="compression"> -<h3>Compression<a class="headerlink" href="#compression" title="Permalink to this headline">¶</a></h3> -<div class="admonition-todo admonition" id="index-0"> -<p class="first last admonition-title">Todo</p> -</div> +<h4>Compression<a class="headerlink" href="#compression" title="Permalink to this headline">¶</a></h4> +<p>See <a class="reference internal" href="compression.html"><em>Compression</em></a>.</p> </div> <div class="section" id="time-zone"> -<h3>Time zone<a class="headerlink" href="#time-zone" title="Permalink to this headline">¶</a></h3> +<h4>Time zone<a class="headerlink" href="#time-zone" title="Permalink to this headline">¶</a></h4> <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> @@ -288,6 +285,7 @@ The <code class="docutils literal"><span </div> </div> </div> +</div> </div> Modified: tajo/site/docs/devel/table_management/tablespaces.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/table_management/tablespaces.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/table_management/tablespaces.html (original) +++ tajo/site/docs/devel/table_management/tablespaces.html Wed Dec 2 09:38:59 2015 @@ -30,7 +30,7 @@ <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> <link rel="up" title="Table Management" href="../table_management.html"/> - <link rel="next" title="File Formats" href="file_formats.html"/> + <link rel="next" title="Data Formats" href="data_formats.html"/> <link rel="prev" title="Overview of Tajo Tables" href="table_overview.html"/> @@ -120,7 +120,7 @@ <li class="toctree-l1 current"><a class="reference internal" href="../table_management.html">Table Management</a><ul class="current"> <li class="toctree-l2"><a class="reference internal" href="table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2 current"><a class="current reference internal" href="">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="compression.html">Compression</a></li> </ul> </li> @@ -209,7 +209,22 @@ <div class="section" id="tablespaces"> <h1>Tablespaces<a class="headerlink" href="#tablespaces" title="Permalink to this headline">¶</a></h1> -<p>Tablespaces in Tajo allow users to define locations in the storage system where the files or data objects representing database objects can be stored. Once defined, a tablespace can be referred to by name when creating a database or a table. Especially, it is very useful when a Tajo cluster instance should use heterogeneous storage systems such as HDFS, MySQL, and Oracle.</p> +<p>Tablespaces in Tajo allow users to define locations in the storage system where the files or data objects representing database objects can be stored. +Once defined, a tablespace can be referred to by name when creating a database or a table. +Especially, it is very useful when a Tajo cluster instance should use heterogeneous storage systems such as HDFS, MySQL, and Oracle.</p> +<div class="section" id="external-table-managed-table-and-tablespace"> +<h2>External Table, Managed Table and Tablespace<a class="headerlink" href="#external-table-managed-table-and-tablespace" title="Permalink to this headline">¶</a></h2> +<p>Tajo has two types of table. One is external table. It needs <strong>location</strong> property when the table is created. Using this property, you can create an external table indicating existing external data source. +For example, if there is already your data as Text/JSON files or HBase table, you can register it as tajo external table. +Other one is managed table, which means internal table, that is created in a speficied tablespace.</p> +<p>Tablespace is a pre-defined physical location where data stored on. It is supported for only managed tables. +When you create a managed table, you can use the <strong>tablespace</strong> keyword to specify the location of data will be stored. +If the tablespace is not specified, the default tablespace of the table’s database is used.</p> +<div class="admonition note"> +<p class="first admonition-title">Note</p> +<p class="last">For creating a table, see <a class="reference internal" href="../sql_language/ddl.html"><em>Data Definition Language</em></a>.</p> +</div> +</div> <div class="section" id="configuration"> <h2>Configuration<a class="headerlink" href="#configuration" title="Permalink to this headline">¶</a></h2> <p>By default, Tajo use in <code class="docutils literal"><span class="pre">${tajo.rootdir}/warehouse</span></code> in <code class="docutils literal"><span class="pre">conf/tajo-site.xml</span></code> as a default tablespace. It also allows users to register additional tablespaces.</p> @@ -251,7 +266,7 @@ <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation"> - <a href="file_formats.html" class="btn btn-neutral float-right" title="File Formats"/>Next <span class="fa fa-arrow-circle-right"></span></a> + <a href="data_formats.html" class="btn btn-neutral float-right" title="Data Formats"/>Next <span class="fa fa-arrow-circle-right"></span></a> <a href="table_overview.html" class="btn btn-neutral" title="Overview of Tajo Tables"><span class="fa fa-arrow-circle-left"></span> Previous</a> Modified: tajo/site/docs/devel/table_management/text.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/table_management/text.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/table_management/text.html (original) +++ tajo/site/docs/devel/table_management/text.html Wed Dec 2 09:38:59 2015 @@ -29,9 +29,9 @@ <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/> - <link rel="up" title="File Formats" href="file_formats.html"/> + <link rel="up" title="Data Formats" href="data_formats.html"/> <link rel="next" title="JSON" href="json.html"/> - <link rel="prev" title="File Formats" href="file_formats.html"/> + <link rel="prev" title="Data Formats" href="data_formats.html"/> <script src="https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js";></script> @@ -120,7 +120,7 @@ <li class="toctree-l1 current"><a class="reference internal" href="../table_management.html">Table Management</a><ul class="current"> <li class="toctree-l2"><a class="reference internal" href="table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2 current"><a class="reference internal" href="file_formats.html">File Formats</a></li> +<li class="toctree-l2 current"><a class="reference internal" href="data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="compression.html">Compression</a></li> </ul> </li> @@ -196,7 +196,7 @@ <li><a href="../table_management.html">Table Management</a> »</li> - <li><a href="file_formats.html">File Formats</a> »</li> + <li><a href="data_formats.html">Data Formats</a> »</li> <li>TEXT</li> <li class="wy-breadcrumbs-aside"> @@ -317,7 +317,7 @@ clause in a Hive’s <code class="do <a href="json.html" class="btn btn-neutral float-right" title="JSON"/>Next <span class="fa fa-arrow-circle-right"></span></a> - <a href="file_formats.html" class="btn btn-neutral" title="File Formats"><span class="fa fa-arrow-circle-left"></span> Previous</a> + <a href="data_formats.html" class="btn btn-neutral" title="Data Formats"><span class="fa fa-arrow-circle-left"></span> Previous</a> </div> Modified: tajo/site/docs/devel/table_partitioning.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/table_partitioning.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/table_partitioning.html (original) +++ tajo/site/docs/devel/table_partitioning.html Wed Dec 2 09:38:59 2015 @@ -119,7 +119,7 @@ <li class="toctree-l1"><a class="reference internal" href="table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/tajo_client_api.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tajo_client_api.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/tajo_client_api.html (original) +++ tajo/site/docs/devel/tajo_client_api.html Wed Dec 2 09:38:59 2015 @@ -119,7 +119,7 @@ <li class="toctree-l1"><a class="reference internal" href="table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/time_zone.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/time_zone.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/time_zone.html (original) +++ tajo/site/docs/devel/time_zone.html Wed Dec 2 09:38:59 2015 @@ -119,7 +119,7 @@ <li class="toctree-l1"><a class="reference internal" href="table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/tsql.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/tsql.html (original) +++ tajo/site/docs/devel/tsql.html Wed Dec 2 09:38:59 2015 @@ -119,7 +119,7 @@ <li class="toctree-l1"><a class="reference internal" href="table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/tsql/admin_command.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/admin_command.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/admin_command.html (original) +++ tajo/site/docs/devel/tsql/admin_command.html Wed Dec 2 09:38:59 2015 @@ -120,7 +120,7 @@ <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/tsql/background_command.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/background_command.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/background_command.html (original) +++ tajo/site/docs/devel/tsql/background_command.html Wed Dec 2 09:38:59 2015 @@ -120,7 +120,7 @@ <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/tsql/dfs_command.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/dfs_command.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/dfs_command.html (original) +++ tajo/site/docs/devel/tsql/dfs_command.html Wed Dec 2 09:38:59 2015 @@ -120,7 +120,7 @@ <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/tsql/execute_file.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/execute_file.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/execute_file.html (original) +++ tajo/site/docs/devel/tsql/execute_file.html Wed Dec 2 09:38:59 2015 @@ -120,7 +120,7 @@ <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/tsql/intro.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/intro.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/intro.html (original) +++ tajo/site/docs/devel/tsql/intro.html Wed Dec 2 09:38:59 2015 @@ -120,7 +120,7 @@ <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/tsql/meta_command.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/meta_command.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/meta_command.html (original) +++ tajo/site/docs/devel/tsql/meta_command.html Wed Dec 2 09:38:59 2015 @@ -120,7 +120,7 @@ <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/tsql/single_command.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/single_command.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/single_command.html (original) +++ tajo/site/docs/devel/tsql/single_command.html Wed Dec 2 09:38:59 2015 @@ -120,7 +120,7 @@ <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> </li> Modified: tajo/site/docs/devel/tsql/variables.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/variables.html?rev=1717597&r1=1717596&r2=1717597&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/variables.html (original) +++ tajo/site/docs/devel/tsql/variables.html Wed Dec 2 09:38:59 2015 @@ -120,7 +120,7 @@ <li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul> <li class="toctree-l2"><a class="reference internal" href="../table_management/table_overview.html">Overview of Tajo Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/tablespaces.html">Tablespaces</a></li> -<li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li> +<li class="toctree-l2"><a class="reference internal" href="../table_management/data_formats.html">Data Formats</a></li> <li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li> </ul> </li> @@ -209,7 +209,9 @@ <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>Once a tajo client connects to the Tajo master, it assigns a unique session. This session is kept until the client is disconnected or it is expired.</p> +<p>For the sake of more convenient user configuration, Tajo provides <cite>session variables</cite>. +With session variables, different configurations are allowed for each session.</p> <p><code class="docutils literal"><span class="pre">tsql</span></code> provides the meta command <code class="docutils literal"><span class="pre">\set</span></code> to manipulate session variables. Just <code class="docutils literal"><span class="pre">\set</span></code> command shows all session variables.</p> <div class="highlight-python"><div class="highlight"><pre>default> \set 'name1'='val1' @@ -230,37 +232,614 @@ default> \set </pre></div> </div> <p>Also, <code class="docutils literal"><span class="pre">\unset</span> <span class="pre">key</span></code> will unset the session variable named <em>key</em>.</p> -<p>Now, tajo provides the following session variables.</p> -<ul class="simple"> -<li><code class="docutils literal"><span class="pre">DIST_QUERY_BROADCAST_JOIN_THRESHOLD</span></code></li> -<li><code class="docutils literal"><span class="pre">DIST_QUERY_JOIN_TASK_VOLUME</span></code></li> -<li><code class="docutils literal"><span class="pre">DIST_QUERY_SORT_TASK_VOLUME</span></code></li> -<li><code class="docutils literal"><span class="pre">DIST_QUERY_GROUPBY_TASK_VOLUME</span></code></li> -<li><code class="docutils literal"><span class="pre">DIST_QUERY_JOIN_PARTITION_VOLUME</span></code></li> -<li><code class="docutils literal"><span class="pre">DIST_QUERY_GROUPBY_PARTITION_VOLUME</span></code></li> -<li><code class="docutils literal"><span class="pre">DIST_QUERY_TABLE_PARTITION_VOLUME</span></code></li> -<li><code class="docutils literal"><span class="pre">EXECUTOR_EXTERNAL_SORT_BUFFER_SIZE</span></code></li> -<li><code class="docutils literal"><span class="pre">EXECUTOR_HASH_JOIN_SIZE_THRESHOLD</span></code></li> -<li><code class="docutils literal"><span class="pre">EXECUTOR_INNER_HASH_JOIN_SIZE_THRESHOLD</span></code></li> -<li><code class="docutils literal"><span class="pre">EXECUTOR_OUTER_HASH_JOIN_SIZE_THRESHOLD</span></code></li> -<li><code class="docutils literal"><span class="pre">EXECUTOR_GROUPBY_INMEMORY_HASH_THRESHOLD</span></code></li> -<li><code class="docutils literal"><span class="pre">MAX_OUTPUT_FILE_SIZE</span></code></li> -<li><code class="docutils literal"><span class="pre">CODEGEN</span></code></li> -<li><code class="docutils literal"><span class="pre">CLIENT_SESSION_EXPIRY_TIME</span></code></li> -<li><code class="docutils literal"><span class="pre">CLI_MAX_COLUMN</span></code></li> -<li><code class="docutils literal"><span class="pre">CLI_NULL_CHAR</span></code></li> -<li><code class="docutils literal"><span class="pre">CLI_PRINT_PAUSE_NUM_RECORDS</span></code></li> -<li><code class="docutils literal"><span class="pre">CLI_PRINT_PAUSE</span></code></li> -<li><code class="docutils literal"><span class="pre">CLI_PRINT_ERROR_TRACE</span></code></li> -<li><code class="docutils literal"><span class="pre">CLI_OUTPUT_FORMATTER_CLASS</span></code></li> -<li><code class="docutils literal"><span class="pre">CLI_ERROR_STOP</span></code></li> -<li><code class="docutils literal"><span class="pre">TIMEZONE</span></code></li> -<li><code class="docutils literal"><span class="pre">DATE_ORDER</span></code></li> -<li><code class="docutils literal"><span class="pre">TEXT_NULL</span></code></li> -<li><code class="docutils literal"><span class="pre">DEBUG_ENABLED</span></code></li> -<li><code class="docutils literal"><span class="pre">BEHAVIOR_ARITHMETIC_ABORT</span></code></li> -<li><code class="docutils literal"><span class="pre">RESULT_SET_FETCH_ROWNUM</span></code></li> +<p>Currently, tajo provides the following session variables.</p> +<dl class="describe"> +<dt> +<code class="descname">BROADCAST_NON_CROSS_JOIN_THRESHOLD</code></dt> +<dd></dd></dl> + +<p>A threshold for non-cross joins. When a non-cross join query is executed with the broadcast join, the whole size of broadcasted tables won’t exceed this threshold.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-broadcast-non-cross-join-threshold-kb"><span>tajo.dist-query.broadcast.non-cross-join.threshold-kb</span></a></li> +<li>Property value: Integer</li> +<li>Unit: KB</li> +<li>Default value: 5120</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et BROADCAST_NON_CROSS_JOIN_THRESHOLD 5120 +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">BROADCAST_CROSS_JOIN_THRESHOLD</code></dt> +<dd></dd></dl> + +<p>A threshold for cross joins. When a cross join query is executed, the whole size of broadcasted tables won’t exceed this threshold.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-broadcast-cross-join-threshold-kb"><span>tajo.dist-query.broadcast.cross-join.threshold-kb</span></a></li> +<li>Property value: Integer</li> +<li>Unit: KB</li> +<li>Default value: 1024</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et BROADCAST_CROSS_JOIN_THRESHOLD 1024 +</pre></div> +</div> +<div class="admonition warning"> +<p class="first admonition-title">Warning</p> +<p class="last">In Tajo, the broadcast join is only the way to perform cross joins. Since the cross join is a very expensive operation, this value need to be tuned carefully.</p> +</div> +<dl class="describe"> +<dt> +<code class="descname">JOIN_TASK_INPUT_SIZE</code></dt> +<dd></dd></dl> + +<p>The repartition join is executed in two stages. When a join query is executed with the repartition join, this value indicates the amount of input data processed by each task at the second stage. +As a result, it determines the degree of the parallel processing of the join query.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-join-task-volume-mb"><span>tajo.dist-query.join.task-volume-mb</span></a></li> +<li>Property value: Integer</li> +<li>Unit: MB</li> +<li>Default value: 64</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et JOIN_TASK_INPUT_SIZE 64 +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">JOIN_PER_SHUFFLE_SIZE</code></dt> +<dd></dd></dl> + +<p>The repartition join is executed in two stages. When a join query is executed with the repartition join, +this value indicates the output size of each task at the first stage, which determines the number of partitions to be shuffled between two stages.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-join-partition-volume-mb"><span>tajo.dist-query.join.partition-volume-mb</span></a></li> +<li>Property value: Integer</li> +<li>Unit: MB</li> +<li>Default value: 128</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et JOIN_PER_SHUFFLE_SIZE 128 +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">HASH_JOIN_SIZE_LIMIT</code></dt> +<dd></dd></dl> + +<p>This value provides the criterion to decide the algorithm to perform a join in a task. +If the input data is smaller than this value, join is performed with the in-memory hash join. +Otherwise, the sort-merge join is used.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-common-in-memory-hash-threshold-mb"><span>tajo.executor.join.common.in-memory-hash-threshold-mb</span></a></li> +<li>Property value: Integer</li> +<li>Unit: MB</li> +<li>Default value: 64</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et HASH_JOIN_SIZE_LIMIT 64 +</pre></div> +</div> +<div class="admonition warning"> +<p class="first admonition-title">Warning</p> +<p class="last">This value is the size of the input stored on file systems. So, when the input data is loaded into JVM heap, +its actual size is usually much larger than the configured value, which means that too large threshold can cause unexpected OutOfMemory errors. +This value should be tuned carefully.</p> +</div> +<dl class="describe"> +<dt> +<code class="descname">INNER_HASH_JOIN_SIZE_LIMIT</code></dt> +<dd></dd></dl> + +<p>This value provides the criterion to decide the algorithm to perform an inner join in a task. +If the input data is smaller than this value, the inner join is performed with the in-memory hash join. +Otherwise, the sort-merge join is used.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-inner-in-memory-hash-threshold-mb"><span>tajo.executor.join.inner.in-memory-hash-threshold-mb</span></a></li> +<li>Property value: Integer</li> +<li>Unit: MB</li> +<li>Default value: 64</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et INNER_HASH_JOIN_SIZE_LIMIT 64 +</pre></div> +</div> +<div class="admonition warning"> +<p class="first admonition-title">Warning</p> +<p class="last">This value is the size of the input stored on file systems. So, when the input data is loaded into JVM heap, +its actual size is usually much larger than the configured value, which means that too large threshold can cause unexpected OutOfMemory errors. +This value should be tuned carefully.</p> +</div> +<dl class="describe"> +<dt> +<code class="descname">OUTER_HASH_JOIN_SIZE_LIMIT</code></dt> +<dd></dd></dl> + +<p>This value provides the criterion to decide the algorithm to perform an outer join in a task. +If the input data is smaller than this value, the outer join is performed with the in-memory hash join. +Otherwise, the sort-merge join is used.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-outer-in-memory-hash-threshold-mb"><span>tajo.executor.join.outer.in-memory-hash-threshold-mb</span></a></li> +<li>Property value: Integer</li> +<li>Unit: MB</li> +<li>Default value: 64</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et OUTER_HASH_JOIN_SIZE_LIMIT 64 +</pre></div> +</div> +<div class="admonition warning"> +<p class="first admonition-title">Warning</p> +<p class="last">This value is the size of the input stored on file systems. So, when the input data is loaded into JVM heap, +its actual size is usually much larger than the configured value, which means that too large threshold can cause unexpected OutOfMemory errors. +This value should be tuned carefully.</p> +</div> +<dl class="describe"> +<dt> +<code class="descname">JOIN_HASH_TABLE_SIZE</code></dt> +<dd></dd></dl> + +<p>The initial size of hash table for in-memory hash join.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-join-hash-table-size"><span>tajo.executor.join.hash-table.size</span></a></li> +<li>Property value: Integer</li> +<li>Default value: 100000</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et JOIN_HASH_TABLE_SIZE 100000 +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">SORT_TASK_INPUT_SIZE</code></dt> +<dd></dd></dl> + +<p>The sort operation is executed in two stages. When a sort query is executed, this value indicates the amount of input data processed by each task at the second stage. +As a result, it determines the degree of the parallel processing of the sort query.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-sort-task-volume-mb"><span>tajo.dist-query.sort.task-volume-mb</span></a></li> +<li>Property value: Integer</li> +<li>Unit: MB</li> +<li>Default value: 64</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et SORT_TASK_INPUT_SIZE 64 +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">EXTSORT_BUFFER_SIZE</code></dt> +<dd></dd></dl> + +<p>A threshold to choose the sort algorithm. If the input data is larger than this threshold, the external sort algorithm is used.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-external-sort-buffer-mb"><span>tajo.executor.external-sort.buffer-mb</span></a></li> +<li>Property value: Integer</li> +<li>Unit: MB</li> +<li>Default value: 200</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et EXTSORT_BUFFER_SIZE 200 +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">SORT_LIST_SIZE</code></dt> +<dd></dd></dl> + +<p>The initial size of list for in-memory sort.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-sort-list-size"><span>tajo.executor.sort.list.size</span></a></li> +<li>Property value: Integer</li> +<li>Default value: 100000</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et SORT_LIST_SIZE 100000 +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">GROUPBY_MULTI_LEVEL_ENABLED</code></dt> +<dd></dd></dl> + +<p>A flag to enable the multi-level algorithm for distinct aggregation. If this value is set, 3-phase aggregation algorithm is used. +Otherwise, 2-phase aggregation algorithm is used.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-groupby-multi-level-aggr"><span>tajo.dist-query.groupby.multi-level-aggr</span></a></li> +<li>Property value: Boolean</li> +<li>Default value: true</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et GROUPBY_MULTI_LEVEL_ENABLED <span class="nb">true</span> +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">GROUPBY_PER_SHUFFLE_SIZE</code></dt> +<dd></dd></dl> + +<p>The aggregation is executed in two stages. When an aggregation query is executed, +this value indicates the output size of each task at the first stage, which determines the number of partitions to be shuffled between two stages.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-groupby-partition-volume-mb"><span>tajo.dist-query.groupby.partition-volume-mb</span></a></li> +<li>Property value: Integer</li> +<li>Unit: MB</li> +<li>Default value: 256</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et GROUPBY_PER_SHUFFLE_SIZE 256 +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">GROUPBY_TASK_INPUT_SIZE</code></dt> +<dd></dd></dl> + +<p>The aggregation operation is executed in two stages. When an aggregation query is executed, this value indicates the amount of input data processed by each task at the second stage. +As a result, it determines the degree of the parallel processing of the aggregation query.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-groupby-task-volume-mb"><span>tajo.dist-query.groupby.task-volume-mb</span></a></li> +<li>Property value: Integer</li> +<li>Unit: MB</li> +<li>Default value: 64</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et GROUPBY_TASK_INPUT_SIZE 64 +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">HASH_GROUPBY_SIZE_LIMIT</code></dt> +<dd></dd></dl> + +<p>This value provides the criterion to decide the algorithm to perform an aggregation in a task. +If the input data is smaller than this value, the aggregation is performed with the in-memory hash aggregation. +Otherwise, the sort-based aggregation is used.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-groupby-in-memory-hash-threshold-mb"><span>tajo.executor.groupby.in-memory-hash-threshold-mb</span></a></li> +<li>Property value: Integer</li> +<li>Unit: MB</li> +<li>Default value: 64</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et HASH_GROUPBY_SIZE_LIMIT 64 +</pre></div> +</div> +<div class="admonition warning"> +<p class="first admonition-title">Warning</p> +<p class="last">This value is the size of the input stored on file systems. So, when the input data is loaded into JVM heap, +its actual size is usually much larger than the configured value, which means that too large threshold can cause unexpected OutOfMemory errors. +This value should be tuned carefully.</p> +</div> +<dl class="describe"> +<dt> +<code class="descname">AGG_HASH_TABLE_SIZE</code></dt> +<dd></dd></dl> + +<p>The initial size of hash table for in-memory aggregation.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-executor-aggregate-hash-table-size"><span>tajo.executor.aggregate.hash-table.size</span></a></li> +<li>Property value: Integer</li> +<li>Default value: 10000</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et AGG_HASH_TABLE_SIZE 10000 +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">TIMEZONE</code></dt> +<dd></dd></dl> + +<p>Refer to <a class="reference internal" href="../time_zone.html"><em>Time Zone</em></a>.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-timezone"><span>tajo.timezone</span></a></li> +<li>Property value: Time zone id</li> +<li>Default value: Default time zone of JVM</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et TIMEZONE GMT+9 +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">DATE_ORDER</code></dt> +<dd></dd></dl> + +<p>Date order specification.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-datetime-date-order"><span>tajo.datetime.date-order</span></a></li> +<li>Property value: One of YMD, DMY, MDY.</li> +<li>Default value: YMD</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et DATE_ORDER YMD +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">PARTITION_NO_RESULT_OVERWRITE_ENABLED</code></dt> +<dd></dd></dl> + +<p>If this value is true, a partitioned table is overwritten even if a subquery leads to no result. Otherwise, the table data will be kept if there is no result.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-partition-overwrite-even-if-no-result"><span>tajo.partition.overwrite.even-if-no-result</span></a></li> +<li>Property value: Boolean</li> +<li>Default value: false</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et PARTITION_NO_RESULT_OVERWRITE_ENABLED <span class="nb">false</span> +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">TABLE_PARTITION_PER_SHUFFLE_SIZE</code></dt> +<dd></dd></dl> + +<p>In Tajo, storing a partition table is executed in two stages. +This value indicates the output size of a task of the former stage, which determines the number of partitions to be shuffled between two stages.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-dist-query-table-partition-task-volume-mb"><span>tajo.dist-query.table-partition.task-volume-mb</span></a></li> +<li>Property value: Integer</li> +<li>Unit: MB</li> +<li>Default value: 256</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et TABLE_PARTITION_PER_SHUFFLE_SIZE 256 +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">ARITHABORT</code></dt> +<dd></dd></dl> + +<p>A flag to indicate how to handle the errors caused by invalid arithmetic operations. If true, a running query will be terminated with an overflow or a divide-by-zero.</p> +<blockquote> +<div><ul class="simple"> +<li>Configuration name: <a class="reference internal" href="../configuration/tajo-site-xml.html#tajo-behavior-arithmetic-abort"><span>tajo.behavior.arithmetic-abort</span></a></li> +<li>Property value: Boolean</li> +<li>Default value: false</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et ARITHABORT <span class="nb">false</span> +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">MAX_OUTPUT_FILE_SIZE</code></dt> +<dd></dd></dl> + +<p>Maximum per-output file size. 0 means infinite.</p> +<blockquote> +<div><ul class="simple"> +<li>Property value: Integer</li> +<li>Unit: MB</li> +<li>Default value: 0</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et MAX_OUTPUT_FILE_SIZE 0 +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">SESSION_EXPIRY_TIME</code></dt> +<dd></dd></dl> + +<p>Session expiry time.</p> +<blockquote> +<div><ul class="simple"> +<li>Property value: Integer</li> +<li>Unit: seconds</li> +<li>Default value: 3600</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et SESSION_EXPIRY_TIME 3600 +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">CLI_COLUMNS</code></dt> +<dd></dd></dl> + +<p>Sets the width for the wrapped format.</p> +<blockquote> +<div><ul class="simple"> +<li>Property value: Integer</li> +<li>Default value: 120</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et CLI_COLUMNS 120 +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">CLI_NULL_CHAR</code></dt> +<dd></dd></dl> + +<p>Sets the string to be printed in place of a null value.</p> +<blockquote> +<div><ul class="simple"> +<li>Property value: String</li> +<li>Default value: ‘’</li> +<li>Example</li> </ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et CLI_NULL_CHAR <span class="s1">''</span> +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">CLI_PAGE_ROWS</code></dt> +<dd></dd></dl> + +<p>Sets the number of rows for paging.</p> +<blockquote> +<div><ul class="simple"> +<li>Property value: Integer</li> +<li>Default value: 100</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et CLI_PAGE_ROWS 100 +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">CLI_PAGING_ENABLED</code></dt> +<dd></dd></dl> + +<p>Enable paging of result display.</p> +<blockquote> +<div><ul class="simple"> +<li>Property value: Boolean</li> +<li>Default value: true</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et CLI_PAGING_ENABLED <span class="nb">true</span> +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">CLI_DISPLAY_ERROR_TRACE</code></dt> +<dd></dd></dl> + +<p>Enable display of error trace.</p> +<blockquote> +<div><ul class="simple"> +<li>Property value: Boolean</li> +<li>Default value: true</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et CLI_DISPLAY_ERROR_TRACE <span class="nb">true</span> +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">CLI_FORMATTER_CLASS</code></dt> +<dd></dd></dl> + +<p>Sets the output format class to display results.</p> +<blockquote> +<div><ul class="simple"> +<li>Property value: Class name</li> +<li>Default value: org.apache.tajo.cli.tsql.DefaultTajoCliOutputFormatter</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et CLI_FORMATTER_CLASS org.apache.tajo.cli.tsql.DefaultTajoCliOutputFormatter +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">ON_ERROR_STOP</code></dt> +<dd></dd></dl> + +<p>tsql will exit if an error occurs.</p> +<blockquote> +<div><ul class="simple"> +<li>Property value: Boolean</li> +<li>Default value: false</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et ON_ERROR_STOP <span class="nb">false</span> +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">NULL_CHAR</code></dt> +<dd></dd></dl> + +<p>Null char of text file output. This value is used when the table property <cite>text.null</cite> is not specified.</p> +<blockquote> +<div><ul class="simple"> +<li>Property value: String</li> +<li>Default value: ‘\N’</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et NULL_CHAR <span class="s1">'\\N'</span> +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">DEBUG_ENABLED</code></dt> +<dd></dd></dl> + +<p>A flag to enable debug mode.</p> +<blockquote> +<div><ul class="simple"> +<li>Property value: Boolean</li> +<li>Default value: false</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et DEBUG_ENABLED <span class="nb">false</span> +</pre></div> +</div> +<dl class="describe"> +<dt> +<code class="descname">FETCH_ROWNUM</code></dt> +<dd></dd></dl> + +<p>The number of rows to be fetched from Master each time.</p> +<blockquote> +<div><ul class="simple"> +<li>Property value: Integer</li> +<li>Default value: 200</li> +<li>Example</li> +</ul> +</div></blockquote> +<div class="highlight-sh"><div class="highlight"><pre><span class="se">\s</span>et FETCH_ROWNUM 200 +</pre></div> +</div> </div>
