svn commit: r1703095 - in /tajo/site/docs/devel: _sources/sql_language/sql_expression.txt index.html searchindex.js sql_language/sql_expression.html

[ji...@apache.org]

Author: jihoonson
Date: Tue Sep 15 04:42:36 2015
New Revision: 1703095

URL: http://svn.apache.org/r1703095
Log:
add window function document

Modified:
    tajo/site/docs/devel/_sources/sql_language/sql_expression.txt
    tajo/site/docs/devel/index.html
    tajo/site/docs/devel/searchindex.js
    tajo/site/docs/devel/sql_language/sql_expression.html

Modified: tajo/site/docs/devel/_sources/sql_language/sql_expression.txt
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/_sources/sql_language/sql_expression.txt?rev=1703095&r1=1703094&r2=1703095&view=diff
==============================================================================
--- tajo/site/docs/devel/_sources/sql_language/sql_expression.txt (original)
+++ tajo/site/docs/devel/_sources/sql_language/sql_expression.txt Tue Sep 15 04:42:36 2015
@@ -16,10 +16,10 @@ A type cast converts a specified-typed d
   CAST ( expression AS type )
   expression::type
 
-In addition, several functions are provided for type conversion. Please refer to `:doc:data_type_func_and_operators` and `:doc:datetime_func_and_operators`.
+In addition, several functions are provided for type conversion. Please refer to :doc:`../functions/data_type_func_and_operators` and :doc:`../functions/datetime_func_and_operators`.
 
 -------------------------
