Author: hyunsik
Date: Mon Nov 10 06:57:43 2014
New Revision: 1637798
URL: http://svn.apache.org/r1637798
Log:
Update by TAJO-1157
Modified:
tajo/site/docs/0.9.0/getting_started/prerequisites.html
tajo/site/docs/current/_sources/cli.txt
tajo/site/docs/current/_sources/getting_started/first_query.txt
tajo/site/docs/current/_sources/getting_started/prerequisites.txt
tajo/site/docs/current/_sources/sql_language/ddl.txt
tajo/site/docs/current/_sources/table_management/csv.txt
tajo/site/docs/current/_sources/tsql/variables.txt
tajo/site/docs/current/cli.html
tajo/site/docs/current/getting_started/first_query.html
tajo/site/docs/current/getting_started/prerequisites.html
tajo/site/docs/current/objects.inv
tajo/site/docs/current/searchindex.js
tajo/site/docs/current/sql_language/ddl.html
tajo/site/docs/current/table_management/csv.html
tajo/site/docs/current/tsql/variables.html
Modified: tajo/site/docs/0.9.0/getting_started/prerequisites.html
URL:
http://svn.apache.org/viewvc/tajo/site/docs/0.9.0/getting_started/prerequisites.html?rev=1637798&r1=1637797&r2=1637798&view=diff
==============================================================================
--- tajo/site/docs/0.9.0/getting_started/prerequisites.html (original)
+++ tajo/site/docs/0.9.0/getting_started/prerequisites.html Mon Nov 10 06:57:43
2014
@@ -171,8 +171,8 @@
<h1>Prerequisites<a class="headerlink" href="#prerequisites" title="Permalink
to this headline">¶</a></h1>
<blockquote>
<div><ul class="simple">
-<li>Hadoop 2.2.0, 2.3.0, or 2.4.0</li>
-<li>Java 1.6 or higher</li>
+<li>Hadoop 2.2.0 or higher (up to 2.5.1)</li>
+<li>Java 1.6 or 1.7</li>
<li>Protocol buffer 2.5.0</li>
</ul>
</div></blockquote>
@@ -243,4 +243,4 @@
</body>
-</html>
\ No newline at end of file
+</html>
Modified: tajo/site/docs/current/_sources/cli.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/cli.txt?rev=1637798&r1=1637797&r2=1637798&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/cli.txt (original)
+++ tajo/site/docs/current/_sources/cli.txt Mon Nov 10 06:57:43 2014
@@ -1,159 +1,18 @@
*****************************
-Tajo Shell (TSQL)
+Command-line Interface
*****************************
-==========
-Synopsis
-==========
+Tajo provides a shell utility for users. It is the command-line interface
(CLI). Using the CLI, users can create or drop tables, inspect schema and query
tables, etc. For reference, we named its name to tsql.
-.. code-block:: bash
+.. toctree::
+ :maxdepth: 1
- bin/tsql [options] [database name]
+ tsql/intro
+ tsql/single_command
+ tsql/execute_file
+ tsql/back_command
+ tsql/meta_command
+ tsql/dfs_command
+ tsql/variables
+ tsql/admin_command
-If a *database_name* is given, tsql connects to the database at startup time.
Otherwise, tsql connects to ``default`` database.
-
-Options
-
-* ``-c "quoted sql"`` : Execute quoted sql statements, and then the shell will
exist.
-* ``-f filename (--file filename)`` : Use the file named filename as the
source of commands instead of interactive shell.
-* ``-h hostname (--host hostname)`` : Specifies the host name of the machine
on which the Tajo master is running.
-* ``-p port (--port port)`` : Specifies the TCP port. If it is not set, the
port will be 26002 in default.
-
-===================
-Entering tsql shell
-===================
-
-If the hostname and the port num are not given, tsql will try to connect the
Tajo master specified in ${TAJO_HOME}/conf/tajo-site.xml. ::
-
- bin/tsql
-
- default>
-
-If you want to connect a specified TajoMaster, you should use '-h' and (or)
'p' options as follows: ::
-
- bin/tsql -h localhost -p 9004
-
- default>
-
-The prompt indicates the current database.
-
-===================
- Meta Commands
-===================
-
-In tsql, anything command that begins with an unquoted backslash ('\') is a
tsql meta-command that is processed by tsql itself.
-
-In the current implementation, there are meta commands as follows: ::
-
- default> \?
-
- General
- \copyright show Apache License 2.0
- \version show Tajo version
- \? show help
- \q quit tsql
-
-
- Informational
- \l list databases
- \c show current database
- \c [DBNAME] connect to new database
- \d list tables
- \d [TBNAME] describe table
- \df list functions
- \df NAME describe function
-
-
- Variables
- \set [[NAME] [VALUE] set session variable or list session variables
- \unset NAME unset session variable
-
-
- Documentations
- tsql guide http://tajo.apache.org/docs/0.8.0/cli.html
- Query language http://tajo.apache.org/docs/0.8.0/sql_language.html
- Functions http://tajo.apache.org/docs/0.8.0/functions.html
- Backup & restore http://tajo.apache.org/docs/0.8.0/backup_and_restore.html
- Configuration http://tajo.apache.org/docs/0.8.0/configuration.html
-
------------------------------------------------
-Basic usages
------------------------------------------------
-
-``\l`` command shows a list of all databases.
-
-.. code-block:: sql
-
- default> \l
- default
- tpch
- work1
- default>
-
-``\d`` command shows a list of tables in the current database as follows: ..
-
- default> \d
- customer
- lineitem
- nation
- orders
- part
- partsupp
- region
- supplier
-
-``\d [table name]`` command also shows a table description.
-
- default> \d orders
-
- table name: orders
- table path: hdfs:/xxx/xxx/tpch/orders
- store type: CSV
- number of rows: 0
- volume (bytes): 172.0 MB
- schema:
- o_orderkey INT8
- o_custkey INT8
- o_orderstatus TEXT
- o_totalprice FLOAT8
- o_orderdate TEXT
- o_orderpriority TEXT
- o_clerk TEXT
- o_shippriority INT4
- o_comment TEXT
-
-The prompt ``default>`` indicates the current database. Basically, all SQL
statements and meta commands work in the current database. Also, you can change
the current database with ``\c`` command.
-
-.. code-block:: sql
-
- default> \c work1
- You are now connected to database "test" as user "hyunsik".
- work1>
-
------------------------------------------------
-Session Variables
------------------------------------------------
-
-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.
-
-``tsql`` provides the meta command ``\set`` to manipulate session variables.
Just ``\set`` command shows all session variables. ::
-
- default> \set
- 'name1'='val1'
- 'name2'='val2'
- 'name3'='val3'
- ...
-
-``\set key val`` will set the session variable named *key* with the value
*val*. ::
-
- default> \set
- 'CURRENT_DATABASE'='default'
-
- default> \set key1 val1
-
- default> \set
- 'CURRENT_DATABASE'='default'
- 'key1'='val1'
-
-
-Also, ``\unset key`` will unset the session variable named *key*.
\ No newline at end of file
Modified: tajo/site/docs/current/_sources/getting_started/first_query.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/getting_started/first_query.txt?rev=1637798&r1=1637797&r2=1637798&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/getting_started/first_query.txt (original)
+++ tajo/site/docs/current/_sources/getting_started/first_query.txt Mon Nov 10
06:57:43 2014
@@ -31,7 +31,7 @@ Here, we assume the schema as (int, text
name text,
score float,
type text)
- using csv with ('csvfile.delimiter'='|') location
'file:/home/x/table1';
+ using csv with ('text.delimiter'='|') location 'file:/home/x/table1';
To load an external table, you need to use âcreate external tableâ
statement.
In the location clause, you should use the absolute directory path with an
appropriate scheme.
Modified: tajo/site/docs/current/_sources/getting_started/prerequisites.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/getting_started/prerequisites.txt?rev=1637798&r1=1637797&r2=1637798&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/getting_started/prerequisites.txt (original)
+++ tajo/site/docs/current/_sources/getting_started/prerequisites.txt Mon Nov
10 06:57:43 2014
@@ -2,6 +2,6 @@
Prerequisites
**********************
- * Hadoop 2.2.0, 2.3.0, or 2.4.0
- * Java 1.6 or higher
- * Protocol buffer 2.5.0
\ No newline at end of file
+ * Hadoop 2.3.0 or higher (up to 2.5.1)
+ * Java 1.6 or 1.7
+ * Protocol buffer 2.5.0
Modified: tajo/site/docs/current/_sources/sql_language/ddl.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/sql_language/ddl.txt?rev=1637798&r1=1637797&r2=1637798&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/sql_language/ddl.txt (original)
+++ tajo/site/docs/current/_sources/sql_language/ddl.txt Mon Nov 10 06:57:43
2014
@@ -56,7 +56,7 @@ If you want to add an external table tha
...
L_COMMENT text)
- USING csv WITH
('csvfile.delimiter'='|','compression.codec'='org.apache.hadoop.io.compress.DeflateCodec')
+ USING csv WITH
('text.delimiter'='|','compression.codec'='org.apache.hadoop.io.compress.DeflateCodec')
LOCATION 'hdfs://localhost:9010/tajo/warehouse/lineitem_100_snappy';
`compression.codec` parameter can have one of the following compression codecs:
Modified: tajo/site/docs/current/_sources/table_management/csv.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/table_management/csv.txt?rev=1637798&r1=1637797&r2=1637798&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/table_management/csv.txt (original)
+++ tajo/site/docs/current/_sources/table_management/csv.txt Mon Nov 10
06:57:43 2014
@@ -36,8 +36,8 @@ The ``WITH`` clause in the CREATE TABLE
Now, the CSV storage format provides the following physical properties.
-* ``csvfile.delimiter``: delimiter character. ``|`` or ``\u0001`` is usually
used, and the default field delimiter is ``|``.
-* ``csvfile.null``: NULL character. The default NULL character is an empty
string ``''``. Hive's default NULL character is ``'\\N'``.
+* ``text.delimiter``: delimiter character. ``|`` or ``\u0001`` is usually
used, and the default field delimiter is ``|``.
+* ``text.null``: NULL character. The default NULL character is an empty string
``''``. Hive's default NULL character is ``'\\N'``.
* ``compression.codec``: 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 `org.apache.hadoop.io.compress.CompressionCodec
<https://hadoop.apache.org/docs/current/api/org/apache/hadoop/io/compress/CompressionCodec.html>`_.
By default, compression is disabled.
* ``csvfile.serde``: custom (De)serializer class.
``org.apache.tajo.storage.TextSerializerDeserializer`` is the default
(De)serializer class.
@@ -50,8 +50,8 @@ The following example is to set a custom
name text,
score float,
type text
- ) USING CSV WITH('csvfile.delimiter'='\u0001',
- 'csvfile.null'='\\N',
+ ) USING CSV WITH('text.delimiter'='\u0001',
+ 'text.null'='\\N',
'compression.codec'='org.apache.hadoop.io.compress.SnappyCodec');
.. warning::
@@ -88,7 +88,7 @@ Null Value Handling Issues
In default, NULL character in CSV files is an empty string ``''``.
In other words, an empty field is basically recognized as a NULL value in Tajo.
If a field domain is ``TEXT``, an empty field is recognized as a string value
``''`` instead of NULL value.
-Besides, You can also use your own NULL character by specifying a physical
property ``csvfile.null``.
+Besides, You can also use your own NULL character by specifying a physical
property ``text.null``.
=========================================
Compatibility Issues with Apache Hiveâ¢
Modified: tajo/site/docs/current/_sources/tsql/variables.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/tsql/variables.txt?rev=1637798&r1=1637797&r2=1637798&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/tsql/variables.txt (original)
+++ tajo/site/docs/current/_sources/tsql/variables.txt Mon Nov 10 06:57:43 2014
@@ -54,7 +54,7 @@ Now, tajo provides the following session
* ``CLI_ERROR_STOP``
* ``TIMEZONE``
* ``DATE_ORDER``
-* ``CSVFILE_NULL``
+* ``TEXT_NULL``
* ``DEBUG_ENABLED``
* ``TEST_BROADCAST_JOIN_ENABLED``
* ``TEST_JOIN_OPT_ENABLED``
Modified: tajo/site/docs/current/cli.html
URL:
http://svn.apache.org/viewvc/tajo/site/docs/current/cli.html?rev=1637798&r1=1637797&r2=1637798&view=diff
==============================================================================
--- tajo/site/docs/current/cli.html (original)
+++ tajo/site/docs/current/cli.html Mon Nov 10 06:57:43 2014
@@ -7,7 +7,7 @@
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Tajo Shell (TSQL) — Apache Tajo 0.8.0 documentation</title>
+ <title>Command-line Interface — Apache Tajo 0.8.0 documentation</title>
@@ -29,7 +29,7 @@
<link rel="top" title="Apache Tajo 0.8.0 documentation" href="index.html"/>
- <link rel="next" title="SQL Language" href="sql_language.html"/>
+ <link rel="next" title="Introducing to TSQL" href="tsql/intro.html"/>
<link rel="prev" title="High Availability for TajoMaster"
href="configuration/ha_configuration.html"/>
@@ -77,10 +77,15 @@
<li class="toctree-l2"><a class="reference internal"
href="configuration/ha_configuration.html">High Availability for
TajoMaster</a></li>
</ul>
</li>
-<li class="toctree-l1 current"><a class="current reference internal"
href="">Tajo Shell (TSQL)</a><ul>
-<li class="toctree-l2"><a class="reference internal"
href="#synopsis">Synopsis</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="#entering-tsql-shell">Entering tsql shell</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="#meta-commands">Meta Commands</a></li>
+<li class="toctree-l1 current"><a class="current reference internal"
href="">Command-line Interface</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="tsql/intro.html">Introducing to TSQL</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="tsql/single_command.html">Executing a single command</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="tsql/execute_file.html">Executing Queries from Files</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="tsql/back_command.html">Executing as background process</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="tsql/meta_command.html">Meta Commands</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="tsql/dfs_command.html">Executing HDFS commands</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="tsql/variables.html">Session Variables</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="tsql/admin_command.html">Administration Commands</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal"
href="sql_language.html">SQL Language</a><ul>
@@ -148,7 +153,7 @@
<ul class="wy-breadcrumbs">
<li><a href="index.html">Docs</a> »</li>
- <li>Tajo Shell (TSQL)</li>
+ <li>Command-line Interface</li>
<li class="wy-breadcrumbs-aside">
<a href="_sources/cli.txt" rel="nofollow"> View page source</a>
@@ -159,146 +164,21 @@
</div>
<div role="main">
- <div class="section" id="tajo-shell-tsql">
-<h1>Tajo Shell (TSQL)<a class="headerlink" href="#tajo-shell-tsql"
title="Permalink to this headline">¶</a></h1>
-<div class="section" id="synopsis">
-<h2>Synopsis<a class="headerlink" href="#synopsis" title="Permalink to this
headline">¶</a></h2>
-<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>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 in default.</li>
+ <div class="section" id="command-line-interface">
+<h1>Command-line Interface<a class="headerlink" href="#command-line-interface"
title="Permalink to this headline">¶</a></h1>
+<p>Tajo provides a shell utility for users. It is the command-line interface
(CLI). Using the CLI, users can create or drop tables, inspect schema and query
tables, etc. For reference, we named its name to tsql.</p>
+<div class="toctree-wrapper compound">
+<ul>
+<li class="toctree-l1"><a class="reference internal"
href="tsql/intro.html">Introducing to TSQL</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="tsql/single_command.html">Executing a single command</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="tsql/execute_file.html">Executing Queries from Files</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="tsql/back_command.html">Executing as background process</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="tsql/meta_command.html">Meta Commands</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="tsql/dfs_command.html">Executing HDFS commands</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="tsql/variables.html">Session Variables</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="tsql/admin_command.html">Administration Commands</a></li>
</ul>
</div>
-<div class="section" id="entering-tsql-shell">
-<h2>Entering tsql shell<a class="headerlink" href="#entering-tsql-shell"
title="Permalink to this headline">¶</a></h2>
-<p>If the hostname and the port num are not given, tsql will try to connect
the Tajo master specified in ${TAJO_HOME}/conf/tajo-site.xml.</p>
-<div class="highlight-python"><div class="highlight"><pre>bin/tsql
-
-default>
-</pre></div>
-</div>
-<p>If you want to connect a specified TajoMaster, you should use
‘-h’ and (or) ‘p’ options as follows:</p>
-<div class="highlight-python"><div class="highlight"><pre>bin/tsql -h
localhost -p 9004
-
-default>
-</pre></div>
-</div>
-<p>The prompt indicates the current database.</p>
-</div>
-<div class="section" id="meta-commands">
-<h2>Meta Commands<a class="headerlink" href="#meta-commands" title="Permalink
to this headline">¶</a></h2>
-<p>In tsql, anything command that begins with an unquoted backslash
(‘’) is a tsql meta-command that is processed by tsql itself.</p>
-<p>In the current implementation, there are meta commands as follows:</p>
-<div class="highlight-python"><div class="highlight"><pre>default> \?
-
-General
- \copyright show Apache License 2.0
- \version show Tajo version
- \? show help
- \q quit tsql
-
-
-Informational
- \l list databases
- \c show current database
- \c [DBNAME] connect to new database
- \d list tables
- \d [TBNAME] describe table
- \df list functions
- \df NAME describe function
-
-
-Variables
- \set [[NAME] [VALUE] set session variable or list session variables
- \unset NAME unset session variable
-
-
-Documentations
- tsql guide http://tajo.apache.org/docs/0.8.0/cli.html
- Query language http://tajo.apache.org/docs/0.8.0/sql_language.html
- Functions http://tajo.apache.org/docs/0.8.0/functions.html
- Backup & restore
http://tajo.apache.org/docs/0.8.0/backup_and_restore.html
- Configuration http://tajo.apache.org/docs/0.8.0/configuration.html
-</pre></div>
-</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">\l</span></tt> command shows
a list of all databases.</p>
-<div class="highlight-sql"><div class="highlight"><pre>default> \l
-default
-tpch
-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>
-<blockquote>
-<div>default> d
-customer
-lineitem
-nation
-orders
-part
-partsupp
-region
-supplier</div></blockquote>
-<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.</p>
-<blockquote>
-<div><p>default> d orders</p>
-<p>table name: orders
-table path: hdfs:/xxx/xxx/tpch/orders
-store type: CSV
-number of rows: 0
-volume (bytes): 172.0 MB
-schema:
-o_orderkey INT8
-o_custkey INT8
-o_orderstatus TEXT
-o_totalprice FLOAT8
-o_orderdate TEXT
-o_orderpriority TEXT
-o_clerk TEXT
-o_shippriority INT4
-o_comment TEXT</p>
-</div></blockquote>
-<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>
-<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>
-</div>
-<div class="section" id="session-variables">
-<h3>Session Variables<a class="headerlink" href="#session-variables"
title="Permalink to this headline">¶</a></h3>
-<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>
-<div class="highlight-python"><div class="highlight"><pre>default> \set
-'name1'='val1'
-'name2'='val2'
-'name3'='val3'
- ...
-</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>
-<div class="highlight-python"><div class="highlight"><pre>default> \set
-'CURRENT_DATABASE'='default'
-
-default> \set key1 val1
-
-default> \set
-'CURRENT_DATABASE'='default'
-'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>
-</div>
-</div>
</div>
@@ -307,7 +187,7 @@ default> \set
<div class="rst-footer-buttons" role="navigation" aria-label="footer
navigation">
- <a href="sql_language.html" class="btn btn-neutral float-right"
title="SQL Language"/>Next <span class="fa fa-arrow-circle-right"></span></a>
+ <a href="tsql/intro.html" class="btn btn-neutral float-right"
title="Introducing to TSQL"/>Next <span class="fa
fa-arrow-circle-right"></span></a>
<a href="configuration/ha_configuration.html" class="btn btn-neutral"
title="High Availability for TajoMaster"><span class="fa
fa-arrow-circle-left"></span> Previous</a>
Modified: tajo/site/docs/current/getting_started/first_query.html
URL:
http://svn.apache.org/viewvc/tajo/site/docs/current/getting_started/first_query.html?rev=1637798&r1=1637797&r2=1637798&view=diff
==============================================================================
--- tajo/site/docs/current/getting_started/first_query.html (original)
+++ tajo/site/docs/current/getting_started/first_query.html Mon Nov 10 06:57:43
2014
@@ -194,7 +194,7 @@ tajo> create external table table1 (
name text,
score float,
type text)
- using csv with ('csvfile.delimiter'='|') location
'file:/home/x/table1';
+ using csv with ('text.delimiter'='|') location
'file:/home/x/table1';
</pre></div>
</div>
<p>To load an external table, you need to use âcreate external tableâ
statement.
Modified: tajo/site/docs/current/getting_started/prerequisites.html
URL:
http://svn.apache.org/viewvc/tajo/site/docs/current/getting_started/prerequisites.html?rev=1637798&r1=1637797&r2=1637798&view=diff
==============================================================================
--- tajo/site/docs/current/getting_started/prerequisites.html (original)
+++ tajo/site/docs/current/getting_started/prerequisites.html Mon Nov 10
06:57:43 2014
@@ -171,8 +171,8 @@
<h1>Prerequisites<a class="headerlink" href="#prerequisites" title="Permalink
to this headline">¶</a></h1>
<blockquote>
<div><ul class="simple">
-<li>Hadoop 2.2.0, 2.3.0, or 2.4.0</li>
-<li>Java 1.6 or higher</li>
+<li>Hadoop 2.3.0 or higher (up to 2.5.1)</li>
+<li>Java 1.6 or 1.7</li>
<li>Protocol buffer 2.5.0</li>
</ul>
</div></blockquote>
Modified: tajo/site/docs/current/objects.inv
URL:
http://svn.apache.org/viewvc/tajo/site/docs/current/objects.inv?rev=1637798&r1=1637797&r2=1637798&view=diff
==============================================================================
Binary files - no diff available.
Modified: tajo/site/docs/current/searchindex.js
URL:
http://svn.apache.org/viewvc/tajo/site/docs/current/searchindex.js?rev=1637798&r1=1637797&r2=1637798&view=diff
==============================================================================
--- tajo/site/docs/current/searchindex.js (original)
+++ tajo/site/docs/current/searchindex.js Mon Nov 10 06:57:43 2014
@@ -1 +1 @@
-Search.setIndex({envversion:42,terms:{"1st":18,represent:[37,18],all:[43,46,42,3,44,4,18,33,7,8,49,9,51,53,50],code:[4,49,40],dist:[43,17,49],c_name:53,rdbm:43,queri:[33,40,10,49],global:18,concern:[53,28],month:18,four:[45,18],prefix:[11,18],concept:[43,18],per:[51,33,44,10],abil:33,mno:50,follow:[2,4,6,7,8,9,10,11,31,14,46,17,18,19,20,21,22,23,24,27,28,32,33,35,37,53,41,42,43,44,45,49,50,51],disk:[4,10],row:[11,31,50,6,19,7,8,49,9,37,21],millisecond:18,content:[12,3,35,49],privat:43,complet:33,depend:[33,42,43,8],zone:[23,18],getconnect:43,dist_query_join_task_volum:51,decim:[23,18],executor_external_sort_buffer_s:51,init:50,hadmin:33,present:[40,9],jvm:33,skip:18,sql_languag:9,thursdai:18,"case":[28,15,43,18,19,8,49,21],digit:[23,18],sourc:[40,49,18],everi:[33,7],string:[13,4,28,18],fals:[23,37,4,8],"void":43,ddl:[53,50],csvfile:[50,35,6],varchar:23,util:39,volum:[50,9],failur:33,veri:[3,44,8],affect:[49,10,18],implicitli:7,hdfs_locat:19,exact:23,dbname:9,tri:43,recordcompresswri
t:21,did:18,"12th":18,list:[46,9,44,33,20,8,22,7,50],scalar:[7,37],hive:[12,42,49],"try":[33,43,41],date_part:18,interfac:[33,39,6],adjust:[27,18,19,37,6,10],form:[19,27,7],cosin:[26,9],vertic:6,dealt:7,println:43,tmmonth:18,tajo_src:17,locat:[43,14,3,4,19,35,49,50,53,10],tajo_hom:[43,28,41,3,44,33,49,50],dir:[44,14,10],pleas:[43,3,44,4,18,19,7,50,37,6,53,10],prevent:33,templet:28,smaller:14,boolean_express:7,ten:[42,40],natur:7,sign:[26,8],past:18,dowload:40,long_table_name_1234:7,cost:16,design:[16,20,28,37],aggreg:[11,2,7],pass:7,download:4,val2:[51,8],val1:[51,8],histori:33,port:[27,41,46,43,44,33,49],tmpdir:10,even:[33,18],asin:26,what:18,abc:[8,50],addr:[4,49],compar:23,clock:18,section:[42,43,44,18,19,6,40,10],xtajoxx:15,calcul:7,current:[27,41,42,43,32,18,33,7,8,49,9,37,45,10],c_phone:53,"19th":18,version:[17,49,9],directori:49,decompress:[37,22],ab_bc_cd:15,supplier:9,"new":[33,18,9],to_dat:18,method:[12,53],era:18,showmast:46,ongo:33,elimin:[35,7],full:[7,18],hash:12,deriv
:7,pow:26,gener:[33,6],never:33,onli:[27,28,3,32,18,19,7,21,49,22,37,6],here:[21,3,8,50,18],tangent:26,address:[44,4,33,47,49,23],path:[27,42,43,4,35,49,9,53,50],o_orderprior:9,sine:26,modifi:18,sinc:[19,49,18],valu:[26,12,27,28,42,44,4,18,33,49,10],wait:33,convert:[26,33,4,54,18],aaabc:8,deterior:37,weekdai:18,haadmin:33,shift:18,cli_print_error_trac:51,larger:[23,7,37],table_backup:53,later:40,precis:[23,18],datetim:13,amount:33,behavior_arithmetic_abort:51,behav:7,codebas:22,character_length:15,chang:[44,22,43,49,9],commonli:6,sequencefil:[12,45,19],dayofweek:18,via:[33,44,40],regardless:[19,37],starttim:46,data_typ:35,appli:[33,18],transit:33,substr:[7,15,18],unix:18,"boolean":[23,7,4,37],namenode_hostnam:27,wip:[49,22],instal:[4,49,17],total:[7,10],unit:[49,37],num1:26,from:[26,12,15,50,18,33,22,53],describ:[42,9],would:[42,17,18],memori:[33,49],distinct:[7,18],doubl:18,two:[3,32,18,19,8,28,53,54,21],next:[42,43,18],connector:[42,49],few:28,program:[28,37],call:[12,7],usr:49,re
commend:[17,18],stage:50,type:[26,12,15,4,18,28,50,53,10],until:51,tajo_pid_dir:33,more:[11,31,42,37,44,18,7,8,49,50,40,10],sort:7,flat:[19,21,37],capit:18,discompress:17,hiveql:42,claus:[12,50,20,8,23],mismatch:12,hurt:16,function_nam:54,rootdir:44,exce:18,name2:51,indic:18,name1:51,known:20,postgresql:8,editor:[33,44],unpack:40,must:[11,27,43,18,33,7,49,37,23],tabular:6,word:[19,18,10,6],hour:18,grant:49,formatha:33,alia:[23,7,15,9],setup:38,work:[23,37,18,9],timestamptz:23,dev:4,cat:[11,33,44,53,50],orderbi:12,column:12,itself:[33,9],can:[3,6,7,8,9,10,11,12,18,19,20,21,22,24,28,33,35,37,39,17,42,43,44,49,50],learn:3,field:[18,9,15,6],purpos:[42,28],root:[26,44],fmss:18,def:50,bewtween:23,control:33,nearest:[26,18,9],prompt:[41,31,9],to_char:18,tar:[43,17,49,22],give:[35,7,10],process:[12,16,18,19,20,37,6,39],fmdd:18,share:[19,43,7],backslash:[18,9],templat:[49,18],high:38,liter:[18,28,6],want:[27,43,14,28,41,42,3,44,31,18,33,20,21,49,50,35,24,53,10],tarbal:33,tan:26,keep:18,occur
:[35,19,7,18],tinyint:23,unresolvedaddressexcept:12,alwai:18,sundai:18,isoyear:18,multipl:[33,18,7,10,6],goal:16,divid:[26,7,18],anoth:[33,54],ordinari:18,hdf:[12,27,16,43,44,35,50,39,40,10],mapr:21,how:44,yyyymondd:18,purg:35,consist:[18,19,7,21,28,6],env:[33,49],c_address:53,main:[16,43,8,28],instead:[18,41,8,49,50,6],csv:[12,35,53,50],config:[28,42,43,44,33,47,49,51,10],sin:26,blockcompresswrit:21,updat:33,jline2:2,transitiontoact:33,product:7,resourc:[33,47,44],ltrim:15,atan:26,client_session_expiry_tim:51,clone:[49,22],after:[7,17,18],resultset:43,concatnen:15,cli_error_stop:51,befor:[33,2,7,44],catalog:1,"4th":18,floor:26,date:53,end:[24,15,22],underscor:8,mariadb:49,data:[33,44,49],parallel:44,physic:44,subsequ:18,github:22,essenti:33,third:[49,18],read:[37,22,44,6],cli_print_paus:51,quot:[41,18],favorit:[33,44],correspond:[19,7],element:[33,28],caus:[33,18],inform:[33,18,49,9],preced:[4,18],environ:[28,27,3,42,10],block:[21,37],allow:[11,27,42,37,44,18,19,7,50,35,6,10],enter
:[12,17],worst:16,first:[15,40,28,18,17,49],item:[24,8,18],order:[43,16,42,3,44,6,19,7,49,9,20,37,23,10,50],quantiti:7,includ:[43,7,10,18],oper:[33,13,49],help:9,shorten:49,over:7,fall:[7,18],midnight:18,becaus:[33,2,18,7,6],comma:[18,7,6],same:[26,42,4,18,33,7,8],equival:[14,7,18],still:33,vari:[23,18],dynam:16,entiti:33,smallint:23,write:[19,37,18,21,6],style:8,outer:7,cli:[39,9],overwrit:[12,52,33],fix:18,defin:6,late:18,window:12,complex:[7,18],persist:[3,49],decad:18,therefor:[33,18],isodow:18,non:[37,7,18],"float":[26,37,6,19,20,21,50,23,10],synopsi:[35,12,7,8],greater:26,thei:[19,8,33,18],add_month:18,handl:43,timestamp:[23,18],"1gb":[27,10],spell:18,col2:[14,8],dai:18,initi:33,col1:[14,8],ssss:18,framework:37,lzo:37,verifi:33,item_nam:20,now:[37,17,18,19,9,51,6,53],utc_usec_to:[18,9],nor:8,introduct:12,tajo_worker_heaps:10,choic:37,subqueri:7,hive_jdbc_driver_dir:[42,49],name:[4,6,7,9,10,11,18,19,21,23,27,49,33,37,39,53,41,42,43,44,47,28,50,51],reoptim:16,simpl:[3,50],drop:1
2,regexp_replac:15,instruct:[42,4],lazybinaryserd:21,separ:[31,18,7,21,6],easili:[33,43,44],submit:[33,40,50],mode:49,each:[44,28],januari:18,clsspath:43,quarter:18,compatibl:53,side:[43,15],truncat:26,mean:[8,18],compil:[42,17,49],domain:[33,44,8,6],map:23,unequ:33,individu:7,saturdai:18,procedur:17,group:[7,8,37],resut:26,meta:[12,3,39,49],"static":43,connect:[42,43,41,49,9,51],year:[7,18],our:6,extract:[18,9],special:6,out:10,variabl:[12,27,28,42,3,49,9,23,39,10],unquot:9,shown:18,o_com:9,network:[33,13],space:[15,18],although:18,storag:[27,3,6,19,21,49,37,53],access:[33,42,43,44,37],o_orderkei:9,xxtajo:15,profil:[42,49],millennium:18,hivemetastor:[42,49],print:18,roma:18,math:13,integr:49,bye:50,shut:40,parquet:[12,45],partit:12,advanc:[16,7],lastli:49,manipul:51,given:[14,15,41,50,4,18,23,7,8,9,35],free:50,standard:[16,23,50,8,18],asc:7,standalon:40,base:49,asf:[49,22],dictionari:37,usual:[28,6],put:[11,18],org:[43,42,9,6,19,35,21,49,22],"byte":[23,37,50,9],fridai:18,div:26,car
d:20,care:[18,6],str2:15,recogn:6,launch:49,angl:26,real:26,could:18,omit:[19,18,7,9],p_id:11,retriv:43,round:[26,9],filter:[7,8],length:[23,18],iso:18,rcfile:[12,45],fxyyyi:18,umbil:[33,47,44],timezon:51,think:50,mvn:[42,43,17,49],str1:15,feed:6,schema:[9,14,37,20,50,39],meridiem:18,l_comment:35,suffix:18,directli:[20,6],resourceconfigur:10,feel:50,onc:[33,7,4],arrai:8,independ:37,applciat:43,number:44,system:[43,28,33,16,3,44,19,49,24,17,10],restrict:18,mai:[31,28,3,18,33,7,49,17],o_orderd:9,alreadi:33,done:[17,18],unhealthi:33,blank:18,tpch:[53,9],open:16,primari:[33,27],differ:[7,8,18],cartesian:7,script:[17,28],xii:18,interact:[16,41,50],mkdir:[24,44,50],capac:[44,10],least:[7,8],getstat:33,paramt:11,l_partkei:[35,14,7],too:37,saint:18,termin:6,scheme:[27,50],boot:[3,49],"final":[42,43,49,50],store:[11,33,16,42,3,6,19,21,49,9,10,50],q_1411357607375_0006:46,mysql_jdbc_driv:[42,49],shell:[12,40,28,50],option:[11,46,17,41,35,7,18,53],inspect:39,especi:23,namespac:43,tool:9,copi:[2
8,49],inexact:23,grouping_column_refer:7,radian:26,"short":[19,7],enclos:7,mostli:19,twenti:18,fsshell:24,attempt:18,exactli:8,geoip_country_cod:4,serv:33,enjoi:50,kind:7,target:[26,14,43,33,49,17],keyword:[7,21],provid:[46,31,43,33,16,2,3,4,32,6,19,8,49,50,51,24,45,39,37,10,21],expr:7,remov:[3,35,15,49],tree:17,second:[33,15,49,18],mmdd:18,charact:[15,18,19,20,8,23,6],project:[16,37],serd:[19,6],arc:26,posix:8,balanc:16,becom:[33,18],tajoresourcemanag:33,float8:[26,23,14,53,9],minut:[42,40,18],listen:[43,44],codegen:51,unix_timestamp:18,comput:[7,18],abov:[19,2,31,21,50],textserd:21,ran:49,julian:18,respons:[11,16,2,31,50],mind:18,ani:[43,6,33,7,8,49,9,37],"return":[26,15,4,18,8,6],packag:[42,43],chmod:44,manner:43,have:[12,27,42,18,35,49],further:6,need:[43,33,42,3,18,19,21,49,50,37,6,53],maxmind:4,predic:[12,20,52],calendar:18,test_min_task_num:51,cli_null_char:51,tajocli:33,catalogstor:33,squar:26,zero:[8,18],partsupp:9,statement:[11,14,41,46,43,50,6,19,7,8,9,35,37,21],click:22,
note:[8,49,18],also:[22,50,18,33,20,8,49,9,51,7,6,21],without:[31,16,18,20,49,7,6],take:[42,7,40,22],which:[43,33,16,3,41,18,19,7,21,49,50,51,35],techniqu:16,combin:7,subject:7,brace:11,prepar:[42,17,49,50],singl:[12,44,18,33,8,37,39],compat:[12,49,10],lineitem_100_snappi:35,c_nationkei:53,unless:18,distribut:49,preliminari:38,buffer:[25,37],price:20,previou:[8,18],compress:12,deflatecodec:35,untar:22,most:[49,6],microsecond:18,specifi:[27,14,41,46,42,43,4,6,19,54,7,8,49,37,23,24,18,17,10,21],deploi:33,phase:20,metacharact:8,choos:[17,22],cbrt:26,"class":[42,43,6,19,8,49,21],appear:7,other:[14,33,16,18,19,7,28,6,10],doi:18,don:[43,53,28,17],url:[27,43],doc:9,clear:9,binaryserd:21,request:10,uri:[33,49],ghi:50,salari:7,part:[18,9],snapshot:[17,49],classnotfoundexcept:43,determin:[7,10],pattern:[12,15,18],link:22,querymast:[33,10],axi:26,remot:44,dow:18,pope:18,show:[46,43,50,51,9,40],text:[11,15,23,33,50,44,4,6,19,20,8,9,35,37,18,53,21],hostnam:[41,27,43,44,49],rtrim:15,syntax:[7,54]
,column_refer:8,session:[12,39,9],l_discount:7,identifi:[7,49,18],rang:[12,32],ship_dat:20,find:33,xml:[33,44,49],absolut:[26,50,49,9],row_num:7,explicitli:[7,28],ratio:10,just:[33,7,8,49,51,24,53],copyright:9,much:10,explain:[3,43,44,6,19,7,40],apach:[42,3,4,49,22,40,50],abbrevi:18,than:[11,26,14,42,18,7,8,40],jan:18,fmhh:18,central:33,l_quantiti:[14,7],tbname:9,search_condit:7,local:[4,18,49,22,40,10],test_filter_pushdown_en:51,ddsp:18,info:[46,33,47],"53rd":18,cube:26,variou:[51,18],get:[33,49,18],fmmonth:18,familiar:[19,37,6],express:[12,52,15,18],disagre:18,ceil:26,repo:[49,22],cannot:6,java_hom:3,progress:[11,16,2,46,31],increas:44,score:[11,31,37,6,19,21,50],requir:[33,31,3,7,18],prune:12,table_refer:7,bar:6,enabl:[33,43,44,6,19,49,37],tajodriv:43,upper:[15,18],grtajo01:46,borrow:8,"public":43,ddth:18,current_timestamp:18,common:7,dist_query_sort_task_volum:51,contain:[33,43,35,44,18],clean:[42,43,17,49],metadata:19,where:[12,3,44,20,8,49,50,23,10],valid:18,bytea:23,dhadoop:1
7,set:49,frame:7,knowledg:6,startup:41,memstor:49,c_custkei:53,see:[3,44,18,49,50,10],num:[41,7],sec:[11,31,46,2,49,50],result:[12,43,18,33,7,9,37,50],arg:[46,43],float4:[23,9],close:43,rlike:8,unqualifi:[20,7],improv:37,o_orderstatu:9,valn:8,awar:10,statu:33,detect:33,kei:[11,32,18,19,20,21,51,35],correctli:[23,17],down:[8,40],ieee:23,char_length:15,below:[40,18,19,37,6,53],yet:20,cli_print_pause_num_record:51,smallest:[26,37],subdir:14,between:[43,8],"\u02c6ab":15,l_orderkei:[35,14,7],neither:8,paramet:[26,12,15,4,18,19,35,37,6],approach:53,across:[44,7],altern:8,accord:[23,7],parent:17,numer:18,executor_groupby_inmemory_hash_threshold:51,vatican:18,hadoop_hom:[3,44],add_dai:18,o_totalpric:9,remaind:26,snappi:37,gregorian:18,outfil:53,disconnect:[51,33],argument:[26,31,18,7,9,24],problem:[33,2],monitor:33,both:[15,33,16,6,19,7,21],last:[7,18],"85e7":18,admin:[46,9],fault:16,howev:37,gzipcodec:35,c_comment:53,groupbi:12,against:40,etc:39,roman:18,instanc:[27,3,44,40],compressioncod
ec:[19,6],context:18,logic:8,let:21,whole:10,fmyyyi:18,load:[16,50],english:18,simpli:17,point:[19,33,18],overview:12,format:33,period:[33,18],split_part:15,hh12:18,header:19,rpc:[33,47,43,44],written:[19,21],param:[11,41,7],shutdown:33,toler:16,respect:[23,8],tuesdai:18,guid:9,assum:[31,50,20,10,18],transitiontobackup:33,abscissa:26,cathedr:18,quit:9,xzvf:[43,17,22],strong:53,java:[12,28,42,3,49,25],creat:[12,44,53,49,50,40],nonsens:18,invers:9,empti:[19,7,6],otherwis:[41,18,7,4,8],compon:33,"int":[26,15,37,18,19,20,21,50,23,6],json:6,trigger:33,besid:6,interpret:18,basic:[16,12,53,21,6],addit:[14,43,7,8,10],c_mktsegment:53,multipli:18,host2:[33,44],derbystor:[33,49],o_custkei:9,legaci:4,exercis:40,num2:26,decimaln:9,suppress:18,xxx:9,worker:38,search:12,cli_output_formatter_class:51,wish:11,tajojdbccli:43,coordin:26,togeth:18,func:7,input:[26,15,18],"catch":43,repetit:8,countri:[4,18],due:10,those:[19,37,43,6],statist:33,emploi:16,ident:18,implementaion:27,plain:[19,21],servic:[47
,49],properti:[27,28,42,44,4,33,47,49,10],iyi:18,batch:16,rectangular:26,cli_max_column:51,cast:[12,18],"while":[43,18],uniqu:51,behavior:7,error:[35,18],wild:20,exist:[35,19,14,41],region:9,lazybinarycolumnarserd:19,textserializerdeseri:[19,21,6],bin:[11,31,41,42,2,3,44,33,49,50,53],layer:27,relat:[7,37],advantag:37,ctrl:[33,44,50],key1:51,tabl:[42,3,53,49,50,40],them:7,activ:33,cluster:[38,49],"default":[38,44,49],archiv:[17,49],warehous:[16,24,35],textfil:12,conf:[27,28,41,42,3,44,4,33,49,10],centuri:18,crash:33,mod:26,abcdef:15,primit:23,conn:43,"null":[43,7],develop:[12,22],"35b":50,csvfile_nul:51,perform:7,suggest:22,belong:7,classpath:12,hadoop:[43,16,3,44,17,6,19,35,8,28,50,37,24,25,40,21],sqrt:26,binari:[12,17,49],epoch:18,html:9,pad:18,split:15,largest:26,dtar:[42,43,17,49],start:[33,44,15,18],conflict:33,higher:25,week:18,varbit:23,lineitem:[35,14,46,7,9],http:[9,4,33,47,49,22],nio:12,denot:8,optim:16,nest:37,driver:[12,42,49],geoip_in_countri:4,col3:14,jkl:50,column_nam:
35,moment:[37,6],rais:26,dskiptest:[42,43,17,49],user:[27,18,33,49,50,10],tajo_classpath:49,mani:[19,43,10,9],extern:[35,19,20,53,50],nation:9,tsql:[12,53,50],typic:7,built:[19,43,9],lower:[15,18],appropri:[28,50],off:18,lib:49,mention:19,com:[33,44,4],thu:17,page:[12,44,37],well:[35,14,23,18],parenthes:[7,8],inherit:[19,6],to_numb:18,exampl:[33,44,53,49],command:[12,50,39,53,17],thi:[11,12,37,53,28,42,43,44,17,6,33,7,8,49,22,50,24,18,40,10,21],filesystem:[40,22],gzip:37,fmmm:18,lc_time:18,createdatabaseifnotexist:49,fmmi:18,left:7,explan:50,construct:[7,18],protocol:25,entri:[33,35,44],execut:[33,44,40,10],less:[26,18],when:[43,14,3,18,33,7,49,37,35,6],dist_query_groupby_task_volum:51,ordin:[26,18],tcp:41,jar:[42,43,49],q_1363768615503_0001_000001:50,kill:[46,33],mysql:[42,49],rest:7,simultan:10,bit:23,languag:[16,12,50],inet4:[23,4],move:17,web:[16,33],binaryserializerdeseri:[19,21],all_backup:53,easi:[53,32],mix:18,disk1:10,disk2:10,disk3:10,except:[43,7,49,18],shortcut:24,date_o
rd:51,add:[43,28,42,3,44,33,35,49,24,10],divis:26,blob:23,versa:19,backup_and_restor:9,work1:9,expon:26,disrupt:33,modul:[12,28],euler:26,build:40,earli:18,applic:7,complaint:18,march:18,littl:44,serde2:[19,21],preserv:33,wai:[33,18,53,6],subfield:18,host1:[33,44],bzip2codec:35,"4028235e":23,iyyi:18,workload:10,phcatalog:[42,49],mon:18,background:[12,39],insert:[12,52,33],database_nam:[41,35],password:49,licens:9,desc:[46,7],linux:9,u0001:6,storage_typ:35,table1:[11,31,43,6,19,7,8,50,37,21],resid:50,like:[27,43,20,17,18],specif:[33,27,14,23,18],filenam:41,should:[27,37,41,42,43,44,4,18,19,20,49,50,35,53,6,40,10],manual:[19,49],integ:[26,23,18,10,9],server:[46,33,3,28,49],pdist:[42,43,17,49],collect:21,benefit:32,api:12,necessari:16,either:[42,22,7,8,37,23],descend:7,output:[14,7,21,18],timetz:23,tajo:[38,53,49],result_set_fetch_rownum:51,another_long_table_name_5678:7,geoip:4,yyyi:18,right:7,peter:18,who:6,order_d:20,createstat:43,interv:[33,18],suppli:18,some:[12,28,42,2,3,18,19,7,
49,50,23,37,6,17],begin:[18,9],tajowork:[33,28,10],certain:[19,37,14,6],arithmet:[12,7],intern:28,current_d:18,queryid:46,test_broadcast_join_en:51,yyyymmdd:18,mirror:22,proper:[27,3,49,10,17],home:[42,3,53,49,50],"52nd":18,row_numb:7,tmp:[24,3,27,49,50],query_succeed:50,cnt:7,scale:16,tajo_master_heaps:27,lead:[20,15,18],channel:12,"512mb":10,been:9,avoid:[16,33,2,35,18],exec:21,definit:[12,52,18],best:6,usernam:[3,49],alias_nam:7,tracker:[33,47,44],exit:2,select:[11,26,31,14,15,46,43,4,18,7,8,9,50],bigint:[23,35],xxxxxx:49,condit:7,fornam:43,three:[21,49,18],localhost:[41,44,33,47,35,49],ddd:18,machin:[33,49,41],core:[43,10],o_shipprior:9,run:[33,44],power:[26,8],uncompress:[21,37],oracl:18,executor_hash_join_size_threshold:51,dist_query_table_partition_volum:51,usag:[12,37,53,18],mixtur:18,maven:[42,17,49],broken:6,step:17,atan2:26,durat:49,repositori:22,found:24,peer:47,l_extendedpric:7,subtract:18,unicod:23,c_acctbal:53,comparison:[23,8],ascend:7,repeat:18,actual:12,dist_query_
groupby_partition_volum:51,dist_query_join_partition_volum:51,varbinari:23,aco:[26,9],total2:7,simul:33,degre:[26,44],regular:15,sequecnefil:21,issu:12,table_nam:[35,53],approxim:23,disabl:[19,37,6],hive_hom:[42,49],plan:[16,20,6],executor_outer_hash_join_size_threshold:51,columnarserd:19,client:[12,47,44,49,33],own:6,effici:37,consid:33,primarili:18,within:[33,24,7,18],encod:37,lazybinari:21,compos:[20,37],stop:[33,2],pair:[19,21,28],master:[38,44,49],refer:[43,3,44,4,6,19,7,21,9,37,50],val3:51,ensur:[3,49],"import":43,yyi:18,your:[27,43,28,33,42,3,44,17,18,19,49,22,37,53,6,40],manag:[12,42,3,32,49],git:49,val:51,pictur:9,hh24:18,support:[27,53,49,18],"long":[16,7,18],custom:[53,49],avail:38,width:18,drivermanag:43,current_databas:51,q_1411357607375_0007:46,inner:7,fraction:18,replac:[15,18],"var":49,datanod:10,ipv4:[23,4],snappycodec:[19,35,21,6],enough:49,forc:[7,18],test_join_opt_en:51,drwxr:24,compressiontyp:21,jun:18,tajoxx:15,back:33,query_run:46,int4:[23,14,15,9],jdbc:[12,42
,49],max_output_file_s:51,translat:18,select_stat:35,int2:23,l_shipdat:7,line:[33,39,44,6],"true":[4,33,21,49,37,23,10,8],int8:[26,23,14,53,9],stmt:43,count:[11,31,15,46,18,7],utc:18,"throw":43,dist_query_broadcast_join_threshold:51,theta:26,temp:24,possibl:[7,10,18],whether:[19,7,8],ecosystem:37,vice:19,standbi:33,day_of_week:18,record:[19,37,8,21,6],to_timestamp:18,current_tim:18,limit:[12,10],toggl:18,sum:[11,31,7],site:[33,44,49],"export":[42,3,49],embed:49,executequeri:43,defaultport:49,delimit:[50,35,15,6],expect:18,trim:15,model:[12,52],featur:[11,19,42,37,6],constant:26,semicolon:[24,31],btrim:15,host:[41,46,43,44,33,49],retriev:18,dure:20,pid:33,repres:[18,6],"char":[23,18],novemb:18,executor_inner_hash_join_size_threshold:51,implement:[12,18,3,9],"20000nov31":18,file:[44,53,49],guarante:33,doe:[43,18,33,35,37,7,6],match:[12,23,15,18],fill:[43,18],incorrect:33,tab:6,consum:37,successfulli:[46,33],codec:[19,35,21,6],know:[44,50,7,18],sort_expr:7,index:12,percent:8,detail:[46
,50,44,18,7,49,9,37],getstr:43,debug_en:51,finish:33,bracket:8,bool:23,o_clerk:9,branch:12,varieti:28,test:49,you:[2,3,4,6,7,8,9,10,11,31,14,17,18,19,20,21,22,40,24,27,28,33,35,37,53,41,42,43,44,49,50],node:[33,43,44,10],polar:26,iddd:18,intend:18,exp:26,highli:17,customserializerdeseri:6,sequenc:8,symbol:11,introduc:12,briefli:7,insensit:8,mondai:18,tajomast:[38,44,49],columnar:[19,37],src:[22,43,18],empsalari:7,haven:20,algorithm:[19,37,10,6],trail:[15,18],hyunsik:[53,9],regexp:8,descript:[46,50,18,33,47,8,49,9,23,10],cpu:10,select_list:7,carriag:6,place:9,ignor:[10,18],invok:33,time:33,supergroup:24,decemb:18,backward:10,small:[23,37],hello:18,unset:[51,9],name3:51},objtypes:{"0":"py:function"},objnames:{"0":["py","function","Python
function"]},filenames:["partitioning/hash_partitioning","backup_and_restore","tsql/background_command","getting_started/local_setup","functions/network_func_and_operators","partitioning/range_partitioning","table_management/csv","sql_language/queries"
,"sql_language/predicates","tsql/meta_command","configuration/worker_configuration","tsql/execute_file","index","functions","sql_language/insert","functions/string_func_and_operators","introduction","getting_started/building","functions/datetime_func_and_operators","table_management/rcfile","partitioning/column_partitioning","table_management/sequencefile","getting_started/downloading_source","sql_language/data_model","tsql/dfs_command","getting_started/prerequisites","functions/math_func_and_operators","configuration/tajo_master_configuration","configuration/preliminary","table_management/compression","faq","tsql/single_command","partitioning/intro_to_partitioning","configuration/ha_configuration","table_partitioning","sql_language/ddl","table_management","table_management/parquet","configuration","tsql","getting_started","tsql/intro","hcatalog_integration","jdbc_driver","configuration/cluster_setup","table_management/file_formats","tsql/admin_command","configuration/configuration_
defaults","tajo_client_api","configuration/catalog_configuration","getting_started/first_query","tsql/variables","sql_language","backup_and_restore/catalog","sql_language/sql_expression"],titles:["Hash
Partitioning","Backup and Restore","Executing as background process","Setting
up a local Tajo cluster","Network Functions and Operators","Range
Partitioning","CSV (TextFile)","Queries","Predicates","Meta Commands","Worker
Configuration","Executing Queries from Files","Apache Tajo\u2122 (dev) - User
documentation","Functions","INSERT (OVERWRITE) INTO","String Functions and
Operators","Introduction","Build source code","DateTime Functions and
Operators","RCFile","Column Partitioning","SequenceFile","Dowload and unpack
the source code","Data Model","Executing HDFS commands","Prerequisites","Math
Functions and Operators","Tajo Master
Configuration","Preliminary","Compression","FAQ","Executing a single
command","Introduction to Partitioning","High Availability for
TajoMaster","Table Partit
ioning","Data Definition Language","Table
Management","Parquet","Configuration","Tajo Shell (TSQL)","Getting
Started","Introducing to TSQL","HCatalog Integration","Tajo JDBC
Driver","Cluster Setup","File Formats","Administration Commands","Configuration
Defaults","Tajo Client API","Catalog Configuration","First query
execution","Session Variables","SQL Language","Backup and Restore Catalog","SQL
Expressions"],objects:{"":{trim:[15,0,1,""],upper:[15,0,1,""],to_char:[18,0,1,""],btrim:[15,0,1,""],regexp_replace:[15,0,1,""],cbrt:[26,0,1,""],split_part:[15,0,1,""],sign:[26,0,1,""],add_months:[18,0,1,""],to_date:[18,0,1,""],tan:[26,0,1,""],extract:[18,0,1,""],current_time:[18,0,1,""],floor:[26,0,1,""],sqrt:[26,0,1,""],acos:[26,0,1,""],char_length:[15,0,1,""],current_date:[18,0,1,""],abs:[26,0,1,""],degrees:[26,0,1,""],pow:[26,0,1,""],pi:[26,0,1,""],sin:[26,0,1,""],ltrim:[15,0,1,""],atan:[26,0,1,""],asin:[26,0,1,""],cos:[26,0,1,""],ceil:[26,0,1,""],atan2:[26,0,1,""],rtrim:[15,0,1,""],now:[
18,0,1,""],utc_usec_to:[18,0,1,""],geoip_in_country:[4,0,1,""],mod:[26,0,1,""],lower:[15,0,1,""],radians:[26,0,1,""],date_part:[18,0,1,""],to_timestamp:[18,0,1,""],geoip_country_code:[4,0,1,""],add_days:[18,0,1,""],exp:[26,0,1,""],div:[26,0,1,""],round:[26,0,1,""]}},titleterms:{code:[43,17,22],execut:[11,2,31,24,50],queri:[11,7,50],session:51,permiss:44,hcatalogstor:49,languag:[52,35],paramet:11,xml:28,how:[33,43,6,19,20,37],configur:[27,33,47,49,38,10],apach:[19,12,37,20,6],window:7,local:3,match:8,real:23,sourc:[43,17,22],synopsi:[46,41],string:[8,54,15],format:[45,18],handl:6,faq:[30,43],terminolog:33,background:2,insert:14,introduct:[16,32],mysqlstor:49,document:12,like:8,administr:[46,33],level:53,drop:35,hive:[19,37,20,6],integr:42,partit:[0,34,20,32,5],each:10,fulli:44,where:7,manag:36,failov:33,set:[11,33,3,43,44],hcatalog:42,dump:53,dowload:22,meta:9,download:22,run:10,todo:[0,29,30,5,48,53],time:18,out:22,compat:[19,37,20,6],network:4,cast:54,databas:[35,53],preliminari:28
,definit:35,state:33,directori:[44,10],channel:43,get:[43,40],method:32,math:26,mode:[44,10],qualifi:7,hash:0,driver:43,gener:19,usag:[11,46,9],serializerdeseri:21,base:44,prerequisit:[25,4],releas:22,from:[11,43,7],rcfile:19,valu:[11,23,6],convers:18,launch:[33,44],column:20,tajo:[12,27,43,19,3,44,33,47,48,28,39],groupbi:7,datetim:18,backup:[33,1,53],first:50,oper:[26,18,4,15],rang:5,via:22,overview:7,tajomast:[33,27],number:[23,10],automat:33,api:48,size:[27,10],writer:21,git:22,java:43,memori:[27,10],data:[23,35,10],support:4,doubl:23,overwrit:14,custom:6,avail:33,start:40,call:54,basic:[11,46,9],master:[33,27,47],type:[23,7,54],"function":[26,13,15,4,18,7,54],shell:[41,39],claus:7,worker:[47,44,10],rootdir:27,heap:[27,10],jdbc:43,unpack:22,join:7,prune:20,restor:[1,53],"default":47,setup:44,properti:[19,37,6],maximum:10,dev:12,orderbi:7,hdf:24,serd:21,limit:7,introduc:[41,21],parquet:37,similar:8,file:[11,33,45],creat:[35,19,37,20,6],process:2,site:28,indic:12,high:33,cluster:[3
3,3,44],unresolvedaddressexcept:43,textfil:6,have:7,tabl:[12,6,19,34,20,36,37,35,7],serial:[19,6],"null":6,dedic:10,issu:[19,37,20,6],make:44,ilik:8,when:19,cross:7,check:22,binari:43,exampl:[43,7,10],build:[43,17],env:28,test:33,distribut:[43,44],csv:6,singl:31,variabl:51,express:[8,54],resourc:10,nio:43,classpath:43,enter:41,compress:[29,35],catalog:[28,53,49],regular:8,temporari:10,user:12,sql:[11,52,53,54],date:18,tsql:[41,39],parallel:10,physic:[19,37,6],derbi:49,task:10,read:19,predic:8,arithmet:54,alias:7,client:[43,48],command:[46,24,31,9],pattern:8,model:23,sequencefil:21,mariadbstor:49,latest:22}})
\ No newline at end of file
+Search.setIndex({envversion:42,terms:{c_name:53,jconsol:[],four:[45,17],prefix:[11,17],sleep:[],concaten:[],digit:[22,17],everi:[32,7],"void":43,affect:[27,10,17],previou:[8,17],println:43,tajo_src:39,batch:16,enjoi:50,dowload:[],second:[32,15,27,17],aggreg:[11,2,7],even:[32,17],asin:25,char_length:15,directori:[],supplier:9,"new":[32,17,9],metadata:18,ongo:32,elimin:[34,7],abov:[18,2,30,20,50],never:32,o_totalpric:9,here:[20,3,8,50,17],path:[26,42,43,4,34,27,9,53,50],interpret:17,deterior:36,precis:[22,17],datetim:[],sequencefil:[],q_1363768615503_0001_000001:50,substr:[7,15,17],unix:17,total:[7,10],unit:[27,36],highli:39,describ:[42,9],would:[42,39,17],call:[],compressiontyp:20,l_discount:7,until:51,relat:[7,36],supergroup:23,hurt:16,rootdir:[],exce:17,getconnect:43,must:[11,26,43,17,32,7,27,36,22],word:[18,17,10,6],setup:[],work:[22,36,17,9],coalesc:[],era:17,root:[25,44],dayofweek:17,give:[34,7,10],fmdd:17,want:[26,43,14,27,41,42,3,44,30,17,32,19,20,49,50,34,23,53,10],rpad:[],en
d:[23,15,21],quot:[41,17],str2:15,ordinari:17,how:[],env:[],verifi:32,config:[27,42,43,44,32,47,49,51,10],lazybinaryserd:20,updat:32,recogn:6,after:[7,39,17],cli_error_stop:51,befor:[32,2,7,44],parallel:[],attempt:17,third:[27,17],environ:[42,26,3,49,10],enter:[],first:[],order:[43,16,42,3,44,6,18,7,27,9,19,36,22,10,50],to_bin:[],over:7,failur:32,becaus:[32,2,17,7,6],vari:[22,17],digest:[],smallint:22,cli:[38,9],fix:17,persist:[3,27],isodow:17,them:7,thei:[18,8,32,17],binaryserializerdeseri:[18,20],choic:36,subqueri:7,regexp_replac:15,each:[],side:[43,15],mean:[8,17],saturdai:17,resut:25,extract:[17,9],customserializerdeseri:6,network:[],xxtajo:15,content:[12,3,34,27],millennium:17,free:50,standard:[16,22,50,8,17],md5:[],angl:25,filter:[7,8],iso:17,fxyyyi:17,mvn:[42,43,39,27],rang:[],independ:36,rank:[],capac:[44,10],restrict:17,instruct:[42,4],alreadi:32,tpch:[53,9],primari:[32,26],cartesian:7,xii:17,master:[],too:36,listen:[43,44],namespac:43,tool:9,inexact:22,target:[25,14,43,32,
27,39],keyword:[7,20],provid:[46,30,43,32,16,2,3,4,31,6,18,8,27,36,50,23,45,38,51,10,20],expr:7,tree:39,mmdd:17,project:[16,36],minut:[42,40,17],ran:27,mind:17,manner:43,val2:[51,8],current_d:17,usernam:[3,27],microsecond:17,letter:[],phase:19,doi:17,don:[43,39,49,53],doc:9,binaryserd:20,doe:[43,17,32,34,36,7,6],bracket:8,umbil:[32,47,44],section:[42,43,44,17,18,6,40,10],pope:17,random:[],syntax:[7,54],protocol:24,absolut:[25,50,27,9],row_num:7,explain:[3,43,44,6,18,7,40],apach:[],than:[11,25,14,42,17,7,8,40],search_condit:7,fmmonth:17,stop:[32,2],ceil:25,bar:6,method:[],executor_hash_join_size_threshold:51,memstor:27,num:[41,7],result:[12,43,9,17,32,7,36,50],respons:[11,16,2,30,50],best:6,subject:7,awar:10,score:[11,30,50,6,18,20,36],approach:53,accord:[22,7],text_arrai:[],toler:16,cou:[],fault:16,howev:36,against:40,argum:[],cod:[],logic:8,countri:[4,17],com:[32,44,4],split_part:15,guid:9,assum:[30,50,19,10,17],nonsens:17,three:[20,27,17],been:9,much:10,datanod:10,basic:[],concat_
w:[],c_mktsegment:53,suppress:17,xxx:9,worker:[],ani:[43,9,6,32,7,8,27,36],lpad:[],"catch":43,emploi:16,ident:17,geoip:4,servic:[47,27],properti:[],cli_max_column:51,calcul:7,alias_nam:7,conf:[26,27,41,42,3,44,4,32,49,10],march:17,conn:43,perform:7,suggest:21,complex:[7,17],split:15,complet:32,nio:[],jkl:50,rais:25,dskiptest:[42,43,39,27],squar:25,thu:39,inherit:[18,6],to_numb:17,client:[],thi:[11,12,40,43,53,27,42,36,44,50,6,32,7,8,49,21,23,17,39,10,20],roma:17,gzip:36,left:7,identifi:[7,27,17],just:[32,7,8,27,51,23,53],dist_query_groupby_task_volum:51,ordin:[25,17],yet:19,languag:[],easi:[53,31],pdist:[42,43,39,27],backup_and_restor:9,save:[],applic:7,preserv:32,bzip2codec:34,phcatalog:[42,27],background:[],database_nam:[41,34],u0001:6,specif:[22,26,14,32,17],manual:[18,27],timetz:22,right:7,interv:[32,17],intern:49,successfulli:[46,32],cnt:7,insensit:8,multipli:17,tracker:[32,47,44],condit:7,localhost:[41,44,32,47,34,27],core:[43,10],who:6,uncompress:[20,36],character_length:15,r
epositori:21,peer:47,rcfile:[],postgresql:8,dist_query_join_partition_volum:51,total2:7,simul:32,"float":[25,50,6,18,19,20,36,22,10],encod:36,down:[8,40],storag:[26,3,6,18,20,27,36,53],jdbc:[],wai:[32,17,53,6],support:[],avail:[],width:17,editor:[32,44],fraction:17,o_custkei:9,form:[18,26,7],forc:[7,17],drwxr:23,time_arrai:[],l_comment:34,"true":[4,32,20,27,36,22,10,8],type:[],vatican:17,trim:15,featur:[11,18,42,36,6],semicolon:[23,30],tajocli:32,exist:[34,18,14,41],quantiti:7,check:[],"52nd":17,floor:25,when:[],getstr:43,hh12:17,test:27,node:[32,43,44,10],intend:17,consid:32,abscissa:25,carriag:6,ignor:[10,17],time:32,backward:10,concept:[43,17],skip:17,consum:36,boolean_express:7,row:[11,30,36,50,6,18,7,8,27,9,20],millisecond:17,depend:[32,42,43,8],zone:[22,17],unpack:[],decim:[22,17],hadmin:32,drivermanag:43,jvm:32,sql_languag:9,sourc:[],string:[],hdfs_locat:18,exact:22,administr:[],did:17,"12th":17,item:[23,8,17],sine:25,div:25,tajo_hom:[43,27,41,3,44,32,49,50],dir:[44,14,10],pr
event:32,templet:49,sign:[25,8],long_table_name_1234:7,cost:16,port:[26,41,46,43,44,32,27],addr:[4,27],current:[26,43,41,42,36,31,17,32,7,8,27,9,45,10],deriv:7,gener:[],stmt:43,tangent:25,address:[44,4,32,47,27,22],wait:32,shift:17,csvfile_nul:[],behav:7,commonli:6,regardless:[18,36],modul:[12,49],"1st":17,instal:[4,27,39],to_char:17,memori:[],connector:[42,27],tajo_pid_dir:32,capit:17,claus:[],prepar:[42,39,27,50],uniqu:51,cat:[11,32,44,53,50],can:[3,6,7,8,9,10,11,12,17,18,19,20,21,23,27,32,34,36,38,39,42,43,44,49,50],purpos:[42,49],fmss:17,nearest:[25,17,9],backslash:[17,9],occur:[34,18,7,17],alwai:17,sundai:17,multipl:[32,17,7,10,6],haadmin:32,write:[18,36,17,20,6],purg:34,c_address:53,map:22,product:7,date_arrai:[],atan:25,max:[],clone:[27,21],"4th":17,mai:[30,27,3,17,32,7,49,39],underscor:8,data:[],favorit:[32,44],predic:[],inform:[32,17,27,9],preced:[4,17],combin:7,hh24:17,ghi:50,midnight:17,still:32,ieee:22,dynam:16,entiti:32,divis:25,group:[7,8,36],monitor:32,window:12,main:
[16,43,8,49],non:[36,7,17],synopsi:[],add_month:17,col2:[14,8],col3:14,initi:32,col1:[14,8],now:[9,17,18,36,51,53,6,39],nor:8,introduct:[],hive_jdbc_driver_dir:[42,27],name:[4,6,7,9,10,11,17,18,20,22,26,49,32,36,38,53,41,42,43,44,47,27,50,51],reoptim:16,revers:[],separ:[30,17,7,20,6],januari:17,clsspath:43,quarter:17,tajo_worker_heaps:10,compil:[42,39,27],failov:[],domain:[32,44,8,6],replac:[15,17],individu:7,current_tim:17,year:[7,17],shown:17,space:[15,17],o_orderkei:9,profil:[42,27],hivemetastor:[42,27],partit:[],git:[],org:[43,42,9,6,18,34,20,27,21],"byte":[22,36,50,9],card:19,care:[17,6],p_id:11,codegen:51,place:9,standbi:32,think:50,str1:15,oper:[],directli:[19,6],onc:[32,7,4],arrai:8,o_orderd:9,submit:[32,40,50],open:16,given:[14,15,50,4,17,41,7,8,9,34,22],paramt:11,l_partkei:[34,14,7],float8_arrai:[],especi:22,copi:[27,49],specifi:[26,14,41,46,42,43,4,6,18,54,7,8,27,36,22,23,17,39,10,20],github:21,enclos:7,mostli:18,geoip_country_cod:4,serv:32,serd:[],posix:8,balanc:16,were:
[],argument:[25,30,17,7,9,23],maxmind:4,techniqu:16,partsupp:9,note:[8,27,17],take:[42,7,40,21],xxxxxx:27,channel:[],begin:[17,9],c_nationkei:53,buffer:[24,36],price:19,compress:[],deflatecodec:34,pair:[18,20,49],later:40,executor_inner_hash_join_size_threshold:51,axi:25,show:[46,43,50,51,9,40],ship_dat:19,xml:[],onli:[26,27,3,31,17,18,7,20,49,21,36,6],explicitli:[7,49],ratio:10,activ:32,written:[18,20],"53rd":17,variou:[51,17],get:[],client_session_expiry_tim:51,repo:[27,21],cannot:6,java_hom:3,progress:[11,16,2,46,30],requir:[32,30,3,7,17],table_refer:7,item_nam:19,borrow:8,across:[44,7],where:[],calendar:17,concern:[53,49],detect:32,enough:27,ddsp:17,between:[43,8],"import":43,c_custkei:53,int8_arrai:[],parent:39,executor_groupby_inmemory_hash_threshold:51,hadoop_hom:[3,44],gregorian:17,decimaln:9,region:9,gzipcodec:34,groupbi:[],compressioncodec:[18,6],improv:36,pow:25,period:[32,17],xzvf:[43,39,21],date_ord:51,invers:9,dist_query_broadcast_join_threshold:51,derbystor:[32,27],th
ose:[18,36,43,6],"case":[15,43,17,18,8,49,27,20],hdf:[],invok:32,advantag:36,ctrl:[32,44,50],cluster:[],warehous:[16,23,34],abcdef:15,ascii:[],develop:[12,21],same:[25,42,4,17,32,7,8],binari:[],epoch:17,html:9,pad:17,document:[],week:17,finish:32,nest:36,driver:[],decompress:[36,21],tajo_classpath:27,mani:[18,43,10,9],extern:[34,18,19,53,50],appropri:[49,50],choos:[39,21],without:[30,16,17,19,27,7,6],fmmm:17,model:[],fmmi:17,execut:[],rest:7,kill:[46,32],inet4:[22,4],except:[43,7,27,17],param:[11,41,7],blob:22,exercis:40,overview:[],disrupt:32,real:[],read:[],"4028235e":22,mon:17,mod:25,integ:[25,22,17,10,9],server:[46,32,3,27,49],query_succeed:50,benefit:31,either:[42,21,7,8,36,22],output:[14,7,20,17],tajo:[],result_set_fetch_rownum:51,yyyi:17,ascend:7,tajowork:[32,49,10],test_broadcast_join_en:51,definit:[],exit:2,ddl:[53,50],refer:[43,3,44,4,6,18,7,20,9,36,50],power:[25,8],inspect:38,broken:6,starttim:46,regexp:8,"throw":43,comparison:[22,8],central:32,aco:[25,9],degre:[25,44],yy
yymondd:17,effici:36,lastli:27,defaultport:27,yyi:17,your:[53,26,43,27,32,42,3,44,17,18,49,21,40,36,6,39],overwrit:[],start:[],current_databas:51,ipv4:[22,4],untar:21,jun:17,tajoxx:15,max_output_file_s:51,possibl:[7,10,17],"default":[],day_of_week:17,embed:27,connect:[42,43,41,27,9,51],creat:[],certain:[18,36,14,6],file:[],fill:[43,17],incorrect:32,denot:8,sort_expr:7,tinyint:22,prepend:[],field:[17,9,15,6],valid:17,rdbm:43,you:[2,3,4,6,7,8,9,10,11,53,30,14,17,18,19,20,21,40,23,26,27,32,34,36,39,41,42,43,44,49,50],architectur:[],polar:25,sequenc:8,symbol:11,text_nul:51,briefli:7,tajomast:[],concat:[],hyunsik:[53,9],descript:[46,50,17,32,47,8,27,9,22,10],tajo_master_heaps:26,cpu:10,unset:[51,9],tajodriv:43,represent:[36,17],all:[43,46,42,3,44,4,17,32,7,8,27,9,51,53,50],dist:[43,39,27],month:17,scalar:[7,36],abil:32,mno:50,follow:[2,4,6,7,8,9,10,11,53,30,14,46,17,18,19,20,21,22,23,26,27,31,32,34,36,39,41,42,43,44,45,49,50,51],disk:[4,10],init:50,program:[49,36],thursdai:17,liter:[17,4
9,6],fals:[22,36,4,8],util:38,worst:16,fall:[7,17],veri:[3,44,8],list:[],adjust:[26,17,18,36,6,10],cosin:[25,9],small:[22,36],tmmonth:17,ten:[42,40],past:17,zero:[8,17],design:[16,19,49,36],pass:7,val3:51,further:6,val1:[51,8],what:17,abc:[8,50],clock:17,sum:[11,30,7],abbrevi:17,version:[39,27,9],sup:[],to_dat:17,"public":43,expon:25,full:[7,17],hash:[],valn:8,initcap:[],strong:53,modifi:17,valu:[],search:12,cli_print_error_trac:51,table_backup:53,amount:32,behavior_arithmetic_abort:51,codebas:21,via:[],data_typ:34,primit:22,transit:32,filenam:41,select:[],hexadecim:[],l_extendedpric:7,distinct:[7,17],two:[3,31,17,18,8,49,53,54,20],toggl:17,more:[11,30,42,50,44,17,7,8,27,36,40,10],flat:[18,20,36],discompress:39,function_nam:54,known:19,timestamp_arrai:[],hour:17,formatha:32,dev:[],histori:32,orderbi:12,archiv:[39,27],learn:3,def:50,bewtween:22,buit:[],prompt:[41,30,9],num1:25,num2:25,share:[18,43,7],templat:[27,17],tabular:6,minimum:[],goal:16,divid:[25,7,17],anoth:[32,54],mapr:20,c
sv:[],simpl:[3,50],blockcompresswrit:20,jline2:2,resourc:[],resultset:43,catalog:[],mariadb:27,"short":[18,7],caus:[32,17],atan2:25,help:9,pseudorandom:[],paramet:[],style:8,late:17,"return":[25,15,4,17,8,6],timestamp:[22,17],o_orderstatu:9,ssss:17,framework:36,utc_usec_to:[17,9],serde2:[18,20],easili:[32,43,44],radian:25,found:23,unicod:22,compatibl:53,truncat:25,unequ:32,procedur:39,expect:17,o_clerk:9,"try":[32,43,41],aggregatio:[],print:17,occurr:[],qualifi:[],advanc:[16,7],asc:7,asf:[27,21],put:[11,17],fridai:17,launch:[],omit:[18,17,7,9],round:[25,9],feed:6,meridiem:17,upper:[15,17],feel:50,applciat:43,number:[],done:[39,17],unhealthi:32,blank:17,differ:[7,8,17],exponenti:[],interact:[16,41,50],least:[7,8],saint:17,twenti:17,scheme:[26,50],store:[11,32,16,42,3,6,18,20,27,9,10,50],schema:[9,14,50,19,36,38],statement:[11,43,14,41,46,36,50,6,18,7,8,9,34,20],part:[17,9],kind:7,remot:44,remov:[3,34,15,27],l_orderkei:[34,14,7],str:[],comput:[7,17],packag:[42,43],"null":[],option:[11
,46,17,41,34,7,53,39],catalogstor:32,built:[18,43,9],equival:[14,7,17],also:[21,50,17,32,19,8,27,9,51,7,6,20],build:[],brace:11,distribut:[],str_arr:[],exec:20,filesystem:[40,21],mixtur:17,most:[27,6],plan:[16,19,6],metacharact:8,lc_time:17,appear:7,clear:9,salari:7,classnotfoundexcept:43,clean:[42,43,39,27],session:[],find:32,copyright:9,l_quantiti:[14,7],test_filter_pushdown_en:51,unresolvedaddressexcept:[],express:[],longest:[],strposb:[],statist:32,bytea:22,set:[],startup:41,see:[3,44,17,27,50,10],arc:25,float8:[25,22,14,53,9],arg:[46,43],float4:[22,9],close:43,unqualifi:[19,7],smallest:[25,36],subdir:14,"\u02c6ab":15,altern:8,numer:17,fsshell:23,add_dai:17,outfil:53,both:[15,32,16,6,18,7,20],last:[7,17],delimit:[50,34,15,6],c_comment:53,roman:17,context:17,whole:10,load:[16,50],simpli:39,point:[18,32,17],header:18,littl:44,shutdown:32,suppli:17,transitiontobackup:32,cathedr:17,becom:[32,17],java:[],stamp:[],due:10,empti:[18,7,6],versa:18,iddd:17,ecosystem:36,tajojdbccli:43,coor
din:25,func:7,repetit:8,convers:[],look:[],iyi:17,tajoresourcemanag:32,durat:27,"while":[43,17],behavior:7,error:[34,17],table_nam:[34,53],key1:51,tbname:9,itself:[32,9],centuri:17,grant:27,belong:7,shorten:27,hadoop:[40,43,16,3,44,50,6,18,34,8,49,36,23,24,39,20],decod:[],dtar:[42,43,39,27],conflict:32,higher:24,varbit:22,lineitem:[34,14,46,7,9],optim:16,fornam:43,moment:[36,6],user:[],tsql:[],chang:[44,21,43,27,9],lower:[15,17],lib:27,entri:[32,34,44],parenthes:[7,8],explan:50,construct:[7,17],mysql:[42,27],coun:[],snappi:36,all_backup:53,disk1:10,disk2:10,disk3:10,shortcut:23,cbrt:25,input:[25,15,17],subsequ:17,euler:25,bin:[11,30,41,2,3,44,53,32,27,50,42],complaint:17,varchar:22,format:[],subfield:17,bit:22,table1:[11,30,43,50,6,18,7,8,36,20],collect:20,"boolean":[22,7,4,36],order_d:19,createstat:43,some:[12,27,42,2,3,6,18,7,49,36,22,17,39,50],back:32,global:17,mirror:21,scale:16,"512mb":10,per:[51,32,44,10],cast:[],machin:[32,27,41],o_shipprior:9,run:[],dist_query_table_partitio
n_volum:51,hive_hom:[42,27],step:39,subtract:17,varbinari:22,manag:[],regular:[],"1gb":[26,10],block:[20,36],test_min_task_num:51,executor_outer_hash_join_size_threshold:51,columnarserd:18,primarili:17,within:[32,23,7,17],ensur:[3,27],textual:[],custom:[],arithmet:[],includ:[43,7,10,17],unix_timestamp:17,int4:[22,14,15,9],link:21,translat:17,select_stat:34,int2:22,l_shipdat:7,int8:[25,22,14,53,9],info:[46,32,47],utc:17,consist:[17,18,7,20,49,6],queryid:46,remaind:25,constant:25,repres:[17,6],"char":[22,17],home:[42,3,53,27,50],hiveql:42,debug_en:51,codec:[18,34,20,6],exp:25,introduc:[],algorithm:[18,36,10,6],vice:18,dow:17,hello:17,code:[],xyxtrimyyx:[],queri:[],privat:43,dist_query_join_task_volum:51,executor_external_sort_buffer_s:51,csvfile:6,volum:[50,9],implicitli:7,dbname:9,tri:43,recordcompresswrit:20,descend:7,hive:[],unquot:9,date_part:17,dealt:7,ddd:17,pleas:[43,3,44,4,17,18,7,36,6,53,10,50],smaller:14,natur:7,timestamptz:22,download:4,click:21,tmpdir:10,compat:[],index:12
,compar:22,access:[32,42,43,44,36],c_phone:53,"19th":17,fmhh:17,showmast:46,let:20,o_orderprior:9,vertic:6,sinc:[18,27,17],convert:[25,32,4,54,17],aaabc:8,weekdai:17,derbi:[],larger:[22,7,36],earli:17,typic:7,appli:[32,17],approxim:22,api:[],namenode_hostnam:26,wip:[27,21],cha:[],from:[],c_acctbal:53,next:[42,43,17],few:49,chr:[],usr:27,find_in_set:[],sort:7,src:[21,43,17],mismatch:12,trail:[15,17],name2:51,name3:51,name1:51,retriev:17,alia:[22,7,15,9],parquet:[],control:32,tar:[43,39,27,21],process:[],high:[],query_run:46,tab:6,tarbal:32,tan:25,concatnen:15,isoyear:17,geoip_country_co:[],instead:[17,41,8,27,50,6],sin:25,transitiontoact:32,ltrim:15,o_com:9,getstat:32,physic:[],essenti:32,cli_print_paus:51,correspond:[18,7],element:[32,49],cli_null_char:51,column_refer:8,allow:[11,26,42,50,44,17,18,7,36,34,6,10],move:39,comma:[17,7,6],outer:7,decad:17,bye:50,crash:32,greater:25,handl:[],spell:17,dai:17,mention:18,lzo:36,anyth:[],mode:[],recommend:[39,17],meta:[],"static":43,our:6,spe
cial:6,out:10,variabl:[],suitabl:[],math:[],common:7,shut:40,manipul:51,standalon:40,dictionari:36,could:17,keep:17,length:[22,17],timezon:51,suffix:17,resourceconfigur:10,date:53,"long":[16,7,17],quote_id:[],licens:9,mkdir:[23,44,50],system:[43,27,32,16,3,44,18,49,23,39,10],termin:6,bit_length:[],"final":[42,43,27,50],q_1411357607375_0006:46,mysql_jdbc_driv:[42,27],shell:[],grouping_column_refer:7,rtrim:15,exactli:8,haven:19,prune:[],charact:[15,17,18,19,8,22,6],sec:[11,30,46,2,27,50],textserd:20,julian:17,have:[12,26,42,17,34,27],tabl:[],need:[43,32,42,3,17,18,20,27,36,6,53,50],issu:[],min:[],mix:17,which:[43,32,16,3,41,17,18,7,20,27,50,51,34],singl:[],lineitem_100_snappi:34,unless:17,preliminari:[],lazybinari:20,oracl:17,deploi:32,"class":[42,43,6,18,8,27,20],url:[26,43],request:10,uri:[32,27],snapshot:[39,27],determin:[7,10],querymast:[32,10],text:[11,15,32,36,44,4,50,6,18,19,8,9,34,22,17,53,20],locat:[43,14,3,4,18,34,27,50,53,10],jar:[42,43,27],should:[26,41,42,43,44,4,17,18,19
,27,36,34,53,6,40,10,50],jan:17,local:[],cube:25,familiar:[18,36,6],disagre:17,increas:44,enabl:[32,43,44,6,18,27,36],grtajo01:46,ddth:17,integr:[],dist_query_sort_task_volum:51,contain:[32,43,34,44,17],dhadoop:39,legaci:4,frame:7,knowledg:6,rlike:8,statu:32,correctli:[22,39],pattern:[],to_timestamp:17,cli_print_pause_num_record:51,theta:25,neither:8,kei:[11,31,17,18,19,20,51,34],disconnect:[51,32],addit:[14,43,7,8,10],admin:[46,9],etc:38,instanc:[26,3,44,40],fmyyyi:17,chmod:44,rpc:[32,47,43,44],respect:[22,8],tuesdai:17,quit:9,compos:[19,36],compon:32,json:6,besid:6,sequecnefil:20,representati:[],columnar:[18,36],cli_output_formatter_class:51,togeth:17,present:[40,9],"85e7":17,therefor:[32,17],implementaion:26,plain:[18,20],octet_length:[],rectangular:25,defin:6,wild:19,lazybinarycolumnarserd:18,textserializerdeseri:[18,20,6],layer:26,site:[],bigint:[22,34],textfil:[],avg:[],to_hex:[],"35b":50,classpath:[],sqrt:25,largest:25,http:[9,4,32,47,27,21],hostnam:[41,26,43,44,27],geoip_in_
countri:4,column_nam:34,retriv:43,nation:9,off:17,well:[34,22,14,17],exampl:[],command:[],english:17,usual:[49,6],less:[25,17],percent:8,tcp:41,current_timestamp:17,simultan:10,web:[16,32],script:[39,49],add:[43,27,42,3,44,32,34,49,23,10],host2:[32,44],host1:[32,44],work1:9,match:[],iyyi:17,workload:10,know:[44,50,7,17],createdatabaseifnotexist:27,password:27,desc:[46,7],insert:[],storage_typ:34,resid:50,like:[],necessari:16,page:[12,44,36],another_long_table_name_5678:7,drop:[],linux:9,"export":[42,3,27],yyyymmdd:17,proper:[26,3,39,10,27],guarante:32,peter:17,tmp:[23,3,26,27,50],lead:[19,15,17],avoid:[16,32,2,34,17],boolean_arrai:[],xtajoxx:15,ab_bc_cd:15,usag:[],maven:[42,39,27],host:[41,46,43,44,32,27],although:17,empsalari:7,stage:50,actual:12,dist_query_groupby_partition_volum:51,column:[],disabl:[18,36,6],own:6,automat:[],distinct_a:[],val:51,pictur:9,trigger:32,q_1411357607375_0007:46,inner:7,"var":27,snappycodec:[18,34,20,6],test_join_opt_en:51,count:[11,30,15,46,17,7],temp:
23,whether:[18,7,8],wish:11,record:[18,36,8,20,6],below:[40,17,18,36,6,53],limit:[12,10],otherwis:[41,17,7,4,8],problem:[32,2],executequeri:43,btrim:15,"int":[25,15,50,17,18,19,20,36,22,6],dure:19,pid:32,novemb:17,implement:[12,17,3,9],"20000nov31":17,appendi:[],boot:[3,27],detail:[46,9,44,17,7,27,36,50],other:[14,32,16,17,18,7,49,6,10],bool:22,branch:12,varieti:49,repeat:17,row_numb:7,mondai:17,strpo:[],select_list:7,decemb:17},objtypes:{"0":"py:function"},objnames:{"0":["py","function","Python
function"]},filenames:["partitioning/hash_partitioning","backup_and_restore","tsql/background_command","getting_started/local_setup","functions/network_func_and_operators","partitioning/range_partitioning","table_management/csv","sql_language/queries","sql_language/predicates","tsql/meta_command","configuration/worker_configuration","tsql/execute_file","index","functions","sql_language/insert","functions/string_func_and_operators","introduction","functions/datetime_func_and_operators","table
_management/rcfile","partitioning/column_partitioning","table_management/sequencefile","getting_started/downloading_source","sql_language/data_model","tsql/dfs_command","getting_started/prerequisites","functions/math_func_and_operators","configuration/tajo_master_configuration","configuration/catalog_configuration","table_management/compression","faq","tsql/single_command","partitioning/intro_to_partitioning","configuration/ha_configuration","table_partitioning","sql_language/ddl","table_management","table_management/parquet","configuration","tsql","getting_started/building","getting_started","tsql/intro","hcatalog_integration","jdbc_driver","configuration/cluster_setup","table_management/file_formats","tsql/admin_command","configuration/configuration_defaults","tajo_client_api","configuration/preliminary","getting_started/first_query","tsql/variables","sql_language","backup_and_restore/catalog","sql_language/sql_expression"],titles:["Hash
Partitioning","Backup and Restore","Executi
ng as background process","Setting up a local Tajo cluster","Network Functions
and Operators","Range Partitioning","CSV
(TextFile)","Queries","Predicates","Meta Commands","Worker
Configuration","Executing Queries from Files","Apache Tajo\u2122 (dev) - User
documentation","Functions","INSERT (OVERWRITE) INTO","String Functions and
Operators","Introduction","DateTime Functions and Operators","RCFile","Column
Partitioning","SequenceFile","Dowload and unpack the source code","Data
Model","Executing HDFS commands","Prerequisites","Math Functions and
Operators","Tajo Master Configuration","Catalog
Configuration","Compression","FAQ","Executing a single command","Introduction
to Partitioning","High Availability for TajoMaster","Table Partitioning","Data
Definition Language","Table Management","Parquet","Configuration","Tajo Shell
(TSQL)","Build source code","Getting Started","Introducing to TSQL","HCatalog
Integration","Tajo JDBC Driver","Cluster Setup","File Formats","Administration
Comman
ds","Configuration Defaults","Tajo Client API","Preliminary","First query
execution","Session Variables","SQL Language","Backup and Restore Catalog","SQL
Expressions"],objects:{"":{trim:[15,0,1,""],upper:[15,0,1,""],to_char:[17,0,1,""],btrim:[15,0,1,""],regexp_replace:[15,0,1,""],pow:[25,0,1,""],split_part:[15,0,1,""],sign:[25,0,1,""],geoip_country_code:[4,0,1,""],to_date:[17,0,1,""],tan:[25,0,1,""],extract:[17,0,1,""],asin:[25,0,1,""],floor:[25,0,1,""],sqrt:[25,0,1,""],acos:[25,0,1,""],char_length:[15,0,1,""],current_date:[17,0,1,""],abs:[25,0,1,""],degrees:[25,0,1,""],cbrt:[25,0,1,""],pi:[25,0,1,""],sin:[25,0,1,""],ltrim:[15,0,1,""],atan:[25,0,1,""],current_time:[17,0,1,""],lower:[15,0,1,""],ceil:[25,0,1,""],atan2:[25,0,1,""],rtrim:[15,0,1,""],now:[17,0,1,""],utc_usec_to:[17,0,1,""],geoip_in_country:[4,0,1,""],mod:[25,0,1,""],cos:[25,0,1,""],radians:[25,0,1,""],date_part:[17,0,1,""],to_timestamp:[17,0,1,""],add_months:[17,0,1,""],add_days:[17,0,1,""],exp:[25,0,1,""],div:[25,0,1,""
],round:[25,0,1,""]}},titleterms:{code:[43,39,21],execut:[11,2,30,23,50],enter:41,queri:[11,7,50],session:51,permiss:44,hcatalogstor:27,languag:[52,34],paramet:11,xml:49,binari:43,writer:20,apach:[18,12,36,19,6],configur:[26,32,47,27,37,10],window:7,master:[32,26,47],local:3,match:8,real:22,sourc:[43,39,21],synopsi:[46,41],string:[8,54,15],get:[43,40],handl:6,nio:43,faq:[29,43],terminolog:32,background:2,insert:14,introduct:[16,31],mysqlstor:27,csv:6,like:8,administr:[46,32],level:53,drop:34,list:[],hive:[18,36,19,6],integr:42,partit:[0,33,19,31,5],each:10,fulli:44,tajo:[12,26,43,18,3,44,32,47,48,49,38],manag:35,failov:32,set:[11,32,3,43,44],hcatalog:42,dump:53,dowload:21,meta:9,download:21,run:10,todo:[0,28,29,5,48,53],out:21,compat:[18,36,19,6],network:4,hdf:23,databas:[34,53],preliminari:49,definit:34,state:32,method:31,math:25,mode:[44,10],qualifi:7,hash:0,compress:[28,34],gener:18,usag:[11,46,9],serializerdeseri:20,base:44,prerequisit:[24,4],releas:21,java:43,rcfile:18,valu:[11
,22,6],convers:17,launch:[32,44],column:19,where:7,groupbi:7,datetim:17,backup:[32,1,53],first:50,oper:[25,17,4,15],rang:5,via:21,overview:7,format:[45,17],sql:[11,52,53,54],number:[22,10],automat:32,api:48,select:[],size:[26,10],git:21,from:[11,43,7],memori:[26,10],tsql:[41,38],support:4,doubl:22,overwrit:14,custom:6,avail:32,start:40,singl:30,call:54,basic:[11,46,9],arithmet:54,type:[22,7,54],"function":[25,13,15,4,17,7,54],shell:[41,38],claus:7,worker:[47,44,10],rootdir:26,heap:[26,10],jdbc:43,line:[],unpack:21,join:7,prune:19,restor:[1,53],"default":47,setup:44,properti:[18,36,6],maximum:10,dev:12,orderbi:7,cast:54,serd:20,limit:7,introduc:[41,20],parquet:36,similar:8,file:[11,32,45],creat:[34,18,36,19,6],process:2,tabl:[12,6,18,33,19,35,36,34,7],site:49,indic:12,high:32,cluster:[32,3,44],unresolvedaddressexcept:43,textfil:6,have:7,interfac:[],dedic:10,"null":6,serial:[18,6],make:44,ilik:8,when:18,cross:7,check:21,how:[32,43,6,18,19,36],client:[43,48],read:18,build:[43,39],env:4
9,test:32,document:12,channel:43,variabl:51,express:[8,54],resourc:10,distribut:[43,44],classpath:43,time:17,driver:43,catalog:[27,49,53],regular:8,temporari:10,user:12,tajomast:[32,26],date:17,data:[22,34,10],parallel:10,physic:[18,36,6],derbi:27,task:10,directori:[44,10],predic:8,issu:[18,36,19,6],alias:7,exampl:[43,7,10],command:[46,23,30,9],pattern:8,model:22,sequencefil:20,mariadbstor:27,latest:21}})
\ No newline at end of file
Modified: tajo/site/docs/current/sql_language/ddl.html
URL:
http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/ddl.html?rev=1637798&r1=1637797&r2=1637798&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/ddl.html (original)
+++ tajo/site/docs/current/sql_language/ddl.html Mon Nov 10 06:57:43 2014
@@ -205,7 +205,7 @@
<span class="p">...</span>
<span class="n">L_COMMENT</span> <span class="nb">text</span><span
class="p">)</span>
-<span class="k">USING</span> <span class="n">csv</span> <span
class="k">WITH</span> <span class="p">(</span><span
class="s1">'csvfile.delimiter'</span><span class="o">=</span><span
class="s1">'|'</span><span class="p">,</span><span
class="s1">'compression.codec'</span><span class="o">=</span><span
class="s1">'org.apache.hadoop.io.compress.DeflateCodec'</span><span
class="p">)</span>
+<span class="k">USING</span> <span class="n">csv</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">'compression.codec'</span><span class="o">=</span><span
class="s1">'org.apache.hadoop.io.compress.DeflateCodec'</span><span
class="p">)</span>
<span class="k">LOCATION</span> <span
class="s1">'hdfs://localhost:9010/tajo/warehouse/lineitem_100_snappy'</span><span
class="p">;</span>
</pre></div>
</div>
Modified: tajo/site/docs/current/table_management/csv.html
URL:
http://svn.apache.org/viewvc/tajo/site/docs/current/table_management/csv.html?rev=1637798&r1=1637797&r2=1637798&view=diff
==============================================================================
--- tajo/site/docs/current/table_management/csv.html (original)
+++ tajo/site/docs/current/table_management/csv.html Mon Nov 10 06:57:43 2014
@@ -197,8 +197,8 @@ statement. The below is an example state
The <tt class="docutils literal"><span class="pre">WITH</span></tt> clause in
the CREATE TABLE statement allows users to set those parameters.</p>
<p>Now, the CSV storage format provides the following physical properties.</p>
<ul class="simple">
-<li><tt class="docutils literal"><span
class="pre">csvfile.delimiter</span></tt>: delimiter character. <tt
class="docutils literal"><span class="pre">|</span></tt> or <tt class="docutils
literal"><span class="pre">\u0001</span></tt> is usually used, and the default
field delimiter is <tt class="docutils literal"><span
class="pre">|</span></tt>.</li>
-<li><tt class="docutils literal"><span class="pre">csvfile.null</span></tt>:
NULL character. 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">text.delimiter</span></tt>:
delimiter character. <tt class="docutils literal"><span
class="pre">|</span></tt> or <tt class="docutils literal"><span
class="pre">\u0001</span></tt> is usually used, and the default field delimiter
is <tt class="docutils literal"><span class="pre">|</span></tt>.</li>
+<li><tt class="docutils literal"><span class="pre">text.null</span></tt>: NULL
character. 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><tt class="docutils literal"><span class="pre">csvfile.serde</span></tt>:
custom (De)serializer class. <tt class="docutils literal"><span
class="pre">org.apache.tajo.storage.TextSerializerDeserializer</span></tt> is
the default (De)serializer class.</li>
</ul>
@@ -208,8 +208,8 @@ The <tt class="docutils literal"><span c
<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">CSV</span> <span class="k">WITH</span><span class="p">(</span><span
class="s1">'csvfile.delimiter'</span><span class="o">=</span><span
class="s1">'\u0001'</span><span class="p">,</span>
- <span class="s1">'csvfile.null'</span><span
class="o">=</span><span class="s1">'\\N'</span><span class="p">,</span>
+<span class="p">)</span> <span class="k">USING</span> <span
class="n">CSV</span> <span class="k">WITH</span><span class="p">(</span><span
class="s1">'text.delimiter'</span><span class="o">=</span><span
class="s1">'\u0001'</span><span class="p">,</span>
+ <span class="s1">'text.null'</span><span
class="o">=</span><span class="s1">'\\N'</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>
</div>
@@ -241,7 +241,7 @@ The property value should be a fully qua
<p>In default, NULL character in CSV files is an empty string <tt
class="docutils literal"><span class="pre">''</span></tt>.
In other words, an empty field is basically recognized as a NULL value in Tajo.
If a field domain is <tt class="docutils literal"><span
class="pre">TEXT</span></tt>, an empty field is recognized as a string value
<tt class="docutils literal"><span class="pre">''</span></tt> instead of NULL
value.
-Besides, You can also use your own NULL character by specifying a physical
property <tt class="docutils literal"><span
class="pre">csvfile.null</span></tt>.</p>
+Besides, You can also use your own NULL character by specifying a physical
property <tt class="docutils literal"><span
class="pre">text.null</span></tt>.</p>
</div>
<div class="section" id="compatibility-issues-with-apache-hive">
<h2>Compatibility Issues with Apache Hiveâ¢<a class="headerlink"
href="#compatibility-issues-with-apache-hive" title="Permalink to this
headline">¶</a></h2>
Modified: tajo/site/docs/current/tsql/variables.html
URL:
http://svn.apache.org/viewvc/tajo/site/docs/current/tsql/variables.html?rev=1637798&r1=1637797&r2=1637798&view=diff
==============================================================================
--- tajo/site/docs/current/tsql/variables.html (original)
+++ tajo/site/docs/current/tsql/variables.html Mon Nov 10 06:57:43 2014
@@ -216,7 +216,7 @@ default> \set
<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">CSVFILE_NULL</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>
