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/10/02 06:41:41 UTC
svn commit: r1628884 - in /tajo/site/docs/current:
_sources/configuration/catalog_configuration.txt
_sources/getting_started/local_setup.txt
configuration/catalog_configuration.html getting_started/local_setup.html
index.html searchindex.js
Author: hyunsik
Date: Thu Oct 2 04:41:41 2014
New Revision: 1628884
URL: http://svn.apache.org/r1628884
Log:
Updated Tajo by TAJO-1077
Modified:
tajo/site/docs/current/_sources/configuration/catalog_configuration.txt
tajo/site/docs/current/_sources/getting_started/local_setup.txt
tajo/site/docs/current/configuration/catalog_configuration.html
tajo/site/docs/current/getting_started/local_setup.html
tajo/site/docs/current/index.html
tajo/site/docs/current/searchindex.js
Modified: tajo/site/docs/current/_sources/configuration/catalog_configuration.txt
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/configuration/catalog_configuration.txt?rev=1628884&r1=1628883&r2=1628884&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/configuration/catalog_configuration.txt (original)
+++ tajo/site/docs/current/_sources/configuration/catalog_configuration.txt Thu Oct 2 04:41:41 2014
@@ -24,6 +24,39 @@ If you want to customize the catalog ser
+-----------------------------------+------------------------------------------------+
=========================
+Derby Configuration
+=========================
+
+By default, Tajo uses `Apache Derby <http://db.apache.org/derby/>`_ as a persistent storage in order to manage table meta data. So, without any configuration, you can use Derby for catalog store.
+
+Also, you can set manually configs in ``conf/catalog-site.xml`` as follows:
+
+.. code-block:: xml
+
+ <property>
+ <name>tajo.catalog.store.class</name>
+ <value>org.apache.tajo.catalog.store.DerbyStore</value>
+ </property>
+
+ <property>
+ <name>tajo.catalog.uri</name>
+ <value>jdbc:derby:<absolute directory>;create=true</value>
+ </property>
+
+Since Derby is a file-based embedded database, it stores data into a specified directory. So, you need to specify the directory for storing data files instead of specifying JDBC URI with hostname and port. For example, in case where you use '/var/data/tajo-catalog' as a derby store directory, you should set configs as follows:
+
+.. code-block:: xml
+
+ <property>
+ <name>tajo.catalog.uri</name>
+ <value>jdbc:derby:/var/data/tajo-catalog;create=true</value>
+ </property>
+
+.. warning::
+
+ By default, *Catalog server* stores catalog data into ``/tmp/tajo-catalog-${username}`` directory. But, some operating systems may remove all contents in ``/tmp`` when booting up. In order to ensure persistent store of your catalog data, you need to set a proper location of derby directory.
+
+=========================
MySQLStore Configuration
=========================
Modified: tajo/site/docs/current/_sources/getting_started/local_setup.txt
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/_sources/getting_started/local_setup.txt?rev=1628884&r1=1628883&r2=1628884&view=diff
==============================================================================
--- tajo/site/docs/current/_sources/getting_started/local_setup.txt (original)
+++ tajo/site/docs/current/_sources/getting_started/local_setup.txt Thu Oct 2 04:41:41 2014
@@ -23,3 +23,9 @@ To launch the tajo master, execute start
.. note::
If you want to how to setup a fully distributed mode of Tajo, please see :doc:`/configuration/cluster_setup`.
+
+.. warning::
+
+ By default, *Catalog server* which manages table meta data uses `Apache Derby <http://db.apache.org/derby/>`_ as a persistent storage, and Derby stores data into ``/tmp/tajo-catalog-${username}`` directory. But, some operating systems may remove all contents in ``/tmp`` when booting up. In order to ensure persistent store of your catalog data, you need to set a proper location of derby directory. To learn Catalog configuration, please refer to :doc:`/configuration/catalog_configuration`.
+
+
Modified: tajo/site/docs/current/configuration/catalog_configuration.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/configuration/catalog_configuration.html?rev=1628884&r1=1628883&r2=1628884&view=diff
==============================================================================
--- tajo/site/docs/current/configuration/catalog_configuration.html (original)
+++ tajo/site/docs/current/configuration/catalog_configuration.html Thu Oct 2 04:41:41 2014
@@ -199,6 +199,33 @@ tests.</td>
</tr>
</tbody>
</table>
+<div class="section" id="derby-configuration">
+<h2>Derby Configuration<a class="headerlink" href="#derby-configuration" title="Permalink to this headline">¶</a></h2>
+<p>By default, Tajo uses <a class="reference external" href="http://db.apache.org/derby/">Apache Derby</a> as a persistent storage in order to manage table meta data. So, without any configuration, you can use Derby for catalog store.</p>
+<p>Also, you can set manually configs in <tt class="docutils literal"><span class="pre">conf/catalog-site.xml</span></tt> as follows:</p>
+<div class="highlight-xml"><div class="highlight"><pre><property>
+ <name>tajo.catalog.store.class</name>
+ <value>org.apache.tajo.catalog.store.DerbyStore</value>
+</property>
+
+<property>
+ <name>tajo.catalog.uri</name>
+ <value>jdbc:derby:<absolute directory>;create=true</value>
+</property>
+</pre></div>
+</div>
+<p>Since Derby is a file-based embedded database, it stores data into a specified directory. So, you need to specify the directory for storing data files instead of specifying JDBC URI with hostname and port. For example, in case where you use ‘/var/data/tajo-catalog’ as a derby store directory, you should set configs as follows:</p>
+<div class="highlight-xml"><div class="highlight"><pre><span class="nt"><property></span>
+ <span class="nt"><name></span>tajo.catalog.uri<span class="nt"></name></span>
+ <span class="nt"><value></span>jdbc:derby:/var/data/tajo-catalog;create=true<span class="nt"></value></span>
+<span class="nt"></property></span>
+</pre></div>
+</div>
+<div class="admonition warning">
+<p class="first admonition-title">Warning</p>
+<p class="last">By default, <em>Catalog server</em> stores catalog data into <tt class="docutils literal"><span class="pre">/tmp/tajo-catalog-${username}</span></tt> directory. But, some operating systems may remove all contents in <tt class="docutils literal"><span class="pre">/tmp</span></tt> when booting up. In order to ensure persistent store of your catalog data, you need to set a proper location of derby directory.</p>
+</div>
+</div>
<div class="section" id="mysqlstore-configuration">
<h2>MySQLStore Configuration<a class="headerlink" href="#mysqlstore-configuration" title="Permalink to this headline">¶</a></h2>
<p>In order to use MySQLStore, you need to create database and user on MySQL for Tajo.</p>
Modified: tajo/site/docs/current/getting_started/local_setup.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/getting_started/local_setup.html?rev=1628884&r1=1628883&r2=1628884&view=diff
==============================================================================
--- tajo/site/docs/current/getting_started/local_setup.html (original)
+++ tajo/site/docs/current/getting_started/local_setup.html Thu Oct 2 04:41:41 2014
@@ -181,6 +181,10 @@
<p class="first admonition-title">Note</p>
<p class="last">If you want to how to setup a fully distributed mode of Tajo, please see <a class="reference internal" href="../configuration/cluster_setup.html"><em>Cluster Setup</em></a>.</p>
</div>
+<div class="admonition warning">
+<p class="first admonition-title">Warning</p>
+<p class="last">By default, <em>Catalog server</em> which manages table meta data uses <a class="reference external" href="http://db.apache.org/derby/">Apache Derby</a> as a persistent storage, and Derby stores data into <tt class="docutils literal"><span class="pre">/tmp/tajo-catalog-${username}</span></tt> directory. But, some operating systems may remove all contents in <tt class="docutils literal"><span class="pre">/tmp</span></tt> when booting up. In order to ensure persistent store of your catalog data, you need to set a proper location of derby directory. To learn Catalog configuration, please refer to <a class="reference internal" href="../configuration/catalog_configuration.html"><em>Catalog Configuration</em></a>.</p>
+</div>
</div>
Modified: tajo/site/docs/current/index.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/index.html?rev=1628884&r1=1628883&r2=1628884&view=diff
==============================================================================
--- tajo/site/docs/current/index.html (original)
+++ tajo/site/docs/current/index.html Thu Oct 2 04:41:41 2014
@@ -204,6 +204,7 @@ As a result, some contents can be mismat
</ul>
</li>
<li class="toctree-l2"><a class="reference internal" href="configuration/catalog_configuration.html">Catalog Configuration</a><ul>
+<li class="toctree-l3"><a class="reference internal" href="configuration/catalog_configuration.html#derby-configuration">Derby Configuration</a></li>
<li class="toctree-l3"><a class="reference internal" href="configuration/catalog_configuration.html#mysqlstore-configuration">MySQLStore Configuration</a></li>
<li class="toctree-l3"><a class="reference internal" href="configuration/catalog_configuration.html#mariadbstore-configuration">MariaDBStore Configuration</a></li>
</ul>
Modified: tajo/site/docs/current/searchindex.js
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/searchindex.js?rev=1628884&r1=1628883&r2=1628884&view=diff
==============================================================================
--- tajo/site/docs/current/searchindex.js (original)
+++ tajo/site/docs/current/searchindex.js Thu Oct 2 04:41:41 2014
@@ -1 +1 @@
-Search.setIndex({envversion:42,terms:{represent:[33,15],all:[38,12,37,2,39,3,29,6,7,43,44,35],code:[3,43,23],dist:[38,14,43],c_name:35,rdbm:38,queri:[29,43,12,8,23],consum:33,concern:[35,25],month:15,four:40,scalar:[6,33],concept:38,per:[29,39,12,8],boolean_express:6,mno:44,follow:[3,5,6,7,8,11,12,35,16,17,18,19,20,24,25,28,29,31,33,14,37,38,39,40,43,44],disk:[3,8],row:[12,33,5,16,6,7,43,44,18],profil:[37,43],privat:38,depend:[37,38,7],c_acctbal:35,zone:20,git:43,getconnect:38,decim:20,init:44,hadmin:29,present:23,sql_languag:12,backup_and_restor:12,"case":[25,36,38,16,7,43,18],digit:20,sourc:[12,43,23],everi:[29,6],string:[10,3,25,15],fals:[20,33,3,7],"void":38,csvfile:[44,31,5],volum:[12,44],failur:29,veri:[2,39,7],affect:[43,8],implicitli:6,hdfs_locat:16,exact:20,dbname:12,tri:38,recordcompresswrit:18,implementaion:24,list:[12,44,39,29,17,7,19,6],hive:[9,37,43],"try":[29,38,12],item:7,adjust:[16,24,33,8,5],form:[16,24,6],cosin:22,vertic:5,dealt:6,println:38,div:22,tajo_src:14,loc
at:[11,38,3,16,31,44,35,8],tajo_hom:[25,38,12,2,39,29,43,44],dir:[39,11,8],pleas:[38,2,39,3,5,16,6,44,33,35,8],prevent:29,templet:25,smaller:11,abil:29,ten:[37,23],natur:6,sign:[22,7],enjoi:44,dowload:23,second:[29,36,43],cost:13,design:[13,17,25,33],aggreg:6,pass:6,val3:12,val2:[7,12],val1:[7,12],durat:43,port:[24,12,38,39,29,43],tmpdir:8,integr:43,compat:[9,43,8],asin:22,abc:[7,44],addr:[3,43],compar:20,cast:9,section:[37,38,39,5,16,23,8],xtajoxx:36,calcul:6,access:[37,38,39,33],c_phone:35,"19th":15,version:[12,43,14],directori:43,supplier:12,"new":[29,12],fall:6,method:[9,35],metadata:16,ongo:29,elimin:[31,6],full:6,hash:9,deriv:6,gener:[29,12,5],never:29,o_totalpric:12,here:[2,7,44,18],tangent:22,address:[39,3,29,41,43,20],path:[24,12,37,38,3,31,43,44,35],o_orderprior:12,sine:22,sinc:16,valu:[22,25,24,12,37,39,3,29,43,8],wait:29,convert:[22,29,3,46],aaabc:7,deterior:33,convers:22,derbi:[29,43],shift:15,larger:[20,6,33],table_backup:35,precis:20,datetim:10,behav:6,codebas:19,impl
ement:[9,2,12],ghi:44,commonli:5,sequencefil:[9,40,16],dayofweek:15,via:[29,39,23],regardless:[16,33],data_typ:31,cbrt:22,transit:29,filenam:12,unix:15,"boolean":[20,6,3,33],namenode_hostnam:24,wip:[43,19],instal:[3,43,14],total:[6,8],unit:[43,33],highli:14,from:[22,9,36,44,15,29,19,35],describ:[37,12],would:[37,14],memori:43,distinct:6,two:[2,28,16,7,25,35,46,18],next:[37,38],connector:[37,43],few:25,program:[25,33],call:[9,6],usr:43,recommend:14,type:[22,9,12,3,15,25,44,35,8,36],until:12,tajo_pid_dir:29,more:[37,33,39,6,7,43,44,23,8],sort:6,flat:[16,18,33],discompress:14,l_quantiti:[11,6],hiveql:37,claus:[9,44,17,7,20],mismatch:9,tbname:12,function_nam:46,rootdir:39,name2:12,name3:12,name1:12,known:17,postgresql:7,editor:[29,39],unpack:23,must:[24,38,29,6,43,33,20],tabular:5,word:[16,8,5],hour:15,formatha:29,alia:[20,6,36,15],setup:34,work:[20,12,33],uniqu:12,dev:3,cat:[29,39,35,44],orderbi:9,archiv:[14,43],can:[9,38,12,25,29,37,2,39,44,5,16,6,7,43,19,31,17,33,14,8,18],parquet:[9,
40],purpos:[37,25],root:[22,39],def:44,bewtween:20,control:29,nearest:22,prompt:12,num1:22,tar:[38,14,43,19],give:[31,6,8],process:[12,13,5,16,17,33],share:[16,38,6],backslash:12,indic:12,high:34,liter:[25,5],want:[25,24,38,11,12,37,2,39,29,17,18,43,44,31,35,8],tarbal:29,tan:22,occur:[31,16,6,15],timestamptz:20,unresolvedaddressexcept:9,sundai:15,multipl:[29,6,8,5],goal:13,quot:12,haadmin:29,str1:36,hdf:[24,12,13,38,39,31,44,23,8],divis:22,how:[9,37,2,39,23,8],purg:31,env:[29,43],c_address:35,main:[13,38,7,25],instead:[12,44,7,5],csv:[9,44,31,12,35],config:[25,12,37,38,39,41,43,8],sin:22,blockcompresswrit:18,updat:29,transitiontoact:29,product:6,resourc:[29,41,39],ltrim:36,atan:22,clone:[43,19],after:[6,14],resultset:38,concatnen:36,befor:[29,6,39],catalog:1,o_com:12,end:[36,19],underscor:7,mariadb:43,data:39,parallel:39,physic:39,tajo_worker_heaps:8,github:19,essenti:29,third:[43,15],read:[33,19,39,5],divid:[22,6],favorit:[29,39],correspond:[16,6],element:[29,25],issu:9,inform:[29,
12,43],preced:3,environ:[25,24,2,37,8],block:[18,33],allow:[24,37,33,39,5,16,31,44,6,8],anoth:[29,46],worst:13,order:[12,13,37,38,39,5,16,6,43,20,17,33,8,44],oper:[29,10],help:12,shorten:43,over:6,move:14,midnight:15,becaus:[29,6,5],comma:[6,5],same:[22,37,3,15,29,6,7],still:29,vari:20,dynam:13,entiti:29,smallint:20,mapr:18,style:7,outer:6,cli:12,window:9,html:12,persist:43,therefor:29,split:36,them:6,within:6,"return":[22,36,3,15,7,5],greater:22,thei:[16,7,29],handl:38,timestamp:[20,15],"1gb":[24,8],col2:[11,7],col3:11,initi:29,nation:12,framework:33,lzo:33,abscissa:22,item_nam:17,now:[12,14,16,33,5,35],utc_usec_to:15,nor:7,introduct:9,choic:33,subqueri:6,hive_jdbc_driver_dir:[37,43],name:[25,24,12,29,37,38,39,3,5,16,41,6,18,43,44,20,33,35,8],anyth:12,simpl:[2,44],drop:9,regexp_replac:36,o_orderd:12,lazybinaryserd:18,separ:[6,18,5],easili:[29,38,39],submit:[29,23,44],mode:43,each:[39,12,25],clsspath:38,complet:29,compatibl:35,side:[38,36],truncat:22,mean:7,compil:[37,14,43],failov:
29,domain:[29,39,7,5],map:20,unequ:29,individu:6,saturdai:15,procedur:14,group:[6,7,33],resut:22,"static":38,connect:[37,38,12,43],year:[6,15],recogn:5,special:5,out:[38,8,19],unquot:12,network:10,space:36,develop:[9,19],o_orderkei:12,xxtajo:36,content:[9,31],hivemetastor:[37,43],current:[24,12,37,38,28,40,29,6,7,43,33,8],math:10,statist:29,shut:23,advanc:[13,6],lastli:43,manipul:12,given:[11,12,44,3,31,7,20,6,36],free:44,standard:[13,20,7,44],asc:6,small:[20,33],cartesian:6,asf:[43,19],dictionari:33,usual:[25,5],org:[12,37,38,5,16,31,18,43,19],"byte":[20,33,12,44],fridai:15,refer:[38,39,3,5,16,6,18,44,33],card:17,care:5,str2:36,val:12,launch:43,angl:22,could:15,omit:[16,6],retriv:38,round:22,filter:[6,7],length:20,rcfile:[9,40],standbi:29,umbil:[29,41,39],interact:[13,12,44],mvn:[37,38,14,43],first:[36,23,25,15,14,43],feed:5,rang:[9,28],directli:[17,5],resourceconfigur:8,feel:44,onc:[6,3,19],arrai:7,independ:33,applciat:38,number:[39,12],capac:[39,8],mai:[29,6,14,25,15],instruct:[3
7,3,19],set:[12,43],done:14,unhealthi:29,tpch:[12,35],open:13,primari:[29,24],differ:[6,7],"long":[13,6,15],script:[14,25],licens:12,mkdir:[39,44],system:[38,29,13,2,39,16,25,14,8],least:[6,7],getstat:29,master:[34,39,12,43],too:33,statement:[11,12,38,5,16,6,7,44,31,33,18],l_partkei:[31,11,6],scheme:[24,44],"final":[37,38,43,44],store:[12,13,37,5,16,18,43,44,8],listen:[38,39],mysql_jdbc_driv:[37,43],option:[12,14,31,6,15,35],especi:20,namespac:38,copi:[25,43],inexact:20,grouping_column_refer:6,hurt:13,"short":[16,6],enclos:6,mostli:16,rtrim:36,standalon:23,exactli:7,geoip_country_cod:3,serv:29,kind:6,target:[22,11,38,29,43,14],keyword:[6,18],provid:[38,12,29,13,2,3,28,5,16,7,43,44,33,40,8,18],expr:6,remov:[31,36],tree:14,long_table_name_1234:6,charact:[36,5,16,17,7,20],project:[13,33],serd:[16,5],num:[6,12],posix:7,balanc:13,becom:29,entri:[29,31,39],sec:[43,44],minut:[37,23],schema:[17,33,11,12,44],comput:6,abov:[16,18,44],textserd:18,ran:43,respons:[13,44],ani:[38,5,29,6,7,33],dow
nload:[3,19],manner:38,have:[9,24,37,31,43,19],further:5,need:[38,29,37,2,5,16,18,43,44,33,35],maxmind:3,"import":38,predic:[9,17,45],tajocli:29,date:[20,35],squar:22,equival:[11,6],partsupp:12,click:19,note:[7,43],also:[12,44,5,29,17,7,19,6,18],without:[13,17,6,5],take:[37,6,23,19],xxxxxx:43,techniqu:13,combin:6,subject:6,prepar:[37,14,43,44],singl:[29,39,7,33],even:29,begin:[12,15],c_nationkei:35,distribut:43,preliminari:34,buffer:[21,33],price:17,filesystem:[23,19],compress:9,deflatecodec:31,most:[43,5],microsecond:15,specifi:[24,11,12,37,38,3,5,16,46,6,7,43,33,20,14,8,18],arithmet:[9,6],phase:17,metacharact:7,"class":[37,38,5,16,7,43,18],dai:15,appear:6,other:[11,13,5,16,6,25,8],don:[38,35,25,14],url:[24,38],doc:12,later:23,request:8,uri:[29,43],quantiti:6,salari:6,part:12,snapshot:[14,43],classnotfoundexcept:38,determin:[6,8],pattern:[9,36],querymast:8,axi:22,sum:6,think:44,show:[38,12,44,23],text:[12,36,29,44,39,3,15,16,17,7,20,31,33,5,35,18],hostnam:[24,38,39,12],syntax:[6,46
],column_refer:7,l_discount:6,identifi:[6,43],ship_dat:17,find:29,xml:[29,39,12,43],absolut:[22,44],onli:[24,25,2,28,15,16,6,18,43,19,33,5],explicitli:[6,25],ratio:8,just:[12,29,6,7,43,35],copyright:12,explain:[2,38,39,5,16,6,23],configur:12,jar:[37,38,43],enough:43,than:[22,11,37,6,7,23],smallest:[22,33],central:29,templat:43,search_condit:6,local:[23,43,3,8,19],info:[29,41],cube:22,variou:12,get:43,familiar:[16,33,5],express:[9,36,45],stop:29,ceil:22,repo:[43,19],cannot:5,java_hom:2,progress:13,increas:39,requir:[2,6,15],prune:9,table_refer:6,bar:5,enabl:[29,38,39,5,16,43,33],termin:5,upper:36,borrow:7,"public":38,remot:39,common:6,partit:9,contain:[29,38,31,39],clean:[37,38,14,43],where:[9,2,39,17,7,44,20,8],bytea:20,dhadoop:14,legaci:3,frame:6,knowledg:5,startup:12,memstor:43,c_custkei:35,see:[2,39,43,8,44],arc:22,float8:[22,20,11,12,35],result:[9,38,29,6,33,44],arg:38,float4:20,close:38,rlike:7,unqualifi:[17,6],o_orderstatu:12,valn:7,awar:8,statu:29,kei:[12,28,16,31,18,17],corr
ectli:[20,14],ieee:20,char_length:36,written:[16,18],score:[16,33,44,18,5],subdir:11,between:[38,7],"\u02c6ab":36,l_orderkei:[31,11,6],neither:7,paramet:[22,36,3,15,16,31,33,5],approach:35,across:[39,6],altern:7,accord:[20,6],parent:14,hadoop_hom:[2,39],snappi:33,stmt:38,outfil:35,disconnect:12,argument:[22,6,15],monitor:29,both:[36,13,5,16,6,18],last:6,delimit:[44,31,36,5],fault:13,region:12,gzipcodec:31,c_comment:35,groupbi:9,against:23,instanc:[24,2,39,23],compressioncodec:[16,5],logic:7,improv:33,whole:8,load:[13,44],simpli:14,point:[16,29],overview:9,format:[9,32,29,5],period:29,split_part:36,header:16,rpc:[29,41,38,39],featur:[16,37,33,5],non:[6,33],littl:39,shutdown:29,toler:13,respect:[20,7],tuesdai:15,guid:12,assum:[17,8,44],transitiontobackup:29,row_num:6,quit:12,xzvf:[38,14,19],strong:35,java:[9,25,37,2,43,21],compos:[17,33],empti:[16,6,5],compon:29,"int":[22,36,33,15,16,17,18,44,20,5],json:5,much:8,besid:5,basic:35,addit:[11,38,6,7,8],c_mktsegment:35,host2:[29,39],derbys
tor:[29,43],o_custkei:12,remaind:22,exercis:23,num2:22,xxx:12,worker:34,search:9,apach:[23,3,43,12],tajojdbccli:38,coordin:22,zero:7,func:6,work1:12,"catch":38,repetit:7,countri:3,due:8,those:[16,33,38,5],emploi:13,bye:44,look:19,packag:[37,38],plain:[16,18],servic:[41,43],properti:[24,25,37,39,3,29,41,43,8],batch:13,rectangular:22,defin:5,"while":38,euler:22,behavior:6,error:31,wild:17,howev:33,lazybinarycolumnarserd:16,textserializerdeseri:[16,18,5],bin:[12,37,2,39,29,43,44,35],layer:24,file:[39,12,43,35],advantag:33,ctrl:[29,39,44],key1:12,tabl:[37,35,44,12,23],site:[29,39,12,43],activ:29,cluster:[34,43],itself:[29,12],warehous:[13,31],textfil:9,conf:[25,24,12,37,2,39,3,29,43,8],theta:22,mod:22,abcdef:36,primit:20,conn:38,tcp:12,"null":[38,6],let:18,"35b":44,grant:43,perform:6,suggest:19,belong:6,classpath:9,hadoop:[38,13,2,39,14,5,16,31,7,25,44,33,21,23,18],sqrt:22,binari:[9,14,43],complex:6,descend:6,largest:22,document:[12,19],dtar:[37,38,14,43],conflict:29,higher:21,week:15,v
arbit:20,lineitem:[31,11,6,12],http:[12,3,29,41,43,19],nio:9,denot:7,optim:13,nest:33,driver:[9,37,43],geoip_in_countri:3,decompress:[33,19],jkl:44,column_nam:31,moment:[33,5],rais:22,dskiptest:[37,38,14,43],user:[24,12,29,43,44,8],tajo_classpath:43,mani:[16,38,8],extern:[31,16,17,35,44],catalogstor:29,col1:[11,7],tsql:35,typic:6,built:[16,38],lower:36,appropri:[25,44],lib:43,mention:16,com:[29,39,3],thu:14,floor:22,well:[31,11,20],parenthes:[6,7],inherit:[16,5],tinyint:20,exampl:[29,39,35],command:35,thi:[9,33,25,37,38,39,14,15,29,6,7,43,19,44,35,5,23,8,18],choos:[14,19],gzip:33,model:[9,45],createdatabaseifnotexist:43,left:6,explan:44,construct:6,protocol:21,execut:[29,39,12,8,23],less:22,when:[11,38,5,29,31,33,6],ordin:22,rest:[6,19],q_1363768615503_0001_000001:44,drivermanag:38,mysql:[37,43],simultan:8,yet:17,languag:[13,9,12,44],inet4:[20,3],web:13,binaryserializerdeseri:[16,18],all_backup:35,easi:[35,28],field:[36,5],disk1:8,disk2:8,disk3:8,except:[38,6,43],param:6,add:[38,25,
37,2,39,29,31,43,8],codec:[16,31,18,5],blob:20,versa:16,pow:22,input:[22,36],expon:22,disrupt:29,modul:[9,25],match:[9,36,20],build:23,real:22,applic:6,varchar:20,which:[12,13,38,16,6,18,43,44,31],serde2:[16,18],preserv:29,untar:19,host1:[29,39],bzip2codec:31,"4028235e":20,workload:8,phcatalog:[37,43],chmod:39,lineitem_100_snappi:31,insert:[9,45,29],bit:20,password:43,desc:6,u0001:5,storage_typ:31,table1:[38,5,16,6,7,44,33,18],resid:44,like:[24,38,17,14],specif:[29,24,11,20],substr:[6,36],should:[24,33,12,37,38,39,3,5,16,17,43,44,31,35,23,8],reoptim:13,manual:16,integ:[22,20,8],server:[29,25,43],query_succeed:44,collect:18,benefit:28,api:9,necessari:13,either:[37,19,6,7,33,20],output:[11,6,18],timetz:20,tajo:35,page:[9,39,33],another_long_table_name_5678:6,geoip:3,right:6,order_d:17,createstat:38,interv:29,"1st":15,some:[9,37,33,5,16,6,25,44,20,14],back:29,tajowork:[29,25,8],sequecnefil:18,intern:25,previou:7,"export":[37,2,43],mirror:19,proper:[24,14,8],home:[37,2,35,43,44],march:1
5,row_numb:6,tmp:[24,44],cnt:6,scale:13,tajo_master_heaps:24,lead:[17,36],channel:9,"512mb":8,avoid:[13,29,31],exec:18,definit:[9,45],best:5,alias_nam:6,tracker:[29,41,39],select:[22,11,36,38,3,15,6,7,44],bigint:[20,31],ddl:[35,44],condit:6,fornam:38,localhost:[12,39,29,41,31,43],radian:22,machin:[12,43],core:[38,8],who:5,run:[29,39,12],power:[22,7],uncompress:[18,33],ab_bc_cd:36,usag:35,pdist:[37,38,14,43],maven:[37,14,43],broken:5,step:14,atan2:22,character_length:36,repositori:19,peer:41,l_extendedpric:6,appli:29,unicod:20,stage:44,comparison:[20,7],actual:9,datanod:8,column:9,varbinari:20,aco:22,total2:6,manag:[9,37,28],degre:[22,39],regular:36,includ:[38,6,8],table_nam:[31,35],approxim:20,disabl:[16,33,5],hive_hom:[37,43],plan:[13,17,5],columnarserd:16,client:[9,12,39,29,41,43],own:5,effici:33,"float":[22,33,5,16,17,18,44,20,8],encod:33,lazybinari:18,automat:29,three:[18,43],down:[7,23],pair:[16,18,25],chang:[38,39,12,43,19],storag:[24,5,16,18,43,33,35],your:[24,25,29,37,38,39,
14,23,16,43,19,33,5,35],jdbc:[9,37,43],wai:[29,35,5],support:[24,35,43],overwrit:[9,45,29],custom:[12,43,35],avail:34,start:[29,39,36],current_databas:12,interfac:5,inner:6,replac:36,unix_timestamp:15,ipv4:[20,3],"function":12,snappycodec:[16,31,18,5],forc:6,ascend:6,compressiontyp:18,tajoxx:36,l_comment:31,int4:[20,11,12,36],link:19,select_stat:31,int2:20,l_shipdat:6,line:[29,39,5],"true":[3,29,18,43,33,20,8,7],int8:[22,20,11,12,35],count:[6,36],"throw":38,columnar:[16,33],consist:[16,6,18,25,5],possibl:[6,8],whether:[16,6,7],ecosystem:33,vice:16,day_of_week:15,record:[16,33,7,18,5],below:[16,35,33,23,5],limit:[9,8],otherwis:[12,6,3,7],problem:29,executequeri:38,defaultport:43,trim:36,binaryserd:18,constant:22,creat:[9,12,39,23,43,44,35],btrim:36,host:[29,38,39,12,43],certain:[16,33,11,5],dure:17,repres:[15,5],"char":20,exist:[31,16,11,12],o_shipprior:12,our:5,doe:[31,33,38,6,5],check:19,fill:38,incorrect:29,tab:5,know:[39,6,44],sort_expr:6,index:9,percent:7,detail:[39,33,6,43,44],
getstr:38,"default":[34,39,12,43],bracket:7,bool:20,o_clerk:12,branch:9,varieti:25,test:[12,43],you:[2,3,5,6,7,15,8,11,12,35,16,17,18,19,23,24,25,29,31,33,14,37,38,39,43,44],node:[29,38,39,8],polar:22,relat:[6,33],database_nam:[31,12],exp:22,customserializerdeseri:5,sequenc:7,briefli:6,insensit:7,tajomast:[34,39,12,43],src:[38,19],empsalari:6,haven:17,algorithm:[16,33,8,5],trail:36,hyunsik:[12,35],regexp:7,descript:[12,29,41,7,43,44,20,8],select_list:6,carriag:5,write:[16,33,18,5],ignor:8,invok:29,time:[13,20,44,7,12],backward:8,cpu:8,unset:12,tajodriv:38},objtypes:{"0":"py:function"},objnames:{"0":["py","function","Python function"]},filenames:["partitioning/hash_partitioning","backup_and_restore","getting_started/local_setup","functions/network_func_and_operators","partitioning/range_partitioning","table_management/csv","sql_language/queries","sql_language/predicates","configuration/worker_configuration","index","functions","sql_language/insert","cli","introduction","getting_start
ed/building","functions/datetime_func_and_operators","table_management/rcfile","partitioning/column_partitioning","table_management/sequencefile","getting_started/downloading_source","sql_language/data_model","getting_started/prerequisites","functions/math_func_and_operators","getting_started","configuration/tajo_master_configuration","configuration/preliminary","table_management/compression","faq","partitioning/intro_to_partitioning","configuration/ha_configuration","table_partitioning","sql_language/ddl","table_management","table_management/parquet","configuration","backup_and_restore/catalog","functions/string_func_and_operators","hcatalog_integration","jdbc_driver","configuration/cluster_setup","table_management/file_formats","configuration/configuration_defaults","tajo_client_api","configuration/catalog_configuration","getting_started/first_query","sql_language","sql_language/sql_expression"],titles:["Hash Partitioning","Backup and Restore","Setting up a local Tajo cluster","Ne
twork Functions and Operators","Range Partitioning","CSV (TextFile)","Queries","Predicates","Worker Configuration","Apache Tajo\u2122 (dev) - User documentation","Functions","INSERT (OVERWRITE) INTO","Tajo Shell (TSQL)","Introduction","Build source code","DateTime Functions and Operators","RCFile","Column Partitioning","SequenceFile","Dowload and unpack the source code of Apache Tajo","Data Model","Prerequisites","Math Functions and Operators","Getting Started","Tajo Master Configuration","Preliminary","Compression","FAQ","Introduction to Partitioning","High Availability for TajoMaster","Table Partitioning","Data Definition Language","Table Management","Parquet","Configuration","Backup and Restore Catalog","String Functions and Operators","HCatalog Integration","Tajo JDBC Driver","Cluster Setup","File Formats","Configuration Defaults","Tajo Client API","Catalog Configuration","First query execution","SQL Language","SQL Expressions"],objects:{"":{trim:[36,0,1,""],upper:[36,0,1,""],bt
rim:[36,0,1,""],regexp_replace:[36,0,1,""],cbrt:[22,0,1,""],split_part:[36,0,1,""],sign:[22,0,1,""],geoip_country_code:[3,0,1,""],tan:[22,0,1,""],asin:[22,0,1,""],floor:[22,0,1,""],sqrt:[22,0,1,""],acos:[22,0,1,""],char_length:[36,0,1,""],abs:[22,0,1,""],degrees:[22,0,1,""],pow:[22,0,1,""],pi:[22,0,1,""],sin:[22,0,1,""],ltrim:[36,0,1,""],atan:[22,0,1,""],cos:[22,0,1,""],ceil:[22,0,1,""],rtrim:[36,0,1,""],utc_usec_to:[15,0,1,""],geoip_in_country:[3,0,1,""],mod:[22,0,1,""],lower:[36,0,1,""],radians:[22,0,1,""],atan2:[22,0,1,""],exp:[22,0,1,""],div:[22,0,1,""],round:[22,0,1,""]}},titleterms:{code:[38,14,19],execut:44,queri:[6,44],session:12,permiss:39,hcatalogstor:43,ilik:7,languag:[45,31],xml:25,how:[16,33,38,17,5],writer:18,apach:[9,19,5,16,17,33],window:6,local:2,match:7,real:20,sourc:[38,14,19],synopsi:12,string:[7,46,36],format:40,handl:5,faq:[27,38],insert:11,introduct:[13,28],mysqlstor:43,document:9,like:7,administr:29,level:35,drop:31,hive:[16,33,17,5],integr:37,partit:[0,30,17
,28,4],each:8,fulli:39,where:6,manag:32,set:[29,2,38,39],hcatalog:37,dump:35,dowload:19,meta:12,run:8,todo:[0,26,27,4,42,35],distribut:[38,39],variabl:12,network:3,cast:46,databas:[31,35],preliminari:25,definit:31,state:29,directori:[39,8],method:28,math:22,mode:[39,8],qualifi:6,hash:0,driver:38,gener:16,usag:12,serializerdeseri:18,base:39,prerequisit:[21,3],releas:19,from:[38,6],rcfile:16,valu:[20,5],launch:[29,39],via:19,tajo:[9,24,38,12,29,2,39,16,41,42,25,19],groupbi:6,datetim:15,backup:[29,1,35],first:44,oper:[22,36,3,15],rang:4,configur:[24,29,41,43,34,8],overview:6,tajomast:[29,24],number:[20,8],terminolog:29,api:42,size:[24,8],git:19,java:38,memori:[24,8],tsql:12,support:3,doubl:20,overwrit:11,custom:5,avail:29,start:23,call:46,basic:12,master:[29,24,41],type:[20,6,46],"function":[22,10,36,3,15,6,46],shell:12,claus:6,worker:[41,39,8],rootdir:24,heap:[24,8],jdbc:38,unpack:19,join:6,prune:17,restor:[1,35],"default":41,setup:39,properti:[16,33,5],maximum:8,dev:9,orderbi:6,colum
n:17,serd:18,limit:6,introduc:18,parquet:33,similar:7,file:[29,40],creat:[31,16,33,17,5],site:25,indic:9,high:29,cluster:[29,2,39],unresolvedaddressexcept:38,textfil:5,have:6,tabl:[9,5,16,30,17,32,33,31,6],dedic:8,"null":5,serial:[16,5],issu:[16,33,17,5],make:39,get:[38,23,19],when:16,cross:6,binari:38,exampl:[38,6,8],build:[38,14],env:25,csv:5,channel:38,compat:[16,33,17,5],express:[7,46],resourc:8,nio:38,classpath:38,enter:12,compress:[26,31],catalog:[25,35,43],regular:7,temporari:8,user:9,sql:[45,35,46],data:[20,31,8],parallel:8,physic:[16,33,5],task:8,read:16,predic:7,arithmet:46,alias:6,client:[38,42],command:12,pattern:7,model:20,sequencefil:18,mariadbstor:43,latest:19}})
\ No newline at end of file
+Search.setIndex({envversion:42,terms:{represent:[33,15],all:[38,12,37,2,39,3,29,6,7,43,44,35],code:[3,43,23],dist:[38,14,43],c_name:35,rdbm:38,queri:[29,43,12,8,23],consum:33,concern:[35,25],month:15,four:40,scalar:[6,33],concept:38,per:[29,39,12,8],boolean_express:6,mno:44,follow:[3,5,6,7,8,11,12,35,16,17,18,19,20,24,25,28,29,31,33,14,37,38,39,40,43,44],disk:[3,8],row:[12,33,5,16,6,7,43,44,18],content:[9,2,31,43],privat:38,depend:[37,38,7],c_acctbal:35,zone:20,getconnect:38,decim:20,init:44,hadmin:29,present:23,sql_languag:12,backup_and_restor:12,"case":[25,36,38,16,7,43,18],digit:20,sourc:[12,43,23],everi:[29,6],string:[10,3,25,15],fals:[20,33,3,7],"void":38,csvfile:[44,31,5],volum:[12,44],failur:29,veri:[2,39,7],affect:[43,8],implicitli:6,hdfs_locat:16,exact:20,dbname:12,tri:38,recordcompresswrit:18,implementaion:24,list:[12,44,39,29,17,7,19,6],hive:[9,37,43],"try":[29,38,12],item:7,adjust:[16,24,33,8,5],form:[16,24,6],cosin:22,vertic:5,dealt:6,println:38,div:22,tajo_src:14,locat
:[38,11,2,3,16,31,43,44,35,8],tajo_hom:[25,38,12,2,39,29,43,44],dir:[39,11,8],pleas:[38,2,39,3,5,16,6,44,33,35,8],prevent:29,templet:25,smaller:11,abil:29,ten:[37,23],natur:6,sign:[22,7],enjoi:44,dowload:23,second:[29,36,43],cost:13,design:[13,17,25,33],aggreg:6,pass:6,val3:12,val2:[7,12],val1:[7,12],durat:43,port:[24,12,38,39,29,43],tmpdir:8,integr:43,compat:[9,43,8],asin:22,abc:[7,44],addr:[3,43],compar:20,cast:9,section:[37,38,39,5,16,23,8],xtajoxx:36,calcul:6,current:[24,12,37,38,28,40,29,6,7,43,33,8],c_phone:35,"19th":15,version:[12,43,14],directori:43,supplier:12,"new":[29,12],fall:6,method:[9,35],metadata:16,ongo:29,elimin:[31,6],full:6,hash:9,deriv:6,gener:[29,12,5],never:29,o_totalpric:12,here:[2,7,44,18],tangent:22,address:[39,3,29,41,43,20],path:[24,12,37,38,3,31,43,44,35],o_orderprior:12,sine:22,sinc:[16,43],valu:[22,25,24,12,37,39,3,29,43,8],wait:29,convert:[22,29,3,46],aaabc:7,deterior:33,convers:22,standalon:23,shift:15,larger:[20,6,33],table_backup:35,precis:20,datet
im:10,behav:6,codebas:19,implement:[9,2,12],ghi:44,commonli:5,sequencefil:[9,40,16],dayofweek:15,via:[29,39,23],regardless:[16,33],data_typ:31,cbrt:22,transit:29,filenam:12,unix:15,"boolean":[20,6,3,33],namenode_hostnam:24,wip:[43,19],instal:[3,43,14],total:[6,8],unit:[43,33],highli:14,from:[22,9,36,44,15,29,19,35],describ:[37,12],would:[37,14],memori:43,distinct:6,two:[2,28,16,7,25,35,46,18],next:[37,38],connector:[37,43],few:25,program:[25,33],call:[9,6],usr:43,recommend:14,type:[22,9,12,3,15,25,44,35,8,36],until:12,tajo_pid_dir:29,more:[37,33,39,6,7,43,44,23,8],sort:6,flat:[16,18,33],discompress:14,l_quantiti:[11,6],hiveql:37,claus:[9,44,17,7,20],mismatch:9,tbname:12,function_nam:46,rootdir:39,name2:12,name3:12,name1:12,known:17,postgresql:7,editor:[29,39],unpack:23,must:[24,38,29,6,43,33,20],tabular:5,word:[16,8,5],hour:15,formatha:29,alia:[20,6,36,15],setup:34,work:[20,12,33],uniqu:12,dev:3,cat:[29,39,35,44],orderbi:9,archiv:[14,43],can:[9,38,12,25,29,37,2,39,44,5,16,6,7,43,19,
31,17,33,14,8,18],learn:2,purpos:[37,25],root:[22,39],def:44,bewtween:20,control:29,nearest:22,prompt:12,num1:22,tar:[38,14,43,19],give:[31,6,8],process:[12,13,5,16,17,33],share:[16,38,6],backslash:12,indic:12,high:34,liter:[25,5],want:[25,24,38,11,12,37,2,39,29,17,18,43,44,31,35,8],tarbal:29,tan:22,occur:[31,16,6,15],timestamptz:20,unresolvedaddressexcept:9,sundai:15,end:[36,19],goal:13,quot:12,haadmin:29,str1:36,hdf:[24,12,13,38,39,31,44,23,8],divis:22,how:[9,37,2,39,23,8],purg:31,consist:[16,6,18,25,5],env:[29,43],c_address:35,main:[13,38,7,25],instead:[12,44,7,43,5],csv:[9,44,31,12,35],config:[25,12,37,38,39,41,43,8],sin:22,blockcompresswrit:18,updat:29,transitiontoact:29,product:6,resourc:[29,41,39],ltrim:36,atan:22,clone:[43,19],after:[6,14],resultset:38,concatnen:36,befor:[29,6,39],catalog:1,mai:[25,2,15,29,6,43,14],multipl:[29,6,8,5],underscor:7,mariadb:43,data:[39,43],parallel:39,physic:39,tajo_worker_heaps:8,github:19,essenti:29,third:[43,15],read:[33,19,39,5],divid:[22,6]
,favorit:[29,39],correspond:[16,6],element:[29,25],issu:9,inform:[29,12,43],preced:3,environ:[25,24,2,37,8],block:[18,33],allow:[24,37,33,39,5,16,31,44,6,8],anoth:[29,46],worst:13,order:[38,12,13,37,2,39,5,16,6,43,20,17,33,8,44],oper:[29,10,43],help:12,shorten:43,over:6,move:14,midnight:15,becaus:[29,6,5],comma:[6,5],same:[22,37,3,15,29,6,7],still:29,vari:20,dynam:13,entiti:29,smallint:20,mapr:18,style:7,outer:6,cli:12,window:9,html:12,persist:[2,43],therefor:29,split:36,them:6,within:6,"return":[22,36,3,15,7,5],greater:22,thei:[16,7,29],handl:38,timestamp:[20,15],"1gb":[24,8],col2:[11,7],col3:11,initi:29,nation:12,framework:33,lzo:33,abscissa:22,item_nam:17,now:[12,14,16,33,5,35],utc_usec_to:15,nor:7,introduct:9,choic:33,subqueri:6,hive_jdbc_driver_dir:[37,43],name:[25,24,12,29,37,38,39,3,5,16,41,6,18,43,44,20,33,35,8],anyth:12,simpl:[2,44],drop:9,regexp_replac:36,o_orderd:12,lazybinaryserd:18,separ:[6,18,5],easili:[29,38,39],submit:[29,23,44],mode:43,each:[39,12,25],clsspath:38,co
mplet:29,compatibl:35,side:[38,36],truncat:22,mean:7,compil:[37,14,43],failov:29,domain:[29,39,7,5],map:20,unequ:29,individu:6,saturdai:15,procedur:14,group:[6,7,33],resut:22,"static":38,connect:[37,38,12,43],year:[6,15],recogn:5,special:5,out:[38,8,19],unquot:12,network:10,space:36,develop:[9,19],o_orderkei:12,xxtajo:36,profil:[37,43],hivemetastor:[37,43],math:10,statist:29,shut:23,parquet:[9,40],advanc:[13,6],lastli:43,manipul:12,given:[11,12,44,3,31,7,20,6,36],free:44,standard:[13,20,7,44],asc:6,small:[20,33],base:43,asf:[43,19],dictionari:33,usual:[25,5],org:[12,37,38,5,16,31,18,43,19],"byte":[20,33,12,44],fridai:15,refer:[38,2,39,3,5,16,6,18,44,33],card:17,care:5,str2:36,val:12,launch:43,angl:22,could:15,omit:[16,6],retriv:38,round:22,filter:[6,7],length:20,rcfile:[9,40],standbi:29,umbil:[29,41,39],interact:[13,12,44],mvn:[37,38,14,43],first:[36,23,25,15,14,43],feed:5,rang:[9,28],directli:[17,5],resourceconfigur:8,feel:44,onc:[6,3,19],arrai:7,independ:33,applciat:38,number:[39,
12],system:[38,25,29,13,2,39,16,43,14,8],o_com:12,instruct:[37,3,19],set:[12,43],done:14,unhealthi:29,tpch:[12,35],open:13,primari:[29,24],differ:[6,7],"long":[13,6,15],script:[14,25],licens:12,mkdir:[39,44],capac:[39,8],least:[6,7],getstat:29,master:[34,39,12,43],too:33,statement:[11,12,38,5,16,6,7,44,31,33,18],l_partkei:[31,11,6],scheme:[24,44],boot:[2,43],"final":[37,38,43,44],store:[12,13,37,2,5,16,18,43,44,8],schema:[17,33,11,12,44],mysql_jdbc_driv:[37,43],option:[12,14,31,6,15,35],especi:20,namespac:38,copi:[25,43],inexact:20,grouping_column_refer:6,hurt:13,"short":[16,6],enclos:6,mostli:16,rtrim:36,jdbc:[9,37,43],exactli:7,geoip_country_cod:3,serv:29,kind:6,target:[22,11,38,29,43,14],keyword:[6,18],provid:[38,12,29,13,2,3,28,5,16,7,43,44,33,40,8,18],expr:6,remov:[2,31,36,43],tree:14,long_table_name_1234:6,charact:[36,5,16,17,7,20],project:[13,33],serd:[16,5],num:[6,12],posix:7,balanc:13,becom:29,entri:[29,31,39],sec:[43,44],minut:[37,23],listen:[38,39],comput:6,abov:[16,18,44
],textserd:18,ran:43,respons:[13,44],ani:[38,5,29,6,7,43,33],download:[3,19],manner:38,have:[9,24,37,31,43,19],further:5,need:[38,29,37,2,5,16,18,43,44,33,35],maxmind:3,"import":38,predic:[9,17,45],tajocli:29,date:[20,35],squar:22,equival:[11,6],partsupp:12,click:19,note:[7,43],also:[12,44,5,29,17,7,43,19,6,18],without:[13,17,6,43,5],take:[37,6,23,19],xxxxxx:43,techniqu:13,combin:6,subject:6,prepar:[37,14,43,44],singl:[29,39,7,33],even:29,begin:[12,15],c_nationkei:35,distribut:43,preliminari:34,usernam:[2,43],price:17,filesystem:[23,19],compress:9,deflatecodec:31,most:[43,5],microsecond:15,specifi:[24,11,12,37,38,3,5,16,46,6,7,43,33,20,14,8,18],arithmet:[9,6],phase:17,metacharact:7,"class":[37,38,5,16,7,43,18],dai:15,appear:6,other:[11,13,5,16,6,25,8],don:[38,35,25,14],url:[24,38],doc:12,later:23,request:8,uri:[29,43],quantiti:6,salari:6,part:12,snapshot:[14,43],classnotfoundexcept:38,determin:[6,8],pattern:[9,36],querymast:8,axi:22,sum:6,think:44,show:[38,12,44,23],text:[12,36,29,4
4,39,3,15,16,17,7,20,31,33,5,35,18],hostnam:[24,38,39,12,43],syntax:[6,46],column_refer:7,l_discount:6,identifi:[6,43],ship_dat:17,find:29,xml:[29,39,12,43],absolut:[22,43,44],onli:[24,25,2,28,15,16,6,18,43,19,33,5],explicitli:[6,25],ratio:8,just:[12,29,6,7,43,35],copyright:12,explain:[2,38,39,5,16,6,23],configur:12,jar:[37,38,43],enough:43,than:[22,11,37,6,7,23],smallest:[22,33],central:29,templat:43,search_condit:6,local:[23,43,3,8,19],info:[29,41],cube:22,variou:12,get:43,familiar:[16,33,5],express:[9,36,45],stop:29,ceil:22,repo:[43,19],cannot:5,java_hom:2,progress:13,increas:39,requir:[2,6,15],prune:9,table_refer:6,bar:5,enabl:[29,38,39,5,16,43,33],termin:5,upper:36,borrow:7,"public":38,remot:39,common:6,partit:9,contain:[29,38,31,39],clean:[37,38,14,43],where:[9,2,39,17,7,43,44,20,8],bytea:20,dhadoop:14,legaci:3,frame:6,knowledg:5,startup:12,memstor:43,c_custkei:35,see:[2,39,43,8,44],arc:22,float8:[22,20,11,12,35],result:[9,38,29,6,33,44],arg:38,float4:20,close:38,rlike:7,unqua
lifi:[17,6],o_orderstatu:12,valn:7,awar:8,statu:29,kei:[12,28,16,31,18,17],correctli:[20,14],ieee:20,char_length:36,written:[16,18],score:[16,33,44,18,5],subdir:11,between:[38,7],"\u02c6ab":36,l_orderkei:[31,11,6],neither:7,paramet:[22,36,3,15,16,31,33,5],approach:35,across:[39,6],altern:7,accord:[20,6],parent:14,hadoop_hom:[2,39],snappi:33,stmt:38,outfil:35,disconnect:12,argument:[22,6,15],embed:43,monitor:29,both:[36,13,5,16,6,18],last:6,delimit:[44,31,36,5],fault:13,region:12,gzipcodec:31,c_comment:35,groupbi:9,against:23,instanc:[24,2,39,23],compressioncodec:[16,5],logic:7,improv:33,whole:8,load:[13,44],simpli:14,point:[16,29],overview:9,format:[9,32,29,5],period:29,split_part:36,header:16,rpc:[29,41,38,39],featur:[16,37,33,5],non:[6,33],littl:39,shutdown:29,toler:13,respect:[20,7],tuesdai:15,guid:12,assum:[17,8,44],transitiontobackup:29,row_num:6,quit:12,xzvf:[38,14,19],strong:35,java:[9,25,37,2,43,21],compos:[17,33],empti:[16,6,5],compon:29,"int":[22,36,33,15,16,17,18,44,20,5]
,json:5,much:8,besid:5,basic:35,addit:[11,38,6,7,8],c_mktsegment:35,host2:[29,39],derbystor:[29,43],o_custkei:12,remaind:22,exercis:23,num2:22,xxx:12,worker:34,search:9,apach:[23,3,43,12],tajojdbccli:38,coordin:22,zero:7,func:6,work1:12,"catch":38,repetit:7,countri:3,due:8,those:[16,33,38,5],emploi:13,bye:44,look:19,packag:[37,38],plain:[16,18],servic:[41,43],properti:[24,25,37,39,3,29,41,43,8],batch:13,rectangular:22,defin:5,"while":38,euler:22,behavior:6,error:31,wild:17,howev:33,lazybinarycolumnarserd:16,textserializerdeseri:[16,18,5],bin:[12,37,2,39,29,43,44,35],layer:24,file:[39,12,43,35],advantag:33,ctrl:[29,39,44],key1:12,tabl:[12,37,2,23,43,44,35],site:[29,39,12,43],activ:29,cluster:[34,43],itself:[29,12],warehous:[13,31],textfil:9,conf:[25,24,12,37,2,39,3,29,43,8],theta:22,mod:22,abcdef:36,primit:20,conn:38,tcp:12,"null":[38,6],let:18,"35b":44,cartesian:6,grant:43,perform:6,suggest:19,belong:6,classpath:9,hadoop:[38,13,2,39,14,5,16,31,7,25,44,33,21,23,18],sqrt:22,binari:[9,
14,43],complex:6,descend:6,largest:22,document:[12,19],dtar:[37,38,14,43],conflict:29,higher:21,week:15,varbit:20,lineitem:[31,11,6,12],http:[12,3,29,41,43,19],nio:9,optim:13,nest:33,driver:[9,37,43],geoip_in_countri:3,decompress:[33,19],jkl:44,column_nam:31,moment:[33,5],rais:22,dskiptest:[37,38,14,43],user:[24,12,29,43,44,8],tajo_classpath:43,mani:[16,38,8],extern:[31,16,17,35,44],catalogstor:29,col1:[11,7],tsql:35,typic:6,built:[16,38],lower:36,appropri:[25,44],lib:43,mention:16,com:[29,39,3],thu:14,floor:22,well:[31,11,20],parenthes:[6,7],inherit:[16,5],tinyint:20,exampl:[29,39,35,43],command:35,thi:[9,33,25,37,38,39,14,15,29,6,7,43,19,44,35,5,23,8,18],choos:[14,19],gzip:33,model:[9,45],createdatabaseifnotexist:43,left:6,explan:44,construct:6,protocol:21,execut:[29,39,12,8,23],less:22,when:[38,11,2,5,29,6,43,33,31],ordin:22,rest:[6,19],q_1363768615503_0001_000001:44,drivermanag:38,mysql:[37,43],simultan:8,yet:17,languag:[13,9,12,44],inet4:[20,3],web:13,binaryserializerdeseri:[16
,18],all_backup:35,easi:[35,28],field:[36,5],disk1:8,disk2:8,disk3:8,except:[38,6,43],param:6,add:[38,25,37,2,39,29,31,43,8],codec:[16,31,18,5],blob:20,versa:16,pow:22,input:[22,36],expon:22,disrupt:29,modul:[9,25],match:[9,36,20],build:23,real:22,applic:6,varchar:20,which:[38,12,13,2,16,6,18,43,44,31],serde2:[16,18],preserv:29,untar:19,host1:[29,39],bzip2codec:31,"4028235e":20,workload:8,phcatalog:[37,43],chmod:39,lineitem_100_snappi:31,insert:[9,45,29],bit:20,password:43,desc:6,u0001:5,storage_typ:31,table1:[38,5,16,6,7,44,33,18],resid:44,like:[24,38,17,14],specif:[29,24,11,20],substr:[6,36],should:[24,33,12,37,38,39,3,5,16,17,43,44,31,35,23,8],reoptim:13,manual:[16,43],integ:[22,20,8],server:[29,2,25,43],query_succeed:44,collect:18,benefit:28,api:9,necessari:13,either:[37,19,6,7,33,20],output:[11,6,18],timetz:20,tajo:35,page:[9,39,33],another_long_table_name_5678:6,geoip:3,right:6,order_d:17,createstat:38,interv:29,"1st":15,some:[9,25,37,2,5,16,6,43,44,20,33,14],back:29,tajowork:
[29,25,8],sequecnefil:18,intern:25,previou:7,"export":[37,2,43],mirror:19,proper:[24,2,43,8,14],home:[37,2,35,43,44],march:15,row_numb:6,tmp:[24,2,43,44],cnt:6,scale:13,tajo_master_heaps:24,lead:[17,36],channel:9,"512mb":8,avoid:[13,29,31],exec:18,definit:[9,45],best:5,buffer:[21,33],alias_nam:6,tracker:[29,41,39],access:[37,38,39,33],select:[22,11,36,38,3,15,6,7,44],bigint:[20,31],ddl:[35,44],condit:6,fornam:38,localhost:[12,39,29,41,31,43],radian:22,machin:[12,43],core:[38,8],who:5,run:[29,39,12],power:[22,7],uncompress:[18,33],ab_bc_cd:36,usag:35,pdist:[37,38,14,43],maven:[37,14,43],broken:5,step:14,atan2:22,character_length:36,repositori:19,peer:41,l_extendedpric:6,appli:29,unicod:20,stage:44,comparison:[20,7],actual:9,datanod:8,column:9,varbinari:20,aco:22,total2:6,manag:[9,37,2,28,43],degre:[22,39],regular:36,includ:[38,6,8],table_nam:[31,35],approxim:20,disabl:[16,33,5],hive_hom:[37,43],plan:[13,17,5],columnarserd:16,client:[9,12,39,29,41,43],own:5,effici:33,"float":[22,33,5,
16,17,18,44,20,8],encod:33,lazybinari:18,automat:29,three:[18,43],down:[7,23],pair:[16,18,25],ensur:[2,43],chang:[38,39,12,43,19],storag:[24,2,5,16,18,43,33,35],your:[24,38,25,29,37,2,39,14,23,16,43,19,33,5,35],git:43,wai:[29,35,5],support:[24,35,43],overwrit:[9,45,29],custom:[12,43,35],avail:34,start:[29,39,36],current_databas:12,interfac:5,inner:6,replac:36,"var":43,unix_timestamp:15,ipv4:[20,3],"function":12,snappycodec:[16,31,18,5],forc:6,ascend:6,compressiontyp:18,tajoxx:36,l_comment:31,int4:[20,11,12,36],link:19,select_stat:31,int2:20,l_shipdat:6,line:[29,39,5],"true":[3,29,18,43,33,20,8,7],int8:[22,20,11,12,35],count:[6,36],"throw":38,columnar:[16,33],tab:5,possibl:[6,8],whether:[16,6,7],ecosystem:33,vice:16,day_of_week:15,record:[16,33,7,18,5],below:[16,35,33,23,5],limit:[9,8],otherwis:[12,6,3,7],problem:29,executequeri:38,defaultport:43,trim:36,binaryserd:18,constant:22,creat:[9,12,39,23,43,44,35],btrim:36,host:[29,38,39,12,43],certain:[16,33,11,5],dure:17,repres:[15,5],"ch
ar":20,exist:[31,16,11,12],o_shipprior:12,our:5,doe:[31,33,38,6,5],check:19,fill:38,incorrect:29,denot:7,know:[39,6,44],sort_expr:6,index:9,percent:7,detail:[39,33,6,43,44],getstr:38,"default":[34,39,12,43],bracket:7,bool:20,o_clerk:12,branch:9,varieti:25,test:[12,43],you:[2,3,5,6,7,15,8,11,12,35,16,17,18,19,23,24,25,29,31,33,14,37,38,39,43,44],node:[29,38,39,8],polar:22,relat:[6,33],database_nam:[31,12],exp:22,customserializerdeseri:5,sequenc:7,briefli:6,insensit:7,tajomast:[34,39,12,43],src:[38,19],empsalari:6,haven:17,algorithm:[16,33,8,5],trail:36,hyunsik:[12,35],regexp:7,descript:[12,29,41,7,43,44,20,8],select_list:6,carriag:5,write:[16,33,18,5],ignor:8,invok:29,time:[13,20,44,7,12],backward:8,cpu:8,unset:12,tajodriv:38},objtypes:{"0":"py:function"},objnames:{"0":["py","function","Python function"]},filenames:["partitioning/hash_partitioning","backup_and_restore","getting_started/local_setup","functions/network_func_and_operators","partitioning/range_partitioning","table_manage
ment/csv","sql_language/queries","sql_language/predicates","configuration/worker_configuration","index","functions","sql_language/insert","cli","introduction","getting_started/building","functions/datetime_func_and_operators","table_management/rcfile","partitioning/column_partitioning","table_management/sequencefile","getting_started/downloading_source","sql_language/data_model","getting_started/prerequisites","functions/math_func_and_operators","getting_started","configuration/tajo_master_configuration","configuration/preliminary","table_management/compression","faq","partitioning/intro_to_partitioning","configuration/ha_configuration","table_partitioning","sql_language/ddl","table_management","table_management/parquet","configuration","backup_and_restore/catalog","functions/string_func_and_operators","hcatalog_integration","jdbc_driver","configuration/cluster_setup","table_management/file_formats","configuration/configuration_defaults","tajo_client_api","configuration/catalog_conf
iguration","getting_started/first_query","sql_language","sql_language/sql_expression"],titles:["Hash Partitioning","Backup and Restore","Setting up a local Tajo cluster","Network Functions and Operators","Range Partitioning","CSV (TextFile)","Queries","Predicates","Worker Configuration","Apache Tajo\u2122 (dev) - User documentation","Functions","INSERT (OVERWRITE) INTO","Tajo Shell (TSQL)","Introduction","Build source code","DateTime Functions and Operators","RCFile","Column Partitioning","SequenceFile","Dowload and unpack the source code of Apache Tajo","Data Model","Prerequisites","Math Functions and Operators","Getting Started","Tajo Master Configuration","Preliminary","Compression","FAQ","Introduction to Partitioning","High Availability for TajoMaster","Table Partitioning","Data Definition Language","Table Management","Parquet","Configuration","Backup and Restore Catalog","String Functions and Operators","HCatalog Integration","Tajo JDBC Driver","Cluster Setup","File Formats","C
onfiguration Defaults","Tajo Client API","Catalog Configuration","First query execution","SQL Language","SQL Expressions"],objects:{"":{trim:[36,0,1,""],upper:[36,0,1,""],btrim:[36,0,1,""],regexp_replace:[36,0,1,""],cbrt:[22,0,1,""],split_part:[36,0,1,""],sign:[22,0,1,""],geoip_country_code:[3,0,1,""],tan:[22,0,1,""],asin:[22,0,1,""],floor:[22,0,1,""],sqrt:[22,0,1,""],acos:[22,0,1,""],char_length:[36,0,1,""],abs:[22,0,1,""],degrees:[22,0,1,""],pow:[22,0,1,""],pi:[22,0,1,""],sin:[22,0,1,""],ltrim:[36,0,1,""],atan:[22,0,1,""],cos:[22,0,1,""],ceil:[22,0,1,""],rtrim:[36,0,1,""],utc_usec_to:[15,0,1,""],geoip_in_country:[3,0,1,""],mod:[22,0,1,""],lower:[36,0,1,""],radians:[22,0,1,""],atan2:[22,0,1,""],exp:[22,0,1,""],div:[22,0,1,""],round:[22,0,1,""]}},titleterms:{code:[38,14,19],execut:44,queri:[6,44],session:12,permiss:39,hcatalogstor:43,ilik:7,languag:[45,31],xml:25,how:[16,33,38,17,5],writer:18,apach:[9,19,5,16,17,33],window:6,local:2,match:7,real:20,sourc:[38,14,19],synopsi:12,string
:[7,46,36],format:40,handl:5,faq:[27,38],insert:11,introduct:[13,28],mysqlstor:43,document:9,like:7,administr:29,level:35,drop:31,hive:[16,33,17,5],integr:37,partit:[0,30,17,28,4],each:8,fulli:39,where:6,manag:32,set:[29,2,38,39],hcatalog:37,dump:35,dowload:19,meta:12,run:8,todo:[0,26,27,4,42,35],distribut:[38,39],variabl:12,network:3,cast:46,databas:[31,35],preliminari:25,definit:31,state:29,directori:[39,8],method:28,math:22,mode:[39,8],qualifi:6,hash:0,driver:38,gener:16,usag:12,serializerdeseri:18,base:39,prerequisit:[21,3],releas:19,from:[38,6],rcfile:16,valu:[20,5],launch:[29,39],via:19,tajo:[9,24,38,12,29,2,39,16,41,42,25,19],groupbi:6,datetim:15,backup:[29,1,35],first:44,oper:[22,36,3,15],rang:4,configur:[24,29,41,43,34,8],overview:6,tajomast:[29,24],number:[20,8],terminolog:29,api:42,size:[24,8],git:19,java:38,memori:[24,8],tsql:12,support:3,doubl:20,overwrit:11,custom:5,avail:29,start:23,call:46,basic:12,master:[29,24,41],type:[20,6,46],"function":[22,10,36,3,15,6,46],shel
l:12,claus:6,worker:[41,39,8],rootdir:24,heap:[24,8],jdbc:38,unpack:19,join:6,prune:17,restor:[1,35],"default":41,setup:39,properti:[16,33,5],maximum:8,dev:9,orderbi:6,column:17,serd:18,limit:6,introduc:18,parquet:33,similar:7,file:[29,40],creat:[31,16,33,17,5],site:25,indic:9,high:29,cluster:[29,2,39],unresolvedaddressexcept:38,textfil:5,have:6,tabl:[9,5,16,30,17,32,33,31,6],dedic:8,"null":5,serial:[16,5],issu:[16,33,17,5],make:39,get:[38,23,19],when:16,cross:6,binari:38,exampl:[38,6,8],build:[38,14],env:25,csv:5,channel:38,compat:[16,33,17,5],express:[7,46],resourc:8,nio:38,classpath:38,enter:12,compress:[26,31],catalog:[25,35,43],regular:7,temporari:8,user:9,sql:[45,35,46],data:[20,31,8],parallel:8,physic:[16,33,5],derbi:43,task:8,read:16,predic:7,arithmet:46,alias:6,client:[38,42],command:12,pattern:7,model:20,sequencefil:18,mariadbstor:43,latest:19}})
\ No newline at end of file