Author: jihoonson
Date: Wed Jan  7 08:45:49 2015
New Revision: 1650014

URL: http://svn.apache.org/r1650014
Log:
TAJO-1245: Add documentation about PostgreSQL and Oracle Catalog driver

Modified:
    tajo/site/docs/current/_sources/backup_and_restore/catalog.txt
    tajo/site/docs/current/_sources/configuration/catalog_configuration.txt
    tajo/site/docs/current/_sources/getting_started.txt
    tajo/site/docs/current/_sources/jdbc_driver.txt
    tajo/site/docs/current/backup_and_restore.html
    tajo/site/docs/current/backup_and_restore/catalog.html
    tajo/site/docs/current/configuration.html
    tajo/site/docs/current/configuration/catalog_configuration.html
    tajo/site/docs/current/configuration/cluster_setup.html
    tajo/site/docs/current/configuration/ha_configuration.html
    tajo/site/docs/current/configuration/preliminary.html
    tajo/site/docs/current/configuration/tajo_master_configuration.html
    tajo/site/docs/current/configuration/worker_configuration.html
    tajo/site/docs/current/faq.html
    tajo/site/docs/current/functions.html
    tajo/site/docs/current/functions/datetime_func_and_operators.html
    tajo/site/docs/current/functions/math_func_and_operators.html
    tajo/site/docs/current/functions/network_func_and_operators.html
    tajo/site/docs/current/functions/string_func_and_operators.html
    tajo/site/docs/current/genindex.html
    tajo/site/docs/current/getting_started.html
    tajo/site/docs/current/hcatalog_integration.html
    tajo/site/docs/current/index.html
    tajo/site/docs/current/introduction.html
    tajo/site/docs/current/jdbc_driver.html
    tajo/site/docs/current/objects.inv
    tajo/site/docs/current/partitioning/column_partitioning.html
    tajo/site/docs/current/partitioning/hash_partitioning.html
    tajo/site/docs/current/partitioning/intro_to_partitioning.html
    tajo/site/docs/current/partitioning/range_partitioning.html
    tajo/site/docs/current/search.html
    tajo/site/docs/current/searchindex.js
    tajo/site/docs/current/sql_language.html
    tajo/site/docs/current/sql_language/data_model.html
    tajo/site/docs/current/sql_language/ddl.html
    tajo/site/docs/current/sql_language/insert.html
    tajo/site/docs/current/sql_language/predicates.html
    tajo/site/docs/current/sql_language/queries.html
    tajo/site/docs/current/sql_language/sql_expression.html
    tajo/site/docs/current/table_management.html
    tajo/site/docs/current/table_management/compression.html
    tajo/site/docs/current/table_management/csv.html
    tajo/site/docs/current/table_management/file_formats.html
    tajo/site/docs/current/table_management/parquet.html
    tajo/site/docs/current/table_management/rcfile.html
    tajo/site/docs/current/table_management/sequencefile.html
    tajo/site/docs/current/table_partitioning.html
    tajo/site/docs/current/tajo_client_api.html
    tajo/site/docs/current/tsql.html
    tajo/site/docs/current/tsql/admin_command.html
    tajo/site/docs/current/tsql/background_command.html
    tajo/site/docs/current/tsql/dfs_command.html
    tajo/site/docs/current/tsql/execute_file.html
    tajo/site/docs/current/tsql/intro.html
    tajo/site/docs/current/tsql/meta_command.html
    tajo/site/docs/current/tsql/single_command.html
    tajo/site/docs/current/tsql/variables.html

Modified: tajo/site/docs/current/_sources/backup_and_restore/catalog.txt
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/backup_and_restore/catalog.txt?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/backup_and_restore/catalog.txt (original)
+++ tajo/site/docs/current/_sources/backup_and_restore/catalog.txt Wed Jan  7 
08:45:49 2015
@@ -11,7 +11,7 @@ Now, Tajo supports a two backup methods
 SQL dump 
 ==========
 
-SQL dump is an easy and strong way. If you use this approach, you don't need 
to concern database-level compatiblities. If you want to backup your catalog, 
just use bin/tajo-dump command. The basic usage of this command is: ::
+SQL dump is an easy and strong way. If you use this approach, you don't need 
to concern database-level compatibilities. If you want to backup your catalog, 
just use bin/tajo-dump command. The basic usage of this command is: ::
 
   $ tajo-dump table_name > outfile
 

Modified: 
tajo/site/docs/current/_sources/configuration/catalog_configuration.txt
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/configuration/catalog_configuration.txt?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/configuration/catalog_configuration.txt 
(original)
+++ tajo/site/docs/current/_sources/configuration/catalog_configuration.txt Wed 
Jan  7 08:45:49 2015
@@ -56,11 +56,13 @@ Since Derby is a file-based embedded dat
 
   By default, *Catalog server* stores catalog data into 
``/tmp/tajo-catalog-${username}`` directory. But, some operating systems may 
remove all contents in ``/tmp`` when booting up. In order to ensure persistent 
store of your catalog data, you need to set a proper location of derby 
directory.
 
-=========================
-MySQLStore Configuration
-=========================
-
-In order to use MySQLStore, you need to create database and user on MySQL for 
Tajo.
+==================================================
+MySQL/MariaDB/PostgreSQL/Oracle Configuration
+==================================================
+
+Tajo supports several database systems, including MySQL, MariaDB, PostgreSQL, 
and Oracle, as its catalog store.
+In order to use these systems, you first need to create a database and a user 
for Tajo.
+The following example shows the creation of a user and a database with MySQL.
 
 .. code-block:: sh
   
@@ -74,48 +76,48 @@ In order to use MySQLStore, you need to
   Query OK, 0 rows affected (0.01 sec)
 
 
-And then, you need to prepare MySQL JDBC driver on the machine which can be 
ran TajoMaster. If you do, you should set ``TAJO_CLASSPATH`` variable in 
``conf/tajo-env.sh`` with it as follows:
+Second, you must install the proper JDBC driver on the TajoMaster node. And 
then, you need to set the ``TAJO_CLASSPATH`` variable in ``conf/tajo-env.sh`` 
as follows:
 
 .. code-block:: sh
 
-  export TAJO_CLASSPATH=/usr/local/mysql/lib/mysql-connector-java-x.x.x.jar
+  (MySQL)
+  $ export TAJO_CLASSPATH=/usr/local/mysql/lib/mysql-connector-java-x.x.x.jar
+
+  (MariaDB)
+  $ export TAJO_CLASSPATH=/usr/local/mariadb/lib/mariadb-java-client-x.x.x.jar
+
+  (PostgreSQL)
+  $ export TAJO_CLASSPATH=/usr/share/java/postgresql-jdbc4.jar
 
-Or you just can copy jdbc driver into ``$TAJO_HOME/lib``.
+  (Oracle)
+  $ export TAJO_CLASSPATH=/path/to/oracle/driver/ojdbc7.jar
 
