You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@tajo.apache.org by hy...@apache.org on 2014/03/05 09:14:36 UTC
svn commit: r1574393 [1/13] - in /incubator/tajo/site: ./ docs/ docs/0.8.0/
docs/0.8.0/_sources/ docs/0.8.0/_sources/backup_and_restore/
docs/0.8.0/_sources/configuration/ docs/0.8.0/_sources/functions/
docs/0.8.0/_sources/getting_started/ docs/0.8.0/_...
Author: hyunsik
Date: Wed Mar 5 08:14:33 2014
New Revision: 1574393
URL: http://svn.apache.org/r1574393
Log:
updated the documentation and tm symbol.
Added:
incubator/tajo/site/docs/
incubator/tajo/site/docs/0.8.0/
incubator/tajo/site/docs/0.8.0/.buildinfo
incubator/tajo/site/docs/0.8.0/_sources/
incubator/tajo/site/docs/0.8.0/_sources/backup_and_restore/
incubator/tajo/site/docs/0.8.0/_sources/backup_and_restore.txt
incubator/tajo/site/docs/0.8.0/_sources/backup_and_restore/catalog.txt
incubator/tajo/site/docs/0.8.0/_sources/cli.txt
incubator/tajo/site/docs/0.8.0/_sources/configuration/
incubator/tajo/site/docs/0.8.0/_sources/configuration.txt
incubator/tajo/site/docs/0.8.0/_sources/configuration/catalog_configuration.txt
incubator/tajo/site/docs/0.8.0/_sources/configuration/cluster_setup.txt
incubator/tajo/site/docs/0.8.0/_sources/configuration/configuration_defaults.txt
incubator/tajo/site/docs/0.8.0/_sources/configuration/preliminary.txt
incubator/tajo/site/docs/0.8.0/_sources/configuration/tajo_master_configuration.txt
incubator/tajo/site/docs/0.8.0/_sources/configuration/worker_configuration.txt
incubator/tajo/site/docs/0.8.0/_sources/faq.txt
incubator/tajo/site/docs/0.8.0/_sources/functions/
incubator/tajo/site/docs/0.8.0/_sources/functions.txt
incubator/tajo/site/docs/0.8.0/_sources/functions/datetime_func_and_operators.txt
incubator/tajo/site/docs/0.8.0/_sources/functions/math_func_and_operators.txt
incubator/tajo/site/docs/0.8.0/_sources/functions/string_func_and_operators.txt
incubator/tajo/site/docs/0.8.0/_sources/getting_started/
incubator/tajo/site/docs/0.8.0/_sources/getting_started.txt
incubator/tajo/site/docs/0.8.0/_sources/getting_started/building.txt
incubator/tajo/site/docs/0.8.0/_sources/getting_started/downloading_source.txt
incubator/tajo/site/docs/0.8.0/_sources/getting_started/first_query.txt
incubator/tajo/site/docs/0.8.0/_sources/getting_started/local_setup.txt
incubator/tajo/site/docs/0.8.0/_sources/getting_started/prerequisites.txt
incubator/tajo/site/docs/0.8.0/_sources/hcatalog_integration.txt
incubator/tajo/site/docs/0.8.0/_sources/index.txt
incubator/tajo/site/docs/0.8.0/_sources/introduction.txt
incubator/tajo/site/docs/0.8.0/_sources/jdbc_driver.txt
incubator/tajo/site/docs/0.8.0/_sources/partitioning/
incubator/tajo/site/docs/0.8.0/_sources/partitioning/column_partitioning.txt
incubator/tajo/site/docs/0.8.0/_sources/partitioning/hash_partitioning.txt
incubator/tajo/site/docs/0.8.0/_sources/partitioning/intro_to_partitioning.txt
incubator/tajo/site/docs/0.8.0/_sources/partitioning/range_partitioning.txt
incubator/tajo/site/docs/0.8.0/_sources/sql_language/
incubator/tajo/site/docs/0.8.0/_sources/sql_language.txt
incubator/tajo/site/docs/0.8.0/_sources/sql_language/data_model.txt
incubator/tajo/site/docs/0.8.0/_sources/sql_language/ddl.txt
incubator/tajo/site/docs/0.8.0/_sources/sql_language/insert.txt
incubator/tajo/site/docs/0.8.0/_sources/sql_language/predicates.txt
incubator/tajo/site/docs/0.8.0/_sources/sql_language/queries.txt
incubator/tajo/site/docs/0.8.0/_sources/sql_language/sql_expression.txt
incubator/tajo/site/docs/0.8.0/_sources/table_management/
incubator/tajo/site/docs/0.8.0/_sources/table_management.txt
incubator/tajo/site/docs/0.8.0/_sources/table_management/compression.txt
incubator/tajo/site/docs/0.8.0/_sources/table_management/file_formats.txt
incubator/tajo/site/docs/0.8.0/_sources/table_partitioning.txt
incubator/tajo/site/docs/0.8.0/_sources/tajo_client_api.txt
incubator/tajo/site/docs/0.8.0/_static/
incubator/tajo/site/docs/0.8.0/_static/ajax-loader.gif (with props)
incubator/tajo/site/docs/0.8.0/_static/basic.css
incubator/tajo/site/docs/0.8.0/_static/comment-bright.png (with props)
incubator/tajo/site/docs/0.8.0/_static/comment-close.png (with props)
incubator/tajo/site/docs/0.8.0/_static/comment.png (with props)
incubator/tajo/site/docs/0.8.0/_static/css/
incubator/tajo/site/docs/0.8.0/_static/css/badge_only.css
incubator/tajo/site/docs/0.8.0/_static/css/theme.css
incubator/tajo/site/docs/0.8.0/_static/doctools.js
incubator/tajo/site/docs/0.8.0/_static/down-pressed.png (with props)
incubator/tajo/site/docs/0.8.0/_static/down.png (with props)
incubator/tajo/site/docs/0.8.0/_static/file.png (with props)
incubator/tajo/site/docs/0.8.0/_static/font/
incubator/tajo/site/docs/0.8.0/_static/font/fontawesome_webfont.eot (with props)
incubator/tajo/site/docs/0.8.0/_static/font/fontawesome_webfont.svg
incubator/tajo/site/docs/0.8.0/_static/font/fontawesome_webfont.ttf (with props)
incubator/tajo/site/docs/0.8.0/_static/font/fontawesome_webfont.woff (with props)
incubator/tajo/site/docs/0.8.0/_static/jquery.js
incubator/tajo/site/docs/0.8.0/_static/js/
incubator/tajo/site/docs/0.8.0/_static/js/theme.js
incubator/tajo/site/docs/0.8.0/_static/minus.png (with props)
incubator/tajo/site/docs/0.8.0/_static/plus.png (with props)
incubator/tajo/site/docs/0.8.0/_static/pygments.css
incubator/tajo/site/docs/0.8.0/_static/searchtools.js
incubator/tajo/site/docs/0.8.0/_static/underscore.js
incubator/tajo/site/docs/0.8.0/_static/up-pressed.png (with props)
incubator/tajo/site/docs/0.8.0/_static/up.png (with props)
incubator/tajo/site/docs/0.8.0/_static/websupport.js
incubator/tajo/site/docs/0.8.0/backup_and_restore/
incubator/tajo/site/docs/0.8.0/backup_and_restore.html
incubator/tajo/site/docs/0.8.0/backup_and_restore/catalog.html
incubator/tajo/site/docs/0.8.0/cli.html
incubator/tajo/site/docs/0.8.0/configuration/
incubator/tajo/site/docs/0.8.0/configuration.html
incubator/tajo/site/docs/0.8.0/configuration/catalog_configuration.html
incubator/tajo/site/docs/0.8.0/configuration/cluster_setup.html
incubator/tajo/site/docs/0.8.0/configuration/configuration_defaults.html
incubator/tajo/site/docs/0.8.0/configuration/preliminary.html
incubator/tajo/site/docs/0.8.0/configuration/tajo_master_configuration.html
incubator/tajo/site/docs/0.8.0/configuration/worker_configuration.html
incubator/tajo/site/docs/0.8.0/faq.html
incubator/tajo/site/docs/0.8.0/functions/
incubator/tajo/site/docs/0.8.0/functions.html
incubator/tajo/site/docs/0.8.0/functions/datetime_func_and_operators.html
incubator/tajo/site/docs/0.8.0/functions/math_func_and_operators.html
incubator/tajo/site/docs/0.8.0/functions/string_func_and_operators.html
incubator/tajo/site/docs/0.8.0/genindex.html
incubator/tajo/site/docs/0.8.0/getting_started/
incubator/tajo/site/docs/0.8.0/getting_started.html
incubator/tajo/site/docs/0.8.0/getting_started/building.html
incubator/tajo/site/docs/0.8.0/getting_started/downloading_source.html
incubator/tajo/site/docs/0.8.0/getting_started/first_query.html
incubator/tajo/site/docs/0.8.0/getting_started/local_setup.html
incubator/tajo/site/docs/0.8.0/getting_started/prerequisites.html
incubator/tajo/site/docs/0.8.0/hcatalog_integration.html
incubator/tajo/site/docs/0.8.0/index.html
incubator/tajo/site/docs/0.8.0/introduction.html
incubator/tajo/site/docs/0.8.0/jdbc_driver.html
incubator/tajo/site/docs/0.8.0/objects.inv (with props)
incubator/tajo/site/docs/0.8.0/partitioning/
incubator/tajo/site/docs/0.8.0/partitioning/column_partitioning.html
incubator/tajo/site/docs/0.8.0/partitioning/hash_partitioning.html
incubator/tajo/site/docs/0.8.0/partitioning/intro_to_partitioning.html
incubator/tajo/site/docs/0.8.0/partitioning/range_partitioning.html
incubator/tajo/site/docs/0.8.0/search.html
incubator/tajo/site/docs/0.8.0/searchindex.js
incubator/tajo/site/docs/0.8.0/sql_language/
incubator/tajo/site/docs/0.8.0/sql_language.html
incubator/tajo/site/docs/0.8.0/sql_language/data_model.html
incubator/tajo/site/docs/0.8.0/sql_language/ddl.html
incubator/tajo/site/docs/0.8.0/sql_language/insert.html
incubator/tajo/site/docs/0.8.0/sql_language/predicates.html
incubator/tajo/site/docs/0.8.0/sql_language/queries.html
incubator/tajo/site/docs/0.8.0/sql_language/sql_expression.html
incubator/tajo/site/docs/0.8.0/table_management/
incubator/tajo/site/docs/0.8.0/table_management.html
incubator/tajo/site/docs/0.8.0/table_management/compression.html
incubator/tajo/site/docs/0.8.0/table_management/file_formats.html
incubator/tajo/site/docs/0.8.0/table_partitioning.html
incubator/tajo/site/docs/0.8.0/tajo_client_api.html
Modified:
incubator/tajo/site/dependencies.html
incubator/tajo/site/dependency-management.html
incubator/tajo/site/distribution-management.html
incubator/tajo/site/downloads.html
incubator/tajo/site/faq.html
incubator/tajo/site/index.html
incubator/tajo/site/integration.html
incubator/tajo/site/issue-tracking.html
incubator/tajo/site/license.html
incubator/tajo/site/mail-lists.html
incubator/tajo/site/mailing-lists.html
incubator/tajo/site/plugin-management.html
incubator/tajo/site/plugins.html
incubator/tajo/site/project-info.html
incubator/tajo/site/project-reports.html
incubator/tajo/site/project-summary.html
incubator/tajo/site/review-request-tool.html
incubator/tajo/site/source-code.html
incubator/tajo/site/source-repository.html
incubator/tajo/site/surefire-report.html
incubator/tajo/site/tajo-0.2.0-doc.html
incubator/tajo/site/tajo-0.8.0-doc.html
incubator/tajo/site/team-list.html
Modified: incubator/tajo/site/dependencies.html
URL: http://svn.apache.org/viewvc/incubator/tajo/site/dependencies.html?rev=1574393&r1=1574392&r2=1574393&view=diff
==============================================================================
--- incubator/tajo/site/dependencies.html (original)
+++ incubator/tajo/site/dependencies.html Wed Mar 5 08:14:33 2014
@@ -1,13 +1,13 @@
<!DOCTYPE html>
<!--
- | Generated by Apache Maven Doxia at 2014-02-23
+ | Generated by Apache Maven Doxia at 2014-03-05
| Rendered using Apache Maven Fluido Skin 1.3.0
-->
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
- <meta name="Date-Revision-yyyymmdd" content="20140223" />
+ <meta name="Date-Revision-yyyymmdd" content="20140305" />
<meta http-equiv="Content-Language" content="en" />
<title>Tajo - A Big Data Warehouse System on Hadoop - Project Dependencies</title>
<link rel="stylesheet" href="./css/apache-maven-fluido-1.3.0.min.css" />
@@ -102,10 +102,10 @@
<a href="#" class="dropdown-toggle" data-toggle="dropdown">Documentation <b class="caret"></b></a>
<ul class="dropdown-menu">
- <li> <a href="tajo-0.8.0-doc.html" title="0.8.0-SNAPSHOT (Dev)">0.8.0-SNAPSHOT (Dev)</a>
+ <li> <a href="docs/0.8.0/index.html" title="0.8.0-SNAPSHOT (dev)">0.8.0-SNAPSHOT (dev)</a>
</li>
- <li> <a href="tajo-0.2.0-doc.html" title="0.2.0-incubating (Current)">0.2.0-incubating (Current)</a>
+ <li> <a href="tajo-0.2.0-doc.html" title="0.2.0-incubating release">0.2.0-incubating release</a>
</li>
</ul>
</li>
@@ -206,7 +206,7 @@
- <li id="publishDate" class="pull-right">Last Published: 2014-02-23</li> <li class="divider pull-right">|</li>
+ <li id="publishDate" class="pull-right">Last Published: 2014-03-05</li> <li class="divider pull-right">|</li>
<li id="projectVersion" class="pull-right">Version: 0.8.0-SNAPSHOT</li>
</ul>
@@ -295,16 +295,16 @@
<li>
- <a href="tajo-0.8.0-doc.html" title="0.8.0-SNAPSHOT (Dev)">
+ <a href="docs/0.8.0/index.html" title="0.8.0-SNAPSHOT (dev)">
<i class="none"></i>
- 0.8.0-SNAPSHOT (Dev)</a>
+ 0.8.0-SNAPSHOT (dev)</a>
</li>
<li>
- <a href="tajo-0.2.0-doc.html" title="0.2.0-incubating (Current)">
+ <a href="tajo-0.2.0-doc.html" title="0.2.0-incubating release">
<i class="none"></i>
- 0.2.0-incubating (Current)</a>
+ 0.2.0-incubating release</a>
</li>
<li class="nav-header">Contributes</li>
Modified: incubator/tajo/site/dependency-management.html
URL: http://svn.apache.org/viewvc/incubator/tajo/site/dependency-management.html?rev=1574393&r1=1574392&r2=1574393&view=diff
==============================================================================
--- incubator/tajo/site/dependency-management.html (original)
+++ incubator/tajo/site/dependency-management.html Wed Mar 5 08:14:33 2014
@@ -1,13 +1,13 @@
<!DOCTYPE html>
<!--
- | Generated by Apache Maven Doxia at 2014-02-23
+ | Generated by Apache Maven Doxia at 2014-03-05
| Rendered using Apache Maven Fluido Skin 1.3.0
-->
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
- <meta name="Date-Revision-yyyymmdd" content="20140223" />
+ <meta name="Date-Revision-yyyymmdd" content="20140305" />
<meta http-equiv="Content-Language" content="en" />
<title>Tajo - A Big Data Warehouse System on Hadoop - Project Dependency Management</title>
<link rel="stylesheet" href="./css/apache-maven-fluido-1.3.0.min.css" />
@@ -102,10 +102,10 @@
<a href="#" class="dropdown-toggle" data-toggle="dropdown">Documentation <b class="caret"></b></a>
<ul class="dropdown-menu">
- <li> <a href="tajo-0.8.0-doc.html" title="0.8.0-SNAPSHOT (Dev)">0.8.0-SNAPSHOT (Dev)</a>
+ <li> <a href="docs/0.8.0/index.html" title="0.8.0-SNAPSHOT (dev)">0.8.0-SNAPSHOT (dev)</a>
</li>
- <li> <a href="tajo-0.2.0-doc.html" title="0.2.0-incubating (Current)">0.2.0-incubating (Current)</a>
+ <li> <a href="tajo-0.2.0-doc.html" title="0.2.0-incubating release">0.2.0-incubating release</a>
</li>
</ul>
</li>
@@ -206,7 +206,7 @@
- <li id="publishDate" class="pull-right">Last Published: 2014-02-23</li> <li class="divider pull-right">|</li>
+ <li id="publishDate" class="pull-right">Last Published: 2014-03-05</li> <li class="divider pull-right">|</li>
<li id="projectVersion" class="pull-right">Version: 0.8.0-SNAPSHOT</li>
</ul>
@@ -295,16 +295,16 @@
<li>
- <a href="tajo-0.8.0-doc.html" title="0.8.0-SNAPSHOT (Dev)">
+ <a href="docs/0.8.0/index.html" title="0.8.0-SNAPSHOT (dev)">
<i class="none"></i>
- 0.8.0-SNAPSHOT (Dev)</a>
+ 0.8.0-SNAPSHOT (dev)</a>
</li>
<li>
- <a href="tajo-0.2.0-doc.html" title="0.2.0-incubating (Current)">
+ <a href="tajo-0.2.0-doc.html" title="0.2.0-incubating release">
<i class="none"></i>
- 0.2.0-incubating (Current)</a>
+ 0.2.0-incubating release</a>
</li>
<li class="nav-header">Contributes</li>
Modified: incubator/tajo/site/distribution-management.html
URL: http://svn.apache.org/viewvc/incubator/tajo/site/distribution-management.html?rev=1574393&r1=1574392&r2=1574393&view=diff
==============================================================================
--- incubator/tajo/site/distribution-management.html (original)
+++ incubator/tajo/site/distribution-management.html Wed Mar 5 08:14:33 2014
@@ -1,13 +1,13 @@
<!DOCTYPE html>
<!--
- | Generated by Apache Maven Doxia at 2014-02-23
+ | Generated by Apache Maven Doxia at 2014-03-05
| Rendered using Apache Maven Fluido Skin 1.3.0
-->
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
- <meta name="Date-Revision-yyyymmdd" content="20140223" />
+ <meta name="Date-Revision-yyyymmdd" content="20140305" />
<meta http-equiv="Content-Language" content="en" />
<title>Tajo - A Big Data Warehouse System on Hadoop - Project Distribution Management</title>
<link rel="stylesheet" href="./css/apache-maven-fluido-1.3.0.min.css" />
@@ -102,10 +102,10 @@
<a href="#" class="dropdown-toggle" data-toggle="dropdown">Documentation <b class="caret"></b></a>
<ul class="dropdown-menu">
- <li> <a href="tajo-0.8.0-doc.html" title="0.8.0-SNAPSHOT (Dev)">0.8.0-SNAPSHOT (Dev)</a>
+ <li> <a href="docs/0.8.0/index.html" title="0.8.0-SNAPSHOT (dev)">0.8.0-SNAPSHOT (dev)</a>
</li>
- <li> <a href="tajo-0.2.0-doc.html" title="0.2.0-incubating (Current)">0.2.0-incubating (Current)</a>
+ <li> <a href="tajo-0.2.0-doc.html" title="0.2.0-incubating release">0.2.0-incubating release</a>
</li>
</ul>
</li>
@@ -206,7 +206,7 @@
- <li id="publishDate" class="pull-right">Last Published: 2014-02-23</li> <li class="divider pull-right">|</li>
+ <li id="publishDate" class="pull-right">Last Published: 2014-03-05</li> <li class="divider pull-right">|</li>
<li id="projectVersion" class="pull-right">Version: 0.8.0-SNAPSHOT</li>
</ul>
@@ -295,16 +295,16 @@
<li>
- <a href="tajo-0.8.0-doc.html" title="0.8.0-SNAPSHOT (Dev)">
+ <a href="docs/0.8.0/index.html" title="0.8.0-SNAPSHOT (dev)">
<i class="none"></i>
- 0.8.0-SNAPSHOT (Dev)</a>
+ 0.8.0-SNAPSHOT (dev)</a>
</li>
<li>
- <a href="tajo-0.2.0-doc.html" title="0.2.0-incubating (Current)">
+ <a href="tajo-0.2.0-doc.html" title="0.2.0-incubating release">
<i class="none"></i>
- 0.2.0-incubating (Current)</a>
+ 0.2.0-incubating release</a>
</li>
<li class="nav-header">Contributes</li>
Added: incubator/tajo/site/docs/0.8.0/.buildinfo
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/.buildinfo?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/.buildinfo (added)
+++ incubator/tajo/site/docs/0.8.0/.buildinfo Wed Mar 5 08:14:33 2014
@@ -0,0 +1,4 @@
+# Sphinx build info version 1
+# This file hashes the configuration used when building these files. When it is not found, a full rebuild will be done.
+config: 302f17d8f35dce9a86b6d455a79faa5e
+tags: 645f666f9bcd5a90fca523b33c5a78b7
Added: incubator/tajo/site/docs/0.8.0/_sources/backup_and_restore.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/backup_and_restore.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/backup_and_restore.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/backup_and_restore.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,8 @@
+************************
+Backup and Restore
+************************
+
+.. toctree::
+ :maxdepth: 1
+
+ backup_and_restore/catalog
Added: incubator/tajo/site/docs/0.8.0/_sources/backup_and_restore/catalog.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/backup_and_restore/catalog.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/backup_and_restore/catalog.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/backup_and_restore/catalog.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,48 @@
+***************************
+Backup and Restore Catalog
+***************************
+
+Now, Tajo supports a two backup methods for
+
+* SQL dump
+* Database-level backup
+
+==========
+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: ::
+
+ $ tajo_dump table_name > outfile
+
+For example, if you want to backup a table customer, you should type a command as follows: ::
+
+ $ bin/tajo_dump customer > table_backup.sql
+ $
+ $ cat table_backup.sql
+ -- Tajo database dump
+ -- Dump date: 10/04/2013 16:28:03
+ --
+
+ --
+ -- Name: customer; Type: TABLE; Storage: CSV
+ -- Path: file:/home/hyunsik/tpch/customer
+ --
+ CREATE EXTERNAL TABLE customer (c_custkey INT8, c_name TEXT, c_address TEXT, c_nationkey INT8, c_phone TEXT, c_acctbal FLOAT8, c_mktsegment TEXT, c_comment TEXT) USING CSV LOCATION 'file:/home/hyunsik/tpch/customer';
+
+
+If you want to restore the catalog from the SQL dump file, please type the below command: ::
+
+ $ bin/tsql -f table_backup.sql
+
+
+If you use an option '-a', tajo_dump will dump all table DDLs. ::
+
+ $ bin/tajo_dump -a > all_backup.sql
+
+=======================
+Database-level backup
+=======================
+
+.. todo::
+
Added: incubator/tajo/site/docs/0.8.0/_sources/cli.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/cli.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/cli.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/cli.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,101 @@
+*****************************
+Command Line Interface (TSQL)
+*****************************
+
+==========
+Synopsis
+==========
+
+.. code-block:: bash
+
+ bin/tsql [options]
+
+
+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
+
+ tajo>
+
+If you want to connect a specified TajoMaster, you should use '-h' and (or) 'p' options as follows: ::
+
+ bin/tsql -h localhost -p 9004
+
+ tajo>
+
+===================
+ 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: ::
+
+ tajo> \?
+
+ General
+ \copyright show Apache License 2.0
+ \version show Tajo version
+ \? show help
+ \q quit tsql
+
+
+ Informational
+ \d list tables
+ \d NAME describe table
+
+
+ Documentations
+ tsql guide http://wiki.apache.org/tajo/tsql
+ Query language http://wiki.apache.org/tajo/QueryLanguage
+ Functions http://wiki.apache.org/tajo/Functions
+ Backup & restore http://wiki.apache.org/tajo/BackupAndRestore
+ Configuration http://wiki.apache.org/tajo/Configuration
+
+
+================
+Examples
+================
+
+If you want to list all table names, use '\d' meta command as follows: ::
+
+ tajo> \d
+ customer
+ lineitem
+ nation
+ orders
+ part
+ partsupp
+ region
+ supplier
+
+Now look at the table description: ::
+
+ tajo> \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
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/configuration.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/configuration.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/configuration.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/configuration.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,13 @@
+************************
+Configuration
+************************
+
+.. toctree::
+ :maxdepth: 1
+
+ configuration/preliminary
+ configuration/cluster_setup
+ configuration/tajo_master_configuration
+ configuration/worker_configuration
+ configuration/catalog_configuration
+ configuration/configuration_defaults
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/configuration/catalog_configuration.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/configuration/catalog_configuration.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/configuration/catalog_configuration.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/configuration/catalog_configuration.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,96 @@
+******************************
+Catalog Configuration
+******************************
+
+If you want to customize the catalog service, copy ``$TAJO_HOME/conf/catalog-site.xml.template`` to ``catalog-site.xml``. Then, add the following configs to catalog-site.xml. Note that the default configs are enough to launch Tajo cluster in most cases.
+
+* tajo.catalog.master.addr - If you want to launch a Tajo cluster in distributed mode, you must specify this address. For more detail information, see [Default Ports](#DefaultPorts).
+* tajo.catalog.store.class - If you want to change the persistent storage of the catalog server, specify the class name. Its default value is tajo.catalog.store.DerbyStore. In the current version, Tajo provides three persistent storage classes as follows:
+
++-----------------------------------+------------------------------------------------+
+| Driver Class | Descriptions |
++===================================+================================================+
+| tajo.catalog.store.DerbyStore | this storage class uses Apache Derby. |
++-----------------------------------+------------------------------------------------+
+| tajo.catalog.store.MySQLStore | this storage class uses MySQL. |
++-----------------------------------+------------------------------------------------+
+| tajo.catalog.store.MemStore | this is the in-memory storage. It is only used |
+| | in unit tests to shorten the duration of unit |
+| | tests. |
++-----------------------------------+------------------------------------------------+
+| tajo.catalog.store.HCatalogStore | this storage class uses HiveMetaStore. |
++-----------------------------------+------------------------------------------------+
+
+=========================
+MySQLStore Configuration
+=========================
+
+If you want to use MySQLStore, you must create database and user on mysql for tajo.
+
+And then, you need to prepare mysql jdbc driver on host which can be ran TajoMaster. If you do, you should set ``TAJO_CLASSPATH`` variable in ``conf/tajo-env.sh`` with it as follows:
+
+.. code-block:: sh
+
+ export TAJO_CLASSPATH=/usr/local/mysql/lib/mysql-connector-java-x.x.x.jar
+
+Or you just can copy jdbc driver into $TAJO_HOME/lib.
+
+Finally, you should add the following config 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>
+ </property>
+ <property>
+ <name>tajo.catalog.jdbc.connection.password</name>
+ <value><mysql user password></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>
+
+
+----------------------------------
+ HCatalogStore Configuration
+----------------------------------
+
+Tajo support HCatalogStore to integrate with hive. If you want to use HCatalogStore, you just do as follows.
+
+First, you must compile source code and get a binary archive as follows:
+
+.. code-block:: sh
+
+ $ git clone https://git-wip-us.apache.org/repos/asf/incubator-tajo.git tajo
+ $ mvn clean package -DskipTests -Pdist -Dtar -Phcatalog-0.1x.0
+ $ ls tajo-dist/target/tajo-0.8.0-SNAPSHOT.tar.gz
+
+Tajo support to build based on hive 0.11.0 and hive 0.12.0. If you use hive 0.11.0, you have to set ``-Phcatalog-0.11.0``. And if you use hive 0.12.0, you have to set ``-Phcatalog-0.12.0``.
+
+Second, you must set your hive home directory to HIVE_HOME variable in ``conf/tajo-env.sh`` with it as follows:
+
+.. code-block:: sh
+
+ export HIVE_HOME=/path/to/your/hive/directory
+
+Third, if you need to use jdbc to connect HiveMetaStore, you have to prepare mysql jdbc driver on host which can be ran TajoMaster. If you prepare it, you should set jdbc driver file path to ``HIVE_JDBC_DRIVER_DIR`` variable in conf/tajo-env.sh with it as follows:
+
+.. code-block:: sh
+
+ export HIVE_JDBC_DRIVER_DIR=/path/to/your/mysql_jdbc_driver/mysql-connector-java-x.x.x-bin.jar
+
+
+Lastly, you should add the following config to ``conf/catalog-site.xml`` :
+
+.. code-block:: xml
+
+ <property>
+ <name>tajo.catalog.store.class</name>
+ <value>org.apache.tajo.catalog.store.HCatalogStore</value>
+ </property>
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/configuration/cluster_setup.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/configuration/cluster_setup.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/configuration/cluster_setup.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/configuration/cluster_setup.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,10 @@
+*******************************************
+Tajo run modes: Standalone and Distributed
+*******************************************
+
+
+
+==========================================
+Standalone Mode
+==========================================
+
Added: incubator/tajo/site/docs/0.8.0/_sources/configuration/configuration_defaults.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/configuration/configuration_defaults.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/configuration/configuration_defaults.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/configuration/configuration_defaults.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,28 @@
+**********************
+Configuration Defaults
+**********************
+
+====================================
+Tajo Master Configuration Defaults
+====================================
+
+============================ ============================================================== =========== ===============
+ Service Name Config Property Name Description default address
+============================ ============================================================== =========== ===============
+Tajo Master Umbilical Rpc tajo.master.umbilical-rpc.address localhost:26001
+Tajo Master Client Rpc tajo.master.client-rpc.address localhost:26002
+Tajo Master Info Http tajo.master.info-http.address 0.0.0.0:26080
+Tajo Catalog Client Rpc tajo.catalog.client-rpc.address localhost:26005
+============================ ============================================================== =========== ===============
+
+====================================
+Tajo Worker Configuration Defaults
+====================================
+
+============================ ============================================================== =========== ===============
+ Service Name Config Property Name Description default address
+============================ ============================================================== =========== ===============
+Tajo Worker Peer Rpc tajo.worker.peer-rpc.address 0.0.0.0:28091
+Tajo Worker Client Rpc tajo.worker.client-rpc.address 0.0.0.0:28092
+Tajo Worker Info Http tajo.worker.info-http.address 0.0.0.0:28080
+============================ ============================================================== =========== ===============
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/configuration/preliminary.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/configuration/preliminary.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/configuration/preliminary.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/configuration/preliminary.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,40 @@
+***************
+Preliminary
+***************
+
+===================================
+catalog-site.xml and tajo-site.xml
+===================================
+Tajo's configuration is based on Hadoop's configuration system. Tajo uses two config files:
+
+* catalog-site.xml - configuration for the catalog server.
+* tajo-site.xml - configuration for other tajo modules.
+
+Each config consists of a pair of a name and a value. If you want to set the config name ``a.b.c`` with the value ``123``, add the following element to an appropriate file.
+
+.. code-block:: xml
+
+ <property>
+ <name>a.b.c</name>
+ <value>123</value>
+ </property>
+
+Tajo has a variety of internal configs. If you don't set some config explicitly, the default config will be used for for that config. Tajo is designed to use only a few of configs in usual cases. You may not be concerned with the configuration.
+
+In default, there is no ``tajo-site.xml`` in ``${TAJO}/conf`` directory. If you set some configs, first copy ``$TAJO_HOME/conf/tajo-site.xml.templete`` to ``tajo-site.xml``. Then, add the configs to your tajo-site.
+
+============
+tajo-env.sh
+============
+
+tajo-env.sh is a shell script file. The main purpose of this file is to set shell environment variables for TajoMaster and TajoWorker java program. So, you can set some variable as follows:
+
+.. code-block:: sh
+
+ VARIABLE=value
+
+If a value is a literal string, type this as follows:
+
+.. code-block:: sh
+
+ VARIABLE='value'
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/configuration/tajo_master_configuration.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/configuration/tajo_master_configuration.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/configuration/tajo_master_configuration.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/configuration/tajo_master_configuration.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,32 @@
+**************************
+Tajo Master Configuration
+**************************
+
+================================================
+ Tajo Rootdir
+================================================
+
+Tajo uses HDFS as a primary storage layer. So, one Tajo cluster instance should have one tajo rootdir. A user is allowed to specific your tajo rootdir as follows:
+
+.. code-block:: xml
+
+ <property>
+ <name>tajo.rootdir</name>
+ <value>hdfs://namenode_hostname:port/path</value>
+ </property>
+
+Tajo rootdir must be a url form like ``scheme://hostname:port/path``. The current implementaion only supports ``hdfs://`` and ``file://`` schemes. The default value is ``file:///tmp/tajo-${user.name}/``.
+
+================================================
+TajoMaster Heap Memory Size
+================================================
+
+The environment variable TAJO_MASTER_HEAPSIZE in conf/tajo-env.sh allow Tajo Master to use the specified heap memory size.
+
+If you want to adjust heap memory size, set ``TAJO_MASTER_HEAPSIZE`` variable in ``conf/tajo-env.sh`` with a proper size as follows:
+
+.. code-block:: sh
+
+ TAJO_MASTER_HEAPSIZE=2000
+
+The default size is 1000 (1GB).
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/configuration/worker_configuration.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/configuration/worker_configuration.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/configuration/worker_configuration.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/configuration/worker_configuration.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,105 @@
+*********************
+Worker Configuration
+*********************
+
+========================
+Worker Heap Memory Size
+========================
+
+The environment variable ``TAJO_WORKER_HEAPSIZE`` in ``conf/tajo-env.sh`` allow Tajo Worker to use the specified heap memory size.
+
+If you want to adjust heap memory size, set ``TAJO_WORKER_HEAPSIZE`` variable in ``conf/tajo-env.sh`` with a proper size as follows:
+
+.. code-block:: bash
+
+ TAJO_WORKER_HEAPSIZE=8000
+
+The default size is 1000 (1GB).
+
+========================
+Temporary Data Directory
+========================
+
+TajoWorker stores temporary data on local file system due to out-of-core algorithms. It is possible to specify one or more temporary data directories where temporary data will be stored.
+
+``tajo-site.xml``
+
+.. code-block:: xml
+
+ <property>
+ <name>tajo.worker.tmpdir.locations</name>
+ <value>/disk1/tmpdir,/disk2/tmpdir,/disk3/tmpdir</value>
+ </property>
+
+
+==========================================================
+Maximum number of parallel running tasks for each worker
+==========================================================
+
+In Tajo, the capacity of running tasks in parallel are determined by available resources and workload of running queries. In order to specify it, please see [Worker Resources] (#ResourceConfiguration) section.
+
+==========================================================
+Worker Resources
+==========================================================
+
+Each worker can execute multiple tasks simultaneously.
+In Tajo, users can specify the total size of memory and the number of disks for each worker. Available resources affect how many tasks are executed simultaneously.
+
+In order to specify the resource capacity of each worker, you should add the following configs to ``tajo-site.xml`` :
+
+================================= ========================== =================== =========================
+ property name description value type default value
+================================= ========================== =================== =========================
+ tajo.worker.resource.cpu-cores the number of cpu cores integer 1
+ tajo.worker.resource.memory-mb memory size (MB) integer 1024
+ tajo.worker.resource.disks the number of disks integer 1
+================================= ========================== =================== =========================
+
+.. note::
+
+ Currently, QueryMaster requests 512MB memory and 1.0 disk per task for the backward compatibility.
+
+------------
+ Example
+------------
+
+Assume that you want to give 5120 MB memory, 6.0 disks, and 24 cores on each worker. The example configuration is as follows:
+
+``tajo-site.xml``
+
+.. code-block:: xml
+
+ <property>
+ <name>tajo.worker.resource.tajo.worker.resource.cpu-cores</name>
+ <value>24</value>
+ </property>
+
+ <property>
+ <name>tajo.worker.resource.memory-mb</name>
+ <value>5120</value>
+ </property>
+
+ <property>
+ <name>tajo.worker.resource.tajo.worker.resource.disks</name>
+ <value>6.0</value>
+ </property>
+
+--------------------
+ Dedicated Mode
+--------------------
+Tajo provides a dedicated mode that allows each worker in a Tajo cluster to use whole available system resources including cpu-cores, memory, and disks. For this mode, a user should add the following config to ``tajo-site.xml`` :
+
+.. code-block:: xml
+
+ <property>
+ <name>tajo.worker.resource.dedicated</name>
+ <value>true</value>
+ </property>
+
+In addition, it can limit the memory capacity used for Tajo worker as follows:
+
+=============================================== ================================================ =================== =======================
+ property name description value type default value
+=============================================== ================================================ =================== =======================
+ tajo.worker.resource.dedicated-memory-ratio how much memory to be used in whole memory float 0.8
+=============================================== ================================================ =================== =======================
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/faq.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/faq.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/faq.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/faq.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,5 @@
+*************************************
+FAQ
+*************************************
+
+.. todo::
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/functions.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/functions.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/functions.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/functions.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,10 @@
+******************
+Functions
+******************
+
+.. toctree::
+ :maxdepth: 1
+
+ functions/math_func_and_operators
+ functions/string_func_and_operators
+ functions/datetime_func_and_operators
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/functions/datetime_func_and_operators.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/functions/datetime_func_and_operators.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/functions/datetime_func_and_operators.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/functions/datetime_func_and_operators.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,5 @@
+********************************
+DateTime Functions and Operators
+********************************
+
+.. todo::
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/functions/math_func_and_operators.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/functions/math_func_and_operators.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/functions/math_func_and_operators.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/functions/math_func_and_operators.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,5 @@
+*****************************
+Math Functions and Operators
+*****************************
+
+.. todo::
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/functions/string_func_and_operators.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/functions/string_func_and_operators.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/functions/string_func_and_operators.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/functions/string_func_and_operators.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,154 @@
+*******************************
+String Functions and Operators
+*******************************
+
+.. function:: str1 || str2
+
+ Returns the concatnenated string of both side strings ``str1`` and ``str2``.
+
+ :param str1: first string
+ :param str2: second string
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select âTaâ || âjoâ;
+ > 'Tajo'
+
+
+.. function:: char_length (string text)
+
+ Returns Number of characters in string
+
+ :param string: to be counted
+ :rtype: int4
+ :alias: character_length
+ :example:
+
+ .. code-block:: sql
+
+ select char_length(âTajoâ);
+ > 4
+
+
+.. function:: trim([leading | trailing | both] [characters] from string)
+
+ Removes the characters (a space by default) from the start/end/both ends of the string
+
+ :param string:
+ :param characters:
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select trim(both âxâ from âxTajoxxâ);
+ > Tajo
+
+
+.. function:: btrim(string text, [characters text])
+
+ Removes the characters (a space by default) from the both ends of the string
+
+ :param string:
+ :param characters:
+ :rtype: text
+ :alias: trim
+ :example:
+
+ .. code-block:: sql
+
+ select btrim(âxTajoxxâ, âxâ);
+ > Tajo
+
+
+.. function:: ltrim(string text, [characters text])
+
+ Removes the characters (a space by default) from the start ends of the string
+
+ :param string:
+ :param characters:
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select ltrim(âxxTajoâ, âxâ);
+ > Tajo
+
+
+.. function:: rtrim(string text, [characters text])
+
+ Removes the characters (a space by default) from the end ends of the string
+
+ :param string:
+ :param characters:
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select rtrim('Tajoxx', 'x');
+ > Tajo
+
+
+.. function:: split_part(string text, delimiter text, field int)
+
+ Splits a string on delimiter and return the given field (counting from one)
+
+ :param string:
+ :param delimiter:
+ :param field:
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select split_part(âab_bc_cdâ,â_â,2);
+ > bc
+
+
+
+.. function:: regexp_replace(string text, pattern text, replacement text)
+
+ Replaces substrings matched to a given regular expression pattern
+
+ :param string:
+ :param pattern:
+ :param replacement:
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select regexp_replace(âabcdefâ, â(Ëab|ef$)â, âââ);
+ > âcdâ
+
+
+.. function:: upper(string text)
+
+ makes an input text to be upper case
+
+ :param string:
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select upper('tajo');
+ > TAJO
+
+
+.. function:: lower(string text)
+
+ makes an input text to be lower case
+
+ :param string:
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select lower('TAJO');
+ > tajo
Added: incubator/tajo/site/docs/0.8.0/_sources/getting_started.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/getting_started.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/getting_started.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/getting_started.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,14 @@
+***************
+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
+
+ getting_started/prerequisites
+ getting_started/downloading_source
+ getting_started/building
+ getting_started/local_setup
+ getting_started/first_query
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/getting_started/building.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/getting_started/building.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/getting_started/building.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/getting_started/building.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,22 @@
+*****************
+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 package -DskipTests -Pdist -Dtar
+ $ ls tajo-dist/target/tajo-x.y.z-SNAPSHOT.tar.gz
+
+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
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/getting_started/downloading_source.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/getting_started/downloading_source.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/getting_started/downloading_source.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/getting_started/downloading_source.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,32 @@
+****************************************************
+Dowload and unpack the source code of Apache Tajo
+****************************************************
+
+You can get either the source code release of Apache Tajo or check out the development code base from Git.
+
+================================================
+Dowload the latest source release
+================================================
+
+Choose a download site from this list of `Apache Download Mirrors <http://www.apache.org/dyn/closer.cgi/incubator/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-0.8.0-incubating.tar.gz.
+
+Decompress and untar your download and then change into the unpacked directory. ::
+
+ tar xzvf tajo-0.8.0-incubating.tar.gz
+
+================================================
+Get 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/incubator-tajo.git>`_ as follows: ::
+
+ git clone https://git-wip-us.apache.org/repos/asf/incubator-tajo.git
+
+A read-only git repository is also mirrored on `Github <https://github.com/apache/incubator-tajo>`_.
+
+Once you have downloaded Tajo, follow the `getting started instructions <http://tajo.incubator.apache.org/tajo-0.8.0-doc.html#GettingStarted>`_, and take a look at the rest of the Tajo documentation.
+
+
+
Added: incubator/tajo/site/docs/0.8.0/_sources/getting_started/first_query.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/getting_started/first_query.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/getting_started/first_query.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/getting_started/first_query.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,68 @@
+************************
+First query execution
+************************
+
+First of all, we need to prepare some data for query execution. For example, you can make a simple text-based table as follows: ::
+
+ $ 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>
+
+This schema of this table is (int, text, float, text). ::
+
+ $ $TAJO_HOME/bin/tsql
+ tajo> create external table table1 (
+ id int,
+ name text,
+ score float,
+ type text)
+ using csv with ('csvfile.delimiter'='|') location 'file:/home/x/table1';
+
+In order 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>
+
+
+
Added: incubator/tajo/site/docs/0.8.0/_sources/getting_started/local_setup.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/getting_started/local_setup.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/getting_started/local_setup.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/getting_started/local_setup.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,22 @@
+**********************************
+Setting up a local Tajo cluster
+**********************************
+
+First of all, you need to add the environment variables to conf/tajo-env.sh. ::
+
+ # Hadoop home. Required
+ export HADOOP_HOME= ...
+
+ # The java implementation to use. Required.
+ export JAVA_HOME= ...
+
+To launch the tajo master, execute start-tajo.sh. ::
+
+ $ $TAJO_HOME/bin/start-tajo.sh
+
+After then, you can use tsql, which is the command line shell of Tajo. ::
+
+ $ $TAJO_HOME/bin/tsql
+ tajo>
+
+If you want to how to use tsql, read Tajo Interactive Shell document.
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/getting_started/prerequisites.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/getting_started/prerequisites.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/getting_started/prerequisites.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/getting_started/prerequisites.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,7 @@
+**********************
+Prerequisites
+**********************
+
+ * Hadoop 2.2.0 and higher
+ * Java 1.6 or higher
+ * Protocol buffer 2.5.0
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/hcatalog_integration.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/hcatalog_integration.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/hcatalog_integration.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/hcatalog_integration.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,5 @@
+*************************************
+HCatalog Integration
+*************************************
+
+.. todo::
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/index.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/index.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/index.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/index.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,46 @@
+.. Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+.. http://www.apache.org/licenses/LICENSE-2.0
+
+.. Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+
+.. Apache Tajo documentation master file, created by
+ sphinx-quickstart on Thu Feb 27 08:29:11 2014.
+ You can adapt this file completely to your liking, but it should at least
+ contain the root `toctree` directive.
+
+Apache Tajo⢠0.8.0 (dev) - User documentation
+===========================================================================
+
+Table of Contents:
+
+.. toctree::
+ :maxdepth: 3
+
+ introduction
+ getting_started
+ configuration
+ cli
+ sql_language
+ functions
+ table_management
+ table_partitioning
+ backup_and_restore
+ hcatalog_integration
+ jdbc_driver
+ tajo_client_api
+ faq
+
+Indices and tables
+==================
+
+* :ref:`genindex`
+* :ref:`modindex`
+* :ref:`search`
+
Added: incubator/tajo/site/docs/0.8.0/_sources/introduction.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/introduction.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/introduction.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/introduction.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,13 @@
+***************
+Introduction
+***************
+
+The main goal of Apache Tajo project is to build an advanced open source
+data warehouse system in Hadoop for processing web-scale data sets.
+Basically, Tajo provides SQL standard as a query language.
+Tajo is designed for both interactive and batch queries on data sets
+stored on HDFS and other data sources. Without hurting query response
+times, Tajo provides fault-tolerance and dynamic load balancing which
+are necessary for long-running queries. Tajo employs a cost-based and
+progressive query optimization techniques for reoptimizing running
+queries in order to avoid the worst query plans.
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/jdbc_driver.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/jdbc_driver.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/jdbc_driver.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/jdbc_driver.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,9 @@
+*************************************
+Tajo JDBC Driver
+*************************************
+
+How to get JDBC driver
+=======================
+
+
+.. todo::
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/partitioning/column_partitioning.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/partitioning/column_partitioning.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/partitioning/column_partitioning.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/partitioning/column_partitioning.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,5 @@
+*********************************
+Column Partitioning
+*********************************
+
+.. todo::
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/partitioning/hash_partitioning.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/partitioning/hash_partitioning.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/partitioning/hash_partitioning.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/partitioning/hash_partitioning.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,5 @@
+********************************
+Hash Partitioning
+********************************
+
+.. todo::
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/partitioning/intro_to_partitioning.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/partitioning/intro_to_partitioning.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/partitioning/intro_to_partitioning.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/partitioning/intro_to_partitioning.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,16 @@
+**************************************
+Introduction to Partitioning
+**************************************
+
+======================
+Partition Key
+======================
+
+=========================
+Partitioning Methods
+=========================
+
+Tajo provides the following partitioning methods:
+ * Column Partitioning
+ * Range Partitioning (TODO)
+ * Hash Partitioning (TODO)
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/partitioning/range_partitioning.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/partitioning/range_partitioning.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/partitioning/range_partitioning.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/partitioning/range_partitioning.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,5 @@
+***************************
+Range Partitioning
+***************************
+
+.. todo::
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/sql_language.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/sql_language.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/sql_language.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/sql_language.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,13 @@
+************
+SQL Language
+************
+
+.. toctree::
+ :maxdepth: 1
+
+ sql_language/data_model
+ sql_language/ddl
+ sql_language/insert
+ sql_language/queries
+ sql_language/sql_expression
+ sql_language/predicates
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/sql_language/data_model.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/sql_language/data_model.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/sql_language/data_model.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/sql_language/data_model.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,66 @@
+**********
+Data Model
+**********
+
+===============
+Data Types
+===============
+
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| Supported | SQL Type Name | Alias | Size (byte) | Description | Range |
++===========+================+============================+=============+===================================================+==========================================================================+
+| O | boolean | bool | 1 | | true/false |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| | bit | | 1 | | 1/0 |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| | varbit | bit varying | | | |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| O | smallint | tinyint, int2 | 2 | small-range integer value | -2^15 (-32,768) to 2^15 (32,767) |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| O | integer | int, int4 | 4 | integer value | -2^31 (-2,147,483,648) to 2^31 - 1 (2,147,483,647) |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| O | bigint | bit varying | 8 | larger range integer value | -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807) |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| O | real | int8 | 4 | variable-precision, inexact, real number value | -3.4028235E+38 to 3.4028235E+38 (6 decimal digits precision) |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| O | float[(n)] | float4 | 4 or 8 | variable-precision, inexact, real number value | |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| O | double | float8, double precision | 8 | variable-precision, inexact, real number value | 1 .7Eâ308 to 1.7E+308 (15 decimal digits precision) |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| | number | decimal | | | |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| | char[(n)] | character | | | |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| | varchar[(n)] | character varying | | | |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| O | text | text | | variable-length unicode text | |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| | binary | binary | | | |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| | varbinary[(n)] | binary varying | | | |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| O | blob | bytea | | variable-length binary string | |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| | date | | | | |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| | time | | | | |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| | timetz | time with time zone | | | |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| | timestamp | | | | |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| | timestamptz | | | | |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+| O | inet4 | | 4 | IPv4 address | |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+
+-----------------------------------------
+Using real number value (real and double)
+-----------------------------------------
+
+The real and double data types are mapped to float and double of java primitives respectively. Java primitives float and double follows the IEEE 754 specification. So, these types are correctly matched to SQL standard data types.
+
++ float[( n )] is mapped to either float or double according to a given length n. If n is specified, it must be bewtween 1 and 53. The default value of n is 53.
++ If 1 <- n <- 24, a value is mapped to float (6 decimal digits precision).
++ If 25 <- n <- 53, a value is mapped to double (15 decimal digits precision).
++ Do not use approximate real number columns in WHERE clause in order to compare some exact matches, especially the - and <> operators. The > or < comparisons work well.
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/sql_language/ddl.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/sql_language/ddl.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/sql_language/ddl.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/sql_language/ddl.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,53 @@
+************************
+Data Definition Language
+************************
+
+
+========================
+CREATE TABLE
+========================
+
+*Synopsis*
+
+.. code-block:: sql
+
+ CREATE TABLE <table_name> [(<column_name> <data_type>, ... )]
+ [using <storage_type> [with (<key> = <value>, ...)]] [AS <select_statement>]
+
+ CREATE EXTERNAL TABLE
+
+ CREATE EXTERNAL TABLE <table_name> (<column_name> <data_type>, ... )
+ using <storage_type> [with (<key> = <value>, ...)] LOCATION '<path>'
+
+
+
+------------------------
+ Compression
+------------------------
+
+If you want to add an external table that contains compressed data, you should give 'compression.code' parameter to CREATE TABLE statement.
+
+.. code-block:: sql
+
+ create EXTERNAL table lineitem (
+ L_ORDERKEY bigint,
+ L_PARTKEY bigint,
+ ...
+ L_COMMENT text)
+
+ USING csv WITH ('csvfile.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:
+ * org.apache.hadoop.io.compress.BZip2Codec
+ * org.apache.hadoop.io.compress.DeflateCodec
+ * org.apache.hadoop.io.compress.GzipCodec
+ * org.apache.hadoop.io.compress.SnappyCodec
+
+========================
+ DROP TABLE
+========================
+
+.. code-block:: sql
+
+ DROP TABLE <table_name>
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/sql_language/insert.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/sql_language/insert.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/sql_language/insert.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/sql_language/insert.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,26 @@
+*************************
+INSERT (OVERWRITE) INTO
+*************************
+
+INSERT OVERWRITE statement overwrites a table data of an existing table or a data in a given directory. Tajo's INSERT OVERWRITE statement follows ``INSERT INTO SELECT`` statement of SQL. The examples are as follows:
+
+.. code-block:: sql
+
+ create table t1 (col1 int8, col2 int4, col3 float8);
+
+ -- when a target table schema and output schema are equivalent to each other
+ INSERT OVERWRITE INTO t1 SELECT l_orderkey, l_partkey, l_quantity FROM lineitem;
+ -- or
+ INSERT OVERWRITE INTO t1 SELECT * FROM lineitem;
+
+ -- when the output schema are smaller than the target table schema
+ INSERT OVERWRITE INTO t1 SELECT l_orderkey FROM lineitem;
+
+ -- when you want to specify certain target columns
+ INSERT OVERWRITE INTO t1 (col1, col3) SELECT l_orderkey, l_quantity FROM lineitem;
+
+In addition, INSERT OVERWRITE statement overwrites table data as well as a specific directory.
+
+.. code-block:: sql
+
+ INSERT OVERWRITE INTO LOCATION '/dir/subdir' SELECT l_orderkey, l_quantity FROM lineitem;
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/sql_language/predicates.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/sql_language/predicates.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/sql_language/predicates.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/sql_language/predicates.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,159 @@
+*****************
+ Predicates
+*****************
+
+=====================
+ IN Predicate
+=====================
+
+IN predicate provides row and array comparison.
+
+*Synopsis*
+
+.. code-block:: sql
+
+ column_reference IN (val1, val2, ..., valN)
+ column_reference NOT IN (val1, val2, ..., valN)
+
+
+Examples are as follows:
+
+.. code-block:: sql
+
+ -- this statement filters lists down all the records where col1 value is 1, 2 or 3:
+ SELECT col1, col2 FROM table1 WHERE col1 IN (1, 2, 3);
+
+ -- this statement filters lists down all the records where col1 value is neither 1, 2 nor 3:
+ SELECT col1, col2 FROM table1 WHERE col1 NOT IN (1, 2, 3);
+
+You can use 'IN clause' on text data domain as follows:
+
+.. code-block:: sql
+
+ SELECT col1, col2 FROM table1 WHERE col2 IN ('tajo', 'hadoop');
+
+ SELECT col1, col2 FROM table1 WHERE col2 NOT IN ('tajo', 'hadoop');
+
+
+==================================
+String Pattern Matching Predicates
+==================================
+
+--------------------
+LIKE
+--------------------
+
+LIKE operator returns true or false depending on whether its pattern matches the given string. An underscore (_) in pattern matches any single character. A percent sign (%) matches any sequence of zero or more characters.
+
+*Synopsis*
+
+.. code-block:: sql
+
+ string LIKE pattern
+ string NOT LIKE pattern
+
+
+--------------------
+ILIKE
+--------------------
+
+ILIKE is the same to LIKE, but it is a case insensitive operator. It is not in the SQL standard. We borrow this operator from PostgreSQL.
+
+*Synopsis*
+
+.. code-block:: sql
+
+ string ILIKE pattern
+ string NOT ILIKE pattern
+
+
+--------------------
+SIMILAR TO
+--------------------
+
+*Synopsis*
+
+.. code-block:: sql
+
+ string SIMILAR TO pattern
+ string NOT SIMILAR TO pattern
+
+It returns true or false depending on whether its pattern matches the given string. Also like LIKE, ``SIMILAR TO`` uses ``_`` and ``%`` as metacharacters denoting any single character and any string, respectively.
+
+In addition to these metacharacters borrowed from LIKE, 'SIMILAR TO' supports more powerful pattern-matching metacharacters borrowed from regular expressions:
+
++------------------------+-------------------------------------------------------------------------------------------+
+| metacharacter | description |
++========================+===========================================================================================+
+| | | denotes alternation (either of two alternatives). |
++------------------------+-------------------------------------------------------------------------------------------+
+| * | denotes repetition of the previous item zero or more times. |
++------------------------+-------------------------------------------------------------------------------------------+
+| + | denotes repetition of the previous item one or more times. |
++------------------------+-------------------------------------------------------------------------------------------+
+| ? | denotes repetition of the previous item zero or one time. |
++------------------------+-------------------------------------------------------------------------------------------+
+| {m} | denotes repetition of the previous item exactly m times. |
++------------------------+-------------------------------------------------------------------------------------------+
+| {m,} | denotes repetition of the previous item m or more times. |
++------------------------+-------------------------------------------------------------------------------------------+
+| {m,n} | denotes repetition of the previous item at least m and not more than n times. |
++------------------------+-------------------------------------------------------------------------------------------+
+| [] | A bracket expression specifies a character class, just as in POSIX regular expressions. |
++------------------------+-------------------------------------------------------------------------------------------+
+| () | Parentheses can be used to group items into a single logical item. |
++------------------------+-------------------------------------------------------------------------------------------+
+
+Note that `.`` is not used as a metacharacter in ``SIMILAR TO`` operator.
+
+---------------------
+Regular expressions
+---------------------
+
+Regular expressions provide a very powerful means for string pattern matching. In the current Tajo, regular expressions are based on Java-style regular expressions instead of POSIX regular expression. The main difference between java-style one and POSIX's one is character class.
+
+*Synopsis*
+
+.. code-block:: sql
+
+ string ~ pattern
+ string !~ pattern
+
+ string ~* pattern
+ string !~* pattern
+
++----------+---------------------------------------------------------------------------------------------------+
+| operator | Description |
++==========+===================================================================================================+
+| ~ | It returns true if a given regular expression is matched to string. Otherwise, it returns false. |
++----------+---------------------------------------------------------------------------------------------------+
+| !~ | It returns false if a given regular expression is matched to string. Otherwise, it returns true. |
++----------+---------------------------------------------------------------------------------------------------+
+| ~* | It is the same to '~', but it is case insensitive. |
++----------+---------------------------------------------------------------------------------------------------+
+| !~* | It is the same to '!~', but it is case insensitive. |
++----------+---------------------------------------------------------------------------------------------------+
+
+Here are examples:
+
+.. code-block:: sql
+
+ 'abc' ~ '.*c' true
+ 'abc' ~ 'c' false
+ 'aaabc' ~ '([a-z]){3}bc true
+ 'abc' ~* '.*C' true
+ 'abc' !~* 'B.*' true
+
+Regular expressions operator is not in the SQL standard. We borrow this operator from PostgreSQL.
+
+*Synopsis for REGEXP and RLIKE operators*
+
+.. code-block:: sql
+
+ string REGEXP pattern
+ string NOT REGEXP pattern
+
+ string RLIKE pattern
+ string NOT RLIKE pattern
+
+But, they do not support case-insensitive operators.
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/_sources/sql_language/queries.txt
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/_sources/sql_language/queries.txt?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/_sources/sql_language/queries.txt (added)
+++ incubator/tajo/site/docs/0.8.0/_sources/sql_language/queries.txt Wed Mar 5 08:14:33 2014
@@ -0,0 +1,38 @@
+**************************
+Queries
+**************************
+
+=====================
+Overview
+=====================
+
+*Synopsis*
+
+.. code-block:: sql
+
+ SELECT [distinct [all]] * | <expression> [[AS] <alias>] [, ...]
+ [FROM <table name> [[AS] <table alias name>] [, ...]]
+ [WHERE <condition>]
+ [GROUP BY <expression> [, ...]]
+ [HAVING <condition>]
+ [ORDER BY <expression> [ASC|DESC] [NULL FIRST|NULL LAST] [, ...]]
+
+
+
+=====================
+From Clause
+=====================
+
+
+=====================
+Where Clause
+=====================
+
+
+=====================
+Groupby Clause
+=====================
+
+=====================
+Select list
+=====================
\ No newline at end of file