-String Constants
+String Literals
 -------------------------
 
 A string constant is an arbitrary sequence of characters bounded by single quotes (``'``):
@@ -29,7 +29,7 @@ A string constant is an arbitrary sequen
   'tajo'
 
 -------------------------
-Function Call
+Function Calls
 -------------------------
 
 The syntax for a function call consists of the name of a function and its argument list enclosed in parentheses:
@@ -38,4 +38,38 @@ The syntax for a function call consists
 
   function_name ([expression [, expression ... ]] )
 
-For more information about functions, please refer to `:doc:functions`.
\ No newline at end of file
+For more information about functions, please refer to :doc:`../functions`.
+
+-------------------------
+Window Function Calls
+-------------------------
+
+A window function call performs aggregate operation across the ``window`` which is a set of rows that are related to the current row. An window function has the following syntax. 
+
+.. code-block:: sql
+
+  function_name OVER ( window_definition )
+
+where *function_name* is the name of aggregation function. Any aggregation function or window function can be used. For built-in aggregation functions and window functions, please refer to :doc:`../functions/agg_func` and :doc:`../functions/window_func`.
+
+*window_definition* has the following syntax.
+
+.. code-block:: sql
+
+  [ PARTITION BY expression [, ...] ]
+  [ ORDER BY expression [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] ]
+
+In the above syntax, *expression* can be any expression except window function call itself.
+*PARTITION BY* and *ORDER BY* lists have the same syntax and semantics as *GROUP BY* and *ORDER BY* clauses.
+That is, *PARTITION BY* list describes how the output result will be partitioned like *GROUP BY* clause creates multiple partitions according to the value of its expression.
+With *ORDER BY* list, result values are sorted in each partition.
+
+Here are some examples.
+
+.. code-block:: sql
+
+  select l_orderkey, count(*) as cnt, row_number() over (order by count(*) desc) row_num from lineitem group by l_orderkey order by l_orderkey;
+
+  select o_custkey, o_orderstatus, sum(o_totalprice) over (partition by o_custkey) as price from orders;
+
+  select l_linenumber, l_tax, sum(l_quantity) over (partition by l_linenumber order by l_tax desc) as quantity, avg(l_extendedprice) over (partition by l_shipdate) from lineitem order by l_tax;
\ No newline at end of file

Modified: tajo/site/docs/devel/index.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/index.html?rev=1703095&r1=1703094&r2=1703095&view=diff
==============================================================================
--- tajo/site/docs/devel/index.html (original)
+++ tajo/site/docs/devel/index.html Tue Sep 15 04:42:36 2015
@@ -341,8 +341,9 @@ As a result, some contents can be mismat
 <li class="toctree-l2"><a class="reference internal" href="sql_language/sql_expression.html">SQL Expressions</a><ul>
 <li class="toctree-l3"><a class="reference internal" href="sql_language/sql_expression.html#arithmetic-expressions">Arithmetic Expressions</a></li>
 <li class="toctree-l3"><a class="reference internal" href="sql_language/sql_expression.html#type-casts">Type Casts</a></li>
-<li class="toctree-l3"><a class="reference internal" href="sql_language/sql_expression.html#string-constants">String Constants</a></li>
-<li class="toctree-l3"><a class="reference internal" href="sql_language/sql_expression.html#function-call">Function Call</a></li>
+<li class="toctree-l3"><a class="reference internal" href="sql_language/sql_expression.html#string-literals">String Literals</a></li>
+<li class="toctree-l3"><a class="reference internal" href="sql_language/sql_expression.html#function-calls">Function Calls</a></li>
+<li class="toctree-l3"><a class="reference internal" href="sql_language/sql_expression.html#window-function-calls">Window Function Calls</a></li>
 </ul>
 </li>
 <li class="toctree-l2"><a class="reference internal" href="sql_language/predicates.html">Predicates</a><ul>

Modified: tajo/site/docs/devel/searchindex.js
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/searchindex.js?rev=1703095&r1=1703094&r2=1703095&view=diff
==============================================================================
--- tajo/site/docs/devel/searchindex.js (original)
+++ tajo/site/docs/devel/searchindex.js Tue Sep 15 04:42:36 2015
@@ -1 +1 @@
-Search.setIndex({envversion:42,terms:{c_name:67,four:[58,21],prefix:[13,47,56,21],deviat:50,locaion:56,newli:5,digit:[27,21],everi:[17,33,66,7,40],"void":54,affect:[56,62,12,21],println:54,tajo_src:49,direct:14,batch:59,enjoi:49,second:[18,40,9,21,33,62],even:[40,33,21],asin:31,neg:53,asia:[42,43,56],char_length:18,supplier:10,"new":[5,9,21,40,10,30],metadata:[22,30,43],ongo:40,elimin:[64,9,7],abov:[38,25,2,22,24,9,49],never:[9,40],o_totalpric:10,here:[17,9,21,33,24,47,49,8],path:[32,17,25,53,54,3,9,67,30,5,56,42,62,10,64,49],interpret:21,deterior:45,headerlin:43,anymor:25,precis:[27,21],datetim:[15,66],pack:36,sequencefil:[14,58,22],q_1363768615503_0001_000001:49,substr:[7,18,21],unix:21,total:[7,12],unit:[62,12,45],highli:[49,56],describ:[36,10,11,9,5],would:[5,49,18,21],call:[14,7,33],recommend:[47,49,21],type:[50,34,15,67,12],until:63,relat:[33,7,45],supergroup:28,hurt:59,rootdir:55,exce:21,recommand:56,getconnect:54,must:[13,32,17,18,40,25,42,9,21,5,7,62,45,27,11,66,30],join:[1
 4,51],setup:16,work:[14,21],era:21,root:[31,65,42,55],dayofweek:21,give:[64,7,12],fmdd:21,indic:21,want:[5,12,38,46,21,23,24,9,49,28,32,62,25,40,64,44,67,57,54,55,34,42],rpad:18,end:[30,53,28,18,49],quot:[57,18,68,21],str2:18,ordinari:21,hdf:[14,32,19,59,36,55,65,30,5,42,44,25,64,47,48,49,12],how:55,conn:54,env:[40,62],verifi:[9,40],config:[40,34,55,6,62],lazybinaryserd:24,updat:[5,40],recogn:[47,43,56],after:[17,9,21,7,49,61],cli_error_stop:63,befor:[9,2,55,40,7,61],parallel:55,averag:50,attempt:21,third:[62,21],environ:[32,9,5,34,49,12],enter:[14,49],first:[17,18,21,34,62,61],order:[11,59,9,54,55,5,23,62,27,66,49,12],oper:[40,15,62],to_bin:29,over:7,failur:40,becaus:[33,9,2,56,21,40,42,43,7],veri:[55,33,42,8,44,49],vari:[27,21],digest:18,smallint:27,cli:48,fix:21,better:47,persist:[49,62],easier:56,descend:7,them:[17,7,56],thei:[33,21,22,42,8,40],binaryserializerdeseri:[22,24],choic:45,subqueri:7,regexp_replac:18,udaf1:17,each:[55,34],side:[18,56],mean:[9,33,8,21],saturdai:21,resu
 t:31,mdy:66,extract:[53,21,18,10],customserializerdeseri:43,network:[40,15],dst:[43,56],xxtajo:18,content:[14,64,49,62,9],millennium:21,got:9,free:49,standard:[50,59,21,8,27,49],md5:18,get_partial_result:17,angl:31,filter:[7,8],iso:21,fxyyyi:21,mvn:[54,49,62],rang:[31,14,39],independ:45,rank:61,system:[40,55,34,62],restrict:[31,21],instruct:[5,3],alreadi:[36,42,18,40,30],tpch:[25,67,10],primari:[40,32],cartesian:7,rewritten:33,xii:21,master:[16,55,62],too:45,json_arrai:53,listen:[54,55],namespac:54,tool:[47,10],inexact:27,target:[31,46,18,9,54,40,62,49],keyword:[42,7,24],provid:[14,15,54,17,40,59,52,3,39,5,8,62,33,49,68],expr:7,tree:[65,49,33],mmdd:21,project:[59,45],minut:[5,49,21],ran:62,mind:21,manner:54,script2:17,val2:[63,8],thoma:18,current_d:21,though:33,usernam:[47,49,62],object:[47,42,44],microsecond:21,letter:18,phase:23,doi:21,don:[25,54,67,34,9,47,49],doc:[68,10],binaryserd:24,doe:[9,54,56,21,40,7,43,45,64,42,30],declar:33,umbil:[40,55,6],dow:21,pope:21,random:31,syntax:
 [7,68],identifi:[36,7,18,62,21],involv:33,absolut:[31,49,62,10],row_num:7,submit:[25,49,40],layout:[42,19],explain:[54,55,22,7,43,19,49],apach:[5,9,3,62,49],geoip_country_cod:3,search_condit:7,fmmonth:21,stop:[40,2],ceil:31,amazon:[36,42],bar:[18,43],emb:36,method:[14,18,67],executor_hash_join_size_threshold:63,respond:5,l_receiptd:25,memstor:62,num:[57,7,43,12],mandatori:47,result:[14,17,33,9,45,56,21,30,40,7,10,49],respons:[13,38,59,9,2,33,49],extlib:36,best:[33,43],subject:7,awar:[5,47,12],heterogen:[42,44],figur:17,score:[13,38,22,42,24,45,47,49,43],approach:67,accord:[27,7,43,33],extend:65,extens:15,toler:[59,43],fault:59,howev:[33,45],against:49,logic:[8,19],countri:[3,21],com:[40,55,3,30],split_part:18,guid:10,assum:[38,23,49,12,21],nonsens:21,three:[33,24,62,21],been:10,trigger:40,datanod:12,basic:[14,59,33,43,67,24],c_mktsegment:67,tini:27,suppress:21,xxx:[30,10],worker:16,ani:[54,53,45,40,7,8,62,10,47,30,61,43],lpad:18,"catch":54,emploi:59,ident:21,geoip:3,servic:[16,55,62
 ],properti:[14,32,17,34,40,9,55,3,5,62,66,6,12],cli_max_column:63,calcul:[7,18],alias_nam:7,udaf:17,conf:[34,32,44,40,36,55,3,57,56,5,62,9,33,47,49,12],march:21,sever:[33,68,62],pemiss:43,perform:[25,47,7,33],suggest:49,complex:[7,21],isodow:21,complet:[40,30],jkl:49,rais:31,dskiptest:[54,49,62],kim:9,squar:31,thu:[5,33,49,43],inherit:[22,43],to_numb:21,client:[14,9,55,40,62,25,6],shortli:65,thi:[5,7,8,9,13,14,11,18,21,24,25,28,30,49,34,36,40,64,43,19,45,47,67,33,53,54,55,56,62],roma:21,gzip:45,left:[33,7,18],protocol:49,just:[40,7,8,62,63,28,67],dist_query_groupby_task_volum:63,dtar:[54,49,62],yet:[33,23],languag:[59,14,49,25],jose:18,easi:[67,39],pdist:[54,49,62],backup_and_restor:10,expon:31,applic:7,preserv:40,bzip2codec:64,bushi:33,background:[14,48],database_nam:[57,64],u0001:[42,43],specif:[27,32,46,40,21],arbitrari:68,manual:[22,62],timetz:27,underli:47,right:[33,7,18],interv:[40,21],intern:[56,34],"52nd":21,cnt:[17,7],insensit:8,multipli:21,tracker:[40,55,6],condit:[33,7],f
 oo:18,localhost:[57,25,55,40,64,62,6],concat_pi:17,core:[47,66,12],who:[33,43],uncompress:[24,45],character_length:18,corr:50,peer:6,rcfile:[14,58],dist_query_join_partition_volum:63,total2:7,simul:40,"float":[31,50,17,42,22,23,24,45,27,47,49,43],encod:[18,45],bound:68,down:[8,49],storag:[14,32,9,67,62,49],jdbc:[5,62,14],wai:[9,56,21,40,43,67],support:[15,32,67,62,21],avail:16,width:21,editor:[40,55],fraction:21,o_custkei:10,creation:[25,62],form:[32,22,56,33,7,43],forc:[7,30,21],drwxr:28,compressiontyp:24,l_comment:[25,64],"true":[25,3,40,8,62,45,27,47,12,24],reset:17,l_discount:[25,7],vatican:21,trim:18,nnn:18,adopt:33,semicolon:[28,38],tajocli:[40,56],exist:[46,57,9,53,22,64,30],executor_inner_hash_join_size_threshold:63,successfulli:[20,25,17,40],floor:31,when:[17,33,25,9,21,40,7,62,45,64,46,65,49],getstr:54,role:36,hh12:21,test:62,node:[17,55,40,62,65,12],intend:21,consid:[40,56,33],longer:18,abscissa:31,carriag:43,jsonpath:53,ignor:[43,12,21],time:40,backward:12,ojdbc7:62,conc
 ept:[54,21],skip:[43,30,21],global:[33,56,21],stddev_pop:50,boolean_express:7,row:[13,50,38,33,25,45,9,56,22,7,24,62,10,42,43,49,61,8],millisecond:21,depend:[5,8,40],zone:[14,66,27,21],decim:[27,21],intermedi:[33,17],json_extract_path_text:53,hadmin:40,drivermanag:54,jvm:[40,12],sql_languag:10,sourc:[29,18,62,21],string:[15,53,3,21,34,29],word:[18,56,21,22,43,12],hdfs_locat:22,exact:27,did:21,"12th":21,item:[28,17,8,21],sine:31,div:31,tajo_hom:[34,57,54,55,40,62,33,47,49],dir:[46,17,55,12,42],prevent:40,templet:34,sign:[31,8],long_table_name_1234:7,cost:[59,33,52],port:[32,62,57,20,9,54,55,40,44,47],addr:[3,62],current:[32,54,17,61,40,25,45,65,39,21,57,5,7,8,62,10,64,33,58,12],deriv:7,gener:40,coeffici:50,stmt:54,tangent:31,address:[9,55,3,40,42,62,27,6],wait:40,shift:21,behav:7,commonli:43,regardless:[22,25,33,45],repositori:49,modul:[14,34],msck:5,output_typ:17,instal:[17,3,62,49],num1:31,memori:[40,62],connector:[5,62],handler:36,msk:5,tajo_pid_dir:40,capit:21,claus:[14,9,33,23,8
 ,27,49],ojat:18,templat:[36,62,21],prepar:[5,49,62],timestamptz:27,cat:[13,40,55,49,67],countpi:17,"02b0e20540b89f0b735092bbac8093eb2e3804cf":18,purpos:[5,34],fmss:21,nearest:[31,21,10],l_orderkey_idx:25,l_shipinstruct:25,backslash:[21,18,10],occur:[9,21,22,64,43,7],alwai:[25,21],sundai:21,multipl:[17,33,56,21,40,7,43,12],haadmin:40,write:[17,56,21,22,42,24,45,43],purg:[9,64,30],c_address:67,ordin:[31,21],map:27,product:7,atan:31,max:[50,43],clone:[11,49,62],"4th":21,date:67,shuffl:33,underscor:8,data:[40,55,62],favorit:[40,55],predic:[64,14,51,23,33],inform:[44,33,25,21,40,7,62,10,64,42,47,66,68],preced:[3,21],combin:7,hh24:21,ghi:49,columnarserd:22,midnight:21,still:[40,11],ieee:27,dynam:59,entiti:40,mapr:24,disconnect:[63,40],monitor:40,new_table_nam:30,main:[59,9,54,8,34],non:[33,21,7,18,45],synopsi:[14,9,64,8,7,30],add_month:21,col2:[46,8,30],col3:[9,46,30],initi:40,nation:[17,10],therebi:33,now:[49,45,21,22,10,63,67],nor:8,introduct:14,hive_jdbc_driver_dir:[5,62],name:[3,5,7,1
 0,25,12,13,17,21,22,24,9,27,33,30,32,34,36,6,49,42,43,44,45,47,48,67,40,54,55,56,57,62,63,64,66,68],reoptim:59,revers:18,separ:[43,38,7,24,21],januari:21,quarter:21,tajo_worker_heaps:12,compil:[49,62],domain:[40,55,8,43],replac:[18,21],individu:7,current_tim:21,significantli:33,year:[7,21],shown:21,space:[18,44,21],o_orderkei:10,profil:5,hivemetastor:[5,62],lag:61,partit:[5,52,61,14],git:62,org:[11,22,36,54,30,5,42,24,62,10,64,47,49,43],"byte":[18,45,33,10,27,49],card:23,care:[43,21],suffici:25,p_id:13,catalog:1,codegen:63,turn:33,place:10,standbi:40,think:49,str1:18,origin:9,directli:[11,54,5,23,43,65],onc:[17,25,3,40,7,44,42,47],arrai:[53,8],o_orderd:10,"long":[59,33,7,21],open:59,given:[46,18,9,53,3,21,57,56,7,8,10,64,27,47,49,43],stddev_samp:50,paramt:13,l_partkei:[64,46,7,9,25],especi:[27,42,44,33],copi:[36,34,62],specifi:[3,5,7,8,12,17,18,20,21,22,24,27,28,30,32,9,57,42,43,45,46,47,49,33,53,54,56,62,68],github:49,enclos:[7,68],tajo_password:47,mostli:22,than:[13,31,46,18,33,9,
 21,5,7,8,49],serv:40,wide:33,serd:22,posix:8,balanc:59,posit:65,argument:[31,38,18,53,21,7,10,28,29,68],maxmind:3,engin:[65,11],techniqu:[59,33],partsupp:10,note:[17,8,62,21],take:[5,7,49,33],xxxxxx:62,begin:[21,10],c_nationkei:67,buffer:[49,45],price:23,compress:[14,30],deflatecodec:64,pair:[50,22,24,34],renam:14,later:49,quantiti:7,link:[25,49],axi:31,clientport:9,show:[20,54,62,10,63,49],threshold:33,ship_dat:23,xml:16,onli:[34,32,18,33,65,39,21,22,7,24,62,45,64,49,43],explicitli:[33,7,34],"500mb":12,activ:40,written:[22,56,24,43],l_suppkei:25,table_space_nam:44,"53rd":21,variou:[63,36,19,21],get:[40,17,62,21],client_session_expiry_tim:63,allocat:12,repo:[11,49,62],cannot:[33,17,43],java_hom:49,progress:[13,38,20,9,2,59],ssd:44,requir:[38,21,40,42,7,49],table_refer:[33,7],item_nam:23,borrow:8,c_custkei:67,list_endpoint:47,where:[14,17,18,9,55,33,23,8,62,64,27,49,12],calendar:21,concern:[67,34],detect:40,enough:62,ddsp:21,between:[50,8],"import":[33,54],across:[55,7],parent:49,exe
 cutor_groupby_inmemory_hash_threshold:63,hadoop_hom:[47,55,49],gregorian:21,decimaln:10,region:[47,10],gzipcodec:64,groupbi:14,compressioncodec:[22,43],improv:[33,45],among:33,acceler:33,jdbc4:62,pow:31,"4028235e":27,featur:[5,25,52,9,14],xzvf:[54,49],date_ord:63,invers:10,dist_query_broadcast_join_threshold:[63,33],derbystor:[40,62],those:[22,42,17,43,45],"case":[34,18,56,21,22,24,62,30,8],cast:[14,21],invok:40,new_column_nam:30,column_family_nam:9,advantag:45,ctrl:[40,55,49],cluster:[16,62],warehous:[59,9,42,44,64,28,30],abcdef:18,ascii:18,"__init__":17,develop:[14,49],regionon:47,alphabet:18,same:[31,50,17,40,9,3,21,5,7,8,33,47,61],binari:[14,18,62,65,29,49],epoch:21,html:10,pad:[18,21],week:21,finish:40,nest:45,driver:[5,62,14],decompress:[49,45],tajo_classpath:[47,62],mani:[22,56,12,10],extern:[14,9,49,22,23,64,67,47,30],appropri:[49,34],without:[38,59,36,21,33,23,43,62,7],fmmm:21,lc_time:21,fmmi:21,execut:[40,55,12],rest:[7,18],bitmap:52,kill:[20,40],speed:33,inet4:[27,3],stru
 ct:[36,44],except:[54,7,21],littl:55,desktop:9,blog:9,codec:[22,64,43,42,30,24],blob:[27,17],versa:22,overview:14,pgpgpgpg:18,disrupt:40,real:31,read:[65,55,49,45],period:[40,21],swiftnativefilesystem:47,mon:21,world:[33,17],pst:[43,56],mod:31,mysqlstor:62,integ:[31,21,61,43,10,27,29,12],server:[14,62,40,34,47,49],query_succeed:49,benefit:39,either:[53,5,7,8,45,27,49],last_valu:[50,61],output:[17,9,21,7,24,46],tajo:[16,67,62],result_set_fetch_rownum:63,yyyi:21,ascend:7,tajowork:[40,34,12],json_path:53,definit:[14,25,51,21],exit:2,ddl:[49,67],blocksiz:47,power:[31,8],inspect:48,broken:43,starttim:20,l_tax:25,regexp:8,"throw":54,comparison:[27,8],central:40,choi:9,aco:[31,10],degre:[31,55],yyyymondd:21,table_nam:[5,64,67,9,30],effici:[25,11,45],lastli:62,defaultport:62,yyi:21,your:[32,17,34,22,36,54,55,9,21,5,43,62,45,67,66,49,40],rowkei:9,hex:18,overwrit:40,start:[40,55,17,18,21],current_databas:63,interfac:[40,48,43],ipv4:[27,3],lot:[33,15],tupl:[25,17,65],untar:49,jun:21,tajoxx:18,
 index_en:25,max_output_file_s:63,notat:33,possibl:[33,7,12,21],ddth:21,bucket:42,day_of_week:21,embed:[18,62],expect:[25,21],creat:[55,49,62,67],multibyt:18,certain:[22,46,43,9,45],strongli:47,file:[16,67],oraclestor:62,fill:[54,18,21],incorrect:40,denot:8,sort_expr:7,tinyint:27,prepend:18,field:[43,21,42,18,10],valid:21,rdbm:[36,54,19],you:[33,2,3,5,7,8,9,10,11,12,13,38,17,21,22,23,24,36,28,30,49,32,34,25,40,42,43,44,45,46,47,67,57,54,55,56,62,64,66],polar:31,sequenc:[8,68,18],symbol:13,text_nul:63,briefli:7,tajomast:[16,55,62],hyunsik:[9,67,10],descript:[20,6,21,40,8,62,10,27,47,66,49,12],tajo_master_heaps:32,index_support:11,cpu:12,unset:[63,10],tajodriv:54,represent:[21,29,18,45],all:[3,5,7,8,10,17,20,21,9,30,49,36,40,42,43,19,67,50,54,55,56,62,63],dist:[33,54,49,62],month:21,correl:50,abil:40,mno:49,follow:[33,2,3,5,7,8,9,10,21,12,13,38,17,20,49,22,23,24,25,27,28,32,34,36,39,40,42,43,44,45,46,47,67,57,54,55,56,11,58,62,63,64,66],disk:[65,3,12],init:49,program:[34,45],thursdai:2
 1,liter:[43,34,21],fals:[27,25,8,3,45],util:[25,48],worst:59,fall:[7,21],expression1:50,expression2:50,list:[17,40,20,55,56,5,7,8,10,23,49,68],helloworld:17,adjust:[32,56,21,22,42,43,45,12],cosin:[31,10],small:[33,27,25,45],tmmonth:21,ten:49,past:21,zero:[21,8,18],design:[59,23,34,45],pass:7,val3:63,further:43,val1:[63,8],what:21,abc:[49,8,18],clock:21,section:[11,22,36,54,55,21,5,43,19,9,47,49,12],abl:[5,9],abbrevi:[56,43,21],version:[49,62,10],consecut:33,to_dat:21,"public":54,zookeep:9,full:[33,7,21],hash:[14,18],valn:8,initcap:18,zong:56,strong:67,modifi:[36,21],valu:[31,14,32,61,17,18,34,40,9,53,55,3,21,5,66,50,62,11,29,30,12],search:[14,11,18,65],cli_print_error_trac:63,table_backup:67,amount:40,behavior_arithmetic_abort:63,codebas:49,via:[40,55],data_typ:[9,64,30],primit:27,transit:40,filenam:57,unbias:50,select:[13,31,38,17,18,52,20,9,53,54,3,21,33,56,7,8,10,46,29,49],hexadecim:29,l_extendedpric:[25,7],distinct:[7,21],etc:[47,48],regist:[14,17],two:[34,33,39,67,22,24,44,65,2
 1,49,68,8],toggl:21,more:[13,38,44,52,25,55,21,5,68,7,8,62,45,64,42,33,47,49,12],flat:[22,24,45],discompress:49,function_nam:68,flag:47,known:23,endpoint:47,hour:21,formatha:40,dev:3,histori:40,orderbi:14,archiv:[49,62],learn:[42,49,56],def:[17,49],bewtween:27,prompt:[57,38,10],to_char:[29,56,21],num2:31,scan:[5,9,14],share:[54,22,47,7,62],accept:[43,56],tabular:43,minimum:[50,12],goal:59,divid:[31,7,21],anoth:[40,68],divis:31,n_name:17,csv:49,simpl:49,swift_tabl:47,blockcompresswrit:24,jline2:2,resourc:[40,55,6],seoul:[42,43,56],resultset:54,json_array_length:53,varianc:50,associ:33,"short":[22,7],author:9,caus:[40,21],atan2:31,help:10,pseudorandom:31,through:5,paramet:[31,14,18,53,3,21,22,42,43,45,64,50,29,61],style:8,late:21,alter:[5,51,14],good:[33,19],"return":[31,50,17,18,53,3,21,33,8,29,30,61,43],timestamp:[50,9,56,21,42,43,27],o_orderstatu:10,ssss:21,framework:45,mtizxdawmfwwmd:18,get_final_result:17,utc_usec_to:[21,10],serde2:[22,24],easili:[40,54,55],token:47,radian:31,fou
 nd:28,unicod:[27,18],truncat:[31,18],unequ:40,procedur:49,connect:[57,54,5,62,10,63],o_clerk:10,"try":[40,54,57],csvlineserd:43,print:21,proxi:47,advanc:[59,7],asc:[64,25,7],base:62,asf:[11,49,62],put:[13,9,56,21],fridai:21,refer:[3,7,10,17,22,24,9,25,33,64,43,44,45,11,47,49,54,55,56,42,66,68],thrown:30,launch:62,omit:[22,21,7,61,10],round:[31,10],perman:65,feed:43,meridiem:21,upper:[18,21],feel:49,exchang:33,applciat:54,number:55,done:[49,21],unhealthi:40,blank:21,differ:[9,56,21,33,7,8,44,42,30,43],script:[17,49,34],interact:[59,57,49],construct:[7,21],saint:21,twenti:21,scheme:[36,32,49],store:[13,44,22,59,25,9,5,42,24,62,10,65,43,47,49,12,40],schema:[46,19,25,45,23,9,10,48,49],option:[13,20,25,21,57,7,43,9,64,67,49],part:[21,10],pars:43,start_index:18,kind:[65,7,43],remot:55,remov:[18,9,49,64,62,30],l_orderkei:[64,46,7,9,25],str:17,comput:[33,47,7,21],packag:54,"null":[25,53,54,22,64,42,7,61],catalogstor:40,equival:[46,7,9,21],self:17,also:[44,33,36,56,21,40,7,8,62,10,63,23,43,4
 7,49,24],tmpdir:12,brace:13,distribut:62,exec:24,previou:[8,21],mixtur:21,most:[33,42,43,62],plai:36,plan:[59,36,23,43,33],metacharact:8,model:[14,17,51],appear:7,quorum:9,filesystem:49,clear:10,salari:7,classnotfoundexcept:54,clean:[54,49,62],jaehwa:9,data_type_func_and_oper:68,session:[14,33,48,56,10],find:[40,33,65],access:[40,9,54,55,5,45,33,47],copyright:10,solut:33,fmhh:21,ymd:66,l_quantiti:[46,7,9,25],query_run:20,express:[50,14,18,21,64,51,12],nativ:33,strposb:18,hbase_table_nam:9,statist:40,sum_pi:17,bytea:27,set:62,startup:57,see:[44,36,55,9,21,62,25,47,49,12],arc:31,sec:[13,38,20,9,2,62,49],arg:[20,54],float4:[27,25,10],close:54,unqualifi:[23,7],particip:33,smallest:[31,45],subdir:46,"\u02c6ab":18,altern:[8,62],numer:21,fsshell:28,add_dai:21,outfil:67,popul:50,both:[18,40,59,22,7,24,61,43],last:[50,18,25,21,64,7,61],"85e7":21,c_comment:67,roman:21,snativ:47,context:21,load:[59,9,49,30],simpli:[25,49],point:[22,53,18,40,21],hbase_hom:9,header:[22,43],param:[13,57,7],shutdo
 wn:40,suppli:21,transitiontobackup:40,cathedr:21,becom:[40,56,21],java:[34,54,56,5,8,62,27,49],due:12,empti:[22,7,43],sinc:[22,62,21],l_linestatu:25,exercis:49,iddd:21,gap:61,tajojdbccli:54,coordin:31,understand:[17,19],func:7,repetit:[8,18],xa2:9,iyi:21,tajoresourcemanag:40,durat:62,n_regionkei:17,"while":[33,54,21],behavior:7,error:[9,43,64,30,21],script1:17,earli:[33,21],key1:63,tbname:10,itself:[40,10],centuri:21,grant:62,belong:7,shorten:62,hadoop:[14,59,9,55,49,64,8,34,30],decod:18,octal:18,conflict:40,higher:49,varbit:27,lineitem:[46,20,25,10,7,9,64],x84:9,optim:[59,14,52],fornam:54,moment:[43,45],user:[40,32,62,12],tsql:[14,56,49,67],chang:[54,55,49,33,62,10,30],lower:[18,21],sha1:18,lib:[47,62],entri:[9,64,55,40],parenthes:[7,8,68],udf1:17,expens:33,explan:49,shape:33,openstack:[36,14],snappi:45,all_backup:67,disk1:12,disk2:12,disk3:12,shortcut:28,appli:[40,33,21],input:[31,50,17,18,21,33,61],subsequ:[65,21],euler:31,bin:[13,38,40,2,55,57,67,5,62,49],complaint:21,varchar:27
 ,format:[40,29],big:9,subfield:21,register_d:9,bit:[27,18],characterist:19,table2:30,table1:[13,38,54,56,30,22,7,24,45,42,43,49,8],collect:24,"boolean":[27,7,3,45],l_commitd:25,often:43,order_d:23,createstat:54,"1st":21,some:[14,34,22,9,2,42,56,21,5,7,43,62,45,27,49],back:40,sampl:50,mirror:49,tablespac:[36,19,14],scale:59,id4:33,id2:[33,30],id3:33,per:[14,55,12,40],id1:33,bst:[25,65],substitut:[36,18],machin:[40,42,57],o_shipprior:10,run:[40,55],dist_query_table_partition_volum:63,hive_hom:[5,62],step:[25,47,49],"15gb":12,subtract:21,varbinari:27,manag:[14,9,39,49,5,62,30],regular:18,"1gb":[32,12],block:[65,24,45],executor_outer_hash_join_size_threshold:63,repair:5,primarili:21,within:[40,21,33,7,28,61],ensur:[49,62],megabyt:12,textual:18,custom:[14,67,62],arithmet:[14,7],includ:[15,7,62,21],unix_timestamp:21,metastor:5,record:[8,22,24,45,30,43],properli:[17,18],int4:[31,46,18,53,10,27,17,29],int1:27,translat:[56,21],select_stat:64,int2:27,l_shipdat:[25,7],line:[55,56,40,43,47,48],
 int8:[31,50,46,25,53,10,27,29,67,61],info:[20,9,6,40],utc:[56,43,21],utf:18,consist:[34,21,22,7,43,19,65,68,24],blrunner:9,sum:[13,17,38,7,50],"export":[9,5,62,47,49,12],impl:47,constant:[31,14],doesn:[5,53,30,9],repres:[21,33,42,43,44,47],"char":[27,18,21],qualifier_nam:9,home:[5,9,49,62,67],titl:9,hiveql:5,debug_en:63,bracket:[33,8],servicenam:62,ecosystem:45,exp:31,jhkim:9,introduc:14,eval:17,join_typ:33,algorithm:[22,43,12,45],vice:22,first_valu:61,hixyx:18,json_array_contain:53,hello:[17,21],code:[17,3,62,18],"900150983cd24fb0d6963f7d28e17f72":18,queri:[40,62,12],dist_query_join_task_volum:63,base64:18,executor_external_sort_buffer_s:63,keyston:47,volum:[25,49,9,10],implicitli:7,dbname:10,recordcompresswrit:24,evn:47,hive:62,unquot:10,date_part:21,dealt:7,ddd:21,pleas:[3,7,12,17,21,22,25,49,36,33,64,43,44,45,11,47,67,54,55,56,42,68],smaller:[9,46],natur:[33,7],uniqu:63,fold:18,download:3,click:49,append:18,compat:[14,67,12],index:[14,53,18,52],compar:27,cell:9,c_phone:67,"19th"
 :21,experiment:14,can:[19,5,7,8,10,12,13,14,17,21,22,23,24,9,28,30,34,25,40,42,43,44,45,11,47,48,49,33,54,55,56,62,64],showmast:20,return_on:17,let:[42,24,30],authenticaiton:47,o_orderprior:10,vertic:43,implicit:33,convert:[31,18,3,21,40,29,68],aaabc:8,weekdai:21,larger:[27,33,7,45],typic:[17,7],control:40,cbrt:31,approxim:27,api:[5,25,14],namenode_hostnam:32,wip:[11,49,62],join_condit:33,from:[31,14,17,18,9,53,67,40,65,21,49,61],c_acctbal:67,doubl:[18,21],next:[36,21,54,5],few:34,chr:18,usr:62,remaind:31,sort:[9,7],src:[54,49,21],mismatch:14,trail:[18,21],name2:63,name3:63,name1:63,retriev:[25,56,11,18,21],alia:[31,27,7,18,10],annot:17,thin:62,parquet:[14,58],employe:42,tar:[54,49,62],process:[14,11,59,56,21,22,23,43,45,48],high:16,tab:43,tarbal:40,tan:31,concatnen:18,isoyear:21,instead:[56,21,57,43,62,49,61,8],sin:31,transitiontoact:40,ltrim:18,jinho:9,o_com:10,getstat:40,physic:[55,19],essenti:40,cli_print_paus:63,correspond:[22,7,65],element:[40,53,34],issu:14,column_refer:8,wri
 t:43,allow:[13,32,22,36,55,9,21,30,5,56,7,43,44,45,64,42,33,49,12],least:[7,8],move:49,comma:[7,43,21],outer:[33,7],chosen:33,decad:21,therefor:[40,21],crash:40,greater:31,handl:[33,54],spell:21,dai:21,auth:47,mention:22,lzo:45,quorum2:44,quorum1:44,mode:62,cluster1:44,consum:45,meta:[14,9,56,62,48,49],"static":54,our:43,special:[42,43],out:[17,12],variabl:[14,32,34,33,9,56,5,62,10,27,48,49,12],hbasetablespac:36,var_pop:50,suitabl:18,math:15,common:[14,7,33],shut:49,insid:30,manipul:63,standalon:49,dictionari:45,l_shipmod:25,tenant:47,joined_t:33,could:21,keep:21,length:[27,53,18,21],timezon:[56,42,43,63,66,30],suffix:21,resourceconfigur:12,mai:[38,34,33,21,40,7,62,49],quote_id:18,t_timestamp:[42,56],unknown:[25,9],licens:10,mkdir:[28,55,49],capac:[55,12],termin:43,bit_length:18,"final":[17,54,5,62,65,47,49],inner:[33,7],mysql_jdbc_driv:[5,62],shell:[14,49,34,9],grouping_column_refer:7,udf:17,rtrim:18,exactli:8,haven:23,prune:14,split:[47,18],structur:[11,64],charact:[18,42,21,22,23
 ,8,27,68,43],float8:[31,50,46,10,21,27,17,67],textserd:24,julian:21,fail:43,have:[14,32,33,9,21,5,64,62],tabl:[49,62,67],need:[19,22,9,54,21,5,24,62,45,67,47,49,40,43],json_array_get:53,cli_null_char:63,min:[50,12],mix:21,builtin:36,which:[63,15,18,40,59,9,54,65,57,21,22,56,7,24,62,30,64,42,33,49,43],singl:[14,33,55,21,40,42,8,19,45,48,68],lineitem_100_snappi:64,unless:[5,21],preliminari:16,l_returnflag:25,deploi:40,"class":[17,5,36,54,22,8,62,43,24],url:[32,47,54,19],request:12,uri:[62,36,40,42,44,47],snapshot:[49,62],determin:[66,53,7,12],querymast:[40,12],text:[3,8,14,17,18,21,22,23,24,9,27,29,30,49,25,40,42,45,47,67,50,53,55,58,64],locat:[46,18,44,54,3,67,22,56,42,43,62,30,64,47,49,12],postgresqlstor:62,jar:[36,47,54,62,5],should:[3,5,25,12,17,21,22,23,9,49,32,36,57,64,43,44,45,67,54,55,56,62,42,66],jan:21,suppos:33,local:[62,3,12,21],cube:31,familiar:[22,43,45],disagre:21,tbl:47,increas:55,l_linenumb:25,enabl:[14,55,40],grtajo01:20,"default":[40,16,55,34,62],integr:62,dist_quer
 y_sort_task_volum:63,contain:[17,18,54,55,21,40,64,47],view:19,dhadoop:49,legaci:3,frame:7,knowledg:43,n_nationkei:17,rlike:8,statu:40,correctli:[27,49],t_date:[42,56],pattern:[14,18,21],to_timestamp:21,cli_print_pause_num_record:63,xyxhi:18,theta:31,neither:8,kei:[13,33,9,53,39,21,22,23,24,65,63,64,30],otherwis:[57,21,7,3,8],group:[7,8,45],swift:[36,14],addit:[46,56,33,7,8,44,68],plugin:14,admin:[20,10],equal:[9,33],april:56,instanc:[32,36,55,42,44,49],fmyyyi:21,english:21,arriv:9,chmod:55,rpc:[40,54,55,6],respect:[27,8,61],tuesdai:21,quit:10,compos:[23,45],compon:40,json:15,besid:43,sequecnefil:24,columnar:[22,45],cli_output_formatter_class:63,togeth:21,present:[49,10],delimit:[17,18,25,56,49,42,43,64,47,30],replic:33,bye:49,implementaion:32,plain:[22,24,43],octet_length:18,rectangular:31,wild:23,lazybinarycolumnarserd:22,textserializerdeseri:[22,24],layer:32,demo:47,site:16,bigint:[27,64],avgpi:17,avg:50,to_hex:29,"35b":49,classpath:[14,9],cross:33,sqrt:31,python:15,zookeeper_add
 ress:9,largest:31,http:[11,3,6,40,62,10,47,49],hostnam:[32,54,55,57,42,62],geoip_in_countri:3,column_nam:[9,64,30],col1:[9,46,8,30],off:21,well:[46,9,21,33,64,27],exampl:[40,55,67,62],command:[14,9,56,49,5,48,67],choos:49,usual:[43,34],less:[31,21],percent:8,tcp:57,current_timestamp:21,auth_:47,simultan:12,web:[59,40],add:[14,34,40,9,54,55,5,62,66,49,12],host2:[40,55],host1:[40,55],work1:10,match:[14,27,18,21],gmt:[30,56],int32:47,iyyi:21,workload:12,five:5,know:[55,56,21,42,44,7,49],xe2:9,createdatabaseifnotexist:62,password:[47,62],desc:[20,64,7],insert:40,storage_typ:64,resid:[49,30],like:[32,54,23,49,21],lost:30,necessari:[59,18],page:[14,55,45],another_long_table_name_5678:7,datetime_func_and_oper:68,linux:10,queryid:20,yyyymmdd:21,proper:[32,49,12,62],guarante:40,peter:21,librari:9,tmp:[28,32,49,62],leaf:65,lead:[23,18,61,21],avoid:[59,9,2,21,40,64],estim:52,zookeeper_client_port:9,blog_backup:9,xtajoxx:18,ab_bc_cd:18,usag:[67,21],maven:[5,49],host:[62,57,20,55,40,44,66],altho
 ugh:21,offset:[43,61,56],empsalari:7,stage:[33,17,49],about:[44,25,64,19,42,68],actual:[14,9],dist_query_groupby_partition_volum:63,column:[14,9],statement:[13,54,46,18,57,20,9,45,56,30,22,7,8,10,64,42,43,49,24],disabl:14,own:[42,43,56],lazybinari:24,merg:17,val:63,pictur:10,q_1411357607375_0007:20,q_1411357607375_0006:20,"var":62,snappycodec:[22,64,43,42,30,24],count:[13,50,38,18,20,21,7,61],temp:28,whether:[22,7,8],wish:13,directori:62,below:[49,36,21,22,43,45,67],limit:14,dmy:66,problem:[40,2,33],executequeri:54,evalu:[17,61],btrim:18,"int":[31,50,18,42,21,22,23,24,45,27,49,43],dure:23,pid:40,novemb:21,implement:[14,15,36,21,10,47,49],"20000nov31":21,var_samp:50,boot:[49,62],detail:[20,45,55,21,33,7,62,10,47,49],other:[17,18,40,59,9,56,21,22,7,43,34,46,47,12],bool:27,futur:14,branch:[14,11],varieti:34,repeat:[18,21],row_numb:[7,61],jung:9,mondai:21,escap:18,strpo:18,rule:33,mariadbstor:62,select_list:7,two_level_bin_tre:[25,64,65],decemb:21},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","hive_integration","configuration/service_config_defaults","sql_language/queries","sql_language/predicates","hbase_integration","tsql/meta_command","index_overview","configuration/worker_configuration","tsql/execute_file","index","functions","configuration","functions/python","functions/string_func_and_operators","table_management","tsql/admin_command","functions/datetime_func_and_operators","table_management/rcfile","partitioning/column_partitioning","table_management/sequencefile","index/how_to_use","configuration/catalog-site-xml","sql_language/data_model","tsql/dfs_command","functions/data_type_func_and_operators","sql_language/alter_table","functions/math_func_and_operators","configuration/tajo_master_configuration","sql_language/joins","configuration/preliminary","table_mana
 gement/compression","storage_plugin","faq","tsql/single_command","partitioning/intro_to_partitioning","configuration/ha_configuration","table_partitioning","table_management/table_overview","table_management/text","table_management/tablespaces","table_management/parquet","sql_language/insert","swift_integration","tsql","getting_started","functions/agg_func","sql_language","index/future_work","functions/json_func","jdbc_driver","configuration/cluster_setup","time_zone","tsql/intro","table_management/file_formats","introduction","tajo_client_api","functions/window_func","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","Hive Integration","Cluster Service Configuration Defaults","Queries","Predicates","HBase Integration","Me
 ta Commands","Index (Experimental Feature)","Worker Configuration","Executing Queries from Files","Apache Tajo\u2122 (dev) - User documentation","Functions","Configuration","Python Functions","String Functions and Operators","Table Management","Administration Commands","DateTime Functions and Operators","RCFile","Column Partitioning","SequenceFile","How to use index?","The catalog-site.xml File","Data Model","Executing HDFS commands","Data Type Functions and Operators","ALTER TABLE","Math Functions and Operators","Tajo Master Configuration","Joins","Preliminary","Compression","Storage Plugin","FAQ","Executing a single command","Introduction to Partitioning","High Availability for TajoMaster","Table Partitioning","Overview of Tajo Tables","TEXT","Tablespaces","Parquet","INSERT (OVERWRITE) INTO","OpenStack Swift Integration","Tajo Shell (TSQL)","Getting Started","Aggregation Functions","SQL Language","Future Works","JSON Functions","Tajo JDBC Driver","Cluster Setup","Time Zone","Intro
 ducing to TSQL","File Formats","Introduction","Tajo Client API","Window Functions","Catalog Configuration","Session Variables","Data Definition Language","Index Types","The tajo-site.xml File","Backup and Restore Catalog","SQL Expressions"],objects:{"":{trim:[18,0,1,""],upper:[18,0,1,""],now:[21,0,1,""],to_bin:[29,0,1,""],acos:[31,0,1,""],to_char:[21,0,1,""],btrim:[18,0,1,""],regexp_replace:[18,0,1,""],cbrt:[31,0,1,""],date_part:[21,0,1,""],random:[31,0,1,""],split_part:[18,0,1,""],sign:[31,0,1,""],substr:[18,0,1,""],stddev_pop:[50,0,1,""],add_months:[21,0,1,""],right:[18,0,1,""],to_date:[21,0,1,""],quote_ident:[18,0,1,""],rpad:[18,0,1,""],tan:[31,0,1,""],avg:[50,0,1,""],extract:[21,0,1,""],digest:[18,0,1,""],to_hex:[29,0,1,""],var_samp:[50,0,1,""],first_value:[61,0,1,""],lead:[61,0,1,""],min:[50,0,1,""],ascii:[18,0,1,""],sum:[50,0,1,""],current_date:[21,0,1,""],json_extract_path_text:[53,0,1,""],stddev_samp:[50,0,1,""],char_length:[18,0,1,""],chr:[18,0,1,""],abs:[31,0,1,""],var_pop
 :[50,0,1,""],pow:[31,0,1,""],encode:[18,0,1,""],degrees:[31,0,1,""],bit_length:[18,0,1,""],pi:[31,0,1,""],sin:[31,0,1,""],row_number:[61,0,1,""],locate:[18,0,1,""],sqrt:[31,0,1,""],ltrim:[18,0,1,""],atan:[31,0,1,""],current_time:[21,0,1,""],max:[50,0,1,""],lag:[61,0,1,""],cos:[31,0,1,""],rtrim:[18,0,1,""],initcap:[18,0,1,""],json_array_length:[53,0,1,""],rank:[61,0,1,""],corr:[50,0,1,""],lpad:[18,0,1,""],strposb:[18,0,1,""],json_array_contains:[53,0,1,""],utc_usec_to:[21,0,1,""],geoip_in_country:[3,0,1,""],repeat:[18,0,1,""],md5:[18,0,1,""],count:[50,0,1,""],lower:[18,0,1,""],reverse:[18,0,1,""],asin:[31,0,1,""],ceil:[31,0,1,""],floor:[31,0,1,""],octet_length:[18,0,1,""],radians:[31,0,1,""],json_array_get:[53,0,1,""],atan2:[31,0,1,""],to_timestamp:[21,0,1,""],geoip_country_code:[3,0,1,""],add_days:[21,0,1,""],mod:[31,0,1,""],decode:[18,0,1,""],exp:[31,0,1,""],div:[31,0,1,""],last_value:[61,0,1,""],round:[31,0,1,""],left:[18,0,1,""]}},titleterms:{code:[54,49],execut:[13,2,38,28,49],q
 ueri:[13,17,47,7,49],cross:7,scalar:15,session:63,permiss:55,mysql:62,openstack:47,hbase:9,classpath:54,languag:[51,64],paramet:13,xml:[26,66,34],oracl:62,zone:[42,56],how:[40,25,54,22,23,43,45],configur:[32,16,62,36,40,44,47,6,12],apach:[22,14,23,43,45],common:[47,42],window:[15,7,61],text:43,local:49,alter:30,match:8,build:[54,49],real:27,sourc:[54,49],synopsi:[20,57],string:[8,68,18],format:[58,21],python:17,faq:37,terminolog:40,background:2,introduct:[59,39],insert:[9,46],document:14,like:8,administr:[20,40],level:67,drop:[9,64,30],hive:[22,5,23,43,45],server:56,"default":6,mode:55,partit:[0,39,41,23,4,30],each:12,fulli:55,tajo:[14,32,40,66,54,55,6,22,42,34,60,47,48,49],manag:[42,19],failov:40,set:[13,54,55,30,40,66,49],dump:67,direct:54,dowload:49,meta:10,aggreg:[50,15,17],download:[54,49],hash:0,todo:[0,35,37,4,42,60,67],time:[66,42,56,21],out:49,compat:[22,23,43,45],index:[25,11,64,65],network:3,defin:[15,17],databas:[64,67],definit:64,per:47,launch:[40,55],state:40,experimen
 t:11,directori:[55,12],get:[54,49],method:[64,39],math:31,integr:[5,47,9],qualifi:7,run:12,compress:[64,35,42],hivecatalogstor:62,usag:[20,13,9,10],serializerdeseri:24,base:55,prerequisit:[3,49],releas:49,swift:47,rcfile:22,valu:[13,27,43],postgresql:62,convers:21,plugin:36,column:[23,30],where:7,groupbi:7,datetim:21,gener:22,backup:[40,1,67],disabl:25,first:49,oper:[31,21,29,3,18],rang:4,via:49,overview:[36,33,7,42],tajomast:[40,32],number:[27,12],automat:40,date:[66,21],api:60,storag:36,size:[32,12],git:49,from:[13,54,7],memori:[32,12],data:[64,27,29,12],support:3,doubl:27,regist:36,system:66,overwrit:[9,46],custom:[36,43],avail:40,start:49,json:53,call:68,basic:[20,13,10],master:[40,32,6],type:[17,7,27,65,29,68],"function":[31,50,15,17,18,53,3,21,7,61,29,68],setup:55,shell:[57,48],claus:7,worker:[55,6,12],broadcast:33,rootdir:32,heap:[32,12],jdbc:54,unpack:49,join:[33,7],prune:23,restor:[1,67],provid:47,servic:6,properti:[22,43,42,30,45],maximum:12,dev:14,orderbi:7,cast:68,serd:2
 4,limit:7,introduc:[57,24],parquet:45,tablespac:[42,44],similar:8,featur:11,constant:68,file:[13,26,58,66,40],creat:[25,45,22,23,43,9,64],scan:25,process:2,registr:17,site:[26,66,34],indic:14,high:40,cluster:[40,56,55,49,6],have:7,tabl:[14,9,42,56,22,41,23,43,19,45,64,7,30],serial:[22,43],work:52,check:49,issu:[22,23,43,45],decor:17,"null":43,built:15,make:55,ilik:8,when:22,hadoop:47,hdf:28,binari:54,add:30,exampl:[17,54,56,33,7,12],futur:52,env:34,test:40,writer:24,config:66,singl:38,enabl:25,variabl:63,express:[8,68],resourc:12,distribut:[54,55],preliminari:34,optim:33,enter:57,driver:54,catalog:[26,34,67,62],regular:8,temporari:12,user:[14,15,17],sql:[13,51,67,68],extern:42,mariadb:62,tsql:[57,48],parallel:12,physic:[22,43,45],derbi:62,handl:43,task:12,renam:30,read:22,predic:8,arithmet:68,alias:7,client:[54,60,56],command:[20,28,38,10],pattern:8,model:27,sequencefil:24,order:33,latest:49}})