-Finally, you should add the following config to `conf/catalog-site.xml` :
+Alternatively, you can copy the jdbc driver into ``$TAJO_HOME/lib``.
+
+Finally, you must add the following configurations to `conf/catalog-site.xml` :
 
 .. code-block:: xml
 
   <property>
-    <name>tajo.catalog.store.class</name>
-    <value>org.apache.tajo.catalog.store.MySQLStore</value>
-  </property>
-  <property>
     <name>tajo.catalog.jdbc.connection.id</name>
-    <value><mysql user name></value>
+    <value><user name></value>
   </property>
   <property>
     <name>tajo.catalog.jdbc.connection.password</name>
-    <value><mysql user password></value>
+    <value><user password></value>
+  </property>
+
+  <!-- MySQL -->
+  <property>
+    <name>tajo.catalog.store.class</name>
+    <value>org.apache.tajo.catalog.store.MySQLStore</value>
   </property>
   <property>
     <name>tajo.catalog.jdbc.uri</name>
     <value>jdbc:mysql://<mysql host name>:<mysql port>/<database name for 
tajo>?createDatabaseIfNotExist=true</value>
   </property>
 
-
-===========================
-MariaDBStore Configuration
-===========================
-
-All configurations for using MariaDBStore is compatible with MySQLStore except 
following:
-
-.. code-block:: sh
-
-  export TAJO_CLASSPATH=/usr/local/mariadb/lib/mariadb-java-client-x.x.x.jar
-
-.. code-block:: xml
-
+  <!-- MariaDB -->
   <property>
     <name>tajo.catalog.store.class</name>
     <value>org.apache.tajo.catalog.store.MariaDBStore</value>
@@ -125,9 +127,28 @@ All configurations for using MariaDBStor
     <value>jdbc:mariadb://<mariadb host name>:<mariadb port>/<database name 
for tajo>?createDatabaseIfNotExist=true</value>
   </property>
 
+  <!-- PostgreSQL -->
+  <property>
+    <name>tajo.catalog.store.class</name>
+    <value>org.apache.tajo.catalog.store.PostgreSQLStore</value>
+  </property>
+  <property>
+    <name>tajo.catalog.jdbc.uri</name>
+    <value>jdbc:postgresql://<postgresql host name>:<postgresql 
port>/<database name for tajo>?createDatabaseIfNotExist=true</value>
+  </property>
+
+  <!-- Oracle -->
+  <property>
+    <name>tajo.catalog.store.class</name>
+    <value>org.apache.tajo.catalog.store.OracleStore</value>
+  </property>
+  <property>
+    <name>tajo.catalog.jdbc.uri</name>
+    <value>jdbc:oracle:thin:@//<oracle host name>:<oracle port>/<ServiceName 
for tajo database></value>
+  </property>
 
 ==================================
-  HCatalogStore Configuration
+HCatalogStore Configuration
 ==================================
 
 Tajo support HCatalogStore to integrate with hive. If you want to use 
HCatalogStore, you just do as follows.

Modified: tajo/site/docs/current/_sources/getting_started.txt
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/getting_started.txt?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/getting_started.txt (original)
+++ tajo/site/docs/current/_sources/getting_started.txt Wed Jan  7 08:45:49 2015
@@ -4,11 +4,179 @@ Getting Started
 
 In this section, we explain setup of a standalone Tajo instance. It will run 
against the local filesystem. In later sections, we will present how to run 
Tajo cluster instance on Apache Hadoop's HDFS, a distributed filesystem. This 
section shows you how to start up a Tajo cluster, create tables in your Tajo 
cluster, submit SQL queries via Tajo shell, and shutting down your Tajo cluster 
instance. The below exercise should take no more than ten minutes.
 
-.. toctree::
-  :maxdepth: 1
+======================
+Prerequisites
+======================
 
