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 2015/06/30 06:16:55 UTC
svn commit: r1688350 [31/34] - in /tajo/site/docs: 0.10.1/ 0.10.1/_sources/
0.10.1/_sources/backup_and_restore/ 0.10.1/_sources/configuration/
0.10.1/_sources/functions/ 0.10.1/_sources/index/
0.10.1/_sources/partitioning/ 0.10.1/_sources/sql_language/...
Modified: tajo/site/docs/current/partitioning/hash_partitioning.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/partitioning/hash_partitioning.html?rev=1688350&r1=1688349&r2=1688350&view=diff
==============================================================================
--- tajo/site/docs/current/partitioning/hash_partitioning.html (original)
+++ tajo/site/docs/current/partitioning/hash_partitioning.html Tue Jun 30 04:16:52 2015
@@ -7,7 +7,7 @@
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Hash Partitioning — Apache Tajo 0.10.0 documentation</title>
+ <title>Hash Partitioning — Apache Tajo 0.11.0 documentation</title>
@@ -28,7 +28,7 @@
- <link rel="top" title="Apache Tajo 0.10.0 documentation" href="../index.html"/>
+ <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/>
<link rel="up" title="Table Partitioning" href="../table_partitioning.html"/>
<link rel="next" title="Index (Experimental Feature)" href="../index_overview.html"/>
<link rel="prev" title="Range Partitioning" href="range_partitioning.html"/>
@@ -113,6 +113,7 @@
<li class="toctree-l2"><a class="reference internal" href="../functions/string_func_and_operators.html">String Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="../functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="../functions/network_func_and_operators.html">Network Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../functions/json_func.html">JSON Functions</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul>
@@ -146,11 +147,17 @@
<li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#usage">Usage</a></li>
</ul>
</li>
+<li class="toctree-l1"><a class="reference internal" href="../swift_integration.html">OpenStack Swift Integration</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#swift-configuration">Swift configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#hadoop-configurations">Hadoop configurations</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#tajo-configuration">Tajo configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#querying-on-swift">Querying on Swift</a></li>
+</ul>
+</li>
<li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul>
<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li>
<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li>
<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li>
-<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="../tajo_client_api.html">Tajo Client API</a></li>
@@ -236,7 +243,7 @@
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT:'../',
- VERSION:'0.10.0',
+ VERSION:'0.11.0',
COLLAPSE_INDEX:false,
FILE_SUFFIX:'.html',
HAS_SOURCE: true
Modified: tajo/site/docs/current/partitioning/intro_to_partitioning.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/partitioning/intro_to_partitioning.html?rev=1688350&r1=1688349&r2=1688350&view=diff
==============================================================================
--- tajo/site/docs/current/partitioning/intro_to_partitioning.html (original)
+++ tajo/site/docs/current/partitioning/intro_to_partitioning.html Tue Jun 30 04:16:52 2015
@@ -7,7 +7,7 @@
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Introduction to Partitioning — Apache Tajo 0.10.0 documentation</title>
+ <title>Introduction to Partitioning — Apache Tajo 0.11.0 documentation</title>
@@ -28,7 +28,7 @@
- <link rel="top" title="Apache Tajo 0.10.0 documentation" href="../index.html"/>
+ <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/>
<link rel="up" title="Table Partitioning" href="../table_partitioning.html"/>
<link rel="next" title="Column Partitioning" href="column_partitioning.html"/>
<link rel="prev" title="Table Partitioning" href="../table_partitioning.html"/>
@@ -113,6 +113,7 @@
<li class="toctree-l2"><a class="reference internal" href="../functions/string_func_and_operators.html">String Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="../functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="../functions/network_func_and_operators.html">Network Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../functions/json_func.html">JSON Functions</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul>
@@ -146,11 +147,17 @@
<li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#usage">Usage</a></li>
</ul>
</li>
+<li class="toctree-l1"><a class="reference internal" href="../swift_integration.html">OpenStack Swift Integration</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#swift-configuration">Swift configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#hadoop-configurations">Hadoop configurations</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#tajo-configuration">Tajo configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#querying-on-swift">Querying on Swift</a></li>
+</ul>
+</li>
<li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul>
<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li>
<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li>
<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li>
-<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="../tajo_client_api.html">Tajo Client API</a></li>
@@ -247,7 +254,7 @@ Currently, Apache Tajo only provides Apa
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT:'../',
- VERSION:'0.10.0',
+ VERSION:'0.11.0',
COLLAPSE_INDEX:false,
FILE_SUFFIX:'.html',
HAS_SOURCE: true
Modified: tajo/site/docs/current/partitioning/range_partitioning.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/partitioning/range_partitioning.html?rev=1688350&r1=1688349&r2=1688350&view=diff
==============================================================================
--- tajo/site/docs/current/partitioning/range_partitioning.html (original)
+++ tajo/site/docs/current/partitioning/range_partitioning.html Tue Jun 30 04:16:52 2015
@@ -7,7 +7,7 @@
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Range Partitioning — Apache Tajo 0.10.0 documentation</title>
+ <title>Range Partitioning — Apache Tajo 0.11.0 documentation</title>
@@ -28,7 +28,7 @@
- <link rel="top" title="Apache Tajo 0.10.0 documentation" href="../index.html"/>
+ <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/>
<link rel="up" title="Table Partitioning" href="../table_partitioning.html"/>
<link rel="next" title="Hash Partitioning" href="hash_partitioning.html"/>
<link rel="prev" title="Column Partitioning" href="column_partitioning.html"/>
@@ -113,6 +113,7 @@
<li class="toctree-l2"><a class="reference internal" href="../functions/string_func_and_operators.html">String Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="../functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="../functions/network_func_and_operators.html">Network Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../functions/json_func.html">JSON Functions</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul>
@@ -146,11 +147,17 @@
<li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#usage">Usage</a></li>
</ul>
</li>
+<li class="toctree-l1"><a class="reference internal" href="../swift_integration.html">OpenStack Swift Integration</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#swift-configuration">Swift configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#hadoop-configurations">Hadoop configurations</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#tajo-configuration">Tajo configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#querying-on-swift">Querying on Swift</a></li>
+</ul>
+</li>
<li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul>
<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li>
<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li>
<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li>
-<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="../tajo_client_api.html">Tajo Client API</a></li>
@@ -236,7 +243,7 @@
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT:'../',
- VERSION:'0.10.0',
+ VERSION:'0.11.0',
COLLAPSE_INDEX:false,
FILE_SUFFIX:'.html',
HAS_SOURCE: true
Modified: tajo/site/docs/current/search.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/search.html?rev=1688350&r1=1688349&r2=1688350&view=diff
==============================================================================
--- tajo/site/docs/current/search.html (original)
+++ tajo/site/docs/current/search.html Tue Jun 30 04:16:52 2015
@@ -7,7 +7,7 @@
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Search — Apache Tajo 0.10.0 documentation</title>
+ <title>Search — Apache Tajo 0.11.0 documentation</title>
@@ -28,7 +28,7 @@
- <link rel="top" title="Apache Tajo 0.10.0 documentation" href="index.html"/>
+ <link rel="top" title="Apache Tajo 0.11.0 documentation" href="index.html"/>
<script src="https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js"></script>
@@ -110,6 +110,7 @@
<li class="toctree-l2"><a class="reference internal" href="functions/string_func_and_operators.html">String Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/network_func_and_operators.html">Network Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="functions/json_func.html">JSON Functions</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="table_management.html">Table Management</a><ul>
@@ -143,11 +144,17 @@
<li class="toctree-l2"><a class="reference internal" href="hbase_integration.html#usage">Usage</a></li>
</ul>
</li>
+<li class="toctree-l1"><a class="reference internal" href="swift_integration.html">OpenStack Swift Integration</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="swift_integration.html#swift-configuration">Swift configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="swift_integration.html#hadoop-configurations">Hadoop configurations</a></li>
+<li class="toctree-l2"><a class="reference internal" href="swift_integration.html#tajo-configuration">Tajo configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="swift_integration.html#querying-on-swift">Querying on Swift</a></li>
+</ul>
+</li>
<li class="toctree-l1"><a class="reference internal" href="jdbc_driver.html">Tajo JDBC Driver</a><ul>
<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li>
<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li>
<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li>
-<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#faq">FAQ</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="tajo_client_api.html">Tajo Client API</a></li>
@@ -226,7 +233,7 @@
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT:'./',
- VERSION:'0.10.0',
+ VERSION:'0.11.0',
COLLAPSE_INDEX:false,
FILE_SUFFIX:'.html',
HAS_SOURCE: true
Modified: tajo/site/docs/current/searchindex.js
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/searchindex.js?rev=1688350&r1=1688349&r2=1688350&view=diff
==============================================================================
--- tajo/site/docs/current/searchindex.js (original)
+++ tajo/site/docs/current/searchindex.js Tue Jun 30 04:16:52 2015
@@ -1 +1 @@
-Search.setIndex({envversion:42,terms:{c_name:57,four:[49,17],prefix:[11,47,17],locaion:47,digit:[23,17],everi:[33,56,7],"void":45,affect:[47,52,10,17],previou:[8,17],println:45,tajo_src:41,batch:16,enjoi:41,second:[21,33,15,52,17],aggreg:[11,2,7],even:[33,17],asin:25,asia:[35,47,5],char_length:15,directori:52,supplier:9,"new":[21,44,17,33,9],metadata:18,ongo:33,elimin:[54,21,7],abov:[31,21,2,18,20,29,41],never:[21,33],o_totalpric:9,here:[20,41,8,21,17],path:[26,29,44,45,3,21,57,47,35,52,9,54,41],interpret:17,deterior:37,anymor:29,precis:[23,17],datetim:[13,56],sequencefil:[12,49,18],q_1363768615503_0001_000001:41,substr:[7,15,17],unix:17,total:[7,10],unit:[52,37],highli:[41,47],describ:[21,44,14,9],would:[44,41,17],call:[12,7],compressiontyp:20,l_discount:[29,7],until:53,relat:[7,37],supergroup:24,hurt:16,rootdir:46,exce:17,recommand:47,getconnect:45,must:[11,26,14,29,44,45,21,17,33,7,52,37,23,56],word:[18,17,47,10,5],setup:39,work:[12,17],era:17,root:[25,55,46],dayofweek:17,give:[5
4,7,10],fmdd:17,indic:17,want:[57,26,38,27,48,29,44,45,46,31,17,33,19,20,52,21,54,24,41,10],end:[24,15,41],quot:[48,17],str2:15,ordinari:17,hdf:[12,26,16,29,44,45,46,54,36,55,40,41,10],how:46,conn:45,env:[33,52],verifi:[21,33],config:[33,27,46,6,52],lazybinaryserd:20,updat:[33,44],recogn:[47,5],after:[21,7,41,17],cli_error_stop:53,befor:[21,2,7,46,33],parallel:46,attempt:17,third:[52,17],environ:[26,21,44,27,41,10],enter:[12,41],first:[27,15,52,17],order:[44,45,14,36,46,16,21,19,37,35,47,5,18,7,52,9,23,56,41,10],oper:[33,13,52],over:7,failur:33,becaus:[21,2,47,17,33,7,5],vari:[23,17],smallint:23,cli:40,fix:17,persist:[41,52],easier:47,split:15,them:[7,47],thei:[18,35,8,33,17],binaryserializerdeseri:[18,20],choic:37,subqueri:7,regexp_replac:15,each:[46,27],side:[45,15,47],mean:[21,8,17],saturdai:17,resut:25,mdy:56,extract:[17,9],customserializerdeseri:5,network:[33,13],newli:44,xxtajo:15,content:[12,54,41,52,21],millennium:17,got:21,free:41,standard:[16,23,41,8,17],angl:25,filter:[7,
8],iso:17,fxyyyi:17,mvn:[44,45,41,52],rang:[12,32],independ:37,system:[33,46,27,52],restrict:17,instruct:[44,3],alreadi:33,tpch:[29,57,9],primari:[33,26],cartesian:7,xii:17,master:[39,46,52],too:37,listen:[45,46],namespac:45,tool:9,inexact:23,target:[25,38,21,45,33,52,41],keyword:[7,20],provid:[2,3,5,8,10,31,50,18,20,24,32,33,35,37,40,41,43,44,45,49,16,52,53],expr:7,tree:[55,41],mmdd:17,project:[16,37],minut:[44,41,17],ran:52,mind:17,manner:45,val2:[53,8],current_d:17,usernam:[41,52],microsecond:17,phase:19,doi:17,don:[29,45,57,27,21,41],doc:9,binaryserd:20,doe:[21,45,47,17,33,7,37,54,5],bracket:8,umbil:[33,46,6],dow:17,pope:17,dst:[47,5],syntax:[7,58],identifi:[7,52,17],absolut:[25,41,52,9],row_num:7,layout:[35,36],explain:[45,46,5,18,7,36,41],apach:[21,44,3,52,41],geoip_country_cod:3,search_condit:7,fmmonth:17,stop:[33,2],ceil:25,bar:5,method:[12,57],clean:[44,45,41,52],respond:44,l_receiptd:29,memstor:52,num:[48,7,5],result:[45,21,37,47,17,33,7,9,41],respons:[11,31,16,21,2,41],fa
il:5,best:5,subject:7,awar:[44,10],score:[11,31,5,18,35,20,37,41],approach:57,accord:[23,7,5],extend:55,toler:[16,5],fault:16,howev:37,against:41,logic:[8,36],countri:[3,17],com:[33,46,3],split_part:15,guid:9,assum:[31,19,41,10,17],nonsens:17,three:[20,52,17],been:9,trigger:33,datanod:10,basic:[16,12,57,20,5],c_mktsegment:57,suppress:17,xxx:9,worker:39,ani:[45,37,5,33,7,8,52,9],"catch":45,emploi:16,ident:17,geoip:3,servic:[39,46,52],properti:[12,26,36,27,21,44,46,3,33,52,56,6,10],cli_max_column:53,calcul:7,alias_nam:7,conf:[26,27,48,21,44,46,3,47,33,52,41,10],march:17,sever:52,pemiss:5,perform:[29,7],suggest:41,complex:[7,17],isodow:17,complet:33,nio:12,jkl:41,rais:25,dskiptest:[44,45,41,52],kim:21,squar:25,thu:[44,41],inherit:[18,5],to_numb:17,client:[12,21,46,33,52,29,6],shortli:55,thi:[5,7,8,10,11,14,17,20,21,24,41,27,29,33,54,36,37,57,44,45,46,47,52],roma:17,gzip:37,left:7,protocol:41,just:[33,7,8,52,53,24,57],dist_query_groupby_task_volum:53,dtar:[44,45,41,52],yet:19,languag:[1
6,12,41,29],easi:[57,32],pdist:[44,45,41,52],backup_and_restor:9,expon:25,applic:7,preserv:33,bzip2codec:54,phcatalog:[44,52],background:[12,40],database_nam:[48,54],u0001:[35,5],specif:[23,26,38,33,17],filenam:48,manual:[18,52],timetz:23,right:7,interv:[33,17],intern:[47,27],"52nd":17,cnt:7,insensit:8,multipli:17,tracker:[33,46,6],condit:7,localhost:[48,29,46,33,54,52,6],core:[45,56,10],who:5,uncompress:[20,37],character_length:15,repositori:41,peer:6,rcfile:[12,49],dist_query_join_partition_volum:53,total2:7,simul:33,"float":[25,35,5,18,19,20,37,23,41,10],encod:37,down:[8,41],storag:[26,21,5,18,20,52,37,57,41],jdbc:[12,44,52],wai:[21,47,17,33,5,57],support:[26,57,52,17],avail:39,width:17,editor:[33,46],fraction:17,o_custkei:9,form:[18,26,7,47,5],forc:[7,17],drwxr:24,recommend:[41,17],l_comment:[29,54],"true":[29,3,33,20,52,37,23,10,8],type:[25,12,15,43,29,3,17,27,21,57,41,10],vatican:17,trim:15,featur:[12,44,43,21,29],semicolon:[24,31],tajocli:[33,47],exist:[18,54,38,48,21],quanti
ti:7,successfulli:[50,29,33],floor:25,when:[38,29,45,21,17,33,7,52,37,54,55,5,41],getstr:45,hh12:17,test:52,node:[45,46,33,52,55,10],intend:17,consid:[33,47],abscissa:25,tinyint:23,ignor:[17,10,5],time:33,backward:10,ojdbc7:52,concept:[45,17],skip:17,global:[47,17],boolean_express:7,row:[11,31,29,37,21,5,18,47,7,8,52,9,41,20],millisecond:17,depend:[33,44,45,8],zone:[12,17,56,23,5],decim:[23,17],hadmin:33,drivermanag:45,jvm:33,sql_languag:9,sourc:[52,17],string:[13,3,27,17],hdfs_locat:18,exact:23,did:17,"12th":17,item:[24,8,17],div:25,tajo_hom:[27,48,45,46,33,52,41],dir:[46,38,10],prevent:33,templet:27,sign:[25,8],long_table_name_1234:7,cost:[16,43],port:[26,48,50,21,45,46,33,52],addr:[3,52],current:[26,45,48,29,44,37,55,32,17,33,7,8,52,9,54,49,10],deriv:7,gener:[33,5],stmt:45,tangent:25,address:[21,46,3,33,35,52,23,6],wait:33,shift:17,behav:7,commonli:5,regardless:[18,29,37],modul:[12,27],msck:44,"1st":17,instal:[3,52,41],num1:25,memori:[33,52],connector:[44,52],msk:44,tajo_pid_dir:
33,capit:17,claus:[12,21,19,8,23,41],templat:[52,17],prepar:[44,41,52],timestamptz:23,cat:[11,33,46,41,57],can:[5,7,8,9,10,11,14,17,18,19,20,21,24,27,29,33,35,36,37,40,41,44,45,46,47,52,54],purpos:[44,27],fmss:17,nearest:[25,17,9],l_orderkey_idx:29,l_shipinstruct:29,backslash:[17,9],occur:[21,17,18,54,7,5],alwai:[29,17],sundai:17,multipl:[47,17,33,7,5,10],haadmin:33,write:[47,17,18,35,20,37,5],purg:[21,54],c_address:57,ordin:[25,17],map:23,product:7,atan:25,max:5,clone:[14,41,52],"4th":17,date:57,underscor:8,data:[33,46,52],favorit:[33,46],predic:[54,12,19,42],inform:[29,17,33,54,52,9,56],preced:[3,17],combin:7,hh24:17,ghi:41,repair:44,midnight:17,still:[33,14],ieee:23,dynam:16,entiti:33,divis:25,disconnect:[53,33],monitor:33,window:12,main:[16,21,45,8,27],non:[17,7,37],synopsi:[54,12,7,8,21],add_month:17,col2:[38,8],col3:[21,38],initi:33,col1:[21,38,8],now:[37,17,18,9,53,57,5,41],nor:8,introduct:12,hive_jdbc_driver_dir:[44,52],name:[3,5,7,9,17,10,11,57,18,20,21,23,26,27,29,33,35,37
,40,6,41,48,44,45,46,47,52,53,54,56],reoptim:16,separ:[31,17,7,20,5],januari:17,clsspath:45,quarter:17,tajo_worker_heaps:10,compil:[44,41,52],domain:[33,46,8,5],replac:[15,17],individu:7,current_tim:17,year:[7,17],shown:17,space:[15,17],o_orderkei:9,profil:[44,52],hivemetastor:[44,52],partit:[12,44,43],git:52,org:[14,44,45,5,18,35,20,52,9,54,41],"byte":[23,9,41,37],card:19,care:[17,5],suffici:29,p_id:11,codegen:53,place:9,standbi:33,think:41,str1:15,origin:21,directli:[19,44,14,55,5],onc:[29,7,3,33],arrai:8,o_orderd:9,submit:[29,41,33],open:16,given:[38,15,21,3,5,48,47,7,8,9,54,23,17,41],paramt:11,l_partkei:[54,29,7,38,21],especi:23,copi:[27,52],specifi:[3,5,7,8,10,38,50,17,18,20,23,24,26,21,48,35,37,41,44,45,47,52,58],github:41,enclos:7,mostli:18,than:[11,25,38,21,44,17,7,8,41],serv:33,serd:[18,5],posix:8,balanc:16,posit:55,argument:[25,31,17,7,9,24],maxmind:3,engin:[55,14],techniqu:16,partsupp:9,note:[8,52,17],take:[44,7,41],xxxxxx:52,channel:12,begin:[17,9],c_nationkei:57,buffer:
[41,37],price:19,compress:12,deflatecodec:54,pair:[18,20,27],later:41,executor_inner_hash_join_size_threshold:53,axi:25,clientport:21,show:[50,45,52,9,53,41],ship_dat:19,xml:39,onli:[26,27,55,32,17,18,7,20,52,37,54,5,41],explicitli:[7,27],ratio:10,activ:33,written:[18,47,20,5],l_suppkei:29,"53rd":17,variou:[53,36,17],get:[33,52,17],client_session_expiry_tim:53,repo:[14,41,52],cannot:5,java_hom:41,progress:[11,31,16,21,2,50],requir:[33,31,7,41,17],table_refer:7,item_nam:19,borrow:8,c_custkei:57,where:[12,21,46,19,8,52,54,23,41,10],calendar:17,concern:[57,27],detect:33,enough:52,ddsp:17,between:[45,8],"import":45,across:[46,7],parent:41,executor_groupby_inmemory_hash_threshold:53,hadoop_hom:[46,41],gregorian:17,decimaln:9,region:9,gzipcodec:54,groupbi:12,compressioncodec:[18,5],improv:37,jdbc4:52,pow:25,"4028235e":23,xzvf:[45,41],date_ord:53,invers:9,dist_query_broadcast_join_threshold:53,derbystor:[33,52],those:[45,18,5,35,37],"case":[27,15,45,47,17,18,8,52,20],cast:[12,17],invok:33,
column_family_nam:21,advantag:37,ctrl:[33,46,41],cluster:[39,52],warehous:[16,21,24,54],abcdef:15,develop:41,april:47,same:[25,21,44,3,17,33,7,8],binari:[12,41,52,55],epoch:17,html:9,pad:17,week:17,finish:33,nest:37,driver:[12,44,52],decompress:[41,37],tajo_classpath:52,mani:[18,45,47,10,9],extern:[12,21,41,18,19,54,57],appropri:[41,27],choos:41,without:[31,16,17,19,52,7,5],fmmm:17,model:[12,42],fmmi:17,execut:[33,46,10],rest:7,bitmap:43,kill:[50,33],inet4:[23,3],except:[45,7,17],littl:46,desktop:21,blog:21,blob:23,exercis:41,overview:12,disrupt:33,real:25,read:[55,5,46,41,37],period:[33,17],mon:17,pst:[47,5],mod:25,mysqlstor:52,integ:[25,17,9,23,5,10],server:[12,27,41,52,33],query_succeed:41,benefit:32,either:[44,7,8,37,23,41],output:[38,21,7,20,17],tajo:[39,57,52],result_set_fetch_rownum:53,yyyi:17,ascend:7,tajowork:[33,27,10],test_broadcast_join_en:53,definit:[12,29,42,17],exit:2,ddl:[41,57],refer:[45,14,29,37,46,3,5,18,47,7,20,21,9,54,35,56,41],process:[12,14,16,47,5,18,19,37,17
,40],power:[25,8],inspect:40,broken:5,starttim:50,l_tax:29,regexp:8,"throw":45,comparison:[23,8],central:33,choi:21,aco:[25,9],degre:[25,46],yyyymondd:17,effici:[29,14,37],lastli:52,defaultport:52,yyi:17,your:[41,27,33,21,44,45,46,26,17,18,52,37,5,56,57],rowkei:21,overwrit:33,start:[33,46,15,17],current_databas:53,interfac:[33,40,5],ipv4:[23,3],tupl:[29,55],untar:41,jun:17,tajoxx:15,index_en:29,max_output_file_s:53,possibl:[7,10,17],"default":[33,39,46,27,52],day_of_week:17,embed:52,connect:[44,45,48,52,9,53],creat:[46,41,52,57],certain:[18,5,38,21,37],file:[39,57],oraclestor:52,fill:[45,17],incorrect:33,denot:8,sort_expr:7,carriag:5,field:[17,9,35,15,5],valid:17,rdbm:[45,36],you:[2,3,5,7,8,9,10,11,31,14,17,18,19,20,21,41,24,26,27,29,33,35,37,38,57,48,44,45,46,47,52,54,56],polar:25,sequenc:8,symbol:11,text_nul:53,briefli:7,tajomast:[39,46,52],hyunsik:[21,57,9],descript:[50,6,17,33,8,52,9,23,56,41,10],tajo_master_heaps:26,index_support:14,mariadbstor:52,unset:[53,9],tajodriv:45,repre
sent:[17,37],all:[36,50,21,44,45,46,3,17,33,47,7,8,52,9,53,35,57,5,41],dist:[45,41,52],month:17,scalar:[7,37],abil:33,mno:41,follow:[2,3,5,7,8,9,10,11,31,14,50,17,18,19,20,21,23,24,26,27,29,32,41,35,37,38,57,33,44,45,46,47,48,49,52,53,54,56],disk:[55,3,10],init:41,program:[27,37],thursdai:17,liter:[17,27,5],fals:[23,29,8,3,37],util:[29,40],worst:16,fall:[7,17],veri:[46,8,41],list:[50,44,46,47,33,19,8,9,7,41],adjust:[26,47,17,18,35,37,5,10],cosin:[25,9],small:[23,29,37],tmmonth:17,ten:[44,41],past:17,zero:[8,17],design:[16,19,27,37],pass:7,val3:53,further:5,val1:[53,8],what:17,abc:[8,41],clock:17,section:[14,21,44,45,46,17,18,36,5,41,10],abl:[21,44],abbrevi:[17,47,5],version:[41,52,9],to_dat:17,"public":45,zookeep:21,full:[7,17],hash:12,valn:8,zong:47,strong:57,modifi:17,valu:[25,12,26,14,27,21,44,46,3,17,33,52,56,10],search:[12,14,55],cli_print_error_trac:53,table_backup:57,amount:33,behavior_arithmetic_abort:53,codebas:41,via:[33,46],data_typ:[21,54],primit:23,transit:33,deprec:5,s
elect:[11,25,31,38,15,43,50,21,45,3,17,47,7,8,9,41],l_extendedpric:[29,7],distinct:[7,17],regist:47,two:[32,57,18,8,27,55,17,41,58,20],toggl:17,more:[11,31,43,29,44,46,17,7,8,52,37,54,41,10],flat:[18,20,37],discompress:41,function_nam:58,known:19,hour:17,formatha:33,dev:3,histori:33,orderbi:12,archiv:[41,52],learn:[35,41,47],def:41,bewtween:23,prompt:[48,31,9],to_char:[47,17],num2:25,scan:[12,44,21],share:[18,45,7,52],accept:[47,5],tabular:5,goal:16,divid:[25,7,17],anoth:[33,58],mapr:20,csv:[12,57,54,41,29],simpl:41,blockcompresswrit:20,jline2:2,resourc:[33,46,6],seoul:[35,47,5],resultset:45,catalog:1,"short":[18,7],author:21,caus:[33,17],atan2:25,help:9,through:44,paramet:[25,12,15,3,5,18,35,37,54,17],style:8,late:17,alter:44,good:36,"return":[25,15,3,17,8,5],timestamp:[21,47,17,35,23,5],o_orderstatu:9,ssss:17,framework:37,utc_usec_to:[17,9],serde2:[18,20],easili:[33,45,46],radian:25,found:24,unicod:23,truncat:25,unequ:33,procedur:41,expect:[29,17],o_clerk:9,"try":[33,45,48],print:
17,advanc:[16,7],asc:[54,29,7],base:52,asf:[14,41,52],put:[11,21,47,17],fridai:17,launch:52,omit:[18,17,7,9],round:[25,9],perman:55,feed:5,meridiem:17,upper:[15,17],feel:41,applciat:45,number:46,done:[41,17],unhealthi:33,blank:17,differ:[21,47,17,7,8,5],script:[41,27],interact:[16,48,41],least:[7,8],saint:17,twenti:17,scheme:[26,41],store:[11,33,16,29,44,21,5,18,20,52,9,55,41,10],schema:[38,36,29,37,19,21,9,40,41],option:[11,50,29,41,48,7,21,54,17,57],part:[17,9],pars:5,kind:[55,7],remot:46,remov:[21,54,15,52,41],l_orderkei:[54,29,7,38,21],comput:[7,17],packag:[44,45],"null":[54,29,45,7],catalogstor:33,built:[18,45,9],equival:[21,7,38,17],also:[47,17,33,19,8,52,9,53,7,5,41,20],brace:11,distribut:52,exec:20,filesystem:41,mixtur:17,most:[35,52,5],plan:[16,19,5],metacharact:8,lc_time:17,appear:7,quorum:21,clear:9,salari:7,classnotfoundexcept:45,exp:25,jaehwa:21,session:[12,40,47,9],find:[33,55],access:[21,44,45,46,33,37],copyright:9,fmhh:17,ymd:56,l_quantiti:[29,7,38,21],test_filter_pu
shdown_en:53,unresolvedaddressexcept:12,express:[12,42,54,15,17],hbase_table_nam:21,statist:33,bytea:23,set:52,startup:48,see:[21,46,17,52,29,41,10],arc:25,float8:[25,23,38,57,9],arg:[50,45],float4:[23,29,9],close:45,unqualifi:[19,7],smallest:[25,37],subdir:38,"\u02c6ab":15,altern:[8,52],numer:17,fsshell:24,add_dai:17,outfil:57,both:[15,33,16,5,18,7,20],last:[54,29,7,17],"85e7":17,c_comment:57,roman:17,context:17,whole:10,load:[16,21,41],simpli:[29,41],point:[18,33,17],hbase_hom:21,header:18,param:[11,48,7],shutdown:33,suppli:17,o_orderprior:9,cathedr:17,becom:[33,47,17],java:[12,44,27,41,52],due:10,empti:[18,7,5],l_linestatu:29,versa:18,iddd:17,ecosystem:37,tajojdbccli:45,coordin:25,two_level_bin_tre:[29,54,55],func:7,repetit:8,xa2:21,iyi:17,tajoresourcemanag:33,durat:52,"while":[45,17],behavior:7,error:[21,17,54,5],table_nam:[21,44,54,57],key1:53,tbname:9,itself:[33,9],centuri:17,grant:52,belong:7,shorten:52,hadoop:[16,21,45,46,5,18,35,8,27,37,54,24,41,20],conflict:33,higher:41,va
rbit:23,lineitem:[38,50,29,9,54,21,7],x84:21,optim:[16,43],fornam:45,moment:[5,37],user:[26,44,17,33,52,41,10],tsql:[12,47,41,57],chang:[45,46,41,52,9],lower:[15,17],lib:52,entri:[21,54,46,33],parenthes:[7,8],explan:41,construct:[7,17],snappi:37,all_backup:57,disk1:10,disk2:10,disk3:10,shortcut:24,appli:[33,17],input:[25,15,17],subsequ:[55,17],euler:25,bin:[11,31,48,44,2,46,57,33,52,41],complaint:17,varchar:23,format:33,big:21,subfield:17,register_d:21,bit:23,characterist:36,table1:[11,31,45,47,5,18,7,8,37,35,41,20],collect:20,"boolean":[23,7,3,37],l_commitd:29,order_d:19,createstat:45,creation:[29,52],some:[27,44,21,2,35,47,5,18,7,52,37,23,17,41],back:33,mirror:41,scale:16,"512mb":10,per:[53,33,46,10],bst:[29,55],machin:[33,48],o_shipprior:9,run:[33,46],dist_query_table_partition_volum:53,hive_hom:[44,52],step:[29,41],subtract:17,varbinari:23,manag:[12,21,44,32,52,41],regular:15,"1gb":[26,10],block:[55,20,37],test_min_task_num:53,executor_outer_hash_join_size_threshold:53,columnars
erd:18,primarili:17,within:[33,24,7,17],ensur:[41,52],"long":[16,7,17],custom:[57,52],arithmet:[12,7],includ:[45,7,52,10,17],unix_timestamp:17,metastor:44,int4:[23,38,15,9],link:[29,41],translat:[47,17],select_stat:54,int2:23,l_shipdat:[29,7],line:[33,47,40,46,5],int8:[25,38,29,9,23,57],info:[50,21,6,33],utc:[17,47,5],consist:[27,17,18,7,20,36,55,5],blrunner:21,sum:[11,31,7],"export":[21,44,41,52],constant:25,doesn:[21,44],repres:[17,5],"char":[23,17],qualifier_nam:21,guarante:33,titl:21,hiveql:44,debug_en:53,codec:[54,18,35,20,5],servicenam:52,executor_hash_join_size_threshold:53,introduc:12,jhkim:21,algorithm:[18,5,10,37],vice:18,hello:17,code:[3,52],queri:[33,52,10],privat:45,dist_query_join_task_volum:53,executor_external_sort_buffer_s:53,csvfile:5,volum:[29,41,21,9],implicitli:7,dbname:9,tri:45,recordcompresswrit:20,descend:7,hive:[12,44,52],unquot:9,date_part:17,vertic:5,dealt:7,ddd:17,pleas:[14,29,45,46,3,5,18,47,7,37,54,35,57,17,41,10],smaller:[21,38],natur:7,uniqu:53,downlo
ad:3,click:41,tmpdir:10,compat:[12,57,10],index:[12,43],compar:23,cell:21,c_phone:57,"19th":17,experiment:12,showmast:50,let:20,transitiontobackup:33,sine:25,sinc:[18,52,17],convert:[25,33,3,58,17],aaabc:8,weekdai:17,larger:[23,7,37],earli:17,typic:7,cbrt:25,approxim:23,api:[12,44,29],namenode_hostnam:26,wip:[14,41,52],from:[25,12,15,21,57,33,55,17,41],c_acctbal:57,doubl:17,next:[44,45,17],few:27,usr:52,remaind:25,sort:[21,7],src:[45,41,17],trail:[15,17],name2:53,name3:53,name1:53,retriev:[29,14,47,17],alia:[23,7,15,9],thin:52,parquet:[12,49],control:33,tar:[45,41,52],lineitem_100_snappi:54,high:39,query_run:50,tab:5,tarbal:33,tan:25,concatnen:15,isoyear:17,instead:[47,17,48,8,52,5,41],sin:25,transitiontoact:33,ltrim:15,jinho:21,o_com:9,getstat:33,physic:[46,36],essenti:33,cli_print_paus:53,correspond:[18,7,55],element:[33,27],cli_null_char:53,column_refer:8,writ:5,allow:[11,26,21,44,46,47,5,18,7,37,54,35,17,41,10],move:41,comma:[17,7,5],outer:7,decad:17,therefor:[33,17],crash:33,gr
eater:25,handl:45,spell:17,dai:17,mention:18,lzo:37,mode:52,consum:37,meta:[12,21,47,52,40,41],"static":45,our:5,special:[35,5],out:10,variabl:[12,26,27,21,44,47,52,9,23,40,41,10],math:13,common:[12,7],shut:41,manipul:53,standalon:41,dictionari:37,l_shipmod:29,could:17,keep:17,length:[23,17],timezon:[53,56,35,47,5],suffix:17,resourceconfigur:10,mai:[31,27,17,33,7,52,41],t_timestamp:[35,47],unknown:[29,21],licens:9,mkdir:[24,46,41],capac:[46,10],termin:5,"final":[55,44,45,41,52],inner:7,mysql_jdbc_driv:[44,52],shell:[12,41,27,21],grouping_column_refer:7,rtrim:15,exactli:8,haven:19,prune:12,structur:[54,14],charact:[15,35,17,18,19,8,23,5],sec:[11,31,50,21,2,52,41],textserd:20,julian:17,have:[12,26,21,44,17,54,52],tabl:[41,52,57],need:[36,33,21,44,45,17,18,20,52,37,57,5,41],issu:12,mix:17,which:[53,33,16,21,45,47,48,17,18,7,20,52,55,54,35,41],singl:[12,46,17,33,8,36,37,40],unless:[44,17],preliminari:39,l_returnflag:29,deploi:33,"class":[44,45,5,18,8,52,20],url:[26,45,36],request:10,uri
:[33,52],snapshot:[41,52],determin:[56,7,10],querymast:[33,10],text:[11,46,15,33,29,37,35,3,5,18,47,19,8,21,9,54,23,57,17,41,20],locat:[38,45,3,57,18,47,35,52,54,5,41,10],postgresqlstor:52,jar:[44,45,52],should:[26,48,29,44,45,46,3,21,17,18,47,19,52,37,54,57,5,56,41,10],jan:17,local:[52,3,10,17],cube:25,familiar:[18,5,37],disagre:17,increas:46,l_linenumb:29,enabl:[12,46,52,33],grtajo01:50,ddth:17,integr:52,dist_query_sort_task_volum:53,contain:[33,45,54,46,17],view:36,dhadoop:41,legaci:3,frame:7,knowledg:5,rlike:8,statu:33,correctli:[23,41],t_date:[35,47],pattern:[12,15,17],to_timestamp:17,cli_print_pause_num_record:53,theta:25,neither:8,kei:[11,21,32,17,18,19,20,55,53,54],otherwis:[48,17,7,3,8],group:[7,8,37],addit:[38,45,47,7,8,10],admin:[50,9],equal:21,etc:40,instanc:[26,46,41],fmyyyi:17,arriv:21,chmod:46,rpc:[33,45,46,6],respect:[23,8],tuesdai:17,quit:9,compos:[19,37],compon:33,json:5,besid:5,sequecnefil:20,columnar:[18,37],cli_output_formatter_class:53,togeth:17,present:[41,9],
delimit:[15,29,47,5,54,35,41],bye:41,implementaion:26,plain:[18,20],rectangular:25,defin:5,wild:19,lazybinarycolumnarserd:18,textserializerdeseri:[18,20,5],layer:26,site:39,bigint:[23,54],textfil:12,"35b":41,classpath:[12,21],sqrt:25,zookeeper_address:21,largest:25,http:[14,3,6,33,52,9,41],hostnam:[48,26,45,46,52],geoip_in_countri:3,column_nam:[21,54],retriv:45,nation:9,off:17,well:[23,54,38,21,17],exampl:[33,46,57,52],command:[12,21,44,47,57,40,41],english:17,usual:[27,5],less:[25,17],percent:8,tcp:48,current_timestamp:17,simultan:10,web:[16,33],add:[27,21,44,45,46,33,54,52,24,56,41,10],host2:[33,46],host1:[33,46],work1:9,match:[12,23,15,17],gmt:47,iyyi:17,workload:10,know:[46,47,7,41,17],xe2:21,createdatabaseifnotexist:52,password:52,desc:[50,54,7],insert:33,storage_typ:54,resid:41,like:[26,45,19,41,17],necessari:16,page:[12,46,37],another_long_table_name_5678:7,linux:9,queryid:50,yyyymmdd:17,proper:[26,41,10,52],home:[21,44,41,52,57],peter:17,librari:21,tmp:[24,26,41,52],leaf:55,
lead:[19,15,17],avoid:[16,21,2,17,33,54],estim:43,zookeeper_client_port:21,blog_backup:21,xtajoxx:15,ab_bc_cd:15,usag:[57,17],maven:[44,41,52],host:[48,50,45,46,33,52,56],although:17,offset:[47,5],empsalari:7,stage:41,about:[29,54,36],actual:21,dist_query_groupby_partition_volum:53,column:[12,21],statement:[11,45,38,48,50,21,37,47,5,18,7,8,9,54,35,41,20],disabl:12,own:[35,47,5],lazybinari:20,val:53,pictur:9,much:10,q_1411357607375_0007:50,q_1411357607375_0006:50,"var":52,snappycodec:[54,18,35,20,5],test_join_opt_en:53,count:[11,31,15,50,17,7],temp:24,whether:[18,7,8],wish:11,record:[18,5,8,20,37],below:[41,17,18,37,5,57],limit:[12,10],dmy:56,problem:[33,2],executequeri:45,btrim:15,"int":[25,15,35,17,18,19,20,37,23,5,41],dure:19,pid:33,novemb:17,implement:[17,41,9],"20000nov31":17,boot:[41,52],detail:[50,37,46,17,7,52,9,41],other:[38,33,16,21,47,17,18,7,27,5,10],bool:23,futur:12,branch:14,varieti:27,repeat:17,row_numb:7,jung:21,mondai:17,cpu:10,select_list:7,understand:36,decemb:17},
objtypes:{"0":"py:function"},objnames:{"0":["py","function","Python function"]},filenames:["partitioning/hash_partitioning","backup_and_restore","tsql/background_command","functions/network_func_and_operators","partitioning/range_partitioning","table_management/csv","configuration/service_config_defaults","sql_language/queries","sql_language/predicates","tsql/meta_command","configuration/worker_configuration","tsql/execute_file","index","functions","index_overview","functions/string_func_and_operators","introduction","functions/datetime_func_and_operators","table_management/rcfile","partitioning/column_partitioning","table_management/sequencefile","hbase_integration","configuration/catalog-site-xml","sql_language/data_model","tsql/dfs_command","functions/math_func_and_operators","configuration/tajo_master_configuration","configuration/preliminary","table_management/compression","index/how_to_use","faq","tsql/single_command","partitioning/intro_to_partitioning","configuration/ha_conf
iguration","table_partitioning","table_management/table_overview","table_management","table_management/parquet","sql_language/insert","configuration","tsql","getting_started","sql_language","index/future_work","hcatalog_integration","jdbc_driver","configuration/cluster_setup","time_zone","tsql/intro","table_management/file_formats","tsql/admin_command","tajo_client_api","configuration/catalog_configuration","tsql/variables","sql_language/ddl","index/types","configuration/tajo-site-xml","backup_and_restore/catalog","sql_language/sql_expression"],titles:["Hash Partitioning","Backup and Restore","Executing as background process","Network Functions and Operators","Range Partitioning","CSV (TextFile)","Cluster Service Configuration Defaults","Queries","Predicates","Meta Commands","Worker Configuration","Executing Queries from Files","Apache Tajo\u2122 0.10.0 - User documentation","Functions","Index (Experimental Feature)","String Functions and Operators","Introduction","DateTime Function
s and Operators","RCFile","Column Partitioning","SequenceFile","HBase Integration","The catalog-site.xml File","Data Model","Executing HDFS commands","Math Functions and Operators","Tajo Master Configuration","Preliminary","Compression","How to use index?","FAQ","Executing a single command","Introduction to Partitioning","High Availability for TajoMaster","Table Partitioning","Overview of Tajo Tables","Table Management","Parquet","INSERT (OVERWRITE) INTO","Configuration","Tajo Shell (TSQL)","Getting Started","SQL Language","Future Works","HCatalog Integration","Tajo JDBC Driver","Cluster Setup","Time Zone","Introducing to TSQL","File Formats","Administration Commands","Tajo Client API","Catalog Configuration","Session Variables","Data Definition Language","Index Types","The tajo-site.xml File","Backup and Restore Catalog","SQL Expressions"],objects:{"":{trim:[15,0,1,""],upper:[15,0,1,""],to_char:[17,0,1,""],btrim:[15,0,1,""],regexp_replace:[15,0,1,""],cbrt:[25,0,1,""],split_part:[15
,0,1,""],sign:[25,0,1,""],add_months:[17,0,1,""],to_date:[17,0,1,""],tan:[25,0,1,""],extract:[17,0,1,""],current_time:[17,0,1,""],floor:[25,0,1,""],sqrt:[25,0,1,""],acos:[25,0,1,""],char_length:[15,0,1,""],current_date:[17,0,1,""],abs:[25,0,1,""],degrees:[25,0,1,""],pow:[25,0,1,""],pi:[25,0,1,""],sin:[25,0,1,""],ltrim:[15,0,1,""],atan:[25,0,1,""],asin:[25,0,1,""],cos:[25,0,1,""],ceil:[25,0,1,""],atan2:[25,0,1,""],rtrim:[15,0,1,""],now:[17,0,1,""],utc_usec_to:[17,0,1,""],geoip_in_country:[3,0,1,""],mod:[25,0,1,""],lower:[15,0,1,""],radians:[25,0,1,""],date_part:[17,0,1,""],to_timestamp:[17,0,1,""],geoip_country_code:[3,0,1,""],add_days:[17,0,1,""],exp:[25,0,1,""],div:[25,0,1,""],round:[25,0,1,""]}},titleterms:{code:[45,41],execut:[11,2,31,24,41],queri:[11,7,41],session:53,permiss:46,mysql:52,hbase:21,hcatalogstor:52,languag:[42,54],paramet:11,xml:[22,56,27],oracl:52,zone:[35,47],how:[33,29,45,5,18,19,37],configur:[26,33,52,39,6,10],apach:[18,12,5,19,37],window:7,local:41,match:8,buil
d:[45,41],real:23,sourc:[45,41],synopsi:[50,48],string:[8,58,15],format:[49,17],handl:5,faq:[30,45],terminolog:33,background:2,introduct:[16,32],insert:[21,38],document:12,like:8,administr:[50,33],level:57,drop:[21,54],hive:[18,5,19,37],server:47,mode:[46,10],partit:[0,34,19,32,4],each:10,fulli:46,tajo:[12,26,18,56,45,46,6,33,35,27,51,40,41],manag:[35,36],failov:33,set:[11,45,46,33,56,41],hcatalog:44,dump:57,dowload:41,meta:9,download:41,run:10,todo:[0,28,30,4,35,51,57],time:[56,35,47,17],out:41,compat:[18,5,19,37],index:[54,29,14,55],network:3,cast:58,databas:[54,57],preliminari:27,definit:54,state:33,experiment:14,directori:[46,10],channel:45,get:[45,41],method:[54,32],math:25,common:35,qualifi:7,hash:0,compress:[54,28,35],gener:18,usag:[11,21,50,9],serializerdeseri:20,base:46,prerequisit:[3,41],releas:41,from:[11,45,7],rcfile:18,valu:[11,23,5],postgresql:52,convers:17,launch:[33,46],column:19,where:7,groupbi:7,datetim:17,integr:[21,44],backup:[33,1,57],disabl:29,first:41,oper:[25
,17,3,15],rang:4,via:41,overview:[35,7],tajomast:[33,26],number:[23,10],automat:33,date:[56,17],api:51,size:[26,10],writer:20,git:41,java:45,memori:[26,10],data:[23,54,10],support:3,doubl:23,system:56,overwrit:[21,38],custom:5,avail:33,start:41,call:58,basic:[11,50,9],master:[33,26,6],type:[23,7,58,55],"function":[25,13,15,3,17,7,58],setup:46,shell:[48,40],claus:7,worker:[46,6,10],rootdir:26,heap:[26,10],jdbc:45,unpack:41,join:7,prune:19,restor:[1,57],"default":6,servic:6,properti:[18,5,35,37],maximum:10,orderbi:7,hdf:24,serd:20,limit:7,introduc:[48,20],parquet:37,similar:8,featur:14,file:[11,22,49,56,33],creat:[29,37,5,18,19,21,54],scan:29,process:2,site:[22,56,27],indic:12,high:33,cluster:[33,47,46,41,6],unresolvedaddressexcept:45,textfil:5,have:7,tabl:[12,21,35,47,5,18,34,19,36,37,54,7],serial:[18,5],work:43,dedic:10,issu:[18,5,19,37],"null":5,make:46,ilik:8,when:18,cross:7,check:41,binari:45,exampl:[45,7,47,10],futur:43,env:27,test:33,distribut:[45,46],csv:5,config:56,singl:31,e
nabl:29,variabl:53,express:[8,58],resourc:10,nio:45,classpath:45,enter:48,driver:45,catalog:[22,27,57,52],regular:8,temporari:10,user:12,sql:[11,42,57,58],extern:35,mariadb:52,tsql:[48,40],parallel:10,physic:[18,5,37],derbi:52,task:10,read:18,predic:8,arithmet:58,alias:7,client:[45,51,47],command:[50,24,31,9],pattern:8,model:23,sequencefil:20,latest:41}})
\ No newline at end of file
+Search.setIndex({envversion:46,filenames:["backup_and_restore","backup_and_restore/catalog","configuration","configuration/catalog-site-xml","configuration/catalog_configuration","configuration/cluster_setup","configuration/ha_configuration","configuration/preliminary","configuration/service_config_defaults","configuration/tajo-site-xml","configuration/tajo_master_configuration","configuration/worker_configuration","faq","functions","functions/datetime_func_and_operators","functions/json_func","functions/math_func_and_operators","functions/network_func_and_operators","functions/string_func_and_operators","getting_started","hbase_integration","hcatalog_integration","index","index/future_work","index/how_to_use","index/types","index_overview","introduction","jdbc_driver","partitioning/column_partitioning","partitioning/hash_partitioning","partitioning/intro_to_partitioning","partitioning/range_partitioning","sql_language","sql_language/data_model","sql_language/ddl","sql_language/inse
rt","sql_language/predicates","sql_language/queries","sql_language/sql_expression","swift_integration","table_management","table_management/compression","table_management/file_formats","table_management/parquet","table_management/rcfile","table_management/sequencefile","table_management/table_overview","table_management/text","table_partitioning","tajo_client_api","time_zone","tsql","tsql/admin_command","tsql/background_command","tsql/dfs_command","tsql/execute_file","tsql/intro","tsql/meta_command","tsql/single_command","tsql/variables"],objects:{"":{abs:[16,0,1,""],acos:[16,0,1,""],add_days:[14,0,1,""],add_months:[14,0,1,""],asin:[16,0,1,""],atan2:[16,0,1,""],atan:[16,0,1,""],btrim:[18,0,1,""],cbrt:[16,0,1,""],ceil:[16,0,1,""],char_length:[18,0,1,""],cos:[16,0,1,""],current_date:[14,0,1,""],current_time:[14,0,1,""],date_part:[14,0,1,""],degrees:[16,0,1,""],div:[16,0,1,""],exp:[16,0,1,""],extract:[14,0,1,""],floor:[16,0,1,""],geoip_country_code:[17,0,1,""],geoip_in_country:[17,0,1,
""],json_extract_path_text:[15,0,1,""],lower:[18,0,1,""],ltrim:[18,0,1,""],mod:[16,0,1,""],now:[14,0,1,""],pi:[16,0,1,""],pow:[16,0,1,""],radians:[16,0,1,""],regexp_replace:[18,0,1,""],round:[16,0,1,""],rtrim:[18,0,1,""],sign:[16,0,1,""],sin:[16,0,1,""],split_part:[18,0,1,""],sqrt:[16,0,1,""],tan:[16,0,1,""],to_char:[14,0,1,""],to_date:[14,0,1,""],to_timestamp:[14,0,1,""],trim:[18,0,1,""],upper:[18,0,1,""],utc_usec_to:[14,0,1,""]}},objnames:{"0":["py","function","Python function"]},objtypes:{"0":"py:function"},terms:{"12th":14,"19th":14,"1gb":[10,11],"1st":14,"20000nov31":14,"35b":19,"4028235e":34,"4th":14,"512mb":11,"52nd":14,"53rd":14,"85e7":14,"\u02c6ab":18,"boolean":[17,34,38,44],"byte":[19,34,44,58],"case":[4,7,14,18,37,45,46,51],"catch":28,"char":[14,34],"class":[4,21,28,37,45,46,48],"default":[2,4,5,6,7],"export":[4,19,20,21,40],"final":[4,19,21,25,28,40],"float":[11,16,19,29,34,40,44,45,46,47,48],"import":28,"int":[14,16,18,19,29,34,44,45,46,47,48],"long":[14,27,38],"new":[6
,14,20,21,58],"null":[24,28,35,38,45,47],"public":28,"return":[14,15,16,17,18,37,48],"short":[38,45],"static":28,"throw":28,"true":[4,6,11,17,24,34,37,40,44,46],"try":[6,28,57],"var":4,"void":28,"while":[14,28],aaabc:37,ab_bc_cd:18,abbrevi:[14,48,51],abc:[19,37],abcdef:18,abil:6,abl:[20,21],about:[24,35,41],abov:[19,20,24,45,46,54,59],abscissa:16,absolut:[4,16,19,58],accept:[48,51],access:[5,6,20,21,28,40,44],accord:[34,38,48],aco:[16,58],across:[5,38],activ:6,actual:20,add:[4,5,6,7,9,11,19,20,21,28,35,55],add_dai:14,add_month:14,addit:[11,36,37,38,51],addr:[4,17],address:[4,5,6,8,17,20,34,47],adjust:[10,11,14,44,45,47,48,51],admin:[53,58],advanc:[27,38],advantag:44,affect:[4,11,14,51],after:[14,19,20,38],against:19,aggreg:[38,54,56],algorithm:[11,44,45,48],alia:[18,34,38,58],alias_nam:38,all:[1,4,5,6,14,17,19,20,21,28,37,38,41,47,48,51,53,58,60],all_backup:1,allow:[5,10,11,14,19,20,21,35,38,44,45,47,48,51,56],alreadi:6,also:[4,6,14,19,29,37,38,40,46,48,51,58,60],alter:21,altern:[4,
37],although:14,alwai:[14,24],amount:6,angl:16,ani:[4,6,28,37,38,40,44,48,58],anoth:[6,39],another_long_table_name_5678:38,anymor:24,apach:[4,17,19,20,21],api:[21,22,24],appear:38,applciat:28,appli:[6,14],applic:38,approach:1,appropri:[7,19],approxim:34,april:51,arc:16,archiv:[4,19],arg:[28,53],argument:[14,16,38,55,58,59],arithmet:[22,38],arrai:37,arriv:20,asc:[24,35,38],ascend:38,asf:[4,19,26],asia:[47,48,51],asin:16,assum:[11,14,19,29,59],atan2:16,atan:16,attempt:14,auth:40,auth_:40,authenticaiton:40,author:20,avail:2,avoid:[6,14,20,27,35,54],awar:[11,21,40],axi:16,back:6,background:[22,52],backslash:[14,58],backup_and_restor:58,backward:11,balanc:27,bar:48,base:4,basic:[1,22,27,46,48],batch:27,becaus:[6,14,20,38,48,51,54],becom:[6,14,51],been:58,befor:[5,6,20,38,54],begin:[14,58],behav:38,behavior:38,behavior_arithmetic_abort:60,belong:38,below:[1,14,19,44,45,48],benefit:31,besid:48,best:48,better:40,between:37,bewtween:34,big:20,bigint:[34,35],bin:[1,4,5,6,19,21,54,56,57,59],bi
nari:[4,19,22,25],binaryserd:46,binaryserializerdeseri:[45,46],bit:34,bitmap:23,blank:14,blob:34,block:[25,44,46],blockcompresswrit:46,blocksiz:40,blog:20,blog_backup:20,blrunner:20,bool:34,boolean_express:38,boot:[4,19],borrow:37,both:[6,18,27,38,45,46,48],brace:56,bracket:37,branch:26,briefli:38,broken:48,bst:[24,25],btrim:18,buffer:[19,44],built:[45,58],bye:19,bytea:34,bzip2codec:35,c_acctbal:1,c_address:1,c_comment:1,c_custkei:1,c_mktsegment:1,c_name:1,c_nationkei:1,c_phone:1,calcul:38,calendar:14,call:[22,38],can:[4,5,6,7,11,14,19,20,21,24,26,28,29,35,37,38,40,41,44,45,46,47,48,51,52,55,56,58],cannot:48,capac:[5,11],capit:14,card:29,care:[14,48],carriag:48,cartesian:38,cast:[14,22],cat:[1,5,6,19,56],catalog:0,catalogstor:6,cathedr:14,caus:[6,14],cbrt:16,ceil:16,cell:20,central:6,centuri:14,certain:[20,36,44,45,48],chang:[4,5,19,28,58],char_length:18,charact:[14,18,29,34,37,45,47,48],character_length:18,characterist:41,chmod:5,choi:20,choic:44,choos:19,classnotfoundexcept:28,cla
sspath:[20,22],claus:[19,20,22,29,34,37],clean:[4,19,21,28],clear:58,cli:52,cli_error_stop:60,cli_max_column:60,cli_null_char:60,cli_output_formatter_class:60,cli_print_error_trac:60,cli_print_paus:60,cli_print_pause_num_record:60,click:19,client:[4,5,6,8,20,22,24],client_session_expiry_tim:60,clientport:20,clock:14,clone:[4,19,26],close:28,cluster:[2,4],cnt:38,code:[4,17],codebas:19,codec:[35,45,46,47,48],codegen:60,col1:[20,36,37],col2:[36,37],col3:[20,36],collect:46,column:[20,22],column_family_nam:20,column_nam:[20,35],column_refer:37,columnar:[44,45],columnarserd:45,com:[5,6,17],combin:38,comma:[14,38,48],command:[1,19,20,21,22,51,52],common:[22,38],commonli:48,compar:34,comparison:[34,37],compat:[1,11,22],compil:[4,19,21],complaint:14,complet:6,complex:[14,38],compon:6,compos:[29,44],compress:22,compressioncodec:[45,48],compressiontyp:46,comput:[14,38,40],concatnen:18,concept:[14,28],concern:[1,7],condit:38,conf:[4,5,6,7,10,11,17,19,20,21,40,51,57],config:[4,5,6,7,8],conflict:
6,conn:28,connect:[4,21,28,57,58,60],connector:[4,21],consid:[6,51],consist:[7,14,25,38,41,45,46,48],constant:16,construct:[14,38],consum:44,contain:[5,6,14,28,35,40],content:[4,19,20,22,35],context:14,control:6,convert:[6,14,16,17,39],coordin:16,copi:[4,7],copyright:58,core:[9,11,40],correctli:[19,34],correspond:[25,38,45],cosin:[16,58],cost:[23,27],could:14,count:[14,18,38,53,56,59],countri:[14,17],cpu:11,crash:6,creat:[1,4,5,19],createdatabaseifnotexist:4,createstat:28,creation:[4,24],csv:[1,19,24,58],csvlineserd:48,ctrl:[5,6,19],cube:16,current:[4,6,10,11,14,21,24,25,28,31,35,37,38,43,44,57,58],current_d:14,current_databas:60,current_tim:14,current_timestamp:14,custom:[1,4,45,47],customserializerdeseri:48,dai:14,data:[4,5,6],data_typ:[20,35],database_nam:[35,57],datanod:11,date:1,date_ord:60,date_part:14,datetim:[9,13],day_of_week:14,dayofweek:14,dbname:58,ddd:14,ddl:[1,19],ddsp:14,ddth:14,dealt:38,debug_en:60,decad:14,decemb:14,decim:[14,34],decimaln:58,decompress:[19,44],def:1
9,defaultport:4,defin:48,definit:[14,22,24,33],deflatecodec:35,degre:[5,16],delimit:[18,19,24,35,40,47,48,51],demo:40,denot:37,depend:[6,21,37],deploi:6,derbystor:[4,6],deriv:38,desc:[35,38,53],descend:38,describ:[20,21,26,58],descript:[4,6,8,9,11,14,19,34,37,40,53,58],design:[7,27,29,44],desktop:20,detail:[4,5,14,19,38,40,44,53,58],detect:6,deterior:44,determin:[9,11,38],dev:17,develop:19,dhadoop:19,dictionari:44,did:14,differ:[14,20,37,38,48,51],digit:[14,34],dir:[5,11,36],direct:22,directli:[21,25,26,28,29,48],directori:4,disabl:22,disagre:14,discompress:19,disconnect:[6,60],disk1:11,disk2:11,disk3:11,disk:[11,17,25],disrupt:6,dist:[4,19,28],dist_query_broadcast_join_threshold:60,dist_query_groupby_partition_volum:60,dist_query_groupby_task_volum:60,dist_query_join_partition_volum:60,dist_query_join_task_volum:60,dist_query_sort_task_volum:60,dist_query_table_partition_volum:60,distinct:[14,38],distribut:4,div:16,divid:[14,16,38],divis:16,dmy:9,doc:58,doe:[6,14,20,28,35,38,44,48,
51],doesn:[20,21],doi:14,domain:[5,6,37,48],don:[1,7,19,20,24,28,40],done:[14,19],doubl:14,dow:14,down:[19,37],download:17,driver:[4,21,22],drivermanag:28,drwxr:55,dskiptest:[4,19,21,28],dst:[48,51],dtar:[4,19,21,28],due:11,durat:4,dure:29,dynam:27,each:[5,7],earli:14,easi:[1,31],easier:51,easili:[5,6,28],ecosystem:44,editor:[5,6],effici:[24,26,44],either:[19,21,34,37,38,44],element:[6,7],elimin:[20,35,38],embed:4,emploi:27,empsalari:38,empti:[38,45,48],enabl:[4,5,6,22],enclos:38,encod:44,end:[18,19,55],endpoint:40,engin:[25,26],english:14,enjoi:19,enough:4,ensur:[4,19],enter:[19,22],entiti:6,entri:[5,6,20,35],env:[4,6],environ:[7,10,11,19,20,21],epoch:14,equal:20,equival:[14,20,36,38],era:14,error:[14,20,35,48],especi:34,essenti:6,estim:23,etc:[40,52],euler:16,even:[6,14],everi:[6,9,38],evn:40,exact:34,exactli:37,exampl:[1,4,5,6],exce:14,except:[14,28,38],exec:46,execut:[5,6,11],executequeri:28,executor_external_sort_buffer_s:60,executor_groupby_inmemory_hash_threshold:60,executor_
hash_join_size_threshold:60,executor_inner_hash_join_size_threshold:60,executor_outer_hash_join_size_threshold:60,exercis:19,exist:[20,35,36,45,57],exit:54,exp:16,expect:[14,24],experiment:22,explain:[5,19,28,38,41,45,48],explan:19,explicitli:[7,38],expon:16,expr:38,express:[14,18,22,33,35],extend:25,extern:[1,19,20,22,29,35,40,45],extract:[14,15,58],fail:48,failur:6,fall:[14,38],fals:[17,24,34,37,44],familiar:[44,45,48],fault:27,favorit:[5,6],featur:[20,21,22,23,24],feed:48,feel:19,few:7,field:[14,18,47,48,58],file:[1,2],filenam:57,filesystem:19,fill:[14,28],filter:[37,38],find:[6,25],finish:6,first:[4,7,14,18],fix:14,flag:40,flat:[44,45,46],float4:[24,34,58],float8:[1,16,34,36,58],floor:16,fmdd:14,fmhh:14,fmmi:14,fmmm:14,fmmonth:14,fmss:14,fmyyyi:14,follow:[1,4,5,6,7,9,10,11,14,17,19,20,21,24,26,28,29,31,34,35,36,37,38,40,43,44,45,46,47,48,51,53,54,55,56,57,58,59,60],forc:[14,38],form:[10,38,45,48,51],format:6,formatha:6,fornam:28,found:55,four:[14,43],fraction:14,frame:38,framewo
rk:44,free:19,fridai:14,from:[1,6,14,15,16,18,19,20,22,25],fsshell:55,full:[14,38],func:38,function_nam:39,further:48,futur:22,fxyyyi:14,gener:6,geoip:17,geoip_country_cod:17,geoip_in_countri:17,get:[4,6,14],getconnect:28,getstat:6,getstr:28,ghi:19,git:4,github:19,give:[11,35,38],given:[14,17,18,19,20,34,35,36,37,38,40,48,51,57,58],global:[14,51],gmt:51,goal:27,good:41,got:20,grant:4,greater:16,gregorian:14,group:[37,38,44],groupbi:22,grouping_column_refer:38,grtajo01:53,guarante:6,guid:58,gzip:44,gzipcodec:35,haadmin:6,hadmin:6,hadoop:[5,7,19,20,22,27,35,37],hadoop_hom:[5,19,40],handl:28,hash:22,have:[4,10,14,20,21,22,35],haven:29,hbase_hom:20,hbase_table_nam:20,hdf:[5,10,11,19,21,22,24,25,27,35,40,41,52],hdfs_locat:45,header:45,hello:14,help:58,here:[14,19,20,37,40,46],hh12:14,hh24:14,high:2,higher:19,highli:[19,51],histori:6,hive:[4,21,22],hive_hom:[4,21],hive_jdbc_driver_dir:[4,21],hivemetastor:[4,21],hiveql:21,home:[1,4,19,20,21],host1:[5,6],host2:[5,6],host:[4,5,6,9,53,57],hos
tnam:[4,5,10,28,57],hour:14,how:5,howev:44,html:58,http:[4,6,8,17,19,26,40,58],hurt:27,hyunsik:[1,20,58],iddd:14,ident:14,identifi:[4,14,38],ieee:34,ignor:[11,14,48],impl:40,implement:[14,19,40,58],implementaion:10,implicitli:38,improv:44,includ:[4,11,14,38],incorrect:6,increas:5,independ:44,index:[22,23],index_en:24,index_support:26,indic:14,individu:38,inet4:[17,34],inexact:34,info:[6,8,20,53],inform:[4,6,9,14,24,35,40,58],inherit:[45,48],init:19,initi:6,inner:38,input:[14,16,18],insensit:37,insert:6,inspect:52,instal:[4,17,19],instanc:[5,10,19],instead:[4,14,19,37,48,51,57],instruct:[17,21],int1:34,int2:34,int32:40,int4:[18,34,36,58],int8:[1,16,24,34,36,58],integ:[11,14,16,34,48,58],integr:4,intend:14,interact:[19,27,57],interfac:[6,48,52],intern:[7,51],interpret:14,interv:[6,14],introduc:22,introduct:22,invers:58,invok:6,ipv4:[17,34],iso:14,isodow:14,isoyear:14,issu:22,item:[14,37,55],item_nam:29,itself:[6,58],iyi:14,iyyi:14,jaehwa:20,jan:14,januari:14,jar:[4,21,28,40],java:[4,7
,19,21,28,34,37,51],java_hom:19,jdbc4:4,jdbc:[4,21,22],jhkim:20,jinho:20,jkl:19,jline2:54,json:13,json_extract_path_text:15,julian:14,jun:14,jung:20,just:[1,4,6,37,38,55,60],jvm:6,keep:14,kei:[14,15,20,25,29,31,35,45,46,56,60],key1:60,keyston:40,keyword:[38,46],kill:[6,53],kim:20,kind:[25,38],know:[5,14,19,38,51],knowledg:48,known:29,l_comment:[24,35],l_commitd:24,l_discount:[24,38],l_extendedpric:[24,38],l_linenumb:24,l_linestatu:24,l_orderkei:[20,24,35,36,38],l_orderkey_idx:24,l_partkei:[20,24,35,36,38],l_quantiti:[20,24,36,38],l_receiptd:24,l_returnflag:24,l_shipdat:[24,38],l_shipinstruct:24,l_shipmod:24,l_suppkei:24,l_tax:24,languag:[19,22,24,27],larger:[34,38,44],largest:16,last:[14,24,35,38],lastli:4,late:14,later:19,launch:4,layer:10,layout:[41,47],lazybinari:46,lazybinarycolumnarserd:45,lazybinaryserd:46,lc_time:14,lead:[14,18,29],leaf:25,learn:[19,47,51],least:[37,38],left:38,legaci:17,length:[14,34],less:[14,16],let:46,lib:[4,40],librari:20,licens:58,like:[10,14,19,28,29],
limit:[11,22],line:[5,6,40,48,51,52],lineitem:[20,24,35,36,38,53,58],lineitem_100_snappi:35,link:[19,24],linux:58,list:[5,6,19,21,29,37,38,51,53,58],list_endpoint:40,listen:[5,28],liter:[7,14,48],littl:5,load:[19,20,27],locaion:51,local:[4,11,14,17],localhost:[4,5,6,8,24,35,57],locat:[1,4,11,17,19,28,35,36,40,45,47,48,51],logic:[37,41],long_table_name_1234:38,lower:[14,18],ltrim:18,lzo:44,machin:[6,57],mai:[4,6,7,14,19,38,59],main:[7,20,27,28,37],manag:[4,19,20,21,22,31],mandatori:40,mani:[11,45,51,58],manipul:60,manner:28,manual:[4,45],map:34,mapr:46,march:14,mariadbstor:4,master:[2,4,5],match:[14,18,22,34],math:13,maven:[4,19,21],max:48,max_output_file_s:60,maxmind:17,mdy:9,mean:[14,20,37],memori:[4,6],memstor:4,mention:45,meridiem:14,meta:[4,19,20,22,51,52],metacharact:37,metadata:45,metastor:21,method:[1,22],microsecond:14,midnight:14,millennium:14,millisecond:14,mind:14,minut:[14,19,21],mirror:19,mix:14,mixtur:14,mkdir:[5,19,55],mmdd:14,mno:19,mod:16,mode:4,model:[22,33],modifi
:14,modul:[7,22],moment:[44,48],mon:14,mondai:14,monitor:6,month:14,more:[4,5,11,14,19,21,23,24,35,37,38,40,44,56,59],most:[4,47,48],mostli:45,move:19,msck:21,msk:21,much:11,multipl:[6,11,14,38,48,51],multipli:14,must:[4,6,9,10,14,20,21,24,26,34,38,44,56],mvn:[4,19,21,28],mysql_jdbc_driv:[4,21],mysqlstor:4,name1:60,name2:60,name3:60,name:[1,4,5,6,7,8,9,10,11,14,17,19,20,21,24,28,34,35,38,40,44,45,46,47,48,51,52,56,57,58,60],namenode_hostnam:10,namespac:28,nation:58,natur:38,nearest:[14,16,58],necessari:27,need:[1,4,6,14,19,20,21,28,40,41,44,45,46,48],neither:37,nest:44,network:[6,13],never:[6,20],newli:21,next:[14,21,28],node:[4,5,6,11,25],non:[14,38,44],nonsens:14,nor:37,note:[4,14,37],novemb:14,now:[1,14,19,44,45,58,60],num1:16,num2:16,num:[38,48,57],number:5,numer:14,o_clerk:58,o_com:58,o_custkei:58,o_orderd:58,o_orderkei:58,o_orderprior:58,o_orderstatu:58,o_shipprior:58,o_totalpric:58,object:40,occur:[14,20,35,38,45,48],off:14,offset:[48,51],ojdbc7:4,omit:[14,38,45,58],onc:[6,17
,24,38,40],ongo:6,onli:[4,7,10,14,19,25,31,35,38,44,45,46,48],open:27,openstack:22,oper:[4,6,13],optim:[23,27],option:[1,14,19,20,24,35,38,53,56,57],oraclestor:4,order:[4,5,9,11,19,20,21,26,27,28,29,34,38,41,44,45,47,48,51,58],order_d:29,orderbi:22,ordin:[14,16],ordinari:14,org:[4,19,21,26,28,35,40,45,46,47,48,58],origin:20,other:[6,7,11,14,20,27,36,38,40,45,48,51],otherwis:[14,17,37,38,57],our:48,out:11,outer:38,outfil:1,output:[14,20,36,38,46],over:38,overview:22,overwrit:6,own:[47,48,51],p_id:56,packag:[21,28],pad:14,page:[5,22,44],pair:[7,45,46],parallel:5,param:[38,56,57],paramet:[14,15,16,17,18,22,35,44,45,47,48],paramt:56,parent:19,parenthes:[37,38],parquet:[22,43],pars:48,part:[14,58],partit:[21,22,23],partsupp:58,pass:38,password:[4,40],past:14,path:[1,4,10,15,17,19,20,21,24,28,35,47,51,58],pattern:[14,18,22],pdist:[4,19,21,28],peer:8,pemiss:48,per:[5,6,11,22],percent:37,perform:[24,38,40],period:[6,14],perman:25,persist:[4,19],peter:14,phase:29,phcatalog:[4,21],physic:[5,4
1],pictur:58,pid:6,place:58,plain:[45,46,48],plan:[27,29,48],pleas:[1,5,11,14,17,19,24,26,28,35,38,40,44,45,47,48,51],point:[6,14,15,45],polar:16,pope:14,port:[4,5,6,10,20,28,40,53,57],posit:25,posix:37,possibl:[11,14,38],postgresqlstor:4,pow:16,power:[16,37],preced:[14,17],precis:[14,34],predic:[22,29,33,35],prefix:[14,40,51,56],preliminari:2,prepar:[4,19,21],present:[19,58],preserv:6,prevent:6,previou:[14,37],price:29,primari:[6,10],primarili:14,primit:34,print:14,println:28,problem:[6,54],procedur:19,process:[14,22,26,27,29,44,45,48,51,52],product:38,profil:[4,21],program:[7,44],progress:[20,27,53,54,56,59],project:[27,44],prompt:[57,58,59],proper:[4,10,11,19],properti:[4,5,6,7,8,9,10,11,17,20,21,22,40,41],protocol:19,provid:[4,6,11,17,19,21,22,23,27,28,31,37],proxi:40,prune:22,pst:[48,51],purg:[20,35],purpos:[7,21],put:[14,20,51,56],q_1363768615503_0001_000001:19,q_1411357607375_0006:53,q_1411357607375_0007:53,qualifier_nam:20,quantiti:38,quarter:14,queri:[4,6,11],query_run:53,q
uery_succeed:19,queryid:53,querymast:[6,11],quit:58,quorum:20,quot:[14,57],radian:16,rais:16,ran:4,rang:[22,31],ratio:11,rcfile:[22,43],rdbm:[28,41],read:[5,19,25,44],real:16,recogn:[40,48,51],recommand:51,recommend:[14,19,40],record:[37,44,45,46,48],recordcompresswrit:46,rectangular:16,refer:[5,9,17,19,20,24,26,28,35,38,40,44,45,46,47,48,51,58],regardless:[24,44,45],regexp:37,regexp_replac:18,region:[40,58],regionon:40,regist:51,register_d:20,regular:18,relat:[38,44],remaind:16,remot:5,remov:[4,18,19,20,35],reoptim:27,repair:21,repeat:14,repetit:37,replac:[14,18],repo:[4,19,26],repositori:19,repres:[14,40,48],represent:[14,44],request:11,requir:[6,14,19,38,59],resid:19,resourc:[5,6,8],resourceconfigur:11,respect:[34,37],respond:21,respons:[19,20,27,54,56,59],rest:38,restrict:14,result:[6,14,19,20,38,44,51,58],result_set_fetch_rownum:60,resultset:28,resut:16,retriev:[14,24,26,51],right:38,rlike:37,roma:14,roman:14,root:[5,16,25],rootdir:5,round:[16,58],row:[4,19,20,24,37,38,44,45,46
,48,51,56,58,59],row_num:38,row_numb:38,rowkei:20,rpc:[5,6,8,28],rtrim:18,run:[5,6],saint:14,salari:38,same:[6,14,16,17,20,21,37,38,40],saturdai:14,scalar:[38,44],scale:27,scan:[20,21,22],schema:[19,20,24,29,36,41,44,52,58],scheme:[10,19],score:[19,40,44,45,46,47,48,56,59],script:[7,19],search:[22,25,26],search_condit:38,sec:[4,19,20,53,54,56,59],second:[4,6,14,18,20],section:[5,11,14,19,20,21,26,28,40,41,45,48],see:[4,5,11,14,19,20,24,40],select:[14,16,17,18,19,20,23,28,36,37,38,51,53,56,58,59],select_list:38,select_stat:35,semicolon:[55,59],seoul:[47,48,51],separ:[14,38,46,48,59],sequecnefil:46,sequenc:37,sequencefil:[22,43,45],serd:45,serde2:[45,46],serv:6,server:[4,6,7,19,22,40],servic:[2,4,5],servicenam:4,session:[22,51,52,58],set:4,setup:2,sever:4,share:[4,28,38,40,45],shell:[7,19,20,22],shift:14,ship_dat:29,shortcut:55,shorten:4,shortli:25,should:[1,4,5,9,10,11,14,17,19,20,21,24,28,29,35,44,45,48,51,57],show:[4,19,28,53,58,60],showmast:53,shown:14,shut:19,shutdown:6,side:[18,
51],sign:[16,37],simpl:19,simpli:[19,24],simul:6,simultan:11,sin:16,sinc:[4,14,45],sine:16,singl:[5,6,14,22,37,41,44,52],site:2,skip:14,small:[24,34,44],smaller:[20,36],smallest:[16,44],smallint:34,snappi:44,snappycodec:[35,45,46,47,48],snapshot:[4,19],snativ:40,some:[4,7,14,19,20,21,34,38,44,45,47,48,51,54],sort:[20,38],sort_expr:38,sourc:[4,14],space:[14,18],special:[47,48],specif:[6,10,14,34,36],specifi:[4,10,11,14,15,17,19,20,21,28,34,36,37,38,39,40,44,45,46,47,48,51,53,55,57],spell:14,split:[18,40],split_part:18,sql_languag:58,sqrt:16,squar:16,src:[14,19,28],ssss:14,stage:19,standalon:19,standard:[14,19,27,34,37],standbi:6,start:[5,6,14,18],starttim:53,startup:57,statement:[19,20,28,35,36,37,38,44,45,46,47,48,51,53,56,57,58],statist:6,statu:6,step:[19,24,40],still:[6,26],stmt:28,stop:[6,54],storag:[1,4,10,19,20,40,44,45,46,48],storage_typ:35,store:[4,6,11,19,20,21,24,25,27,40,45,46,48,56,58],str1:18,str2:18,string:[7,13,14,15,17],strong:1,strongli:40,structur:[26,35],style:37,s
ubdir:36,subfield:14,subject:38,submit:[6,19,24],subqueri:38,subsequ:[14,25],substr:[14,18,38],subtract:14,successfulli:[6,24,53],suffici:24,suffix:14,suggest:19,sum:[38,56,59],sundai:14,supergroup:55,suppli:14,supplier:58,support:[1,4,10,14],suppress:14,swift:22,swift_tabl:40,swiftnativefilesystem:40,symbol:56,synopsi:[20,22,35,37,38],syntax:[38,39],system:[4,5,6,7],t_date:[47,51],t_timestamp:[47,51],tab:48,tabl:[1,4,19],table1:[19,28,37,38,44,45,46,47,48,51,56,59],table_backup:1,table_nam:[1,20,21,35],table_refer:38,tabular:48,tajo:[1,2,4],tajo_classpath:[4,40],tajo_hom:[4,5,6,7,19,28,40,57],tajo_master_heaps:10,tajo_password:40,tajo_pid_dir:6,tajo_src:19,tajo_worker_heaps:11,tajocli:[6,51],tajodriv:28,tajojdbccli:28,tajomast:[2,4,5],tajoresourcemanag:6,tajowork:[6,7,11],tajoxx:18,take:[19,21,38],tan:16,tangent:16,tar:[4,19,28],tarbal:6,target:[4,6,16,19,20,28,36],tbl:40,tbname:58,tcp:57,techniqu:27,temp:55,templat:[4,14],templet:7,ten:[19,21],tenant:40,termin:48,test:4,test_broad
cast_join_en:60,test_filter_pushdown_en:60,test_join_opt_en:60,test_min_task_num:60,text:[1,5,6,14,15,17,18,19,20,22,24,29,34,35,37,40,43,44,45,46,47],text_nul:60,textserd:46,textserializerdeseri:[45,46],than:[14,16,19,20,21,36,37,38,56],thei:[6,14,37,45,47],them:[38,51],therefor:[6,14],theta:16,thi:[1,4,5,6,7,11,14,19,20,21,24,26,28,35,37,38,40,41,44,46,48,51,55,56],thin:4,think:19,third:[4,14],those:[44,45,47,48],three:[4,14,46],through:21,thu:[19,21],thursdai:14,time:6,timestamp:[14,20,34,47,48,51],timestamptz:34,timetz:34,timezon:[9,47,48,51,60],tini:34,tinyint:34,titl:20,tmmonth:14,tmp:[4,10,19,55],tmpdir:11,to_char:[14,51],to_dat:14,to_numb:14,to_timestamp:14,togeth:14,toggl:14,token:40,toler:[27,48],too:44,tool:[40,58],total2:38,total:[11,38],tpch:[1,24,58],tracker:[5,6,8],trail:[14,18],transit:6,transitiontoact:6,transitiontobackup:6,translat:[14,51],tree:[19,25],trigger:6,trim:18,truncat:16,tsql:[1,19,22,51],tuesdai:14,tupl:[24,25],twenti:14,two:[1,7,14,19,25,31,37,39,45,46
],two_level_bin_tre:[24,25,35],type:[1,7,11,14,15,16,17,18,19,20,22,23,24],typic:38,u0001:[47,48],umbil:[5,6,8],uncompress:[44,46],underli:40,underscor:37,understand:41,unequ:6,unhealthi:6,unicod:34,uniqu:60,unit:[4,44],unix:14,unix_timestamp:14,unknown:[20,24],unless:[14,21],unqualifi:[29,38],unquot:58,unset:[58,60],untar:19,until:60,updat:[6,21],upper:[14,18],uri:[4,6,40],url:[10,28,40,41],usag:[1,14],user:[4,6,10,11,14,19,21],usernam:[4,19,40],usr:4,usual:[7,48],utc:[14,48,51],utc_usec_to:[14,58],util:[24,52],val1:[37,60],val2:[37,60],val3:60,val:60,valid:14,valn:37,valu:[4,5,6,7,9,10,11,14,16,17,20,21,22,26],varbinari:34,varbit:34,varchar:34,vari:[14,34],variabl:[4,7,10,11,19,20,21,22,34,51,52,58],varieti:7,variou:[14,41,60],vatican:14,veri:[5,19,37],verifi:[6,20],versa:45,version:[4,19,58],vertic:48,via:[5,6],vice:45,view:41,volum:[19,20,24,58],wai:[1,6,14,20,48,51],wait:6,want:[1,4,5,6,7,10,11,14,19,20,21,24,28,29,35,36,46,55,57,59],warehous:[20,27,35,55],web:[6,27],week:14,we
ekdai:14,well:[14,20,34,35,36],what:14,when:[4,6,14,19,20,24,25,35,36,38,44],where:[4,5,11,19,20,22,29,34,35,37],whether:[37,38,45],which:[4,6,14,19,20,25,27,28,35,38,45,46,47,51,57,60],who:48,whole:11,width:14,wild:29,window:22,wip:[4,19,26],wish:56,within:[6,14,38,55],without:[4,14,27,29,38,48,59],word:[11,14,45,48,51],work1:58,work:[14,22],worker:2,workload:11,worst:27,would:[14,19,21],writ:48,write:[14,44,45,46,47,48,51],written:[45,46,48,51],x84:20,xa2:20,xe2:20,xii:14,xml:2,xpath:15,xtajoxx:18,xxtajo:18,xxx:58,xxxxxx:4,xzvf:[19,28],year:[14,38],yet:29,ymd:9,you:[1,4,5,6,7,9,10,11,14,17,19,20,21,24,26,28,29,35,36,37,38,40,44,45,46,47,48,51,54,55,56,57,58,59],your:[1,4,5,6,7,9,10,14,19,20,21,28,44,45,48],yyi:14,yyyi:14,yyyymmdd:14,yyyymondd:14,zero:[14,37],zone:[9,14,22,34],zong:51,zookeep:20,zookeeper_address:20,zookeeper_client_port:20},titles:["Backup and Restore","Backup and Restore Catalog","Configuration","The catalog-site.xml File","Catalog Configuration","Cluster Setup",
"High Availability for TajoMaster","Preliminary","Cluster Service Configuration Defaults","The tajo-site.xml File","Tajo Master Configuration","Worker Configuration","FAQ","Functions","DateTime Functions and Operators","JSON Functions","Math Functions and Operators","Network Functions and Operators","String Functions and Operators","Getting Started","HBase Integration","HCatalog Integration","Apache Tajo\u2122 0.10.1 Release - User documentation","Future Works","How to use index?","Index Types","Index (Experimental Feature)","Introduction","Tajo JDBC Driver","Column Partitioning","Hash Partitioning","Introduction to Partitioning","Range Partitioning","SQL Language","Data Model","Data Definition Language","INSERT (OVERWRITE) INTO","Predicates","Queries","SQL Expressions","OpenStack Swift Integration","Table Management","Compression","File Formats","Parquet","RCFile","SequenceFile","Overview of Tajo Tables","TEXT","Table Partitioning","Tajo Client API","Time Zone","Tajo Shell (TSQL)",
"Administration Commands","Executing as background process","Executing HDFS commands","Executing Queries from Files","Introducing to TSQL","Meta Commands","Executing a single command","Session Variables"],titleterms:{"default":8,"function":[13,14,15,16,17,18,38,39],"null":48,administr:[6,53],alias:38,apach:[22,29,44,45,48],api:50,arithmet:39,automat:6,avail:6,background:54,backup:[0,1,6],base:5,basic:[53,56,58],binari:28,build:[19,28],call:39,cast:39,catalog:[1,3,4,7],check:19,classpath:28,claus:38,client:[28,50,51],cluster:[5,6,8,19,51],code:[19,28],column:29,command:[53,55,58,59],common:[40,47],compat:[29,44,45,48],compress:[35,42,47],config:9,configur:[2,4,6,8,10,11,40],convers:14,creat:[20,24,29,35,44,45,48],cross:38,custom:48,data:[11,34,35],databas:[1,35],date:[9,14],datetim:14,dedic:11,definit:35,derbi:4,direct:28,directori:[5,11],disabl:24,distribut:[5,28],document:22,doubl:34,dowload:19,download:[19,28],driver:28,drop:[20,35],dump:1,each:11,enabl:24,enter:57,env:7,exampl:[1
1,28,38,51],execut:[19,54,55,56,59],experiment:26,express:[37,39],extern:47,failov:6,faq:12,featur:26,file:[3,6,9,43,56],first:19,format:[14,43],from:[28,38,56],fulli:5,futur:23,gener:45,get:[19,28],git:19,groupbi:38,hadoop:40,handl:48,hash:30,have:38,hbase:20,hcatalog:21,hcatalogstor:4,hdf:55,heap:[10,11],high:6,hive:[29,44,45,48],how:[6,24,28,29,44,45,48],ilik:37,index:[24,25,26,35],indic:22,insert:[20,36],integr:[20,21,40],introduc:[46,57],introduct:[27,31],issu:[29,44,45,48],jdbc:28,join:38,json:15,languag:[33,35],latest:19,launch:[5,6],level:1,like:37,limit:38,local:19,make:5,manag:[41,47],mariadb:4,master:[6,8,10],match:37,math:16,maximum:11,memori:[10,11],meta:58,method:[31,35],mode:[5,11],model:34,mysql:4,network:17,number:[11,34],openstack:40,oper:[14,16,17,18],oracl:4,orderbi:38,out:19,overview:[38,47],overwrit:[20,36],parallel:11,paramet:56,parquet:44,partit:[29,30,31,32,49],pattern:37,per:40,permiss:5,physic:[44,45,48],postgresql:4,predic:37,preliminari:7,prerequisit:[17
,19],process:54,properti:[44,45,47,48],provid:40,prune:29,qualifi:38,queri:[19,38,40,56],rang:32,rcfile:45,read:45,real:34,regular:37,releas:[19,22],resourc:11,restor:[0,1],rootdir:10,run:11,scan:24,sequencefil:46,serd:46,serial:[45,48],serializerdeseri:46,server:51,servic:8,session:60,set:[5,6,9,19,28,56],setup:5,shell:[52,57],similar:37,singl:59,site:[3,7,9],size:[10,11],sourc:[19,28],sql:[1,33,39,56],start:19,state:6,string:[18,37,39],support:17,swift:40,synopsi:[53,57],system:9,tabl:[20,22,29,35,38,41,44,45,47,48,49,51],tajo:[5,6,7,8,9,10,19,22,28,40,45,47,50,52],tajomast:[6,10],task:11,temporari:11,terminolog:6,test:6,text:48,time:[9,14,47,51],todo:[1,12,30,32,42,47,50],tsql:[52,57],type:[25,34,38,39],unpack:19,usag:[20,53,56,58],user:22,valu:[34,48,56],variabl:60,via:19,when:45,where:38,window:38,work:23,worker:[5,8,11],writer:46,xml:[3,7,9],zone:[47,51]}})
\ No newline at end of file
Modified: tajo/site/docs/current/sql_language.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language.html?rev=1688350&r1=1688349&r2=1688350&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language.html (original)
+++ tajo/site/docs/current/sql_language.html Tue Jun 30 04:16:52 2015
@@ -7,7 +7,7 @@
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>SQL Language — Apache Tajo 0.10.0 documentation</title>
+ <title>SQL Language — Apache Tajo 0.11.0 documentation</title>
@@ -28,7 +28,7 @@
- <link rel="top" title="Apache Tajo 0.10.0 documentation" href="index.html"/>
+ <link rel="top" title="Apache Tajo 0.11.0 documentation" href="index.html"/>
<link rel="next" title="Data Model" href="sql_language/data_model.html"/>
<link rel="prev" title="Executing as background process" href="tsql/background_command.html"/>
@@ -112,6 +112,7 @@
<li class="toctree-l2"><a class="reference internal" href="functions/string_func_and_operators.html">String Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/network_func_and_operators.html">Network Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="functions/json_func.html">JSON Functions</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="table_management.html">Table Management</a><ul>
@@ -145,11 +146,17 @@
<li class="toctree-l2"><a class="reference internal" href="hbase_integration.html#usage">Usage</a></li>
</ul>
</li>
+<li class="toctree-l1"><a class="reference internal" href="swift_integration.html">OpenStack Swift Integration</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="swift_integration.html#swift-configuration">Swift configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="swift_integration.html#hadoop-configurations">Hadoop configurations</a></li>
+<li class="toctree-l2"><a class="reference internal" href="swift_integration.html#tajo-configuration">Tajo configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="swift_integration.html#querying-on-swift">Querying on Swift</a></li>
+</ul>
+</li>
<li class="toctree-l1"><a class="reference internal" href="jdbc_driver.html">Tajo JDBC Driver</a><ul>
<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li>
<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li>
<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li>
-<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#faq">FAQ</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="tajo_client_api.html">Tajo Client API</a></li>
@@ -240,7 +247,7 @@
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT:'./',
- VERSION:'0.10.0',
+ VERSION:'0.11.0',
COLLAPSE_INDEX:false,
FILE_SUFFIX:'.html',
HAS_SOURCE: true
Modified: tajo/site/docs/current/sql_language/data_model.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/data_model.html?rev=1688350&r1=1688349&r2=1688350&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/data_model.html (original)
+++ tajo/site/docs/current/sql_language/data_model.html Tue Jun 30 04:16:52 2015
@@ -7,7 +7,7 @@
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Data Model — Apache Tajo 0.10.0 documentation</title>
+ <title>Data Model — Apache Tajo 0.11.0 documentation</title>
@@ -28,7 +28,7 @@
- <link rel="top" title="Apache Tajo 0.10.0 documentation" href="../index.html"/>
+ <link rel="top" title="Apache Tajo 0.11.0 documentation" href="../index.html"/>
<link rel="up" title="SQL Language" href="../sql_language.html"/>
<link rel="next" title="Data Definition Language" href="ddl.html"/>
<link rel="prev" title="SQL Language" href="../sql_language.html"/>
@@ -113,6 +113,7 @@
<li class="toctree-l2"><a class="reference internal" href="../functions/string_func_and_operators.html">String Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="../functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="../functions/network_func_and_operators.html">Network Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../functions/json_func.html">JSON Functions</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul>
@@ -146,11 +147,17 @@
<li class="toctree-l2"><a class="reference internal" href="../hbase_integration.html#usage">Usage</a></li>
</ul>
</li>
+<li class="toctree-l1"><a class="reference internal" href="../swift_integration.html">OpenStack Swift Integration</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#swift-configuration">Swift configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#hadoop-configurations">Hadoop configurations</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#tajo-configuration">Tajo configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../swift_integration.html#querying-on-swift">Querying on Swift</a></li>
+</ul>
+</li>
<li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul>
<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li>
<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li>
<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li>
-<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="../tajo_client_api.html">Tajo Client API</a></li>
@@ -236,132 +243,139 @@
<td> </td>
</tr>
<tr class="row-odd"><td>O</td>
+<td>tinyint</td>
+<td>int1</td>
+<td>1</td>
+<td>tiny-range integer value</td>
+<td>-2^7 (-128) to 2^7-1 (127)</td>
+</tr>
+<tr class="row-even"><td>O</td>
<td>smallint</td>
-<td>tinyint, int2</td>
+<td>int2</td>
<td>2</td>
<td>small-range integer value</td>
-<td>-2^15 (-32,768) to 2^15 (32,767)</td>
+<td>-2^15 (-32,768) to 2^15-1 (32,767)</td>
</tr>
-<tr class="row-even"><td>O</td>
+<tr class="row-odd"><td>O</td>
<td>integer</td>
<td>int, int4</td>
<td>4</td>
<td>integer value</td>
<td>-2^31 (-2,147,483,648) to 2^31 - 1 (2,147,483,647)</td>
</tr>
-<tr class="row-odd"><td>O</td>
+<tr class="row-even"><td>O</td>
<td>bigint</td>
<td>bit varying</td>
<td>8</td>
<td>larger range integer value</td>
<td>-2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)</td>
</tr>
-<tr class="row-even"><td>O</td>
+<tr class="row-odd"><td>O</td>
<td>real</td>
<td>int8</td>
<td>4</td>
<td>variable-precision, inexact, real number value</td>
<td>-3.4028235E+38 to 3.4028235E+38 (6 decimal digits precision)</td>
</tr>
-<tr class="row-odd"><td>O</td>
+<tr class="row-even"><td>O</td>
<td>float[(n)]</td>
<td>float4</td>
<td>4 or 8</td>
<td>variable-precision, inexact, real number value</td>
<td> </td>
</tr>
-<tr class="row-even"><td>O</td>
+<tr class="row-odd"><td>O</td>
<td>double</td>
<td>float8, double precision</td>
<td>8</td>
<td>variable-precision, inexact, real number value</td>
<td>1 .7Eâ308 to 1.7E+308 (15 decimal digits precision)</td>
</tr>
-<tr class="row-odd"><td> </td>
+<tr class="row-even"><td> </td>
<td>number</td>
<td>decimal</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
-<tr class="row-even"><td> </td>
+<tr class="row-odd"><td> </td>
<td>char[(n)]</td>
<td>character</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
-<tr class="row-odd"><td> </td>
+<tr class="row-even"><td> </td>
<td>varchar[(n)]</td>
<td>character varying</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
-<tr class="row-even"><td>O</td>
+<tr class="row-odd"><td>O</td>
<td>text</td>
<td>text</td>
<td> </td>
<td>variable-length unicode text</td>
<td> </td>
</tr>
-<tr class="row-odd"><td> </td>
+<tr class="row-even"><td> </td>
<td>binary</td>
<td>binary</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
-<tr class="row-even"><td> </td>
+<tr class="row-odd"><td> </td>
<td>varbinary[(n)]</td>
<td>binary varying</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
-<tr class="row-odd"><td>O</td>
+<tr class="row-even"><td>O</td>
<td>blob</td>
<td>bytea</td>
<td> </td>
<td>variable-length binary string</td>
<td> </td>
</tr>
-<tr class="row-even"><td>O</td>
+<tr class="row-odd"><td>O</td>
<td>date</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
-<tr class="row-odd"><td>O</td>
+<tr class="row-even"><td>O</td>
<td>time</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
-<tr class="row-even"><td> </td>
+<tr class="row-odd"><td> </td>
<td>timetz</td>
<td>time with time zone</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
-<tr class="row-odd"><td>O</td>
+<tr class="row-even"><td>O</td>
<td>timestamp</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
-<tr class="row-even"><td> </td>
+<tr class="row-odd"><td> </td>
<td>timestamptz</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
-<tr class="row-odd"><td>O</td>
+<tr class="row-even"><td>O</td>
<td>inet4</td>
<td> </td>
<td>4</td>
@@ -421,7 +435,7 @@
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT:'../',
- VERSION:'0.10.0',
+ VERSION:'0.11.0',
COLLAPSE_INDEX:false,
FILE_SUFFIX:'.html',
HAS_SOURCE: true