\ No newline at end of file
+Search.setIndex({envversion:42,terms:{c_name:67,four:[58,21],prefix:[13,47,56,21],deviat:50,locaion:56,newli:5,digit:[27,21],everi:[17,33,66,7,40],"void":54,affect:[56,62,12,21],println:54,tajo_src:49,direct:14,batch:59,enjoi:49,second:[18,40,9,21,33,62],even:[40,33,21],asin:31,neg:53,asia:[42,43,56],char_length:18,supplier:10,"new":[5,9,21,40,10,30],metadata:[22,30,43],ongo:40,elimin:[64,9,7],abov:[38,25,2,22,24,9,49,68],never:[9,40],o_totalpric:[68,10],here:[17,9,21,33,24,47,49,68,8],path:[32,17,25,53,54,3,9,67,30,5,56,42,62,10,64,49],interpret:21,deterior:45,headerlin:43,anymor:25,precis:[27,21],datetim:[15,66],pack:36,sequencefil:[14,58,22],q_1363768615503_0001_000001:49,substr:[7,18,21],unix:21,total:[7,12],unit:[62,12,45],highli:[49,56],describ:[11,36,5,9,10,68],would:[5,49,18,21],call:[14,7,33],recommend:[47,49,21],type:[50,34,15,67,12],until:63,relat:[33,7,68,45],supergroup:28,hurt:59,rootdir:55,exce:21,recommand:56,getconnect:54,must:[13,32,17,18,40,25,42,9,21,5,7,62,45,27,
 11,66,30],join:[14,51],setup:16,work:[14,21],era:21,root:[31,65,42,55],dayofweek:21,give:[64,7,12],fmdd:21,indic:21,want:[5,12,38,46,21,23,24,9,49,28,32,62,25,40,64,44,67,57,54,55,34,42],rpad:18,end:[30,53,28,18,49],quot:[57,18,68,21],str2:18,ordinari:21,hdf:[14,32,19,59,36,55,65,30,5,42,44,25,64,47,48,49,12],how:55,conn:54,env:[40,62],verifi:[9,40],config:[40,34,55,6,62],lazybinaryserd:24,updat:[5,40],recogn:[47,43,56],after:[17,9,21,7,49,61],cli_error_stop:63,befor:[9,2,55,40,7,61],parallel:55,averag:50,attempt:21,third:[62,21],environ:[32,9,5,34,49,12],enter:[14,49],first:[17,18,21,34,62,61],order:[11,59,9,54,55,5,23,62,27,66,49,12],oper:[40,15,62],to_bin:29,over:[7,68],failur:40,becaus:[33,9,2,56,21,40,42,43,7],veri:[55,33,42,8,44,49],vari:[27,21],digest:18,smallint:27,cli:48,fix:21,better:47,persist:[49,62],easier:56,descend:7,them:[17,7,56],thei:[33,21,22,42,8,40],binaryserializerdeseri:[22,24],choic:45,subqueri:7,regexp_replac:18,udaf1:17,each:[55,34],side:[18,56],mean:[9,33,
 8,21],saturdai:21,resut:31,mdy:66,extract:[53,21,18,10],customserializerdeseri:43,network:[40,15],dst:[43,56],xxtajo:18,content:[14,64,49,62,9],millennium:21,got:9,free:49,standard:[50,59,21,8,27,49],md5:18,get_partial_result:17,angl:31,filter:[7,8],iso:21,fxyyyi:21,mvn:[54,49,62],rang:[31,14,39],independ:45,rank:61,system:[40,55,34,62],restrict:[31,21],instruct:[5,3],alreadi:[36,42,18,40,30],tpch:[25,67,10],primari:[40,32],cartesian:7,rewritten:33,xii:21,master:[16,55,62],too:45,json_arrai:53,listen:[54,55],namespac:54,tool:[47,10],inexact:27,target:[31,46,18,9,54,40,62,49],keyword:[42,7,24],provid:[14,15,54,17,40,59,52,3,39,5,8,62,33,49,68],expr:7,tree:[65,49,33],mmdd:21,project:[59,45],minut:[5,49,21],ran:62,mind:21,manner:54,script2:17,val2:[63,8],thoma:18,current_d:21,though:33,usernam:[47,49,62],object:[47,42,44],microsecond:21,letter:18,phase:23,doi:21,don:[25,54,67,34,9,47,49],doc:10,binaryserd:24,doe:[9,54,56,21,40,7,43,45,64,42,30],declar:33,umbil:[40,55,6],dow:21,pope:21,
 random:31,syntax:[7,68],identifi:[36,7,18,62,21],involv:33,absolut:[31,49,62,10],row_num:[7,68],submit:[25,49,40],layout:[42,19],explain:[54,55,22,7,43,19,49],apach:[5,9,3,62,49],geoip_country_cod:3,search_condit:7,fmmonth:21,stop:[40,2],ceil:31,amazon:[36,42],bar:[18,43],emb:36,method:[14,18,67],executor_hash_join_size_threshold:63,respond:5,l_receiptd:25,memstor:62,num:[57,7,43,12],mandatori:47,result:[14,17,33,9,45,56,21,30,40,7,10,49,68],respons:[13,38,59,9,2,33,49],extlib:36,best:[33,43],subject:7,awar:[5,47,12],heterogen:[42,44],figur:17,score:[13,38,22,42,24,45,47,49,43],approach:67,accord:[27,7,43,68,33],extend:65,extens:15,toler:[59,43],fault:59,howev:[33,45],against:49,logic:[8,19],countri:[3,21],com:[40,55,3,30],split_part:18,guid:10,assum:[38,23,49,12,21],nonsens:21,three:[33,24,62,21],been:10,trigger:40,datanod:12,basic:[14,59,33,43,67,24],c_mktsegment:67,tini:27,suppress:21,xxx:[30,10],worker:16,ani:[61,54,53,45,40,7,8,62,10,47,30,68,43],lpad:18,"catch":54,emploi:59,id
 ent:21,geoip:3,servic:[16,55,62],properti:[14,32,17,34,40,9,55,3,5,62,66,6,12],cli_max_column:63,calcul:[7,18],alias_nam:7,udaf:17,conf:[34,32,44,40,36,55,3,57,56,5,62,9,33,47,49,12],march:21,sever:[33,68,62],pemiss:43,perform:[25,47,7,68,33],suggest:49,complex:[7,21],isodow:21,complet:[40,30],jkl:49,rais:31,dskiptest:[54,49,62],kim:9,squar:31,thu:[5,33,49,43],inherit:[22,43],to_numb:21,client:[14,9,55,40,62,25,6],shortli:65,thi:[5,7,8,9,13,14,11,18,21,24,25,28,30,49,34,36,40,64,43,19,45,47,67,33,53,54,55,56,62],roma:21,gzip:45,left:[33,7,18],protocol:49,just:[40,7,8,62,63,28,67],dist_query_groupby_task_volum:63,dtar:[54,49,62],yet:[33,23],languag:[59,14,49,25],jose:18,easi:[67,39],pdist:[54,49,62],backup_and_restor:10,expon:31,applic:7,preserv:40,bzip2codec:64,bushi:33,background:[14,48],database_nam:[57,64],u0001:[42,43],specif:[27,32,46,40,21],arbitrari:68,manual:[22,62],timetz:27,underli:47,right:[33,7,18],interv:[40,21],intern:[56,34],"52nd":21,cnt:[17,7,68],insensit:8,multipli
 :21,tracker:[40,55,6],condit:[33,7],foo:18,localhost:[57,25,55,40,64,62,6],concat_pi:17,core:[47,66,12],who:[33,43],uncompress:[24,45],character_length:18,corr:50,peer:6,rcfile:[14,58],dist_query_join_partition_volum:63,total2:7,simul:40,"float":[31,50,17,42,22,23,24,45,27,47,49,43],encod:[18,45],bound:68,down:[8,49],storag:[14,32,9,67,62,49],jdbc:[5,62,14],wai:[9,56,21,40,43,67],support:[15,32,67,62,21],avail:16,width:21,editor:[40,55],fraction:21,o_custkei:[68,10],creation:[25,62],form:[32,22,56,33,7,43],forc:[7,30,21],drwxr:28,compressiontyp:24,l_comment:[25,64],"true":[25,3,40,8,62,45,27,47,12,24],reset:17,l_discount:[25,7],vatican:21,trim:18,nnn:18,adopt:33,semicolon:[28,38],tajocli:[40,56],exist:[46,57,9,53,22,64,30],executor_inner_hash_join_size_threshold:63,successfulli:[20,25,17,40],floor:31,when:[17,33,25,9,21,40,7,62,45,64,46,65,49],getstr:54,role:36,hh12:21,test:62,node:[17,55,40,62,65,12],intend:21,consid:[40,56,33],longer:18,abscissa:31,carriag:43,jsonpath:53,ignor:[43
 ,12,21],time:40,backward:12,ojdbc7:62,concept:[54,21],skip:[43,30,21],global:[33,56,21],stddev_pop:50,boolean_express:7,row:[13,50,38,61,33,25,45,9,56,22,7,24,62,10,42,43,49,68,8],millisecond:21,depend:[5,8,40],zone:[14,66,27,21],decim:[27,21],intermedi:[33,17],json_extract_path_text:53,hadmin:40,drivermanag:54,jvm:[40,12],sql_languag:10,sourc:[29,18,62,21],string:[15,53,3,21,34,29],word:[18,56,21,22,43,12],hdfs_locat:22,exact:27,did:21,"12th":21,item:[28,17,8,21],sine:31,div:31,tajo_hom:[34,57,54,55,40,62,33,47,49],dir:[46,17,55,12,42],prevent:40,templet:34,sign:[31,8],long_table_name_1234:7,cost:[59,33,52],port:[32,62,57,20,9,54,55,40,44,47],addr:[3,62],current:[32,54,17,61,40,25,45,65,39,21,57,5,7,8,62,10,64,33,58,68,12],deriv:7,gener:40,coeffici:50,stmt:54,tangent:31,address:[9,55,3,40,42,62,27,6],wait:40,shift:21,behav:7,commonli:43,semant:68,regardless:[22,25,33,45],repositori:49,modul:[14,34],msck:5,output_typ:17,instal:[17,3,62,49],num1:31,memori:[40,62],connector:[5,62],han
 dler:36,msk:5,tajo_pid_dir:40,capit:21,claus:[14,9,33,23,8,27,49],ojat:18,templat:[36,62,21],prepar:[5,49,62],timestamptz:27,cat:[13,40,55,49,67],countpi:17,"02b0e20540b89f0b735092bbac8093eb2e3804cf":18,purpos:[5,34],fmss:21,nearest:[31,21,10],l_orderkey_idx:25,l_shipinstruct:25,backslash:[21,18,10],occur:[9,21,22,64,43,7],alwai:[25,21],sundai:21,multipl:[17,33,56,21,40,7,43,68,12],haadmin:40,write:[17,56,21,22,42,24,45,43],purg:[9,64,30],c_address:67,ordin:[31,21],map:27,product:7,atan:31,max:[50,43],clone:[11,49,62],"4th":21,date:67,shuffl:33,underscor:8,data:[40,55,62],favorit:[40,55],predic:[64,14,51,23,33],inform:[44,33,25,21,40,7,62,10,64,42,47,66,68],preced:[3,21],combin:7,hh24:21,ghi:49,columnarserd:22,midnight:21,still:[40,11],ieee:27,dynam:59,entiti:40,mapr:24,disconnect:[63,40],monitor:40,new_table_nam:30,main:[59,9,54,8,34],non:[33,21,7,18,45],synopsi:[14,9,64,8,7,30],add_month:21,col2:[46,8,30],col3:[9,46,30],initi:40,nation:[17,10],therebi:33,now:[49,45,21,22,10,63,67]
 ,nor:8,introduct:14,hive_jdbc_driver_dir:[5,62],name:[3,5,7,10,25,12,13,17,21,22,24,9,27,33,30,32,34,36,6,49,42,43,44,45,47,48,67,40,54,55,56,57,62,63,64,66,68],reoptim:59,revers:18,separ:[43,38,7,24,21],januari:21,quarter:21,tajo_worker_heaps:12,compil:[49,62],domain:[40,55,8,43],replac:[18,21],individu:7,current_tim:21,significantli:33,year:[7,21],shown:21,space:[18,44,21],o_orderkei:10,profil:5,hivemetastor:[5,62],lag:61,partit:[5,52,61,14],git:62,org:[11,22,36,54,30,5,42,24,62,10,64,47,49,43],"byte":[18,45,33,10,27,49],card:23,care:[43,21],suffici:25,p_id:13,catalog:1,codegen:63,turn:33,place:10,standbi:40,think:49,str1:18,origin:9,directli:[11,54,5,23,43,65],onc:[17,25,3,40,7,44,42,47],arrai:[53,8],o_orderd:10,"long":[59,33,7,21],open:59,given:[46,18,9,53,3,21,57,56,7,8,10,64,27,47,49,43],stddev_samp:50,paramt:13,l_partkei:[64,46,7,9,25],especi:[27,42,44,33],copi:[36,34,62],specifi:[3,5,7,8,12,17,18,20,21,22,24,27,28,30,32,9,57,42,43,45,46,47,49,33,53,54,56,62,68],github:49,enc
 los:[7,68],tajo_password:47,mostli:22,than:[13,31,46,18,33,9,21,5,7,8,49],serv:40,wide:33,serd:22,posix:8,balanc:59,posit:65,argument:[31,38,18,53,21,7,10,28,29,68],maxmind:3,engin:[65,11],techniqu:[59,33],partsupp:10,note:[17,8,62,21],take:[5,7,49,33],xxxxxx:62,begin:[21,10],c_nationkei:67,buffer:[49,45],price:[23,68],compress:[14,30],deflatecodec:64,pair:[50,22,24,34],renam:14,later:49,quantiti:[7,68],link:[25,49],axi:31,clientport:9,show:[20,54,62,10,63,49],threshold:33,ship_dat:23,xml:16,onli:[34,32,18,33,65,39,21,22,7,24,62,45,64,49,43],explicitli:[33,7,34],"500mb":12,activ:40,written:[22,56,24,43],l_suppkei:25,table_space_nam:44,"53rd":21,variou:[63,36,19,21],get:[40,17,62,21],client_session_expiry_tim:63,allocat:12,repo:[11,49,62],cannot:[33,17,43],java_hom:49,progress:[13,38,20,9,2,59],ssd:44,requir:[38,21,40,42,7,49],table_refer:[33,7],item_nam:23,borrow:8,c_custkei:67,list_endpoint:47,where:[14,17,18,9,55,33,23,8,62,64,27,49,12],calendar:21,concern:[67,34],detect:40,enough
 :62,ddsp:21,between:[50,8],"import":[33,54],across:[55,7,68],parent:49,executor_groupby_inmemory_hash_threshold:63,hadoop_hom:[47,55,49],gregorian:21,decimaln:10,region:[47,10],gzipcodec:64,groupbi:14,compressioncodec:[22,43],improv:[33,45],among:33,acceler:33,jdbc4:62,pow:31,"4028235e":27,featur:[5,25,52,9,14],xzvf:[54,49],date_ord:63,invers:10,dist_query_broadcast_join_threshold:[63,33],derbystor:[40,62],those:[22,42,17,43,45],"case":[34,18,56,21,22,24,62,30,8],cast:[14,21],invok:40,new_column_nam:30,column_family_nam:9,advantag:45,ctrl:[40,55,49],cluster:[16,62],warehous:[59,9,42,44,64,28,30],abcdef:18,ascii:18,"__init__":17,develop:[14,49],regionon:47,alphabet:18,same:[31,50,61,17,40,9,3,21,5,7,8,33,47,68],binari:[14,18,62,65,29,49],epoch:21,html:10,pad:[18,21],week:21,finish:40,nest:45,driver:[5,62,14],decompress:[49,45],tajo_classpath:[47,62],mani:[22,56,12,10],extern:[14,9,49,22,23,64,67,47,30],appropri:[49,34],without:[38,59,36,21,33,23,43,62,7],fmmm:21,lc_time:21,fmmi:21,ex
 ecut:[40,55,12],rest:[7,18],bitmap:52,kill:[20,40],speed:33,inet4:[27,3],struct:[36,44],except:[54,7,68,21],littl:55,desktop:9,blog:9,codec:[22,64,43,42,30,24],blob:[27,17],versa:22,overview:14,pgpgpgpg:18,disrupt:40,real:31,read:[65,55,49,45],period:[40,21],swiftnativefilesystem:47,mon:21,world:[33,17],pst:[43,56],mod:31,mysqlstor:62,integ:[31,21,61,43,10,27,29,12],server:[14,62,40,34,47,49],query_succeed:49,benefit:39,either:[53,5,7,8,45,27,49],last_valu:[50,61],output:[17,9,21,7,24,46,68],tajo:[16,67,62],result_set_fetch_rownum:63,yyyi:21,ascend:7,tajowork:[40,34,12],json_path:53,definit:[14,25,51,21],exit:2,ddl:[49,67],blocksiz:47,power:[31,8],inspect:48,broken:43,starttim:20,l_tax:[25,68],regexp:8,"throw":54,comparison:[27,8],central:40,choi:9,aco:[31,10],degre:[31,55],yyyymondd:21,table_nam:[5,64,67,9,30],effici:[25,11,45],lastli:62,defaultport:62,yyi:21,your:[32,17,34,22,36,54,55,9,21,5,43,62,45,67,66,49,40],rowkei:9,hex:18,overwrit:40,start:[40,55,17,18,21],current_databas:6
 3,interfac:[40,48,43],ipv4:[27,3],lot:[33,15],tupl:[25,17,65],untar:49,jun:21,tajoxx:18,index_en:25,max_output_file_s:63,notat:33,possibl:[33,7,12,21],ddth:21,bucket:42,day_of_week:21,embed:[18,62],expect:[25,21],creat:[55,49,62,67],multibyt:18,certain:[22,46,43,9,45],strongli:47,file:[16,67],oraclestor:62,fill:[54,18,21],incorrect:40,denot:8,sort_expr:7,tinyint:27,prepend:18,field:[43,21,42,18,10],valid:21,rdbm:[36,54,19],you:[33,2,3,5,7,8,9,10,11,12,13,38,17,21,22,23,24,36,28,30,49,32,34,25,40,42,43,44,45,46,47,67,57,54,55,56,62,64,66],polar:31,sequenc:[8,68,18],symbol:13,text_nul:63,briefli:7,tajomast:[16,55,62],hyunsik:[9,67,10],descript:[20,6,21,40,8,62,10,27,47,66,49,12],tajo_master_heaps:32,index_support:11,cpu:12,unset:[63,10],tajodriv:54,represent:[21,29,18,45],all:[3,5,7,8,10,17,20,21,9,30,49,36,40,42,43,19,67,50,54,55,56,62,63],dist:[33,54,49,62],month:21,correl:50,abil:40,mno:49,follow:[33,2,3,5,7,8,9,10,21,12,13,38,17,20,49,22,23,24,25,27,28,32,34,36,39,40,42,43,44,45,4
 6,47,67,57,54,55,56,11,58,62,63,64,66,68],disk:[65,3,12],init:49,program:[34,45],thursdai:21,liter:[14,34,21],fals:[27,25,8,3,45],util:[25,48],worst:59,fall:[7,21],expression1:50,expression2:50,list:[17,40,20,55,56,5,7,8,10,23,49,68],helloworld:17,adjust:[32,56,21,22,42,43,45,12],cosin:[31,10],small:[33,27,25,45],tmmonth:21,ten:49,past:21,zero:[21,8,18],design:[59,23,34,45],pass:7,val3:63,further:43,val1:[63,8],what:21,abc:[49,8,18],clock:21,section:[11,22,36,54,55,21,5,43,19,9,47,49,12],abl:[5,9],abbrevi:[56,43,21],version:[49,62,10],consecut:33,to_dat:21,"public":54,zookeep:9,full:[33,7,21],hash:[14,18],valn:8,initcap:18,zong:56,strong:67,modifi:[36,21],valu:[31,14,32,61,17,18,34,40,9,53,55,3,21,5,66,50,62,11,29,30,12],search:[14,11,18,65],cli_print_error_trac:63,table_backup:67,amount:40,behavior_arithmetic_abort:63,codebas:49,via:[40,55],data_typ:[9,64,30],primit:27,transit:40,filenam:57,unbias:50,select:[13,31,38,17,18,52,20,9,53,54,3,21,33,56,7,8,10,46,29,49,68],hexadecim:29,l
 _extendedpric:[25,7,68],distinct:[7,21],etc:[47,48],regist:[14,17],two:[34,33,39,67,22,24,44,65,21,49,68,8],toggl:21,more:[13,38,44,52,25,55,21,5,68,7,8,62,45,64,42,33,47,49,12],flat:[22,24,45],discompress:49,function_nam:68,flag:47,known:23,endpoint:47,hour:21,formatha:40,dev:3,histori:40,orderbi:14,archiv:[49,62],learn:[42,49,56],def:[17,49],bewtween:27,prompt:[57,38,10],to_char:[29,56,21],num2:31,scan:[5,9,14],share:[54,22,47,7,62],accept:[43,56],tabular:43,minimum:[50,12],goal:59,divid:[31,7,21],anoth:[40,68],divis:31,n_name:17,csv:49,simpl:49,swift_tabl:47,blockcompresswrit:24,jline2:2,resourc:[40,55,6],seoul:[42,43,56],resultset:54,json_array_length:53,varianc:50,associ:33,"short":[22,7],author:9,caus:[40,21],atan2:31,help:10,pseudorandom:31,through:5,paramet:[31,14,18,53,3,21,22,42,43,45,64,50,29,61],style:8,late:21,alter:[5,51,14],good:[33,19],"return":[31,50,17,18,53,3,21,33,8,29,30,61,43],timestamp:[50,9,56,21,42,43,27],o_orderstatu:[68,10],ssss:21,framework:45,mtizxdawmfw
 wmd:18,get_final_result:17,utc_usec_to:[21,10],serde2:[22,24],easili:[40,54,55],token:47,radian:31,found:28,unicod:[27,18],truncat:[31,18],unequ:40,procedur:49,connect:[57,54,5,62,10,63],o_clerk:10,"try":[40,54,57],csvlineserd:43,print:21,proxi:47,advanc:[59,7],asc:[64,25,7,68],base:62,asf:[11,49,62],put:[13,9,56,21],fridai:21,refer:[3,7,10,17,22,24,9,25,33,64,43,44,45,11,47,49,54,55,56,42,66,68],thrown:30,launch:62,omit:[22,21,7,61,10],round:[31,10],perman:65,feed:43,meridiem:21,upper:[18,21],feel:49,exchang:33,applciat:54,number:55,done:[49,21],unhealthi:40,blank:21,differ:[9,56,21,33,7,8,44,42,30,43],script:[17,49,34],interact:[59,57,49],construct:[7,21],saint:21,twenti:21,scheme:[36,32,49],store:[13,44,22,59,25,9,5,42,24,62,10,65,43,47,49,12,40],schema:[46,19,25,45,23,9,10,48,49],option:[13,20,25,21,57,7,43,9,64,67,49],part:[21,10],pars:43,start_index:18,kind:[65,7,43],remot:55,remov:[18,9,49,64,62,30],l_orderkei:[46,9,64,25,7,68],str:17,comput:[33,47,7,21],packag:54,"null":[25,
 53,54,22,64,61,42,7,68],catalogstor:40,equival:[46,7,9,21],self:17,also:[44,33,36,56,21,40,7,8,62,10,63,23,43,47,49,24],tmpdir:12,brace:13,distribut:62,exec:24,previou:[8,21],mixtur:21,most:[33,42,43,62],plai:36,plan:[59,36,23,43,33],metacharact:8,model:[14,17,51],appear:7,quorum:9,filesystem:49,clear:10,salari:7,classnotfoundexcept:54,clean:[54,49,62],window_definit:68,jaehwa:9,session:[14,33,48,56,10],find:[40,33,65],access:[40,9,54,55,5,45,33,47],copyright:10,solut:33,fmhh:21,ymd:66,l_quantiti:[46,7,68,9,25],query_run:20,express:[50,14,18,21,64,51,12],nativ:33,strposb:18,hbase_table_nam:9,statist:40,sum_pi:17,bytea:27,set:62,startup:57,see:[44,36,55,9,21,62,25,47,49,12],arc:31,sec:[13,38,20,9,2,62,49],arg:[20,54],float4:[27,25,10],close:54,unqualifi:[23,7],particip:33,smallest:[31,45],subdir:46,"\u02c6ab":18,altern:[8,62],numer:21,fsshell:28,add_dai:21,outfil:67,popul:50,both:[18,40,59,22,7,24,61,43],last:[50,18,25,21,64,61,7,68],"85e7":21,c_comment:67,roman:21,snativ:47,context:
 21,load:[59,9,49,30],simpli:[25,49],point:[22,53,18,40,21],hbase_hom:9,header:[22,43],param:[13,57,7],shutdown:40,suppli:21,transitiontobackup:40,cathedr:21,becom:[40,56,21],java:[34,54,56,5,8,62,27,49],due:12,empti:[22,7,43],sinc:[22,62,21],l_linestatu:25,exercis:49,iddd:21,gap:61,tajojdbccli:54,coordin:31,understand:[17,19],func:7,repetit:[8,18],xa2:9,iyi:21,tajoresourcemanag:40,durat:62,n_regionkei:17,"while":[33,54,21],behavior:7,error:[9,43,64,30,21],script1:17,earli:[33,21],key1:63,tbname:10,itself:[40,68,10],centuri:21,grant:62,belong:7,shorten:62,hadoop:[14,59,9,55,49,64,8,34,30],decod:18,octal:18,conflict:40,higher:49,varbit:27,lineitem:[46,20,25,10,7,9,64,68],x84:9,optim:[59,14,52],fornam:54,moment:[43,45],user:[40,32,62,12],tsql:[14,56,49,67],chang:[54,55,49,33,62,10,30],lower:[18,21],sha1:18,lib:[47,62],entri:[9,64,55,40],parenthes:[7,8,68],udf1:17,expens:33,explan:49,shape:33,openstack:[36,14],snappi:45,all_backup:67,disk1:12,disk2:12,disk3:12,shortcut:28,appli:[40,33,2
 1],input:[31,50,17,18,21,33,61],subsequ:[65,21],euler:31,bin:[13,38,40,2,55,57,67,5,62,49],complaint:21,varchar:27,format:[40,29],big:9,subfield:21,register_d:9,bit:[27,18],characterist:19,table2:30,table1:[13,38,54,56,30,22,7,24,45,42,43,49,8],collect:24,"boolean":[27,7,3,45],l_commitd:25,often:43,order_d:23,createstat:54,"1st":21,some:[14,34,22,9,2,42,56,21,5,7,43,62,45,27,49,68],back:40,sampl:50,mirror:49,tablespac:[36,19,14],scale:59,id4:33,id2:[33,30],id3:33,per:[14,55,12,40],id1:33,bst:[25,65],substitut:[36,18],machin:[40,42,57],o_shipprior:10,run:[40,55],dist_query_table_partition_volum:63,hive_hom:[5,62],step:[25,47,49],"15gb":12,subtract:21,varbinari:27,manag:[14,9,39,49,5,62,30],regular:18,"1gb":[32,12],block:[65,24,45],executor_outer_hash_join_size_threshold:63,repair:5,primarili:21,within:[40,21,33,7,28,61],ensur:[49,62],megabyt:12,textual:18,custom:[14,67,62],arithmet:[14,7],includ:[15,7,62,21],unix_timestamp:21,metastor:5,record:[8,22,24,45,30,43],properli:[17,18],int4
 :[31,46,18,53,10,27,17,29],int1:27,translat:[56,21],select_stat:64,int2:27,l_shipdat:[25,7,68],line:[55,56,40,43,47,48],int8:[31,50,46,25,53,10,27,29,67,61],info:[20,9,6,40],utc:[56,43,21],utf:18,consist:[34,21,22,7,43,19,65,68,24],blrunner:9,sum:[13,50,38,17,7,68],"export":[9,5,62,47,49,12],impl:47,constant:[31,68],doesn:[5,53,30,9],repres:[21,33,42,43,44,47],"char":[27,18,21],qualifier_nam:9,home:[5,9,49,62,67],titl:9,hiveql:5,debug_en:63,bracket:[33,8],servicenam:62,ecosystem:45,exp:31,jhkim:9,introduc:14,eval:17,join_typ:33,algorithm:[22,43,12,45],vice:22,first_valu:61,hixyx:18,json_array_contain:53,hello:[17,21],code:[17,3,62,18],"900150983cd24fb0d6963f7d28e17f72":18,queri:[40,62,12],dist_query_join_task_volum:63,base64:18,executor_external_sort_buffer_s:63,keyston:47,volum:[25,49,9,10],implicitli:7,dbname:10,recordcompresswrit:24,evn:47,hive:62,unquot:10,date_part:21,dealt:7,ddd:21,pleas:[3,7,12,17,21,22,25,49,36,33,64,43,44,45,11,47,67,54,55,56,42,68],smaller:[9,46],natur:[33
 ,7],uniqu:63,fold:18,download:3,click:49,append:18,compat:[14,67,12],index:[14,53,18,52],compar:27,cell:9,c_phone:67,"19th":21,experiment:14,can:[19,5,7,8,10,12,13,14,17,21,22,23,24,9,28,30,34,25,40,42,43,44,45,11,47,48,49,33,54,55,56,62,64,68],showmast:20,return_on:17,let:[42,24,30],authenticaiton:47,o_orderprior:10,vertic:43,implicit:33,convert:[31,18,3,21,40,29,68],aaabc:8,weekdai:21,larger:[27,33,7,45],typic:[17,7],control:40,cbrt:31,approxim:27,api:[5,25,14],namenode_hostnam:32,wip:[11,49,62],join_condit:33,from:[31,14,17,18,9,53,67,40,65,21,49,61],c_acctbal:67,doubl:[18,21],next:[36,21,54,5],few:34,chr:18,usr:62,remaind:31,sort:[9,7,68],src:[54,49,21],mismatch:14,trail:[18,21],name2:63,name3:63,name1:63,retriev:[25,56,11,18,21],alia:[31,27,7,18,10],annot:17,thin:62,parquet:[14,58],employe:42,tar:[54,49,62],process:[14,11,59,56,21,22,23,43,45,48],high:16,tab:43,tarbal:40,tan:31,concatnen:18,isoyear:21,instead:[56,21,57,43,62,49,61,8],sin:31,transitiontoact:40,ltrim:18,jinho:9,o
 _com:10,getstat:40,physic:[55,19],essenti:40,cli_print_paus:63,correspond:[22,7,65],element:[40,53,34],issu:14,column_refer:8,writ:43,allow:[13,32,22,36,55,9,21,30,5,56,7,43,44,45,64,42,33,49,12],least:[7,8],move:49,comma:[7,43,21],outer:[33,7],chosen:33,decad:21,therefor:[40,21],crash:40,greater:31,handl:[33,54],spell:21,dai:21,auth:47,mention:22,lzo:45,quorum2:44,quorum1:44,mode:62,cluster1:44,consum:45,meta:[14,9,56,62,48,49],"static":54,our:43,special:[42,43],out:[17,12],variabl:[14,32,34,33,9,56,5,62,10,27,48,49,12],hbasetablespac:36,var_pop:50,suitabl:18,math:15,common:[14,7,33],shut:49,insid:30,manipul:63,standalon:49,dictionari:45,l_shipmod:25,tenant:47,joined_t:33,could:21,keep:21,length:[27,53,18,21],timezon:[56,42,43,63,66,30],suffix:21,resourceconfigur:12,mai:[38,34,33,21,40,7,62,49],quote_id:18,t_timestamp:[42,56],unknown:[25,9],licens:10,mkdir:[28,55,49],capac:[55,12],termin:43,bit_length:18,"final":[17,54,5,62,65,47,49],inner:[33,7],mysql_jdbc_driv:[5,62],shell:[14,49
 ,34,9],grouping_column_refer:7,udf:17,rtrim:18,exactli:8,haven:23,prune:14,split:[47,18],structur:[11,64],charact:[18,42,21,22,23,8,27,68,43],float8:[31,50,46,10,21,27,17,67],textserd:24,julian:21,fail:43,have:[14,32,33,9,21,5,64,62],tabl:[49,62,67],need:[19,22,9,54,21,5,24,62,45,67,47,49,40,43],json_array_get:53,cli_null_char:63,min:[50,12],mix:21,builtin:36,which:[7,15,18,59,21,22,24,65,33,30,9,40,64,43,49,57,54,56,62,63,42,68],singl:[14,33,55,21,40,42,8,19,45,48,68],lineitem_100_snappi:64,unless:[5,21],preliminari:16,l_returnflag:25,deploi:40,"class":[17,5,36,54,22,8,62,43,24],url:[32,47,54,19],request:12,uri:[62,36,40,42,44,47],snapshot:[49,62],determin:[66,53,7,12],querymast:[40,12],text:[3,8,14,17,18,21,22,23,24,9,27,29,30,49,25,40,42,45,47,67,50,53,55,58,64],locat:[46,18,44,54,3,67,22,56,42,43,62,30,64,47,49,12],postgresqlstor:62,jar:[36,47,54,62,5],should:[3,5,25,12,17,21,22,23,9,49,32,36,57,64,43,44,45,67,54,55,56,62,42,66],jan:21,suppos:33,local:[62,3,12,21],cube:31,famili
 ar:[22,43,45],disagre:21,tbl:47,increas:55,l_linenumb:[25,68],enabl:[14,55,40],grtajo01:20,"default":[40,16,55,34,62],integr:62,dist_query_sort_task_volum:63,contain:[17,18,54,55,21,40,64,47],view:19,dhadoop:49,legaci:3,frame:7,knowledg:43,n_nationkei:17,rlike:8,statu:40,correctli:[27,49],t_date:[42,56],pattern:[14,18,21],to_timestamp:21,cli_print_pause_num_record:63,xyxhi:18,theta:31,neither:8,kei:[13,33,9,53,39,21,22,23,24,65,63,64,30],otherwis:[57,21,7,3,8],group:[7,8,68,45],swift:[36,14],addit:[46,56,33,7,8,44,68],plugin:14,admin:[20,10],equal:[9,33],april:56,instanc:[32,36,55,42,44,49],fmyyyi:21,english:21,arriv:9,chmod:55,rpc:[40,54,55,6],respect:[27,8,61],tuesdai:21,quit:10,compos:[23,45],compon:40,json:15,besid:43,sequecnefil:24,columnar:[22,45],cli_output_formatter_class:63,togeth:21,present:[49,10],delimit:[17,18,25,56,49,42,43,64,47,30],replic:33,bye:49,implementaion:32,plain:[22,24,43],octet_length:18,rectangular:31,wild:23,lazybinarycolumnarserd:22,textserializerdeseri:
 [22,24],layer:32,demo:47,site:16,bigint:[27,64],avgpi:17,avg:[50,68],to_hex:29,"35b":49,classpath:[14,9],cross:33,sqrt:31,python:15,zookeeper_address:9,largest:31,http:[11,3,6,40,62,10,47,49],hostnam:[32,54,55,57,42,62],geoip_in_countri:3,column_nam:[9,64,30],col1:[9,46,8,30],off:21,well:[46,9,21,33,64,27],exampl:[40,55,67,62],command:[14,9,56,49,5,48,67],choos:49,usual:[43,34],less:[31,21],percent:8,tcp:57,current_timestamp:21,auth_:47,simultan:12,web:[59,40],add:[14,34,40,9,54,55,5,62,66,49,12],host2:[40,55],host1:[40,55],work1:10,match:[14,27,18,21],gmt:[30,56],int32:47,iyyi:21,workload:12,five:5,know:[55,56,21,42,44,7,49],xe2:9,createdatabaseifnotexist:62,password:[47,62],desc:[20,64,7,68],insert:40,storage_typ:64,resid:[49,30],like:[32,54,23,49,21],lost:30,necessari:[59,18],page:[14,55,45],another_long_table_name_5678:7,linux:10,queryid:20,yyyymmdd:21,proper:[32,49,12,62],guarante:40,peter:21,librari:9,tmp:[28,32,49,62],leaf:65,lead:[23,18,61,21],avoid:[59,9,2,21,40,64],estim:5
 2,zookeeper_client_port:9,blog_backup:9,xtajoxx:18,ab_bc_cd:18,usag:[67,21],maven:[5,49],host:[62,57,20,55,40,44,66],although:21,offset:[43,61,56],empsalari:7,stage:[33,17,49],about:[44,25,64,19,42,68],actual:[14,9],dist_query_groupby_partition_volum:63,column:[14,9],statement:[13,54,46,18,57,20,9,45,56,30,22,7,8,10,64,42,43,49,24],disabl:14,own:[42,43,56],lazybinari:24,merg:17,val:63,pictur:10,q_1411357607375_0007:20,q_1411357607375_0006:20,"var":62,snappycodec:[22,64,43,42,30,24],count:[13,50,38,18,20,21,7,61,68],temp:28,whether:[22,7,8],wish:13,directori:62,below:[49,36,21,22,43,45,67],limit:14,dmy:66,problem:[40,2,33],executequeri:54,evalu:[17,61],btrim:18,"int":[31,50,18,42,21,22,23,24,45,27,49,43],dure:23,pid:40,novemb:21,implement:[14,15,36,21,10,47,49],"20000nov31":21,var_samp:50,boot:[49,62],detail:[20,45,55,21,33,7,62,10,47,49],other:[17,18,40,59,9,56,21,22,7,43,34,46,47,12],bool:27,futur:14,branch:[14,11],varieti:34,repeat:[18,21],row_numb:[7,61,68],jung:9,mondai:21,escap
 :18,strpo:18,rule:33,mariadbstor:62,select_list:7,two_level_bin_tre:[25,64,65],decemb:21},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","hive_integration","configuration/service_config_defaults","sql_language/queries","sql_language/predicates","hbase_integration","tsql/meta_command","index_overview","configuration/worker_configuration","tsql/execute_file","index","functions","configuration","functions/python","functions/string_func_and_operators","table_management","tsql/admin_command","functions/datetime_func_and_operators","table_management/rcfile","partitioning/column_partitioning","table_management/sequencefile","index/how_to_use","configuration/catalog-site-xml","sql_language/data_model","tsql/dfs_command","functions/data_type_func_and_operators","sql_language/alter_table","functions
 /math_func_and_operators","configuration/tajo_master_configuration","sql_language/joins","configuration/preliminary","table_management/compression","storage_plugin","faq","tsql/single_command","partitioning/intro_to_partitioning","configuration/ha_configuration","table_partitioning","table_management/table_overview","table_management/text","table_management/tablespaces","table_management/parquet","sql_language/insert","swift_integration","tsql","getting_started","functions/agg_func","sql_language","index/future_work","functions/json_func","jdbc_driver","configuration/cluster_setup","time_zone","tsql/intro","table_management/file_formats","introduction","tajo_client_api","functions/window_func","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","Hive Integration","Cluster Service Configuration Defaults","Queries","Predicates","HBase Integration","Meta Commands","Index (Experimental Feature)","Worker Configuration","Executing Queries from Files","Apache Tajo\u2122 (dev) - User documentation","Functions","Configuration","Python Functions","String Functions and Operators","Table Management","Administration Commands","DateTime Functions and Operators","RCFile","Column Partitioning","SequenceFile","How to use index?","The catalog-site.xml File","Data Model","Executing HDFS commands","Data Type Functions and Operators","ALTER TABLE","Math Functions and Operators","Tajo Master Configuration","Joins","Preliminary","Compression","Storage Plugin","FAQ","Executing a single command","Introduction to Partitioning","High Availability for TajoMaster","Table Partitioning","Overview of Tajo Tables","TEXT","Tablespaces","Parquet","INSERT (OVERWRITE) INTO","OpenStack Swift Integration","Tajo Shell (TSQL)","Getting Start
 ed","Aggregation Functions","SQL Language","Future Works","JSON Functions","Tajo JDBC Driver","Cluster Setup","Time Zone","Introducing to TSQL","File Formats","Introduction","Tajo Client API","Window Functions","Catalog Configuration","Session Variables","Data Definition Language","Index Types","The tajo-site.xml File","Backup and Restore Catalog","SQL Expressions"],objects:{"":{trim:[18,0,1,""],upper:[18,0,1,""],now:[21,0,1,""],to_bin:[29,0,1,""],acos:[31,0,1,""],to_char:[21,0,1,""],btrim:[18,0,1,""],regexp_replace:[18,0,1,""],cbrt:[31,0,1,""],date_part:[21,0,1,""],random:[31,0,1,""],split_part:[18,0,1,""],sign:[31,0,1,""],substr:[18,0,1,""],stddev_pop:[50,0,1,""],add_months:[21,0,1,""],right:[18,0,1,""],to_date:[21,0,1,""],quote_ident:[18,0,1,""],rpad:[18,0,1,""],tan:[31,0,1,""],avg:[50,0,1,""],extract:[21,0,1,""],digest:[18,0,1,""],to_hex:[29,0,1,""],var_samp:[50,0,1,""],first_value:[61,0,1,""],lead:[61,0,1,""],min:[50,0,1,""],ascii:[18,0,1,""],sum:[50,0,1,""],current_date:[21,0,
 1,""],json_extract_path_text:[53,0,1,""],stddev_samp:[50,0,1,""],char_length:[18,0,1,""],chr:[18,0,1,""],abs:[31,0,1,""],var_pop:[50,0,1,""],pow:[31,0,1,""],encode:[18,0,1,""],degrees:[31,0,1,""],bit_length:[18,0,1,""],pi:[31,0,1,""],sin:[31,0,1,""],row_number:[61,0,1,""],locate:[18,0,1,""],sqrt:[31,0,1,""],ltrim:[18,0,1,""],atan:[31,0,1,""],current_time:[21,0,1,""],max:[50,0,1,""],lag:[61,0,1,""],cos:[31,0,1,""],rtrim:[18,0,1,""],initcap:[18,0,1,""],json_array_length:[53,0,1,""],rank:[61,0,1,""],corr:[50,0,1,""],lpad:[18,0,1,""],strposb:[18,0,1,""],json_array_contains:[53,0,1,""],utc_usec_to:[21,0,1,""],geoip_in_country:[3,0,1,""],repeat:[18,0,1,""],md5:[18,0,1,""],count:[50,0,1,""],lower:[18,0,1,""],reverse:[18,0,1,""],asin:[31,0,1,""],ceil:[31,0,1,""],floor:[31,0,1,""],octet_length:[18,0,1,""],radians:[31,0,1,""],json_array_get:[53,0,1,""],atan2:[31,0,1,""],to_timestamp:[21,0,1,""],geoip_country_code:[3,0,1,""],add_days:[21,0,1,""],mod:[31,0,1,""],decode:[18,0,1,""],exp:[31,0,1,"
 "],div:[31,0,1,""],last_value:[61,0,1,""],round:[31,0,1,""],left:[18,0,1,""]}},titleterms:{code:[54,49],execut:[13,2,38,28,49],queri:[13,17,47,7,49],cross:7,scalar:15,session:63,permiss:55,mysql:62,openstack:47,hbase:9,classpath:54,languag:[51,64],paramet:13,xml:[26,66,34],oracl:62,zone:[42,56],how:[40,25,54,22,23,43,45],configur:[32,16,62,36,40,44,47,6,12],apach:[22,14,23,43,45],common:[47,42],window:[15,7,61,68],text:43,local:49,alter:30,match:8,build:[54,49],real:27,sourc:[54,49],synopsi:[20,57],string:[8,68,18],format:[58,21],python:17,faq:37,terminolog:40,background:2,introduct:[59,39],insert:[9,46],document:14,like:8,administr:[20,40],level:67,drop:[9,64,30],hive:[22,5,23,43,45],server:56,"default":6,mode:55,partit:[0,39,41,23,4,30],each:12,fulli:55,tajo:[14,32,40,66,54,55,6,22,42,34,60,47,48,49],manag:[42,19],failov:40,set:[13,54,55,30,40,66,49],dump:67,direct:54,dowload:49,meta:10,aggreg:[50,15,17],download:[54,49],hash:0,todo:[0,35,37,4,42,60,67],time:[66,42,56,21],out:49,c
 ompat:[22,23,43,45],index:[25,11,64,65],network:3,defin:[15,17],databas:[64,67],definit:64,per:47,launch:[40,55],state:40,experiment:11,directori:[55,12],get:[54,49],method:[64,39],math:31,integr:[5,47,9],qualifi:7,run:12,compress:[64,35,42],hivecatalogstor:62,usag:[20,13,9,10],serializerdeseri:24,base:55,prerequisit:[3,49],releas:49,swift:47,rcfile:22,valu:[13,27,43],postgresql:62,convers:21,plugin:36,column:[23,30],where:7,groupbi:7,datetim:21,gener:22,backup:[40,1,67],disabl:25,first:49,oper:[31,21,29,3,18],rang:4,via:49,overview:[36,33,7,42],tajomast:[40,32],number:[27,12],automat:40,date:[66,21],api:60,storag:36,size:[32,12],git:49,from:[13,54,7],memori:[32,12],data:[64,27,29,12],support:3,doubl:27,regist:36,system:66,overwrit:[9,46],custom:[36,43],avail:40,start:49,json:53,call:68,basic:[20,13,10],master:[40,32,6],type:[17,7,27,65,29,68],"function":[31,50,15,17,18,53,3,21,7,61,29,68],setup:55,shell:[57,48],claus:7,worker:[55,6,12],broadcast:33,rootdir:32,heap:[32,12],jdbc:54,u
 npack:49,join:[33,7],prune:23,restor:[1,67],provid:47,servic:6,properti:[22,43,42,30,45],maximum:12,dev:14,orderbi:7,cast:68,serd:24,limit:7,introduc:[57,24],parquet:45,tablespac:[42,44],similar:8,featur:11,file:[13,26,58,66,40],creat:[25,45,22,23,43,9,64],scan:25,process:2,registr:17,site:[26,66,34],indic:14,high:40,cluster:[40,56,55,49,6],liter:68,have:7,tabl:[14,9,42,56,22,41,23,43,19,45,64,7,30],serial:[22,43],work:52,check:49,issu:[22,23,43,45],decor:17,"null":43,built:15,make:55,ilik:8,when:22,hadoop:47,hdf:28,binari:54,add:30,exampl:[17,54,56,33,7,12],futur:52,env:34,test:40,writer:24,config:66,singl:38,enabl:25,variabl:63,express:[8,68],resourc:12,distribut:[54,55],preliminari:34,optim:33,enter:57,driver:54,catalog:[26,34,67,62],regular:8,temporari:12,user:[14,15,17],sql:[13,51,67,68],extern:42,mariadb:62,tsql:[57,48],parallel:12,physic:[22,43,45],derbi:62,handl:43,task:12,renam:30,read:22,predic:8,arithmet:68,alias:7,client:[54,60,56],command:[20,28,38,10],pattern:8,model:2
 7,sequencefil:24,order:33,latest:49}})