-  getting_started/prerequisites
-  getting_started/downloading_source
-  getting_started/building
-  getting_started/local_setup
-  getting_started/first_query
\ 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
+
+===================================
+Dowload and unpack the source code
+===================================
+
+You can either download the source code release of Tajo or check out the 
development codebase from Git.
+
+-----------------------------------
+Download the latest source release
+-----------------------------------
+
+Choose a download site from this list of `Apache Download Mirrors 
<http://www.apache.org/dyn/closer.cgi/tajo>`_.
+Click on the suggested mirror link. This will take you to a mirror of Tajo 
Releases. 
+Download the file that ends in .tar.gz to your local filesystem, e.g. 
tajo-x.y.z-src.tar.gz.
+
+Decompress and untar your downloaded file and then change into the unpacked 
directory. ::
+
+  tar xzvf tajo-x.y.z-src.tar.gz
+
+-----------------------------------
+Check out the source code via Git
+-----------------------------------
+
+The development codebase can also be downloaded from `the Apache git 
repository <https://git-wip-us.apache.org/repos/asf/tajo.git>`_ as follows: ::
+
+  git clone https://git-wip-us.apache.org/repos/asf/tajo.git
+
+A read-only git repository is also mirrored on `Github 
<https://github.com/apache/tajo>`_.
+
+
+=================
+Build source code
+=================
+
+You prepare the prerequisites and the source code, you can build the source 
code now.
+
+The first step of the installation procedure is to configure the source tree 
for your system and choose the options you would like. This is done by running 
the configure script. For a default installation simply enter:
+
+You can compile source code and get a binary archive as follows:
+
+.. code-block:: bash
+
+  $ cd tajo-x.y.z
+  $ mvn clean install -DskipTests -Pdist -Dtar -Dhadoop.version=2.X.X
+  $ ls tajo-dist/target/tajo-x.y.z-SNAPSHOT.tar.gz
+
+.. note::
+
+  If you don't specify the hadoop version, tajo cluster may not run correctly. 
Thus, we highly recommend that you specify your hadoop version with maven build 
command.
+
+  Example:
+
+    $ mvn clean install -DskipTests -Pdist -Dtar -Dhadoop.version=2.5.1
+
+Then, after you move some proper directory, discompress the tar.gz file as 
follows:
+
+.. code-block:: bash
+
+  $ cd [a directory to be parent of tajo binary]
+  $ tar xzvf ${TAJO_SRC}/tajo-dist/target/tajo-x.y.z-SNAPSHOT.tar.gz
+
+================================
+Setting up a local Tajo cluster
+================================
+
+Apache Tajo™ provides two run modes: local mode and fully distributed mode. 
Here, we explain only the local mode where a Tajo instance runs on a local file 
system. A local mode Tajo instance can start up with very simple configurations.
+
+First of all, you need to add the environment variables to conf/tajo-env.sh.
+
+.. code-block:: bash
+
+  # Hadoop home. Required
+  export HADOOP_HOME= ...
+
+  # The java implementation to use.  Required.
+  export JAVA_HOME= ...
+
+To launch the tajo master, execute start-tajo.sh.
+
+.. code-block:: bash
+
+  $ $TAJO_HOME/bin/start-tajo.sh
+
+.. note::
+
+  If you want to how to setup a fully distributed mode of Tajo, please see 
:doc:`/configuration/cluster_setup`.
+
+.. warning::
+
+  By default, *Catalog server* which manages table meta data uses `Apache 
Derby <http://db.apache.org/derby/>`_ as a persistent storage, and Derby stores 
data into ``/tmp/tajo-catalog-${username}`` directory. But, some operating 
systems may remove all contents in ``/tmp`` when booting up. In order to ensure 
persistent store of your catalog data, you need to set a proper location of 
derby directory. To learn Catalog configuration, please refer to 
:doc:`/configuration/catalog_configuration`.
+
+======================
+First query execution
+======================
+
+First of all, we need to prepare some table for query execution. For example, 
you can make a simple text-based table as follows: 
+
+.. code-block:: bash
+
+  $ mkdir /home/x/table1
+  $ cd /home/x/table1
+  $ cat > data.csv
+  1|abc|1.1|a
+  2|def|2.3|b
+  3|ghi|3.4|c
+  4|jkl|4.5|d
+  5|mno|5.6|e
+  <CTRL + D>
+
+
+Apache Tajo™ provides a SQL shell which allows users to interactively submit 
SQL queries. In order to use this shell, please execute ``bin/tsql`` ::
+
+  $ $TAJO_HOME/bin/tsql
+  tajo>
+
+In order to load the table we created above, we should think of a schema of 
the table.
+Here, we assume the schema as (int, text, float, text). ::
+
+  $ $TAJO_HOME/bin/tsql
+  tajo> create external table table1 (
+        id int,
+        name text, 
+        score float, 
+        type text) 
+        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. 
+If the table resides in HDFS, you should use ‘hdfs’ instead of ‘file’.
+
+If you want to know DDL statements in more detail, please see Query Language. 
::
+
+  tajo> \d
+  table1
+
+ ``\d`` command shows the list of tables. ::
+
+  tajo> \d table1
+
+  table name: table1
+  table path: file:/home/x/table1
+  store type: CSV
+  number of rows: 0
+  volume (bytes): 78 B
+  schema:
+  id      INT
+  name    TEXT
+  score   FLOAT
+  type    TEXT
+
+``\d [table name]`` command shows the description of a given table.
+
+Also, you can execute SQL queries as follows: ::
+
+  tajo> select * from table1 where id > 2;
+  final state: QUERY_SUCCEEDED, init time: 0.069 sec, response time: 0.397 sec
+  result: file:/tmp/tajo-hadoop/staging/q_1363768615503_0001_000001/RESULT, 3 
rows ( 35B)
+
+  id,  name,  score,  type
+  - - - - - - - - - -  - - -
+  3,  ghi,  3.4,  c
+  4,  jkl,  4.5,  d
+  5,  mno,  5.6,  e
+
+  tajo> \q
+  bye
+
+Feel free to enjoy Tajo with SQL standards. 
+If you want to know more explanation for SQL supported by Tajo, please refer 
:doc:`/sql_language`.
\ No newline at end of file

Modified: tajo/site/docs/current/_sources/jdbc_driver.txt
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/jdbc_driver.txt?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/jdbc_driver.txt (original)
+++ tajo/site/docs/current/_sources/jdbc_driver.txt Wed Jan  7 08:45:49 2015
@@ -53,7 +53,7 @@ The JDBC driver class name is ``org.apac
 You can get the driver ``Class.forName("org.apache.tajo.jdbc.TajoDriver")``.
 The connection url should be ``jdbc:tajo://<TajoMaster hostname>:<TajoMaster 
client rpc port>/<database name>``.
 The default TajoMaster client rpc port is ``26002``.
-If you want to change the listening port, please refer 
:doc:`/configuration/configuration_defaults`.
+If you want to change the listening port, please refer 
:doc:`/configuration/cluster_setup`.
 
 .. note::
   

Modified: tajo/site/docs/current/backup_and_restore.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/backup_and_restore.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/backup_and_restore.html (original)
+++ tajo/site/docs/current/backup_and_restore.html Wed Jan  7 08:45:49 2015
@@ -60,11 +60,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local 
Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#first-query-execution">First query execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1"><a class="reference internal" 
href="configuration.html">Configuration</a><ul>

Modified: tajo/site/docs/current/backup_and_restore/catalog.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/backup_and_restore/catalog.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/backup_and_restore/catalog.html (original)
+++ tajo/site/docs/current/backup_and_restore/catalog.html Wed Jan  7 08:45:49 
2015
@@ -61,11 +61,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="../introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="../getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/local_setup.html">Setting up a local Tajo 
cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a 
local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#first-query-execution">First query 
execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1"><a class="reference internal" 
href="../configuration.html">Configuration</a><ul>
@@ -187,7 +187,7 @@
 </ul>
 <div class="section" id="sql-dump">
 <h2>SQL dump<a class="headerlink" href="#sql-dump" title="Permalink to this 
headline">¶</a></h2>
-<p>SQL dump is an easy and strong way. If you use this approach, you 
don&#8217;t need to concern database-level compatiblities. If you want to 
backup your catalog, just use bin/tajo-dump command. The basic usage of this 
command is:</p>
+<p>SQL dump is an easy and strong way. If you use this approach, you 
don&#8217;t need to concern database-level compatibilities. If you want to 
backup your catalog, just use bin/tajo-dump command. The basic usage of this 
command is:</p>
 <div class="highlight-python"><div class="highlight"><pre>$ tajo-dump 
table_name &gt; outfile
 </pre></div>
 </div>

Modified: tajo/site/docs/current/configuration.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/configuration.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/configuration.html (original)
+++ tajo/site/docs/current/configuration.html Wed Jan  7 08:45:49 2015
@@ -30,7 +30,7 @@
   
     <link rel="top" title="Apache Tajo 0.8.0 documentation" href="index.html"/>
         <link rel="next" title="Preliminary" 
href="configuration/preliminary.html"/>
-        <link rel="prev" title="First query execution" 
href="getting_started/first_query.html"/> 
+        <link rel="prev" title="Getting Started" href="getting_started.html"/> 
 
   
   <script 
src="https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js";></script>
@@ -60,11 +60,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local 
Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#first-query-execution">First query execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1 current"><a class="current reference internal" 
href="">Configuration</a><ul>
@@ -201,7 +201,7 @@
         <a href="configuration/preliminary.html" class="btn btn-neutral 
float-right" title="Preliminary"/>Next <span class="fa 
fa-arrow-circle-right"></span></a>
       
       
-        <a href="getting_started/first_query.html" class="btn btn-neutral" 
title="First query execution"><span class="fa fa-arrow-circle-left"></span> 
Previous</a>
+        <a href="getting_started.html" class="btn btn-neutral" title="Getting 
Started"><span class="fa fa-arrow-circle-left"></span> Previous</a>
       
     </div>
   

Modified: tajo/site/docs/current/configuration/catalog_configuration.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/configuration/catalog_configuration.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/configuration/catalog_configuration.html (original)
+++ tajo/site/docs/current/configuration/catalog_configuration.html Wed Jan  7 
08:45:49 2015
@@ -61,11 +61,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="../introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="../getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/local_setup.html">Setting up a local Tajo 
cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a 
local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#first-query-execution">First query 
execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1 current"><a class="reference internal" 
href="../configuration.html">Configuration</a><ul class="current">
@@ -242,9 +242,11 @@ tests.</td>
 <p class="last">By default, <em>Catalog server</em> stores catalog data into 
<tt class="docutils literal"><span 
class="pre">/tmp/tajo-catalog-${username}</span></tt> directory. But, some 
operating systems may remove all contents in <tt class="docutils literal"><span 
class="pre">/tmp</span></tt> when booting up. In order to ensure persistent 
store of your catalog data, you need to set a proper location of derby 
directory.</p>
 </div>
 </div>
-<div class="section" id="mysqlstore-configuration">
-<h2>MySQLStore Configuration<a class="headerlink" 
href="#mysqlstore-configuration" title="Permalink to this headline">¶</a></h2>
-<p>In order to use MySQLStore, you need to create database and user on MySQL 
for Tajo.</p>
+<div class="section" id="mysql-mariadb-postgresql-oracle-configuration">
+<h2>MySQL/MariaDB/PostgreSQL/Oracle Configuration<a class="headerlink" 
href="#mysql-mariadb-postgresql-oracle-configuration" title="Permalink to this 
headline">¶</a></h2>
+<p>Tajo supports several database systems, including MySQL, MariaDB, 
PostgreSQL, and Oracle, as its catalog store.
+In order to use these systems, you first need to create a database and a user 
for Tajo.
+The following example shows the creation of a user and a database with 
MySQL.</p>
 <div class="highlight-sh"><div class="highlight"><pre>mysql&gt; create user 
<span class="s1">&#39;tajo&#39;</span>@<span 
class="s1">&#39;localhost&#39;</span> identified by <span 
class="s1">&#39;xxxxxx&#39;</span><span class="p">;</span>
 Query OK, <span class="m">0</span> rows affected <span class="o">(</span>0.00 
sec<span class="o">)</span>
 
@@ -255,38 +257,43 @@ mysql&gt; grant all on tajo.* to <span c
 Query OK, <span class="m">0</span> rows affected <span class="o">(</span>0.01 
sec<span class="o">)</span>
 </pre></div>
 </div>
-<p>And then, you need to prepare MySQL JDBC driver on the machine which can be 
ran TajoMaster. If you do, you should set <tt class="docutils literal"><span 
class="pre">TAJO_CLASSPATH</span></tt> variable in <tt class="docutils 
literal"><span class="pre">conf/tajo-env.sh</span></tt> with it as follows:</p>
-<div class="highlight-sh"><div class="highlight"><pre><span class="nb">export 
</span><span class="nv">TAJO_CLASSPATH</span><span 
class="o">=</span>/usr/local/mysql/lib/mysql-connector-java-x.x.x.jar
+<p>Second, you must install the proper JDBC driver on the TajoMaster node. And 
then, you need to set the <tt class="docutils literal"><span 
class="pre">TAJO_CLASSPATH</span></tt> variable in <tt class="docutils 
literal"><span class="pre">conf/tajo-env.sh</span></tt> as follows:</p>
+<div class="highlight-sh"><div class="highlight"><pre><span 
class="o">(</span>MySQL<span class="o">)</span>
+<span class="nv">$ </span><span class="nb">export </span><span 
class="nv">TAJO_CLASSPATH</span><span 
class="o">=</span>/usr/local/mysql/lib/mysql-connector-java-x.x.x.jar
+
+<span class="o">(</span>MariaDB<span class="o">)</span>
+<span class="nv">$ </span><span class="nb">export </span><span 
class="nv">TAJO_CLASSPATH</span><span 
class="o">=</span>/usr/local/mariadb/lib/mariadb-java-client-x.x.x.jar
+
+<span class="o">(</span>PostgreSQL<span class="o">)</span>
+<span class="nv">$ </span><span class="nb">export </span><span 
class="nv">TAJO_CLASSPATH</span><span 
class="o">=</span>/usr/share/java/postgresql-jdbc4.jar
+
+<span class="o">(</span>Oracle<span class="o">)</span>
+<span class="nv">$ </span><span class="nb">export </span><span 
class="nv">TAJO_CLASSPATH</span><span 
class="o">=</span>/path/to/oracle/driver/ojdbc7.jar
 </pre></div>
 </div>
-<p>Or you just can copy jdbc driver into <tt class="docutils literal"><span 
class="pre">$TAJO_HOME/lib</span></tt>.</p>
-<p>Finally, you should add the following config to 
<cite>conf/catalog-site.xml</cite> :</p>
+<p>Alternatively, you can copy the jdbc driver into <tt class="docutils 
literal"><span class="pre">$TAJO_HOME/lib</span></tt>.</p>
+<p>Finally, you must add the following configurations to 
<cite>conf/catalog-site.xml</cite> :</p>
 <div class="highlight-xml"><div class="highlight"><pre>&lt;property&gt;
-  &lt;name&gt;tajo.catalog.store.class&lt;/name&gt;
-  &lt;value&gt;org.apache.tajo.catalog.store.MySQLStore&lt;/value&gt;
-&lt;/property&gt;
-&lt;property&gt;
   &lt;name&gt;tajo.catalog.jdbc.connection.id&lt;/name&gt;
-  &lt;value&gt;&lt;mysql user name&gt;&lt;/value&gt;
+  &lt;value&gt;&lt;user name&gt;&lt;/value&gt;
 &lt;/property&gt;
 &lt;property&gt;
   &lt;name&gt;tajo.catalog.jdbc.connection.password&lt;/name&gt;
-  &lt;value&gt;&lt;mysql user password&gt;&lt;/value&gt;
+  &lt;value&gt;&lt;user password&gt;&lt;/value&gt;
+&lt;/property&gt;
+
+&lt;!-- MySQL --&gt;
+&lt;property&gt;
+  &lt;name&gt;tajo.catalog.store.class&lt;/name&gt;
+  &lt;value&gt;org.apache.tajo.catalog.store.MySQLStore&lt;/value&gt;
 &lt;/property&gt;
 &lt;property&gt;
   &lt;name&gt;tajo.catalog.jdbc.uri&lt;/name&gt;
   &lt;value&gt;jdbc:mysql://&lt;mysql host name&gt;:&lt;mysql 