\ No newline at end of file

Modified: tajo/site/docs/devel/sql_language/sql_expression.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/sql_language/sql_expression.html?rev=1703095&r1=1703094&r2=1703095&view=diff
==============================================================================
--- tajo/site/docs/devel/sql_language/sql_expression.html (original)
+++ tajo/site/docs/devel/sql_language/sql_expression.html Tue Sep 15 04:42:36 2015
@@ -218,22 +218,47 @@
 <span class="n">expression</span><span class="p">::</span><span class="k">type</span>
 </pre></div>
 </div>
-<p>In addition, several functions are provided for type conversion. Please refer to <cite>:doc:data_type_func_and_operators</cite> and <cite>:doc:datetime_func_and_operators</cite>.</p>
+<p>In addition, several functions are provided for type conversion. Please refer to <a class="reference internal" href="../functions/data_type_func_and_operators.html"><em>Data Type Functions and Operators</em></a> and <a class="reference internal" href="../functions/datetime_func_and_operators.html"><em>DateTime Functions and Operators</em></a>.</p>
 </div>
-<div class="section" id="string-constants">
-<h2>String Constants<a class="headerlink" href="#string-constants" title="Permalink to this headline">¶</a></h2>
+<div class="section" id="string-literals">
+<h2>String Literals<a class="headerlink" href="#string-literals" title="Permalink to this headline">¶</a></h2>
 <p>A string constant is an arbitrary sequence of characters bounded by single quotes (<tt class="docutils literal"><span class="pre">'</span></tt>):</p>
 <div class="highlight-sql"><div class="highlight"><pre><span class="s1">&#39;tajo&#39;</span>
 </pre></div>
 </div>
 </div>
-<div class="section" id="function-call">
-<h2>Function Call<a class="headerlink" href="#function-call" title="Permalink to this headline">¶</a></h2>
+<div class="section" id="function-calls">
+<h2>Function Calls<a class="headerlink" href="#function-calls" title="Permalink to this headline">¶</a></h2>
 <p>The syntax for a function call consists of the name of a function and its argument list enclosed in parentheses:</p>
 <div class="highlight-sql"><div class="highlight"><pre><span class="n">function_name</span> <span class="p">([</span><span class="n">expression</span> <span class="p">[,</span> <span class="n">expression</span> <span class="p">...</span> <span class="p">]]</span> <span class="p">)</span>
 </pre></div>
 </div>
-<p>For more information about functions, please refer to <cite>:doc:functions</cite>.</p>
+<p>For more information about functions, please refer to <a class="reference internal" href="../functions.html"><em>Functions</em></a>.</p>
+</div>
+<div class="section" id="window-function-calls">
+<h2>Window Function Calls<a class="headerlink" href="#window-function-calls" title="Permalink to this headline">¶</a></h2>
+<p>A window function call performs aggregate operation across the <tt class="docutils literal"><span class="pre">window</span></tt> which is a set of rows that are related to the current row. An window function has the following syntax.</p>
+<div class="highlight-sql"><div class="highlight"><pre><span class="n">function_name</span> <span class="n">OVER</span> <span class="p">(</span> <span class="n">window_definition</span> <span class="p">)</span>
+</pre></div>
+</div>
+<p>where <em>function_name</em> is the name of aggregation function. Any aggregation function or window function can be used. For built-in aggregation functions and window functions, please refer to <a class="reference internal" href="../functions/agg_func.html"><em>Aggregation Functions</em></a> and <a class="reference internal" href="../functions/window_func.html"><em>Window Functions</em></a>.</p>
+<p><em>window_definition</em> has the following syntax.</p>
+<div class="highlight-sql"><div class="highlight"><pre>[ PARTITION BY expression [, ...] ]
+[ ORDER BY expression [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] ]
+</pre></div>
+</div>
+<p>In the above syntax, <em>expression</em> can be any expression except window function call itself.
+<em>PARTITION BY</em> and <em>ORDER BY</em> lists have the same syntax and semantics as <em>GROUP BY</em> and <em>ORDER BY</em> clauses.
+That is, <em>PARTITION BY</em> list describes how the output result will be partitioned like <em>GROUP BY</em> clause creates multiple partitions according to the value of its expression.
+With <em>ORDER BY</em> list, result values are sorted in each partition.</p>
+<p>Here are some examples.</p>
+<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">l_orderkey</span><span class="p">,</span> <span class="k">count</span><span class="p">(</span><span class="o">*</span><span class="p">)</span> <span class="k">as</span> <span class="n">cnt</span><span class="p">,</span> <span class="n">row_number</span><span class="p">()</span> <span class="n">over</span> <span class="p">(</span><span class="k">order</span> <span class="k">by</span> <span class="k">count</span><span class="p">(</span><span class="o">*</span><span class="p">)</span> <span class="k">desc</span><span class="p">)</span> <span class="n">row_num</span> <span class="k">from</span> <span class="n">lineitem</span> <span class="k">group</span> <span class="k">by</span> <span class="n">l_orderkey</span> <span class="k">order</span> <span class="k">by</span> <span class="n">l_orderkey</span><span class="p">;</span>
+
+<span class="k">select</span> <span class="n">o_custkey</span><span class="p">,</span> <span class="n">o_orderstatus</span><span class="p">,</span> <span class="k">sum</span><span class="p">(</span><span class="n">o_totalprice</span><span class="p">)</span> <span class="n">over</span> <span class="p">(</span><span class="n">partition</span> <span class="k">by</span> <span class="n">o_custkey</span><span class="p">)</span> <span class="k">as</span> <span class="n">price</span> <span class="k">from</span> <span class="n">orders</span><span class="p">;</span>
+
+<span class="k">select</span> <span class="n">l_linenumber</span><span class="p">,</span> <span class="n">l_tax</span><span class="p">,</span> <span class="k">sum</span><span class="p">(</span><span class="n">l_quantity</span><span class="p">)</span> <span class="n">over</span> <span class="p">(</span><span class="n">partition</span> <span class="k">by</span> <span class="n">l_linenumber</span> <span class="k">order</span> <span class="k">by</span> <span class="n">l_tax</span> <span class="k">desc</span><span class="p">)</span> <span class="k">as</span> <span class="n">quantity</span><span class="p">,</span> <span class="k">avg</span><span class="p">(</span><span class="n">l_extendedprice</span><span class="p">)</span> <span class="n">over</span> <span class="p">(</span><span class="n">partition</span> <span class="k">by</span> <span class="n">l_shipdate</span><span class="p">)</span> <span class="k">from</span> <span class="n">lineitem</span> <span class="k">order</span> <span clas
 s="k">by</span> <span class="n">l_tax</span><span class="p">;</span>
+</pre></div>
+</div>
 </div>
 </div>