port&gt;/&lt;database name for 
tajo&gt;?createDatabaseIfNotExist=true&lt;/value&gt;
 &lt;/property&gt;
-</pre></div>
-</div>
-</div>
-<div class="section" id="mariadbstore-configuration">
-<h2>MariaDBStore Configuration<a class="headerlink" 
href="#mariadbstore-configuration" title="Permalink to this 
headline">¶</a></h2>
-<p>All configurations for using MariaDBStore is compatible with MySQLStore 
except following:</p>
-<div class="highlight-sh"><div class="highlight"><pre><span class="nb">export 
</span><span class="nv">TAJO_CLASSPATH</span><span 
class="o">=</span>/usr/local/mariadb/lib/mariadb-java-client-x.x.x.jar
-</pre></div>
-</div>
-<div class="highlight-xml"><div class="highlight"><pre>&lt;property&gt;
+
+&lt;!-- MariaDB --&gt;
+&lt;property&gt;
   &lt;name&gt;tajo.catalog.store.class&lt;/name&gt;
   &lt;value&gt;org.apache.tajo.catalog.store.MariaDBStore&lt;/value&gt;
 &lt;/property&gt;
@@ -294,6 +301,26 @@ Query OK, <span class="m">0</span> rows
   &lt;name&gt;tajo.catalog.jdbc.uri&lt;/name&gt;
   &lt;value&gt;jdbc:mariadb://&lt;mariadb host name&gt;:&lt;mariadb 
port&gt;/&lt;database name for 
tajo&gt;?createDatabaseIfNotExist=true&lt;/value&gt;
 &lt;/property&gt;
+
+&lt;!-- PostgreSQL --&gt;
+&lt;property&gt;
+  &lt;name&gt;tajo.catalog.store.class&lt;/name&gt;
+  &lt;value&gt;org.apache.tajo.catalog.store.PostgreSQLStore&lt;/value&gt;
+&lt;/property&gt;
+&lt;property&gt;
+  &lt;name&gt;tajo.catalog.jdbc.uri&lt;/name&gt;
+  &lt;value&gt;jdbc:postgresql://&lt;postgresql host name&gt;:&lt;postgresql 
port&gt;/&lt;database name for 
tajo&gt;?createDatabaseIfNotExist=true&lt;/value&gt;
+&lt;/property&gt;
+
+&lt;!-- Oracle --&gt;
+&lt;property&gt;
+  &lt;name&gt;tajo.catalog.store.class&lt;/name&gt;
+  &lt;value&gt;org.apache.tajo.catalog.store.OracleStore&lt;/value&gt;
+&lt;/property&gt;
+&lt;property&gt;
+  &lt;name&gt;tajo.catalog.jdbc.uri&lt;/name&gt;
+  &lt;value&gt;jdbc:oracle:thin:@//&lt;oracle host name&gt;:&lt;oracle 
port&gt;/&lt;ServiceName for tajo database&gt;&lt;/value&gt;
+&lt;/property&gt;
 </pre></div>
 </div>
 </div>

Modified: tajo/site/docs/current/configuration/cluster_setup.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/configuration/cluster_setup.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/configuration/cluster_setup.html (original)
+++ tajo/site/docs/current/configuration/cluster_setup.html Wed Jan  7 08:45:49 
2015
@@ -61,11 +61,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="../introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="../getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/local_setup.html">Setting up a local Tajo 
cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a 
local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#first-query-execution">First query 
execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1 current"><a class="reference internal" 
href="../configuration.html">Configuration</a><ul class="current">

Modified: tajo/site/docs/current/configuration/ha_configuration.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/configuration/ha_configuration.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/configuration/ha_configuration.html (original)
+++ tajo/site/docs/current/configuration/ha_configuration.html Wed Jan  7 
08:45:49 2015
@@ -61,11 +61,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="../introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="../getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/local_setup.html">Setting up a local Tajo 
cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a 
local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#first-query-execution">First query 
execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1 current"><a class="reference internal" 
href="../configuration.html">Configuration</a><ul class="current">

Modified: tajo/site/docs/current/configuration/preliminary.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/configuration/preliminary.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/configuration/preliminary.html (original)
+++ tajo/site/docs/current/configuration/preliminary.html Wed Jan  7 08:45:49 
2015
@@ -61,11 +61,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="../introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="../getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/local_setup.html">Setting up a local Tajo 
cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a 
local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#first-query-execution">First query 
execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1 current"><a class="reference internal" 
href="../configuration.html">Configuration</a><ul class="current">

Modified: tajo/site/docs/current/configuration/tajo_master_configuration.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/configuration/tajo_master_configuration.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/configuration/tajo_master_configuration.html 
(original)
+++ tajo/site/docs/current/configuration/tajo_master_configuration.html Wed Jan 
 7 08:45:49 2015
@@ -61,11 +61,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="../introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="../getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/local_setup.html">Setting up a local Tajo 
cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a 
local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#first-query-execution">First query 
execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1 current"><a class="reference internal" 
href="../configuration.html">Configuration</a><ul class="current">

Modified: tajo/site/docs/current/configuration/worker_configuration.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/configuration/worker_configuration.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/configuration/worker_configuration.html (original)
+++ tajo/site/docs/current/configuration/worker_configuration.html Wed Jan  7 
08:45:49 2015
@@ -61,11 +61,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="../introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="../getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/local_setup.html">Setting up a local Tajo 
cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a 
local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#first-query-execution">First query 
execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1 current"><a class="reference internal" 
href="../configuration.html">Configuration</a><ul class="current">

Modified: tajo/site/docs/current/faq.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/faq.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/faq.html (original)
+++ tajo/site/docs/current/faq.html Wed Jan  7 08:45:49 2015
@@ -59,11 +59,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local 
Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#first-query-execution">First query execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1"><a class="reference internal" 
href="configuration.html">Configuration</a><ul>

Modified: tajo/site/docs/current/functions.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/functions.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/functions.html (original)
+++ tajo/site/docs/current/functions.html Wed Jan  7 08:45:49 2015
@@ -60,11 +60,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local 
Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#first-query-execution">First query execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1"><a class="reference internal" 
href="configuration.html">Configuration</a><ul>

Modified: tajo/site/docs/current/functions/datetime_func_and_operators.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/functions/datetime_func_and_operators.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/functions/datetime_func_and_operators.html (original)
+++ tajo/site/docs/current/functions/datetime_func_and_operators.html Wed Jan  
7 08:45:49 2015
@@ -61,11 +61,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="../introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="../getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/local_setup.html">Setting up a local Tajo 
cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a 
local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#first-query-execution">First query 
execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1"><a class="reference internal" 
href="../configuration.html">Configuration</a><ul>

Modified: tajo/site/docs/current/functions/math_func_and_operators.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/functions/math_func_and_operators.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/functions/math_func_and_operators.html (original)
+++ tajo/site/docs/current/functions/math_func_and_operators.html Wed Jan  7 
08:45:49 2015
@@ -61,11 +61,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="../introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="../getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/local_setup.html">Setting up a local Tajo 
cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a 
local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#first-query-execution">First query 
execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1"><a class="reference internal" 
href="../configuration.html">Configuration</a><ul>

Modified: tajo/site/docs/current/functions/network_func_and_operators.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/functions/network_func_and_operators.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/functions/network_func_and_operators.html (original)
+++ tajo/site/docs/current/functions/network_func_and_operators.html Wed Jan  7 
08:45:49 2015
@@ -61,11 +61,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="../introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="../getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/local_setup.html">Setting up a local Tajo 
cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a 
local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#first-query-execution">First query 
execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1"><a class="reference internal" 
href="../configuration.html">Configuration</a><ul>

Modified: tajo/site/docs/current/functions/string_func_and_operators.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/functions/string_func_and_operators.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/functions/string_func_and_operators.html (original)
+++ tajo/site/docs/current/functions/string_func_and_operators.html Wed Jan  7 
08:45:49 2015
@@ -61,11 +61,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="../introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="../getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/local_setup.html">Setting up a local Tajo 
cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="../getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a 
local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="../getting_started.html#first-query-execution">First query 
execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1"><a class="reference internal" 
href="../configuration.html">Configuration</a><ul>

Modified: tajo/site/docs/current/genindex.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/genindex.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/genindex.html (original)
+++ tajo/site/docs/current/genindex.html Wed Jan  7 08:45:49 2015
@@ -59,11 +59,11 @@
             <ul>
 <li class="toctree-l1"><a class="reference internal" 
href="introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local 
Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#first-query-execution">First query execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1"><a class="reference internal" 
href="configuration.html">Configuration</a><ul>

Modified: tajo/site/docs/current/getting_started.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/getting_started.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/getting_started.html (original)
+++ tajo/site/docs/current/getting_started.html Wed Jan  7 08:45:49 2015
@@ -29,7 +29,7 @@
 
   
     <link rel="top" title="Apache Tajo 0.8.0 documentation" href="index.html"/>
-        <link rel="next" title="Prerequisites" 
href="getting_started/prerequisites.html"/>
+        <link rel="next" title="Configuration" href="configuration.html"/>
         <link rel="prev" title="Introduction" href="introduction.html"/> 
 
   
@@ -60,11 +60,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="introduction.html">Introduction</a></li>
 <li class="toctree-l1 current"><a class="current reference internal" 
href="">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="#dowload-and-unpack-the-source-code">Dowload and unpack the source 
code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="#setting-up-a-local-tajo-cluster">Setting up a local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="#first-query-execution">First query execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1"><a class="reference internal" 
href="configuration.html">Configuration</a><ul>
@@ -178,14 +178,156 @@
   <div class="section" id="getting-started">
 <h1>Getting Started<a class="headerlink" href="#getting-started" 
title="Permalink to this headline">¶</a></h1>
 <p>In this section, we explain setup of a standalone Tajo instance. It will 
run against the local filesystem. In later sections, we will present how to run 
Tajo cluster instance on Apache Hadoop&#8217;s HDFS, a distributed filesystem. 
This section shows you how to start up a Tajo cluster, create tables in your 
Tajo cluster, submit SQL queries via Tajo shell, and shutting down your Tajo 
cluster instance. The below exercise should take no more than ten minutes.</p>
-<div class="toctree-wrapper compound">
-<ul>
-<li class="toctree-l1"><a class="reference internal" 
href="getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l1"><a class="reference internal" 
href="getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l1"><a class="reference internal" 
href="getting_started/building.html">Build source code</a></li>
-<li class="toctree-l1"><a class="reference internal" 
href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li>
-<li class="toctree-l1"><a class="reference internal" 
href="getting_started/first_query.html">First query execution</a></li>
+<div class="section" id="prerequisites">
+<h2>Prerequisites<a class="headerlink" href="#prerequisites" title="Permalink 
to this headline">¶</a></h2>
+<blockquote>
+<div><ul class="simple">
+<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>
+</div>
+<div class="section" id="dowload-and-unpack-the-source-code">
+<h2>Dowload and unpack the source code<a class="headerlink" 
href="#dowload-and-unpack-the-source-code" title="Permalink to this 
headline">¶</a></h2>
+<p>You can either download the source code release of Tajo or check out the 
development codebase from Git.</p>
+<div class="section" id="download-the-latest-source-release">
+<h3>Download the latest source release<a class="headerlink" 
href="#download-the-latest-source-release" title="Permalink to this 
headline">¶</a></h3>
+<p>Choose a download site from this list of <a class="reference external" 
href="http://www.apache.org/dyn/closer.cgi/tajo";>Apache Download Mirrors</a>.
+Click on the suggested mirror link. This will take you to a mirror of Tajo 
Releases.
+Download the file that ends in .tar.gz to your local filesystem, e.g. 
tajo-x.y.z-src.tar.gz.</p>
+<p>Decompress and untar your downloaded file and then change into the unpacked 
directory.</p>
+<div class="highlight-python"><div class="highlight"><pre>tar xzvf 
tajo-x.y.z-src.tar.gz
+</pre></div>
+</div>
+</div>
+<div class="section" id="check-out-the-source-code-via-git">
+<h3>Check out the source code via Git<a class="headerlink" 
href="#check-out-the-source-code-via-git" title="Permalink to this 
headline">¶</a></h3>
+<p>The development codebase can also be downloaded from <a class="reference 
external" href="https://git-wip-us.apache.org/repos/asf/tajo.git";>the Apache 
git repository</a> as follows:</p>
+<div class="highlight-python"><div class="highlight"><pre>git clone 
https://git-wip-us.apache.org/repos/asf/tajo.git
+</pre></div>
+</div>
+<p>A read-only git repository is also mirrored on <a class="reference 
external" href="https://github.com/apache/tajo";>Github</a>.</p>
+</div>
+</div>
+<div class="section" id="build-source-code">
+<h2>Build source code<a class="headerlink" href="#build-source-code" 
title="Permalink to this headline">¶</a></h2>
+<p>You prepare the prerequisites and the source code, you can build the source 
code now.</p>
+<p>The first step of the installation procedure is to configure the source 
tree for your system and choose the options you would like. This is done by 
running the configure script. For a default installation simply enter:</p>
+<p>You can compile source code and get a binary archive as follows:</p>
+<div class="highlight-bash"><div class="highlight"><pre><span class="nv">$ 
</span><span class="nb">cd </span>tajo-x.y.z
+<span class="nv">$ </span>mvn clean install -DskipTests -Pdist -Dtar 
-Dhadoop.version<span class="o">=</span>2.X.X
+<span class="nv">$ </span>ls tajo-dist/target/tajo-x.y.z-SNAPSHOT.tar.gz
+</pre></div>
+</div>
+<div class="admonition note">
+<p class="first admonition-title">Note</p>
+<p>If you don&#8217;t specify the hadoop version, tajo cluster may not run 
correctly. Thus, we highly recommend that you specify your hadoop version with 
maven build command.</p>
+<p>Example:</p>
+<blockquote class="last">
+<div>$ mvn clean install -DskipTests -Pdist -Dtar 
-Dhadoop.version=2.5.1</div></blockquote>
+</div>
+<p>Then, after you move some proper directory, discompress the tar.gz file as 
follows:</p>
+<div class="highlight-bash"><div class="highlight"><pre><span class="nv">$ 
</span><span class="nb">cd</span> <span class="o">[</span>a directory to be 
parent of tajo binary<span class="o">]</span>
+<span class="nv">$ </span>tar xzvf <span class="si">${</span><span 
class="nv">TAJO_SRC</span><span 
class="si">}</span>/tajo-dist/target/tajo-x.y.z-SNAPSHOT.tar.gz
+</pre></div>
+</div>
+</div>
+<div class="section" id="setting-up-a-local-tajo-cluster">
+<h2>Setting up a local Tajo cluster<a class="headerlink" 
href="#setting-up-a-local-tajo-cluster" title="Permalink to this 
headline">¶</a></h2>
+<p>Apache Tajo™ provides two run modes: local mode and fully distributed 
mode. Here, we explain only the local mode where a Tajo instance runs on a 
local file system. A local mode Tajo instance can start up with very simple 
configurations.</p>
+<p>First of all, you need to add the environment variables to 
conf/tajo-env.sh.</p>
+<div class="highlight-bash"><div class="highlight"><pre><span class="c"># 
Hadoop home. Required</span>
+<span class="nb">export </span><span class="nv">HADOOP_HOME</span><span 
class="o">=</span> ...
+
+<span class="c"># The java implementation to use.  Required.</span>
+<span class="nb">export </span><span class="nv">JAVA_HOME</span><span 
class="o">=</span> ...
+</pre></div>
+</div>
+<p>To launch the tajo master, execute start-tajo.sh.</p>
+<div class="highlight-bash"><div class="highlight"><pre><span class="nv">$ 
$TAJO_HOME</span>/bin/start-tajo.sh
+</pre></div>
+</div>
+<div class="admonition note">
+<p class="first admonition-title">Note</p>
+<p class="last">If you want to how to setup a fully distributed mode of Tajo, 
please see <a class="reference internal" 
href="configuration/cluster_setup.html"><em>Cluster Setup</em></a>.</p>
+</div>
+<div class="admonition warning">
+<p class="first admonition-title">Warning</p>
+<p class="last">By default, <em>Catalog server</em> which manages table meta 
data uses <a class="reference external" 
href="http://db.apache.org/derby/";>Apache Derby</a> as a persistent storage, 
and Derby stores data into <tt class="docutils literal"><span 
class="pre">/tmp/tajo-catalog-${username}</span></tt> directory. But, some 
operating systems may remove all contents in <tt class="docutils literal"><span 
class="pre">/tmp</span></tt> when booting up. In order to ensure persistent 
store of your catalog data, you need to set a proper location of derby 
directory. To learn Catalog configuration, please refer to <a class="reference 
internal" href="configuration/catalog_configuration.html"><em>Catalog 
Configuration</em></a>.</p>
+</div>
+</div>
+<div class="section" id="first-query-execution">
+<h2>First query execution<a class="headerlink" href="#first-query-execution" 
title="Permalink to this headline">¶</a></h2>
+<p>First of all, we need to prepare some table for query execution. For 
example, you can make a simple text-based table as follows:</p>
+<div class="highlight-bash"><div class="highlight"><pre><span class="nv">$ 
</span>mkdir /home/x/table1
+<span class="nv">$ </span><span class="nb">cd</span> /home/x/table1
+<span class="nv">$ </span>cat &gt; data.csv
+1<span class="p">|</span>abc<span class="p">|</span>1.1<span 
class="p">|</span>a
+2<span class="p">|</span>def<span class="p">|</span>2.3<span 
class="p">|</span>b
+3<span class="p">|</span>ghi<span class="p">|</span>3.4<span 
class="p">|</span>c
+4<span class="p">|</span>jkl<span class="p">|</span>4.5<span 
class="p">|</span>d
+5<span class="p">|</span>mno<span class="p">|</span>5.6<span 
class="p">|</span>e
+&lt;CTRL + D&gt;
+</pre></div>
+</div>
+<p>Apache Tajo™ provides a SQL shell which allows users to interactively 
submit SQL queries. In order to use this shell, please execute <tt 
class="docutils literal"><span class="pre">bin/tsql</span></tt></p>
+<div class="highlight-python"><div class="highlight"><pre>$ $TAJO_HOME/bin/tsql
+tajo&gt;
+</pre></div>
+</div>
+<p>In order to load the table we created above, we should think of a schema of 
the table.
+Here, we assume the schema as (int, text, float, text).</p>
+<div class="highlight-python"><div class="highlight"><pre>$ $TAJO_HOME/bin/tsql
+tajo&gt; create external table table1 (
+      id int,
+      name text,
+      score float,
+      type text)
+      using csv with (&#39;text.delimiter&#39;=&#39;|&#39;) location 
&#39;file:/home/x/table1&#39;;
+</pre></div>
+</div>
+<p>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.
+If the table resides in HDFS, you should use ‘hdfs’ instead of 
‘file’.</p>
+<p>If you want to know DDL statements in more detail, please see Query 
Language.</p>
+<div class="highlight-python"><div class="highlight"><pre> tajo&gt; \d
+ table1
+
+``\d`` command shows the list of tables. ::
+
+ tajo&gt; \d table1
+
+ table name: table1
+ table path: file:/home/x/table1
+ store type: CSV
+ number of rows: 0
+ volume (bytes): 78 B
+ schema:
+ id      INT
+ name    TEXT
+ score   FLOAT
+ type    TEXT
+</pre></div>
+</div>
+<p><tt class="docutils literal"><span class="pre">\d</span> <span 
class="pre">[table</span> <span class="pre">name]</span></tt> command shows the 
description of a given table.</p>
+<p>Also, you can execute SQL queries as follows:</p>
+<div class="highlight-python"><div class="highlight"><pre>tajo&gt; select * 
from table1 where id &gt; 2;
+final state: QUERY_SUCCEEDED, init time: 0.069 sec, response time: 0.397 sec
+result: file:/tmp/tajo-hadoop/staging/q_1363768615503_0001_000001/RESULT, 3 
rows ( 35B)
+
+id,  name,  score,  type
+- - - - - - - - - -  - - -
+3,  ghi,  3.4,  c
+4,  jkl,  4.5,  d
+5,  mno,  5.6,  e
+
+tajo&gt; \q
+bye
+</pre></div>
+</div>
+<p>Feel free to enjoy Tajo with SQL standards.
+If you want to know more explanation for SQL supported by Tajo, please refer 
<a class="reference internal" href="sql_language.html"><em>SQL 
Language</em></a>.</p>
 </div>
 </div>
 
@@ -195,7 +337,7 @@
   
     <div class="rst-footer-buttons" role="navigation" aria-label="footer 
navigation">
       
-        <a href="getting_started/prerequisites.html" class="btn btn-neutral 
float-right" title="Prerequisites"/>Next <span class="fa 
fa-arrow-circle-right"></span></a>
+        <a href="configuration.html" class="btn btn-neutral float-right" 
title="Configuration"/>Next <span class="fa fa-arrow-circle-right"></span></a>
       
       
         <a href="introduction.html" class="btn btn-neutral" 
title="Introduction"><span class="fa fa-arrow-circle-left"></span> Previous</a>

Modified: tajo/site/docs/current/hcatalog_integration.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/hcatalog_integration.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/hcatalog_integration.html (original)
+++ tajo/site/docs/current/hcatalog_integration.html Wed Jan  7 08:45:49 2015
@@ -60,11 +60,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local 
Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#first-query-execution">First query execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1"><a class="reference internal" 
href="configuration.html">Configuration</a><ul>

Modified: tajo/site/docs/current/index.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/index.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/index.html (original)
+++ tajo/site/docs/current/index.html Wed Jan  7 08:45:49 2015
@@ -59,11 +59,11 @@
             <ul>
 <li class="toctree-l1"><a class="reference internal" 
href="introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local 
Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#first-query-execution">First query execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1"><a class="reference internal" 
href="configuration.html">Configuration</a><ul>
@@ -186,15 +186,15 @@ As a result, some contents can be mismat
 <ul>
 <li class="toctree-l1"><a class="reference internal" 
href="introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/downloading_source.html">Dowload and unpack the source 
code</a><ul>
-<li class="toctree-l3"><a class="reference internal" 
href="getting_started/downloading_source.html#download-the-latest-source-release">Download
 the latest source release</a></li>
-<li class="toctree-l3"><a class="reference internal" 
href="getting_started/downloading_source.html#check-out-the-source-code-via-git">Check
 out the source code via Git</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a><ul>
+<li class="toctree-l3"><a class="reference internal" 
href="getting_started.html#download-the-latest-source-release">Download the 
latest source release</a></li>
+<li class="toctree-l3"><a class="reference internal" 
href="getting_started.html#check-out-the-source-code-via-git">Check out the 
source code via Git</a></li>
 </ul>
 </li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local 
Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#first-query-execution">First query execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1"><a class="reference internal" 
href="configuration.html">Configuration</a><ul>
@@ -221,8 +221,7 @@ As a result, some contents can be mismat
 </li>
 <li class="toctree-l2"><a class="reference internal" 
href="configuration/catalog_configuration.html">Catalog Configuration</a><ul>
 <li class="toctree-l3"><a class="reference internal" 
href="configuration/catalog_configuration.html#derby-configuration">Derby 
Configuration</a></li>
-<li class="toctree-l3"><a class="reference internal" 
href="configuration/catalog_configuration.html#mysqlstore-configuration">MySQLStore
 Configuration</a></li>
-<li class="toctree-l3"><a class="reference internal" 
href="configuration/catalog_configuration.html#mariadbstore-configuration">MariaDBStore
 Configuration</a></li>
+<li class="toctree-l3"><a class="reference internal" 
href="configuration/catalog_configuration.html#mysql-mariadb-postgresql-oracle-configuration">MySQL/MariaDB/PostgreSQL/Oracle
 Configuration</a></li>
 <li class="toctree-l3"><a class="reference internal" 
href="configuration/catalog_configuration.html#hcatalogstore-configuration">HCatalogStore
 Configuration</a></li>
 </ul>
 </li>

Modified: tajo/site/docs/current/introduction.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/introduction.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/introduction.html (original)
+++ tajo/site/docs/current/introduction.html Wed Jan  7 08:45:49 2015
@@ -60,11 +60,11 @@
             <ul class="current">
 <li class="toctree-l1 current"><a class="current reference internal" 
href="">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local 
Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#first-query-execution">First query execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1"><a class="reference internal" 
href="configuration.html">Configuration</a><ul>

Modified: tajo/site/docs/current/jdbc_driver.html
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/jdbc_driver.html?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
--- tajo/site/docs/current/jdbc_driver.html (original)
+++ tajo/site/docs/current/jdbc_driver.html Wed Jan  7 08:45:49 2015
@@ -60,11 +60,11 @@
             <ul class="current">
 <li class="toctree-l1"><a class="reference internal" 
href="introduction.html">Introduction</a></li>
 <li class="toctree-l1"><a class="reference internal" 
href="getting_started.html">Getting Started</a><ul>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/prerequisites.html">Prerequisites</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/downloading_source.html">Dowload and unpack the source 
code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/building.html">Build source code</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li>
-<li class="toctree-l2"><a class="reference internal" 
href="getting_started/first_query.html">First query execution</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#dowload-and-unpack-the-source-code">Dowload and 
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#setting-up-a-local-tajo-cluster">Setting up a local 
Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" 
href="getting_started.html#first-query-execution">First query execution</a></li>
 </ul>
 </li>
 <li class="toctree-l1"><a class="reference internal" 
href="configuration.html">Configuration</a><ul>
@@ -218,7 +218,7 @@ Hadoop config files (i.e., <tt class="do
 You can get the driver <tt class="docutils literal"><span 
class="pre">Class.forName(&quot;org.apache.tajo.jdbc.TajoDriver&quot;)</span></tt>.
 The connection url should be <tt class="docutils literal"><span 
class="pre">jdbc:tajo://&lt;TajoMaster</span> <span 
class="pre">hostname&gt;:&lt;TajoMaster</span> <span class="pre">client</span> 
<span class="pre">rpc</span> <span class="pre">port&gt;/&lt;database</span> 
<span class="pre">name&gt;</span></tt>.
 The default TajoMaster client rpc port is <tt class="docutils literal"><span 
class="pre">26002</span></tt>.
-If you want to change the listening port, please refer <tt class="xref doc 
docutils literal"><span 
class="pre">/configuration/configuration_defaults</span></tt>.</p>
+If you want to change the listening port, please refer <a class="reference 
internal" href="configuration/cluster_setup.html"><em>Cluster 
Setup</em></a>.</p>
 <div class="admonition note">
 <p class="first admonition-title">Note</p>
 <p class="last">Currently, Tajo does not support the concept of database and 
namespace.

Modified: tajo/site/docs/current/objects.inv
URL: 
http://svn.apache.org/viewvc/tajo/site/docs/current/objects.inv?rev=1650014&r1=1650013&r2=1650014&view=diff
==============================================================================
Binary files - no diff available.


Reply via email to