Modified: tajo/site/docs/devel/partitioning/column_partitioning.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/partitioning/column_partitioning.html?rev=1650343&r1=1650342&r2=1650343&view=diff ============================================================================== --- tajo/site/docs/devel/partitioning/column_partitioning.html (original) +++ tajo/site/docs/devel/partitioning/column_partitioning.html Thu Jan 8 17:49:23 2015 @@ -183,15 +183,15 @@ <p>The column table partition is designed to support the partition of Apache Hiveâ¢.</p> <div class="section" id="how-to-create-a-column-partitioned-table"> <h2>How to Create a Column Partitioned Table<a class="headerlink" href="#how-to-create-a-column-partitioned-table" title="Permalink to this headline">¶</a></h2> -<p>You can create a partitioned table by using the <code class="docutils literal"><span class="pre">PARTITION</span> <span class="pre">BY</span></code> clause. For a column partitioned table, you should use -the <code class="docutils literal"><span class="pre">PARTITION</span> <span class="pre">BY</span> <span class="pre">COLUMN</span></code> clause with partition keys.</p> -<p>For example, assume there is a table <code class="docutils literal"><span class="pre">orders</span></code> composed of the following schema.</p> +<p>You can create a partitioned table by using the <tt class="docutils literal"><span class="pre">PARTITION</span> <span class="pre">BY</span></tt> clause. For a column partitioned table, you should use +the <tt class="docutils literal"><span class="pre">PARTITION</span> <span class="pre">BY</span> <span class="pre">COLUMN</span></tt> clause with partition keys.</p> +<p>For example, assume there is a table <tt class="docutils literal"><span class="pre">orders</span></tt> composed of the following schema.</p> <div class="highlight-python"><div class="highlight"><pre>id INT, item_name TEXT, price FLOAT </pre></div> </div> -<p>Also, assume that you want to use <code class="docutils literal"><span class="pre">order_date</span> <span class="pre">TEXT</span></code> and <code class="docutils literal"><span class="pre">ship_date</span> <span class="pre">TEXT</span></code> as the partition keys. +<p>Also, assume that you want to use <tt class="docutils literal"><span class="pre">order_date</span> <span class="pre">TEXT</span></tt> and <tt class="docutils literal"><span class="pre">ship_date</span> <span class="pre">TEXT</span></tt> as the partition keys. Then, you should create a table as follows:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">orders</span> <span class="p">(</span> <span class="n">id</span> <span class="nb">INT</span><span class="p">,</span> @@ -203,15 +203,15 @@ Then, you should create a table as follo </div> <div class="section" id="partition-pruning-on-column-partitioned-tables"> <h2>Partition Pruning on Column Partitioned Tables<a class="headerlink" href="#partition-pruning-on-column-partitioned-tables" title="Permalink to this headline">¶</a></h2> -<p>The following predicates in the <code class="docutils literal"><span class="pre">WHERE</span></code> clause can be used to prune unqualified column partitions without processing +<p>The following predicates in the <tt class="docutils literal"><span class="pre">WHERE</span></tt> clause can be used to prune unqualified column partitions without processing during query planning phase.</p> <ul class="simple"> -<li><code class="docutils literal"><span class="pre">=</span></code></li> -<li><code class="docutils literal"><span class="pre"><></span></code></li> -<li><code class="docutils literal"><span class="pre">></span></code></li> -<li><code class="docutils literal"><span class="pre"><</span></code></li> -<li><code class="docutils literal"><span class="pre">>=</span></code></li> -<li><code class="docutils literal"><span class="pre"><=</span></code></li> +<li><tt class="docutils literal"><span class="pre">=</span></tt></li> +<li><tt class="docutils literal"><span class="pre"><></span></tt></li> +<li><tt class="docutils literal"><span class="pre">></span></tt></li> +<li><tt class="docutils literal"><span class="pre"><</span></tt></li> +<li><tt class="docutils literal"><span class="pre">>=</span></tt></li> +<li><tt class="docutils literal"><span class="pre"><=</span></tt></li> <li>LIKE predicates with a leading wild-card character</li> <li>IN list predicates</li> </ul>
Modified: tajo/site/docs/devel/searchindex.js URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/searchindex.js?rev=1650343&r1=1650342&r2=1650343&view=diff ============================================================================== --- tajo/site/docs/devel/searchindex.js (original) +++ tajo/site/docs/devel/searchindex.js Thu Jan 8 17:49:23 2015 @@ -1 +1 @@ -Search.setIndex({envversion:46,terms:{"1st":17,represent:[17,35],all:[34,46,41,42,43,3,17,31,44,7,8,48,9,49,33,52,5,39],code:[3,48],dist:[42,39,48],c_name:52,rdbm:[42,34],queri:[31,48,10],global:[44,17],concern:[52,26],month:17,four:[45,17],prefix:[11,44,17],concept:[42,17],per:[49,31,43,10],abil:31,mno:39,follow:[2,3,5,7,8,9,10,11,29,14,46,17,18,19,20,39,23,22,25,26,30,31,33,35,52,40,41,42,43,44,45,48,49,50,51],disk:[3,10],row:[11,29,35,44,5,18,7,8,48,9,39,20],millisecond:17,content:[12,50,39,48],privat:42,complet:31,depend:[31,41,42,8],zone:[12,17,51,22,5],dist_query_join_task_volum:49,decim:[22,17],executor_external_sort_buffer_s:49,init:39,hadmin:31,present:[39,9],jvm:31,skip:17,locaion:44,sql_languag:9,thursdai:17,"case":[26,15,42,44,17,18,8,48,20],digit:[22,17],sourc:[48,17],everi:[31,51,7],string:[13,3,26,17],fals:[22,8,3,35],"void":42,ddl:[39,52],csvfile:5,varchar:22,util:38,volum:[39,9],configuration_default:42,failur:31,veri:[43,8,39],affect:[44,48,10,17],implicitli:7,hdfs _locat:18,exact:22,dbname:9,tri:42,recordcompresswrit:20,executor_inner_hash_join_size_threshold:49,did:17,"12th":17,list:[46,41,43,44,31,19,8,9,7,39],scalar:[7,35],hive:[12,41,48],"try":[31,42,40],date_part:17,interfac:[31,38,5],adjust:[25,44,17,18,33,35,5,10],form:[18,25,7,44,5],cosin:[24,9],vertic:5,dealt:7,println:42,tmmonth:17,tajo_src:39,locat:[14,42,3,5,18,44,33,48,50,52,39,10],tajo_hom:[26,40,42,43,31,48,39],dir:[43,14,10],pleas:[42,43,3,17,18,44,7,35,33,52,5,39,10],prevent:31,templet:26,smaller:14,boolean_express:7,ten:[41,39],natur:7,sign:[24,8],past:17,across:[43,7],long_table_name_1234:7,cost:16,design:[16,19,26,35],aggreg:[11,2,7],pass:7,download:3,val2:[49,8],val1:[49,8],histori:31,port:[25,40,46,42,43,31,48],tmpdir:10,even:[31,17],asin:24,what:17,abc:[8,39],addr:[3,48],compar:22,clock:17,section:[41,42,43,17,18,34,5,39,10],xtajoxx:15,abl:41,calcul:7,asia:[33,44,5],current:[25,42,40,41,35,30,17,31,7,8,48,9,45,10],c_phone:52,"19th":17,version:[39,48,9],directori:48,deco mpress:[39,35],ab_bc_cd:15,supplier:9,"new":[31,41,17,9],to_dat:17,method:[12,52],era:17,showmast:46,ongo:31,elimin:[50,7],full:[7,17],hash:12,deriv:7,pow:24,gener:[31,5],never:31,onli:[25,26,30,17,18,7,20,48,35,5,39],here:[20,39,8,17],tangent:24,address:[43,3,31,33,48,22,6],path:[25,41,42,3,39,44,33,48,9,50,52],o_orderprior:9,sine:24,modifi:17,sinc:[18,48,17],valu:[24,12,25,26,41,43,3,17,31,48,51,10],wait:31,convert:[24,31,3,53,17],aaabc:8,deterior:35,weekdai:17,shift:17,cli_print_error_trac:49,larger:[22,7,35],table_backup:52,through:41,later:39,precis:[22,17],datetim:[13,51],amount:31,behavior_arithmetic_abort:49,behav:7,codebas:39,character_length:15,chang:[42,43,39,48,9],commonli:5,sequencefil:[12,45,18],dayofweek:17,via:[31,43],regardless:[18,35],starttim:46,data_typ:50,appli:[31,17],transit:31,offset:[44,5],substr:[7,15,17],unix:17,"boolean":[22,7,3,35],namenode_hostnam:25,wip:[39,48],instal:[3,48,39],total:[7,10],unit:[48,35],num1:24,from:[24,12,15,52,31,17,39],describ:[41,9 ],would:[41,39,17],memori:[31,48],distinct:[7,17],doubl:17,regist:44,two:[30,52,18,8,26,17,39,53,20],next:[41,42,17],connector:[41,48],few:26,program:[26,35],msk:41,usr:48,recommend:[39,17],stage:39,type:[24,12,15,3,17,26,52,39,10],until:49,tajo_pid_dir:31,more:[11,29,41,43,17,7,8,48,35,39,10],sort:7,flat:[18,20,35],capit:17,discompress:39,hiveql:41,claus:[12,19,8,22,39],mismatch:12,hurt:16,function_nam:53,rootdir:43,exce:17,mdy:51,indic:17,name1:49,known:19,postgresql:8,recommand:44,getconnect:42,must:[11,25,41,42,17,31,7,48,35,22,51],tabular:5,word:[18,17,44,10,5],hour:17,formatha:31,alia:[22,7,15,9],setup:37,work:[17,9,22,35],timestamptz:22,dev:3,cat:[11,31,43,39,52],orderbi:12,column:12,archiv:[39,48],can:[5,7,8,9,10,11,12,17,18,19,20,23,26,31,33,34,35,38,39,41,42,43,44,48,50],learn:[33,39,44],field:[17,9,33,15,5],purpos:[41,26],root:[24,43],fmss:17,def:39,bewtween:22,control:31,nearest:[24,17,9],prompt:[40,29,9],to_char:[44,17],tar:[42,39,48],give:[50,7,10],process:[12,16,44,17 ,18,19,35,5,38],fmdd:17,share:[18,42,7],backslash:[17,9],templat:[48,17],high:37,liter:[17,26,5],want:[52,25,14,26,40,41,42,43,29,17,31,19,20,48,50,23,39,10],tarbal:31,tan:24,keep:17,occur:[50,18,17,7,5],tinyint:22,unresolvedaddressexcept:12,alwai:17,sundai:17,isoyear:17,multipl:[44,17,31,7,5,10],goal:16,divid:[24,7,17],anoth:[31,53],ordinari:17,hdf:[12,25,16,41,42,43,50,34,38,39,10],mapr:20,how:43,yyyymondd:17,purg:50,consist:[26,17,18,7,20,34,5],env:[31,48],c_address:52,main:[16,42,8,26],instead:[44,17,40,8,48,5,39],csv:[12,50,39,52],config:[31,26,43,6,48],sin:24,blockcompresswrit:20,updat:[31,41],jline2:2,transitiontoact:31,product:7,resourc:[31,43,6],ltrim:15,atan:24,max:5,clone:[39,48],after:[7,39,17],resultset:42,concatnen:15,cli_error_stop:49,befor:[31,2,7,43],catalog:1,"4th":17,floor:24,date:52,end:[23,15,39],underscor:8,mariadb:48,data:[31,43,48],parallel:43,physic:[43,34],subsequ:17,github:39,essenti:31,third:[48,17],read:[5,43,39,35],cli_print_paus:49,quot:[40,17],favorit :[31,43],correspond:[18,7],element:[31,26],caus:[31,17],inform:[31,17,51,48,9],preced:[3,17],environ:[41,25,26,39,10],block:[20,35],allow:[11,25,41,43,44,17,18,7,35,50,33,5,39,10],haadmin:31,worst:16,first:[26,15,48,17],item:[23,8,17],order:[42,34,22,16,43,41,35,33,44,5,18,7,48,9,19,51,39,10],quantiti:7,includ:[42,7,10,17],oper:[31,13,48],help:9,repair:41,shorten:48,over:7,fall:[7,17],midnight:17,becaus:[2,44,17,31,7,5],editor:[31,43],comma:[17,7,5],same:[24,41,3,17,31,7,8],equival:[14,7,17],hbase:34,still:31,vari:[22,17],dynam:16,entiti:31,smallint:22,write:[44,17,18,33,20,35,5],style:8,outer:7,cli:38,overwrit:[12,36,31],fix:17,defin:5,late:17,window:12,complex:[7,17],persist:[39,48],decad:17,therefor:[31,17],easier:44,isodow:17,non:[17,7,35],good:34,synopsi:[50,12,7,8],greater:24,thei:[18,33,8,31,17],add_month:17,handl:42,timestamp:[22,17,33,44,5],"1gb":[25,10],spell:17,col2:[14,8],dai:17,initi:31,col1:[14,8],ssss:17,framework:35,lzo:35,verifi:31,item_nam:19,now:[35,17,18,9,49,52, 5,39],utc_usec_to:[17,9],nor:8,introduct:12,tajo_worker_heaps:10,choic:35,subqueri:7,hive_jdbc_driver_dir:[41,48],name:[3,5,7,9,17,10,11,52,18,20,22,25,26,31,33,35,38,6,39,40,41,42,43,44,48,49,51],reoptim:16,simpl:39,drop:12,regexp_replac:15,instruct:[41,3],lazybinaryserd:20,separ:[29,17,7,20,5],easili:[31,42,43],submit:[31,39],mode:48,each:[43,26],januari:17,clsspath:42,quarter:17,compatibl:52,side:[42,15,44],truncat:24,mean:[8,17],compil:[41,39,48],domain:[31,43,8,5],map:22,unequ:31,individu:7,between:[42,8],saturdai:17,procedur:39,group:[7,8,35],resut:24,ensur:[39,48],meta:[12,38,39,48,44],"static":42,connect:[41,42,40,48,9,49],year:[7,17],our:5,extract:[17,9],special:[33,5],out:10,variabl:[12,25,26,41,44,48,9,22,38,39,10],unquot:9,shown:17,o_com:9,network:[31,13],space:[15,17],although:17,storag:[25,5,18,20,48,35,52,39],newli:41,access:[31,41,42,43,35],o_orderkei:9,xxtajo:15,profil:[41,48],millennium:17,hivemetastor:[41,48],print:17,roma:17,math:13,integr:48,bye:39,shut:39,parqu et:[12,45],partit:[12,41],advanc:[16,7],lastli:48,manipul:49,given:[14,15,40,3,5,22,44,7,8,9,50,17,39],free:39,standard:[16,22,39,8,17],asc:7,standalon:39,base:48,asf:[39,48],dictionari:35,usual:[26,5],put:[11,44,17],org:[41,42,5,18,33,20,48,9,50,39],"byte":[22,9,39,35],fridai:17,div:24,card:19,care:[17,5],str2:15,recogn:[44,5],launch:48,angl:24,real:24,could:17,omit:[18,17,7,9],p_id:11,retriv:42,round:[24,9],filter:[7,8],length:[22,17],iso:17,rcfile:[12,45],fxyyyi:17,umbil:[31,43,6],timezon:[49,51,33,44,5],think:39,mvn:[41,42,39,48],str1:15,feed:5,schema:[14,35,19,34,9,38,39],meridiem:17,current_d:17,suffix:17,directli:[41,19,5],resourceconfigur:10,feel:39,onc:[31,7,3],arrai:8,independ:35,applciat:42,number:43,system:[31,43,26,48],restrict:17,mai:[29,26,17,31,7,48,39],o_orderd:9,alreadi:31,done:[39,17],unhealthi:31,blank:17,tpch:[52,9],open:16,primari:[31,25],differ:[44,17,7,8,5],cartesian:7,t_timestamp:[33,44],script:[39,26],xii:17,interact:[16,40,39],mkdir:[23,43,39],capac:[43,10 ],least:[7,8],getstat:31,paramt:11,l_partkei:[50,14,7],too:35,saint:17,termin:5,scheme:[25,39],boot:[39,48],"final":[41,42,39,48],store:[11,31,16,41,5,18,20,48,9,39,10],q_1411357607375_0006:46,mysql_jdbc_driv:[41,48],shell:[12,39,26],option:[11,46,39,40,50,7,17,52],inspect:38,especi:22,namespac:42,tool:9,copi:[26,48],inexact:22,grouping_column_refer:7,radian:24,client_session_expiry_tim:49,"short":[18,7],enclos:7,mostli:18,twenti:17,attempt:17,exactli:8,geoip_country_cod:3,serv:31,enjoi:39,kind:7,target:[24,14,42,31,48,39],keyword:[7,20],provid:[2,3,5,8,10,29,46,18,20,23,30,31,33,35,38,39,41,42,45,16,48,49],expr:7,remov:[50,15,48,39],tree:39,second:[31,15,48,17],mmdd:17,charact:[15,17,18,19,8,22,33,5],project:[16,35],serd:[18,5],arc:24,posix:8,balanc:16,becom:[31,44,17],tajoresourcemanag:31,float8:[24,22,14,52,9],minut:[41,39,17],listen:[42,43],codegen:49,unix_timestamp:17,comput:[7,17],abov:[18,2,29,20,39],textserd:20,ran:48,julian:17,respons:[11,16,2,29,39],mind:17,ani:[42,35,5,31 ,7,8,48,9],"return":[24,15,3,17,8,5],packag:[41,42],chmod:43,manner:42,have:[12,25,41,17,50,48],further:5,need:[34,31,41,42,17,18,20,48,35,52,5,39],maxmind:3,predic:[12,19,36],calendar:17,test_min_task_num:49,cli_null_char:49,tajocli:[31,44],catalogstor:31,squar:24,zero:[8,17],partsupp:9,lineitem_100_snappi:50,statement:[11,42,14,40,46,35,44,5,18,7,8,9,50,33,39,20],click:39,note:[8,48,17],also:[44,17,31,19,8,48,9,49,7,5,39,20],without:[29,16,17,19,48,7,5],take:[41,7,39],which:[49,31,16,42,44,40,17,18,7,20,48,50,33,39],techniqu:16,combin:7,subject:7,brace:11,prepar:[41,39,48],singl:[12,43,17,31,8,34,35,38],compat:[12,48,10],begin:[17,9],c_nationkei:52,unless:[41,17],distribut:48,preliminari:37,buffer:[39,35],price:19,enter:[12,39],compress:12,deflatecodec:50,untar:39,most:[33,48,5],microsecond:17,specifi:[3,5,7,8,10,14,46,17,18,20,22,23,25,40,33,35,39,41,42,44,48,53],deploi:31,phase:19,metacharact:8,choos:39,cbrt:24,"class":[41,42,5,18,8,48,20],appear:7,other:[14,31,16,44,17,18,7,26, 5,10],doi:17,don:[42,39,26,52],url:[25,42,34],doc:9,clear:9,binaryserd:20,request:10,uri:[31,48],ghi:39,salari:7,part:[17,9],snapshot:[39,48],classnotfoundexcept:42,determin:[51,7,10],pattern:[12,15,17],pst:[44,5],pars:5,querymast:[31,10],axi:24,remot:43,dow:17,pope:17,show:[46,49,42,39,9],text:[11,15,22,31,35,43,3,5,18,44,19,8,9,50,33,52,17,39,20],hostnam:[40,25,42,43,48],rtrim:15,syntax:[7,53],column_refer:8,session:[12,38,44,9],l_discount:7,identifi:[7,48,17],rang:[12,30],ship_dat:19,find:31,xml:37,absolut:[24,39,48,9],row_num:7,explicitli:[7,26],ratio:10,just:[31,7,8,48,49,23,52],copyright:9,much:10,explain:[42,43,5,18,7,34,39],cpu:10,apach:[41,3,48,39],abbrevi:[17,44,5],than:[11,24,14,41,17,7,8,39],jan:17,fmhh:17,ymd:51,l_quantiti:[14,7],tbname:9,search_condit:7,local:[48,3,10,17],test_filter_pushdown_en:49,haven:19,ddsp:17,info:[46,31,6],"53rd":17,cube:24,variou:[49,34,17],get:[31,48,17],fmmonth:17,familiar:[18,5,35],express:[12,36,15,17],disagre:17,ceil:24,repo:[39,48],cannot :5,java_hom:39,progress:[11,16,2,46,29],increas:43,score:[11,29,5,18,33,20,35,39],requir:[31,29,7,39,17],layout:[33,34],table_refer:7,bar:5,enabl:[31,42,43,44,5,18,33,48,35],tajodriv:42,upper:[15,17],grtajo01:46,borrow:8,"public":42,ddth:17,current_timestamp:17,common:[12,7],dist_query_sort_task_volum:49,contain:[31,42,50,43,17],clean:[41,42,39,48],metadata:18,where:[12,43,19,8,48,22,39,10],valid:17,bytea:22,view:34,respond:41,set:48,ascend:7,"float":[24,22,5,18,19,20,35,33,39,10],frame:7,knowledg:5,startup:40,memstor:48,c_custkei:52,see:[48,43,39,10,17],num:[40,7,5],sec:[11,29,46,2,48,39],result:[12,42,35,44,17,31,7,9,39],arg:[46,42],fail:5,close:42,rlike:8,unqualifi:[19,7],improv:35,o_orderstatu:9,valn:8,awar:[41,10],statu:31,detect:31,kei:[11,30,17,18,19,20,49,50],correctli:[22,39],record:[18,5,8,20,35],down:[8,39],ieee:22,char_length:15,below:[39,17,18,35,5,52],yet:19,cli_print_pause_num_record:49,smallest:[24,35],subdir:14,prune:12,"\u02c6ab":15,l_orderkei:[50,14,7],neither:8,p aramet:[24,12,15,3,17,18,33,35,50,5],approach:52,fsshell:23,altern:8,accord:[22,7,5],parent:39,numer:17,executor_groupby_inmemory_hash_threshold:49,vatican:17,hadoop_hom:[43,39],add_dai:17,o_totalpric:9,remaind:24,gregorian:17,outfil:52,disconnect:[49,31],argument:[24,29,17,7,9,23],problem:[31,2],monitor:31,both:[15,31,16,5,18,7,20],last:[7,17],"85e7":17,admin:[46,9],fault:16,howev:35,gzipcodec:50,c_comment:52,groupbi:12,against:39,april:44,roman:17,instanc:[25,43,39],compressioncodec:[18,5],context:17,logic:[8,34],let:20,whole:10,fmyyyi:17,load:[16,39],english:17,simpli:39,point:[18,31,17],overview:12,format:31,period:[31,17],split_part:15,hh12:17,header:18,rpc:[31,42,43,6],written:[18,44,20,5],param:[11,40,7],shutdown:31,toler:[16,5],respect:[22,8],tuesdai:17,guid:9,assum:[29,19,39,10,17],transitiontobackup:31,abscissa:24,cathedr:17,quit:9,xzvf:[42,39],strong:52,java:[12,41,26,39,48],creat:[12,43,39,48,52],nonsens:17,invers:9,empti:[18,7,5],compon:31,"int":[24,15,22,17,18,19,20,35 ,33,5,39],json:5,trigger:31,besid:5,interpret:17,basic:[16,12,52,20,5],addit:[14,42,44,7,8,10],c_mktsegment:52,multipli:17,host2:[31,43],guarante:31,derbystor:[31,48],o_custkei:9,legaci:3,exercis:39,num2:24,decimaln:9,suppress:17,xxx:9,worker:37,search:12,cli_output_formatter_class:49,wish:11,tajojdbccli:42,coordin:24,understand:34,togeth:17,func:7,input:[24,15,17],"catch":42,repetit:8,countri:[3,17],due:10,those:[42,18,5,33,35],statist:31,emploi:16,consum:35,ident:17,implementaion:25,plain:[18,20],servic:[37,43,48],properti:[12,25,34,26,41,43,3,31,48,51,6,10],iyi:17,batch:16,alter:41,cli_max_column:49,cast:[12,17],"while":[42,17],uniqu:49,behavior:7,error:[17,50,5],wild:19,exist:[50,18,14,40],region:9,lazybinarycolumnarserd:18,textserializerdeseri:[18,20,5],bin:[11,29,40,41,2,43,52,31,48,39],layer:25,relat:[7,35],advantag:35,ctrl:[31,43,39],key1:49,tabl:[41,39,48,52],them:[7,44],activ:31,cluster:[37,48],"default":[31,37,43,26,48],itself:[31,9],warehous:[16,23,50],textfil:12,conf:[2 5,26,40,41,43,3,44,31,48,39,10],centuri:17,crash:31,mod:24,abcdef:15,primit:22,conn:42,writ:5,"null":[42,7],develop:[12,39],"35b":39,grant:48,perform:7,suggest:39,seoul:[33,44,5],belong:7,classpath:12,hadoop:[16,42,43,5,18,33,8,26,35,50,23,39,20],sqrt:24,binari:[12,39,48],epoch:17,html:9,pad:17,split:15,largest:24,dtar:[41,42,39,48],start:[31,43,15,17],conflict:31,higher:39,week:17,varbit:22,lineitem:[50,14,46,7,9],http:[3,6,31,48,9,39],nio:12,denot:8,optim:16,nest:35,driver:[12,41,48],geoip_in_countri:3,col3:14,jkl:39,column_nam:50,moment:[5,35],rais:24,dskiptest:[41,42,39,48],user:[25,41,17,31,48,39,10],tajo_classpath:48,mani:[18,42,44,10,9],extern:[12,39,18,50,19,52],nation:9,tsql:[12,44,39,52],typic:7,built:[18,42,9],lower:[15,17],appropri:[39,26],off:17,lib:48,mention:18,com:[31,43,3],thu:[41,39],page:[12,43,35],well:[50,14,22,17],parenthes:[7,8],inherit:[18,5],to_numb:17,exampl:[31,43,52,48],command:[12,41,44,52,38,39],thi:[11,12,52,34,26,41,42,43,44,5,31,7,8,48,35,23,17,39,10 ,20],filesystem:39,gzip:35,fmmm:17,lc_time:17,createdatabaseifnotexist:48,fmmi:17,left:7,explan:39,construct:[7,17],protocol:39,entri:[31,50,43],execut:[31,43,10],less:[24,17],when:[14,42,17,31,7,48,35,50,5,39],dist_query_groupby_task_volum:49,ordin:[24,17],tcp:40,jar:[41,42,48],q_1363768615503_0001_000001:39,kill:[46,31],mysql:[41,48],binaryserializerdeseri:[18,20],rest:7,simultan:10,bit:22,languag:[16,12,39],inet4:[22,3],move:39,web:[16,31],snappi:35,all_backup:52,easi:[52,30],mix:17,disk1:10,disk2:10,disk3:10,except:[42,7,48,17],shortcut:23,date_ord:49,add:[26,41,42,43,31,50,48,23,51,39,10],divis:24,blob:22,versa:18,backup_and_restor:9,work1:9,expon:24,disrupt:31,modul:[12,26],euler:24,gmt:44,earli:17,applic:7,complaint:17,march:17,littl:43,serde2:[18,20],preserv:31,wai:[31,44,17,52,5],subfield:17,host1:[31,43],bzip2codec:50,"4028235e":22,iyyi:17,workload:10,phcatalog:[41,48],mon:17,background:[12,38],insert:[12,41,36,31],resid:39,database_nam:[40,50],characterist:34,licens:9,des c:[46,7],linux:9,u0001:[33,5],storage_typ:50,table1:[11,29,42,44,5,18,7,8,35,33,39,20],xxxxxx:48,like:[25,42,19,39,17],specif:[31,25,14,22,17],filenam:40,should:[25,40,41,42,43,3,17,18,44,19,48,35,50,52,5,51,39,10],manual:[18,48],msck:41,integ:[24,17,9,22,5,10],server:[12,26,39,48,31],pdist:[41,42,39,48],collect:20,benefit:30,api:[12,41],necessari:16,either:[41,7,8,35,22,39],descend:7,output:[14,7,20,17],timetz:22,tajo:[37,52,48],result_set_fetch_rownum:49,another_long_table_name_5678:7,geoip:3,yyyi:17,right:7,peter:17,who:5,order_d:19,createstat:42,interv:[31,17],suppli:17,some:[12,26,22,41,2,44,5,18,7,48,35,33,17,39],back:31,tajowork:[31,26,10],certain:[18,5,14,35],arithmet:[12,7],intern:[44,26],previou:[8,17],queryid:46,test_broadcast_join_en:49,yyyymmdd:17,mirror:39,proper:[25,39,10,48],deprec:5,"52nd":17,row_numb:7,tmp:[23,25,39,48],query_succeed:39,cnt:7,scale:16,tajo_master_heaps:25,zong:44,channel:12,"512mb":10,been:9,avoid:[16,31,2,50,17],exec:20,definit:[12,36,17],pemiss:5 ,best:5,usernam:[39,48],alias_nam:7,tracker:[31,43,6],exit:2,select:[11,24,29,14,15,46,42,3,17,44,7,8,9,39],bigint:[22,50],rectangular:24,condit:7,fornam:42,three:[20,48,17],localhost:[40,43,31,50,48,6],ddd:17,machin:[31,48,40],core:[42,51,10],o_shipprior:9,run:[31,43],power:[24,8],uncompress:[20,35],oracl:17,executor_hash_join_size_threshold:49,dist_query_table_partition_volum:49,usag:[12,17,52,35],mixtur:17,maven:[41,39,48],broken:5,step:39,atan2:24,durat:48,repositori:39,found:23,peer:6,l_extendedpric:7,subtract:17,unicod:22,c_acctbal:52,comparison:[22,8],about:34,repeat:17,actual:12,datanod:10,dist_query_groupby_partition_volum:49,dist_query_join_partition_volum:49,varbinari:22,dhadoop:39,aco:[24,9],total2:7,simul:31,degre:[24,43],regular:15,sequecnefil:20,issu:12,table_nam:[41,50,52],approxim:22,disabl:[18,5,33,35],hive_hom:[41,48],plan:[16,19,5],executor_outer_hash_join_size_threshold:49,columnarserd:18,client:[12,43,6,48,31],own:[33,44,5],effici:35,consid:[31,44],primarili:17 ,within:[31,23,7,17],encod:35,lazybinari:20,compos:[19,35],stop:[31,2],pair:[18,20,26],master:[37,43,48],refer:[42,35,43,3,5,18,44,7,20,9,33,51,39],central:31,float4:[22,9],"import":42,dmy:51,yyi:17,your:[39,26,31,41,42,43,25,17,18,48,35,5,51,52],manag:[12,41,30,39,48],git:48,val:49,pictur:9,hh24:17,support:[25,52,48,17],"long":[16,7,17],custom:[52,48],avail:37,width:17,drivermanag:42,current_databas:49,q_1411357607375_0007:46,inner:7,fraction:17,replac:[15,17],"var":48,call:[12,7],metastor:41,etc:38,snappycodec:[50,18,33,20,5],enough:48,forc:[7,17],test_join_opt_en:49,drwxr:23,compressiontyp:20,jun:17,tajoxx:15,l_comment:50,query_run:46,int4:[22,14,15,9],jdbc:[12,41,48],max_output_file_s:49,translat:[44,17],select_stat:50,int2:22,l_shipdat:7,line:[31,44,38,43,5],"true":[3,31,20,48,35,22,10,8],int8:[24,22,14,52,9],stmt:42,count:[11,29,15,46,17,7],utc:[17,44,5],"throw":42,dist_query_broadcast_join_threshold:49,theta:24,temp:23,possibl:[7,10,17],whether:[18,7,8],ecosystem:35,vice:18,s tandbi:31,day_of_week:17,t_date:[33,44],to_timestamp:17,current_tim:17,limit:[12,10],toggl:17,sum:[11,29,7],site:37,otherwis:[40,17,7,3,8],embed:48,executequeri:42,defaultport:48,delimit:[15,44,5,50,33,39],expect:17,trim:15,model:[12,36],featur:[11,41,5,18,33,34,35],constant:24,semicolon:[23,29],btrim:15,host:[40,46,42,43,31,48,51],retriev:[44,17],dure:19,pid:31,doesn:41,repres:[17,5],"char":[22,17],novemb:17,ipv4:[22,3],implement:[12,17,39,9],"20000nov31":17,file:[37,52],home:[41,39,48,52],doe:[42,44,17,31,50,35,7,5],match:[12,22,15,17],link:39,fill:[42,17],incorrect:31,tab:5,password:48,successfulli:[46,31],codec:[50,18,33,20,5],know:[43,44,7,39,17],sort_expr:7,index:12,percent:8,detail:[46,35,43,17,7,48,9,39],getstr:42,debug_en:49,finish:31,bracket:8,bool:22,o_clerk:9,branch:12,varieti:26,test:48,scan:41,you:[2,3,5,7,8,9,10,11,29,14,17,18,19,20,39,23,25,26,31,33,35,52,40,41,42,43,44,48,50,51],node:[31,42,43,10],polar:24,iddd:17,intend:17,exp:24,highli:[39,44],customserializerdese ri:5,val3:49,sequenc:8,symbol:11,introduc:12,text_nul:49,briefli:7,insensit:8,mondai:17,tajomast:[37,43,48],columnar:[18,35],src:[42,39,17],decemb:17,empsalari:7,lead:[19,15,17],algorithm:[18,5,10,35],trail:[15,17],hyunsik:[52,9],accept:[44,5],regexp:8,descript:[46,6,17,31,8,48,9,22,51,39,10],hello:17,select_list:7,carriag:5,place:9,ignor:[17,10,5],invok:31,time:31,supergroup:23,name2:49,"export":[41,39,48],backward:10,small:[22,35],dst:[44,5],unset:[49,9],name3:49},objtypes:{"0":"py:function"},objnames:{"0":["py","function","Python function"]},filenames:["partitioning/hash_partitioning","backup_and_restore","tsql/background_command","functions/network_func_and_operators","partitioning/range_partitioning","table_management/csv","configuration/service_config_defaults","sql_language/queries","sql_language/predicates","tsql/meta_command","configuration/worker_configuration","tsql/execute_file","index","functions","sql_language/insert","functions/string_func_and_operators","introduction ","functions/datetime_func_and_operators","table_management/rcfile","partitioning/column_partitioning","table_management/sequencefile","configuration/catalog-site-xml","sql_language/data_model","tsql/dfs_command","functions/math_func_and_operators","configuration/tajo_master_configuration","configuration/preliminary","table_management/compression","faq","tsql/single_command","partitioning/intro_to_partitioning","configuration/ha_configuration","table_partitioning","table_management/table_overview","table_management","table_management/parquet","sql_language","configuration","tsql","getting_started","tsql/intro","hcatalog_integration","jdbc_driver","configuration/cluster_setup","time_zone","table_management/file_formats","tsql/admin_command","tajo_client_api","configuration/catalog_configuration","tsql/variables","sql_language/ddl","configuration/tajo-site-xml","backup_and_restore/catalog","sql_language/sql_expression"],titles:["Hash Partitioning","Backup and Restore","Executing as ba ckground process","Network Functions and Operators","Range Partitioning","CSV (TextFile)","Cluster Service Configuration Defaults","Queries","Predicates","Meta Commands","Worker Configuration","Executing Queries from Files","Apache Tajo\u2122 (dev) - User documentation","Functions","INSERT (OVERWRITE) INTO","String Functions and Operators","Introduction","DateTime Functions and Operators","RCFile","Column Partitioning","SequenceFile","The catalog-site.xml File","Data Model","Executing HDFS commands","Math Functions and Operators","Tajo Master Configuration","Preliminary","Compression","FAQ","Executing a single command","Introduction to Partitioning","High Availability for TajoMaster","Table Partitioning","Overview of Tajo Tables","Table Management","Parquet","SQL Language","Configuration","Tajo Shell (TSQL)","Getting Started","Introducing to TSQL","HCatalog Integration","Tajo JDBC Driver","Cluster Setup","Time Zone","File Formats","Administration Commands","Tajo Client API","Catalog Configuration","Session Variables","Data Definition Language","The tajo-site.xml File","Backup and Restore Catalog","SQL Expressions"],objects:{"":{trim:[15,0,1,""],upper:[15,0,1,""],to_char:[17,0,1,""],btrim:[15,0,1,""],regexp_replace:[15,0,1,""],cbrt:[24,0,1,""],split_part:[15,0,1,""],sign:[24,0,1,""],add_months:[17,0,1,""],to_date:[17,0,1,""],tan:[24,0,1,""],extract:[17,0,1,""],current_time:[17,0,1,""],floor:[24,0,1,""],sqrt:[24,0,1,""],acos:[24,0,1,""],char_length:[15,0,1,""],current_date:[17,0,1,""],abs:[24,0,1,""],degrees:[24,0,1,""],pow:[24,0,1,""],pi:[24,0,1,""],sin:[24,0,1,""],ltrim:[15,0,1,""],atan:[24,0,1,""],asin:[24,0,1,""],cos:[24,0,1,""],ceil:[24,0,1,""],atan2:[24,0,1,""],rtrim:[15,0,1,""],now:[17,0,1,""],utc_usec_to:[17,0,1,""],geoip_in_country:[3,0,1,""],mod:[24,0,1,""],lower:[15,0,1,""],radians:[24,0,1,""],date_part:[17,0,1,""],to_timestamp:[17,0,1,""],geoip_country_code:[3,0,1,""],add_days:[17,0,1,""],exp:[24,0,1,""],div:[24,0,1,""],round:[24,0,1,""]}},titleterms :{code:[42,39],execut:[11,2,29,23,39],queri:[11,7,39],time:[51,33,44,17],session:49,permiss:43,hcatalogstor:48,languag:[36,50],paramet:11,xml:[21,51,26],zone:[33,44],how:[31,42,5,18,19,35],configur:[25,31,48,37,6,10],apach:[18,12,5,19,35],window:7,local:39,match:8,real:22,sourc:[42,39],synopsi:[46,40],string:[8,53,15],format:[45,17],handl:5,faq:[28,42],terminolog:31,background:2,insert:14,introduct:[16,30],mysqlstor:48,document:12,like:8,administr:[46,31],level:52,drop:50,hive:[18,5,19,35],server:44,mode:[43,10],partit:[0,32,19,30,4],each:10,fulli:43,where:7,manag:[33,34],failov:31,set:[11,42,43,31,51,39],hcatalog:41,dump:52,dowload:39,meta:9,download:39,run:10,todo:[0,27,28,4,33,47,52],servic:6,out:39,compat:[18,5,19,35],network:3,cast:53,databas:[50,52],preliminari:26,definit:50,state:31,directori:[43,10],channel:42,get:[42,39],method:30,math:24,common:33,qualifi:7,hash:0,driver:42,gener:18,usag:[11,46,9],serializerdeseri:20,base:43,prerequisit:[3,39],releas:39,from:[11,42,7],rcfi le:18,valu:[11,22,5],convers:17,launch:[31,43],column:19,tajo:[12,25,18,51,42,43,6,31,33,26,47,38,39],groupbi:7,datetim:17,integr:41,backup:[31,1,52],first:39,oper:[24,17,3,15],rang:4,via:39,overview:[33,7],tajomast:[31,25],number:[22,10],automat:31,date:[51,17],api:47,size:[25,10],writer:20,git:39,java:42,memori:[25,10],data:[22,50,10],support:3,doubl:22,system:51,overwrit:14,custom:5,avail:31,start:39,call:53,basic:[11,46,9],master:[31,25,6],type:[22,7,53],"function":[24,13,15,3,17,7,53],shell:[40,38],claus:7,worker:[43,6,10],rootdir:25,heap:[25,10],jdbc:42,unpack:39,join:7,prune:19,restor:[1,52],"default":6,setup:43,properti:[18,5,33,35],maximum:10,dev:12,orderbi:7,hdf:23,serd:20,limit:7,introduc:[40,20],parquet:35,similar:8,file:[11,21,45,51,31],creat:[50,18,5,19,35],process:2,site:[21,51,26],indic:12,high:31,cluster:[31,44,43,39,6],unresolvedaddressexcept:42,textfil:5,have:7,tabl:[12,33,44,5,18,32,19,34,35,50,7],serial:[18,5],"null":5,dedic:10,issu:[18,5,19,35],make:43,ilik:8,w hen:18,cross:7,check:39,binari:42,exampl:[42,7,44,10],build:[42,39],env:26,test:31,distribut:[42,43],csv:5,config:51,singl:29,variabl:49,express:[8,53],resourc:10,nio:42,classpath:42,enter:40,compress:[50,27,33],catalog:[21,26,52,48],regular:8,temporari:10,user:12,sql:[11,36,52,53],extern:33,tsql:[40,38],parallel:10,physic:[18,5,35],derbi:48,task:10,read:18,predic:8,arithmet:53,alias:7,client:[42,47,44],command:[46,23,29,9],pattern:8,model:22,sequencefil:20,mariadbstor:48,latest:39}}) \ No newline at end of file +Search.setIndex({envversion:42,terms:{ojdbc7:48,all:[34,46,41,42,43,3,17,31,44,7,8,48,9,49,33,52,5,39],code:[3,48],dist:[42,39,48],c_name:52,represent:[17,35],rdbm:[42,34],queri:[31,48,10],global:[44,17],concern:[52,26],month:17,four:[45,17],prefix:[11,44,17],concept:[42,17],per:[49,31,43,10],abil:31,mno:39,follow:[2,3,5,7,8,9,10,11,29,14,46,17,18,19,20,39,23,22,25,26,30,31,33,35,52,40,41,42,43,44,45,48,49,50,51],disk:[3,10],row:[11,29,35,44,5,18,7,8,48,9,39,20],millisecond:17,content:[12,50,39,48],privat:42,complet:31,depend:[31,41,42,8],zone:[12,17,51,22,5],dist_query_join_task_volum:49,decim:[22,17],executor_external_sort_buffer_s:49,init:39,hadmin:31,present:[39,9],jvm:31,skip:17,locaion:44,sql_languag:9,thursdai:17,"case":[26,15,42,44,17,18,8,48,20],digit:[22,17],sourc:[48,17],everi:[31,51,7],string:[13,3,26,17],without:[29,16,17,19,48,7,5],fals:[22,8,3,35],"void":42,ddl:[39,52],csvfile:5,varchar:22,util:38,volum:[39,9],failur:31,veri:[43,8,39],affect:[44,48,10,17],implicitli:7 ,hdfs_locat:18,exact:22,dbname:9,tri:42,recordcompresswrit:20,executor_inner_hash_join_size_threshold:49,did:17,"12th":17,list:[46,41,43,44,31,19,8,9,7,39],scalar:[7,35],hive:[12,41,48],"try":[31,42,40],date_part:17,interfac:[31,38,5],adjust:[25,44,17,18,33,35,5,10],form:[18,25,7,44,5],cosin:[24,9],vertic:5,dealt:7,println:42,tmmonth:17,tajo_src:39,locat:[14,42,3,5,18,44,33,48,50,52,39,10],tajo_hom:[26,40,42,43,31,48,39],dir:[43,14,10],pleas:[42,43,3,17,18,44,7,35,33,52,5,39,10],prevent:31,templet:26,smaller:14,boolean_express:7,ten:[41,39],natur:7,sign:[24,8],past:17,across:[43,7],long_table_name_1234:7,cost:16,design:[16,19,26,35],aggreg:[11,2,7],pass:7,download:3,val2:[49,8],val1:[49,8],histori:31,port:[25,40,46,42,43,31,48],tmpdir:10,even:[31,17],asin:24,what:17,abc:[8,39],addr:[3,48],compar:22,clock:17,section:[41,42,43,17,18,34,5,39,10],xtajoxx:15,abl:41,calcul:7,asia:[33,44,5],current:[25,42,40,41,35,30,17,31,7,8,48,9,45,10],c_phone:52,"19th":17,version:[39,48,9],directori:48 ,decompress:[39,35],supplier:9,"new":[31,41,17,9],to_dat:17,method:[12,52],can:[5,7,8,9,10,11,12,17,18,19,20,23,26,31,33,34,35,38,39,41,42,43,44,48,50],showmast:46,ongo:31,elimin:[50,7],full:[7,17],hash:12,deriv:7,pow:24,gener:[31,5],never:31,onli:[25,26,30,17,18,7,20,48,35,5,39],here:[20,39,8,17],field:[17,9,33,15,5],tangent:24,address:[43,3,31,33,48,22,6],path:[25,41,42,3,39,44,33,48,9,50,52],o_orderprior:9,sine:24,modifi:17,sinc:[18,48,17],valu:[24,12,25,26,41,43,3,17,31,48,51,10],wait:31,convert:[24,31,3,53,17],aaabc:8,deterior:35,weekdai:17,shift:17,cli_print_error_trac:49,larger:[22,7,35],table_backup:52,through:41,later:39,precis:[22,17],datetim:[13,51],amount:31,behavior_arithmetic_abort:49,behav:7,codebas:39,character_length:15,chang:[42,43,39,48,9],postgresqlstor:48,commonli:5,sequencefil:[12,45,18],dayofweek:17,via:[31,43],regardless:[18,35],starttim:46,data_typ:50,appli:[31,17],transit:31,offset:[44,5],substr:[7,15,17],unix:17,"boolean":[22,7,3,35],namenode_hostnam:25,wi p:[39,48],instal:[3,48,39],total:[7,10],unit:[48,35],num1:24,from:[24,12,15,52,31,17,39],describ:[41,9],would:[41,39,17],memori:[31,48],distinct:[7,17],doubl:17,regist:44,two:[30,52,18,8,26,17,39,53,20],next:[41,42,17],connector:[41,48],few:26,program:[26,35],msk:41,usr:48,recommend:[39,17],stage:39,type:[24,12,15,3,17,26,52,39,10],until:49,tajo_pid_dir:31,more:[11,29,41,43,17,7,8,48,35,39,10],sort:7,flat:[18,20,35],capit:17,discompress:39,hiveql:41,claus:[12,19,8,22,39],mismatch:12,hurt:16,function_nam:53,rootdir:43,exce:17,mdy:51,indic:17,name1:49,known:19,central:31,recommand:44,getconnect:42,must:[11,25,41,42,17,31,7,48,35,22,51],tabular:5,word:[18,17,44,10,5],hour:17,formatha:31,alia:[22,7,15,9],setup:37,work:[17,9,22,35],timestamptz:22,dev:3,cat:[11,31,43,39,52],orderbi:12,column:12,archiv:[39,48],thin:48,learn:[33,39,44],hh12:17,purpos:[41,26],root:[24,43],fmss:17,def:39,bewtween:22,control:31,nearest:[24,17,9],prompt:[40,29,9],to_char:[44,17],tar:[42,39,48],give:[50,7,10],pr ocess:[12,16,44,17,18,19,35,5,38],fmdd:17,share:[18,42,7,48],backslash:[17,9],templat:[48,17],high:37,liter:[17,26,5],want:[52,25,14,26,40,41,42,43,29,17,31,19,20,48,50,23,39,10],tarbal:31,tan:24,keep:17,occur:[50,18,17,7,5],tinyint:22,unresolvedaddressexcept:12,alwai:17,sundai:17,isoyear:17,multipl:[44,17,31,7,5,10],goal:16,divid:[24,7,17],anoth:[31,53],ordinari:17,hdf:[12,25,16,41,42,43,50,34,38,39,10],mapr:20,how:43,yyyymondd:17,purg:50,sever:48,env:[31,48],c_address:52,main:[16,42,8,26],instead:[44,17,40,8,48,5,39],csv:[12,50,39,52],config:[31,26,43,6,48],sin:24,blockcompresswrit:20,updat:[31,41],jline2:2,transitiontoact:31,product:7,resourc:[31,43,6],ltrim:15,atan:24,client_session_expiry_tim:49,clone:[39,48],after:[7,39,17],resultset:42,concatnen:15,cli_error_stop:49,befor:[31,2,7,43],catalog:1,"4th":17,floor:24,date:52,end:[23,15,39],underscor:8,small:[22,35],data:[31,43,48],parallel:43,physic:[43,34],subsequ:17,github:39,essenti:31,third:[48,17],read:[5,43,39,35],cli_print_p aus:49,quot:[40,17],favorit:[31,43],correspond:[18,7],element:[31,26],caus:[31,17],inform:[31,17,51,48,9],preced:[3,17],environ:[41,25,26,39,10],block:[20,35],allow:[11,25,41,43,44,17,18,7,35,50,33,5,39,10],haadmin:31,worst:16,first:[26,15,48,17],item:[23,8,17],ghi:39,quantiti:7,includ:[42,7,48,10,17],oper:[31,13,48],belong:7,help:9,repair:41,shorten:48,over:7,fall:[7,17],midnight:17,becaus:[2,44,17,31,7,5],q_1411357607375_0006:46,guarante:31,comma:[17,7,5],same:[24,41,3,17,31,7,8],equival:[14,7,17],hbase:34,still:31,vari:[22,17],dynam:16,entiti:31,smallint:22,write:[44,17,18,33,20,35,5],style:8,outer:7,cli:38,overwrit:[12,36,31],fix:17,defin:5,late:17,window:12,complex:[7,17],persist:[39,48],decad:17,therefor:[31,17],easier:44,isodow:17,non:[17,7,35],good:34,synopsi:[50,12,7,8],greater:24,thei:[18,33,8,31,17],add_month:17,handl:42,timestamp:[22,17,33,44,5],"1gb":[25,10],spell:17,col2:[14,8],dai:17,initi:31,col1:[14,8],ssss:17,framework:35,lzo:35,verifi:31,item_nam:19,now:[35,17,18, 9,49,52,5,39],utc_usec_to:[17,9],nor:8,introduct:12,choic:35,subqueri:7,hive_jdbc_driver_dir:[41,48],name:[3,5,7,9,17,10,11,52,18,20,22,25,26,31,33,35,38,6,39,40,41,42,43,44,48,49,51],reoptim:16,simpl:39,drop:12,regexp_replac:15,instruct:[41,3],lazybinaryserd:20,separ:[29,17,7,20,5],easili:[31,42,43],submit:[31,39],mode:48,each:[43,26],januari:17,clsspath:42,quarter:17,tajo_worker_heaps:10,side:[42,15,44],truncat:24,mean:[8,17],compil:[41,39,48],domain:[31,43,8,5],map:22,unequ:31,individu:7,between:[42,8],saturdai:17,procedur:39,group:[7,8,35],resut:24,ensur:[39,48],meta:[12,38,39,48,44],"static":42,connect:[41,42,40,48,9,49],year:[7,17],our:5,extract:[17,9],special:[33,5],out:10,variabl:[12,25,26,41,44,48,9,22,38,39,10],unquot:9,shown:17,o_com:9,network:[31,13],space:[15,17],although:17,storag:[25,5,18,20,48,35,52,39],newli:41,access:[31,41,42,43,35],o_orderkei:9,xxtajo:15,profil:[41,48],millennium:17,hivemetastor:[41,48],print:17,roma:17,math:13,integr:48,bye:39,shut:39,parquet:[1 2,45],partit:[12,41],advanc:[16,7],lastli:48,manipul:49,given:[14,15,40,3,5,22,44,7,8,9,50,17,39],free:39,standard:[16,22,39,8,17],asc:7,standalon:39,base:48,asf:[39,48],dictionari:35,usual:[26,5],put:[11,44,17],org:[41,42,5,18,33,20,48,9,50,39],"byte":[22,9,39,35],fridai:17,div:24,card:19,care:[17,5],str2:15,recogn:[44,5],launch:48,angl:24,real:24,could:17,omit:[18,17,7,9],p_id:11,retriv:42,round:[24,9],filter:[7,8],length:[22,17],iso:17,rcfile:[12,45],fxyyyi:17,umbil:[31,43,6],timezon:[49,51,33,44,5],think:39,mvn:[41,42,39,48],str1:15,feed:5,schema:[14,35,19,34,9,38,39],meridiem:17,current_d:17,l_comment:50,suffix:17,directli:[41,19,5],resourceconfigur:10,feel:39,onc:[31,7,3],arrai:8,independ:35,applciat:42,number:43,system:[31,43,26,48],restrict:17,mai:[29,26,17,31,7,48,39],o_orderd:9,alreadi:31,done:[39,17],unhealthi:31,blank:17,tpch:[52,9],open:16,primari:[31,25],differ:[44,17,7,8,5],cartesian:7,t_timestamp:[33,44],script:[39,26],xii:17,interact:[16,40,39],mkdir:[23,43,39],capa c:[43,10],least:[7,8],getstat:31,paramt:11,l_partkei:[50,14,7],too:35,saint:17,which:[49,31,16,42,44,40,17,18,7,20,48,50,33,39],termin:5,scheme:[25,39],boot:[39,48],"final":[41,42,39,48],store:[11,31,16,41,5,18,20,48,9,39,10],editor:[31,43],mysql_jdbc_driv:[41,48],shell:[12,39,26],option:[11,46,39,40,50,7,17,52],inspect:38,especi:22,namespac:42,tool:9,copi:[26,48],inexact:22,grouping_column_refer:7,radian:24,"short":[18,7],enclos:7,mostli:18,twenti:17,attempt:17,exactli:8,geoip_country_cod:3,serv:31,enjoi:39,kind:7,target:[24,14,42,31,48,39],keyword:[7,20],provid:[2,3,5,8,10,29,46,18,20,23,30,31,33,35,38,39,41,42,45,16,48,49],expr:7,remov:[50,15,48,39],tree:39,second:[31,15,48,17],mmdd:17,charact:[15,17,18,19,8,22,33,5],project:[16,35],serd:[18,5],arc:24,posix:8,balanc:16,becom:[31,44,17],tajoresourcemanag:31,float8:[24,22,14,52,9],minut:[41,39,17],listen:[42,43],codegen:49,unix_timestamp:17,comput:[7,17],abov:[18,2,29,20,39],textserd:20,ran:48,julian:17,respons:[11,16,2,29,39],mind :17,ani:[42,35,5,31,7,8,48,9],"return":[24,15,3,17,8,5],packag:[41,42],chmod:43,manner:42,have:[12,25,41,17,50,48],further:5,need:[34,31,41,42,17,18,20,48,35,52,5,39],maxmind:3,predic:[12,19,36],calendar:17,test_min_task_num:49,cli_null_char:49,tajocli:[31,44],catalogstor:31,squar:24,zero:[8,17],partsupp:9,statement:[11,42,14,40,46,35,44,5,18,7,8,9,50,33,39,20],click:39,note:[8,48,17],also:[44,17,31,19,8,48,9,49,7,5,39,20],client:[12,43,6,48,31],take:[41,7,39],xxxxxx:48,techniqu:16,combin:7,subject:7,brace:11,prepar:[41,39,48],singl:[12,43,17,31,8,34,35,38],compat:[12,52,10],lineitem_100_snappi:50,c_nationkei:52,unless:[41,17],distribut:48,preliminari:37,buffer:[39,35],price:19,enter:[12,39],compress:12,deflatecodec:50,untar:39,most:[33,48,5],microsecond:17,specifi:[3,5,7,8,10,14,46,17,18,20,22,23,25,40,33,35,39,41,42,44,48,53],deploi:31,phase:19,metacharact:8,choos:39,cbrt:24,"class":[41,42,5,18,8,48,20],appear:7,other:[14,31,16,44,17,18,7,26,5,10],doi:17,don:[42,39,26,52],consist: [26,17,18,7,20,34,5],url:[25,42,34],doc:9,clear:9,binaryserd:20,request:10,uri:[31,48],order:[42,34,22,16,43,41,35,33,44,5,18,7,48,9,19,51,39,10],salari:7,part:[17,9],snapshot:[39,48],classnotfoundexcept:42,determin:[51,7,10],pattern:[12,15,17],pst:[44,5],pars:5,querymast:[31,10],axi:24,remot:43,dow:17,pope:17,show:[46,42,48,9,49,39],text:[11,15,22,31,35,43,3,5,18,44,19,8,9,50,33,52,17,39,20],hostnam:[40,25,42,43,48],rtrim:15,syntax:[7,53],column_refer:8,session:[12,38,44,9],l_discount:7,identifi:[7,48,17],rang:[12,30],ship_dat:19,find:31,xml:37,absolut:[24,39,48,9],row_num:7,explicitli:[7,26],ratio:10,just:[31,7,8,48,49,23,52],copyright:9,much:10,explain:[42,43,5,18,7,34,39],cpu:10,apach:[41,3,48,39],abbrevi:[17,44,5],than:[11,24,14,41,17,7,8,39],jan:17,fmhh:17,ymd:51,l_quantiti:[14,7],tbname:9,search_condit:7,local:[48,3,10,17],test_filter_pushdown_en:49,haven:19,ddsp:17,info:[46,31,6],"53rd":17,cube:24,variou:[49,34,17],get:[31,48,17],fmmonth:17,familiar:[18,5,35],express:[12,36, 15,17],disagre:17,ceil:24,repo:[39,48],cannot:5,java_hom:39,progress:[11,16,2,46,29],increas:43,score:[11,29,5,18,33,20,35,39],requir:[31,29,7,39,17],layout:[33,34],table_refer:7,bar:5,enabl:[31,42,43,44,5,18,33,48,35],tajodriv:42,upper:[15,17],grtajo01:46,borrow:8,"public":42,ddth:17,current_timestamp:17,common:[12,7],dist_query_sort_task_volum:49,contain:[31,42,50,43,17],clean:[41,42,39,48],metadata:18,where:[12,43,19,8,48,22,39,10],valid:17,bytea:22,view:34,respond:41,set:48,ascend:7,"float":[24,22,5,18,19,20,35,33,39,10],frame:7,knowledg:5,startup:40,memstor:48,c_custkei:52,see:[48,43,39,10,17],num:[40,7,5],sec:[11,29,46,2,48,39],result:[12,42,35,44,17,31,7,9,39],arg:[46,42],fail:5,close:42,rlike:8,unqualifi:[19,7],improv:35,o_orderstatu:9,valn:8,awar:[41,10],statu:31,detect:31,kei:[11,30,17,18,19,20,49,50],correctli:[22,39],record:[18,5,8,20,35],down:[8,39],ieee:22,char_length:15,below:[39,17,18,35,5,52],yet:19,cli_print_pause_num_record:49,smallest:[24,35],subdir:14,prune:12," \u02c6ab":15,l_orderkei:[50,14,7],neither:8,paramet:[24,12,15,3,17,18,33,35,50,5],approach:52,fsshell:23,altern:[8,48],accord:[22,7,5],parent:39,era:17,numer:17,executor_groupby_inmemory_hash_threshold:49,vatican:17,hadoop_hom:[43,39],add_dai:17,o_totalpric:9,remaind:24,gregorian:17,outfil:52,disconnect:[49,31],argument:[24,29,17,7,9,23],problem:[31,2],monitor:31,both:[15,31,16,5,18,7,20],last:[7,17],"85e7":17,admin:[46,9],fault:16,howev:35,gzipcodec:50,c_comment:52,groupbi:12,against:39,april:44,roman:17,instanc:[25,43,39],compressioncodec:[18,5],context:17,logic:[8,34],let:20,whole:10,fmyyyi:17,load:[16,39],trim:15,english:17,jdbc4:48,oraclestor:48,point:[18,31,17],overview:12,period:[31,17],split_part:15,header:18,rpc:[31,42,43,6],written:[18,44,20,5],param:[11,40,7],shutdown:31,toler:[16,5],respect:[22,8],tuesdai:17,guid:9,assum:[29,19,39,10,17],transitiontobackup:31,abscissa:24,cathedr:17,quit:9,xzvf:[42,39],strong:52,java:[12,41,26,39,48],creat:[12,43,39,48,52],nonsens:17,inve rs:9,empti:[18,7,5],compon:31,"int":[24,15,22,17,18,19,20,35,33,5,39],json:5,trigger:31,besid:5,interpret:17,basic:[16,12,52,20,5],addit:[14,42,44,7,8,10],c_mktsegment:52,multipli:17,pdist:[41,42,39,48],derbystor:[31,48],o_custkei:9,legaci:3,exercis:39,num2:24,decimaln:9,suppress:17,xxx:9,worker:37,search:12,cli_output_formatter_class:49,wish:11,tajojdbccli:42,coordin:24,understand:34,togeth:17,func:7,input:[24,15,17],"catch":42,repetit:8,countri:[3,17],due:10,those:[42,18,5,33,35],statist:31,emploi:16,consum:35,ident:17,implementaion:25,plain:[18,20],servic:[37,43,48],properti:[12,25,34,26,41,43,3,31,48,51,6,10],iyi:17,batch:16,alter:41,cli_max_column:49,cast:[12,17],"while":[42,17],uniqu:49,behavior:7,error:[17,50,5],wild:19,exist:[50,18,14,40],empsalari:7,region:9,lazybinarycolumnarserd:18,textserializerdeseri:[18,20,5],bin:[11,29,40,41,2,43,52,31,48,39],layer:25,relat:[7,35],advantag:35,ctrl:[31,43,39],key1:49,tabl:[41,39,48,52],servicenam:48,them:[7,44],activ:31,cluster:[37,48] ,"default":[31,37,43,26,48],itself:[31,9],warehous:[16,23,50],textfil:12,conf:[25,26,40,41,43,3,44,31,48,39,10],centuri:17,crash:31,mod:24,abcdef:15,primit:22,conn:42,writ:5,"null":[42,7],develop:[12,39],"35b":39,grant:48,perform:7,suggest:39,seoul:[33,44,5],format:31,classpath:12,hadoop:[16,42,43,5,18,33,8,26,35,50,23,39,20],sqrt:24,binari:[12,39,48],epoch:17,html:9,pad:17,split:15,largest:24,dtar:[41,42,39,48],start:[31,43,15,17],conflict:31,higher:39,week:17,varbit:22,lineitem:[50,14,46,7,9],http:[3,6,31,48,9,39],nio:12,denot:8,optim:16,nest:35,driver:[12,41,48],geoip_in_countri:3,col3:14,jkl:39,column_nam:50,moment:[5,35],rais:24,dskiptest:[41,42,39,48],user:[25,41,17,31,48,39,10],tajo_classpath:48,mani:[18,42,44,10,9],extern:[12,39,18,50,19,52],nation:9,tsql:[12,44,39,52],typic:7,built:[18,42,9],lower:[15,17],appropri:[39,26],off:17,lib:48,mention:18,com:[31,43,3],thu:[41,39],page:[12,43,35],well:[50,14,22,17],parenthes:[7,8],inherit:[18,5],to_numb:17,exampl:[31,43,52,48],comma nd:[12,41,44,52,38,39],thi:[11,12,52,34,26,41,42,43,44,5,31,7,8,48,35,23,17,39,10,20],filesystem:39,gzip:35,fmmm:17,lc_time:17,createdatabaseifnotexist:48,fmmi:17,left:7,explan:39,construct:[7,17],protocol:39,entri:[31,50,43],execut:[31,43,10],less:[24,17],when:[14,42,17,31,7,48,35,50,5,39],dist_query_groupby_task_volum:49,ordin:[24,17],tcp:40,jar:[41,42,48],q_1363768615503_0001_000001:39,kill:[46,31],binaryserializerdeseri:[18,20],simpli:39,rest:7,simultan:10,bit:22,languag:[16,12,39],inet4:[22,3],move:39,web:[16,31],snappi:35,all_backup:52,easi:[52,30],mix:17,disk1:10,disk2:10,disk3:10,except:[42,7,17],shortcut:23,date_ord:49,add:[26,41,42,43,31,50,48,23,51,39,10],divis:24,blob:22,versa:18,backup_and_restor:9,work1:9,expon:24,disrupt:31,modul:[12,26],euler:24,gmt:44,earli:17,applic:7,complaint:17,march:17,littl:43,serde2:[18,20],preserv:31,wai:[31,44,17,52,5],subfield:17,host1:[31,43],bzip2codec:50,"4028235e":22,iyyi:17,workload:10,phcatalog:[41,48],mon:17,background:[12,38],inser t:[12,41,36,31],database_nam:[40,50],characterist:34,licens:9,desc:[46,7],linux:9,u0001:[33,5],storage_typ:50,table1:[11,29,42,44,5,18,7,8,35,33,39,20],resid:39,like:[25,42,19,39,17],specif:[31,25,14,22,17],filenam:40,should:[25,40,41,42,43,3,17,18,44,19,48,35,50,52,5,51,39,10],manual:[18,48],msck:41,integ:[24,17,9,22,5,10],server:[12,26,39,48,31],query_succeed:39,collect:20,benefit:30,api:[12,41],necessari:16,either:[41,7,8,35,22,39],descend:7,output:[14,7,20,17],timetz:22,tajo:[37,52,48],result_set_fetch_rownum:49,another_long_table_name_5678:7,geoip:3,yyyi:17,right:7,peter:17,who:5,order_d:19,createstat:42,interv:[31,17],"1st":17,some:[12,26,22,41,2,44,5,18,7,48,35,33,17,39],begin:[17,9],tajowork:[31,26,10],certain:[18,5,14,35],arithmet:[12,7],intern:[44,26],previou:[8,17],queryid:46,test_broadcast_join_en:49,host2:[31,43],mirror:39,proper:[25,39,10,48],deprec:5,"52nd":17,row_numb:7,tmp:[23,25,39,48],cnt:7,scale:16,tajo_master_heaps:25,zong:44,channel:12,"512mb":10,been:9,avoid:[ 16,31,2,50,17],exec:20,definit:[12,36,17],pemiss:5,best:5,usernam:[39,48],alias_nam:7,tracker:[31,43,6],exit:2,select:[11,24,29,14,15,46,42,3,17,44,7,8,9,39],bigint:[22,50],rectangular:24,condit:7,fornam:42,three:[20,48,17],localhost:[40,43,31,50,48,6],ddd:17,machin:[31,40],core:[42,51,10],o_shipprior:9,run:[31,43],power:[24,8],uncompress:[20,35],ab_bc_cd:15,executor_hash_join_size_threshold:49,dist_query_table_partition_volum:49,usag:[12,17,52,35],mixtur:17,maven:[41,39,48],broken:5,step:39,atan2:24,durat:48,repositori:39,found:23,peer:6,l_extendedpric:7,subtract:17,unicod:22,c_acctbal:52,comparison:[22,8],about:34,repeat:17,actual:12,datanod:10,dist_query_groupby_partition_volum:49,dist_query_join_partition_volum:49,varbinari:22,dhadoop:39,aco:[24,9],total2:7,simul:31,degre:[24,43],regular:15,sequecnefil:20,issu:12,table_nam:[41,50,52],approxim:22,disabl:[18,5,33,35],hive_hom:[41,48],plan:[16,19,5],executor_outer_hash_join_size_threshold:49,columnarserd:18,own:[33,44,5],effici:35, consid:[31,44],primarili:17,within:[31,23,7,17],encod:35,lazybinari:20,compos:[19,35],stop:[31,2],pair:[18,20,26],master:[37,43,48],refer:[42,35,43,3,5,18,44,7,20,9,33,51,39],val3:49,float4:[22,9],"import":42,dmy:51,yyi:17,your:[39,26,31,41,42,43,25,17,18,48,35,5,51,52],manag:[12,41,30,39,48],git:48,val:49,pictur:9,hh24:17,mysqlstor:48,support:[25,52,48,17],"long":[16,7,17],custom:[52,48],avail:37,width:17,drivermanag:42,current_databas:49,q_1411357607375_0007:46,inner:7,fraction:17,replac:[15,17],"var":48,call:[12,7],metastor:41,etc:38,creation:48,snappycodec:[50,18,33,20,5],enough:48,forc:[7,17],test_join_opt_en:49,drwxr:23,compressiontyp:20,jun:17,tajoxx:15,back:31,query_run:46,int4:[22,14,15,9],jdbc:[12,41,48],max_output_file_s:49,translat:[44,17],select_stat:50,int2:22,l_shipdat:7,line:[31,44,38,43,5],"true":[3,31,20,48,35,22,10,8],int8:[24,22,14,52,9],stmt:42,count:[11,29,15,46,17,7],utc:[17,44,5],"throw":42,dist_query_broadcast_join_threshold:49,theta:24,temp:23,possibl:[7,10 ,17],whether:[18,7,8],ecosystem:35,vice:18,standbi:31,day_of_week:17,t_date:[33,44],to_timestamp:17,current_tim:17,limit:[12,10],toggl:17,sum:[11,29,7],site:37,otherwis:[40,17,7,3,8],embed:48,executequeri:42,defaultport:48,delimit:[15,44,5,50,33,39],expect:17,suppli:17,model:[12,36],featur:[11,41,5,18,33,34,35],constant:24,yyyymmdd:17,semicolon:[23,29],btrim:15,host:[40,46,42,43,31,48,51],retriev:[44,17],dure:19,pid:31,doesn:41,repres:[17,5],"char":[22,17],novemb:17,ipv4:[22,3],implement:[12,17,39,9],"20000nov31":17,file:[37,52],home:[41,39,48,52],doe:[42,44,17,31,50,35,7,5],match:[12,22,15,17],link:39,fill:[42,17],incorrect:31,tab:5,password:48,successfulli:[46,31],codec:[50,18,33,20,5],know:[43,44,7,39,17],sort_expr:7,index:12,percent:8,detail:[46,35,43,17,7,48,9,39],getstr:42,debug_en:49,finish:31,bracket:8,bool:22,o_clerk:9,branch:12,varieti:26,test:48,scan:41,you:[2,3,5,7,8,9,10,11,29,14,17,18,19,20,39,23,25,26,31,33,35,52,40,41,42,43,44,48,50,51],node:[31,42,43,48,10],polar:24 ,iddd:17,intend:17,exp:24,highli:[39,44],customserializerdeseri:5,sequenc:8,symbol:11,introduc:12,text_nul:49,briefli:7,insensit:8,mondai:17,tajomast:[37,43,48],columnar:[18,35],src:[42,39,17],decemb:17,max:5,lead:[19,15,17],algorithm:[18,5,10,35],trail:[15,17],hyunsik:[52,9],accept:[44,5],regexp:8,descript:[46,6,17,31,8,48,9,22,51,39,10],hello:17,select_list:7,carriag:5,place:9,ignor:[17,10,5],invok:31,mariadbstor:48,time:31,supergroup:23,name2:49,"export":[41,39,48],backward:10,dst:[44,5],unset:[49,9],name3:49},objtypes:{"0":"py:function"},objnames:{"0":["py","function","Python function"]},filenames:["partitioning/hash_partitioning","backup_and_restore","tsql/background_command","functions/network_func_and_operators","partitioning/range_partitioning","table_management/csv","configuration/service_config_defaults","sql_language/queries","sql_language/predicates","tsql/meta_command","configuration/worker_configuration","tsql/execute_file","index","functions","sql_language/insert","fu nctions/string_func_and_operators","introduction","functions/datetime_func_and_operators","table_management/rcfile","partitioning/column_partitioning","table_management/sequencefile","configuration/catalog-site-xml","sql_language/data_model","tsql/dfs_command","functions/math_func_and_operators","configuration/tajo_master_configuration","configuration/preliminary","table_management/compression","faq","tsql/single_command","partitioning/intro_to_partitioning","configuration/ha_configuration","table_partitioning","table_management/table_overview","table_management","table_management/parquet","sql_language","configuration","tsql","getting_started","tsql/intro","hcatalog_integration","jdbc_driver","configuration/cluster_setup","time_zone","table_management/file_formats","tsql/admin_command","tajo_client_api","configuration/catalog_configuration","tsql/variables","sql_language/ddl","configuration/tajo-site-xml","backup_and_restore/catalog","sql_language/sql_expression"],titles:["Hash Par titioning","Backup and Restore","Executing as background process","Network Functions and Operators","Range Partitioning","CSV (TextFile)","Cluster Service Configuration Defaults","Queries","Predicates","Meta Commands","Worker Configuration","Executing Queries from Files","Apache Tajo\u2122 (dev) - User documentation","Functions","INSERT (OVERWRITE) INTO","String Functions and Operators","Introduction","DateTime Functions and Operators","RCFile","Column Partitioning","SequenceFile","The catalog-site.xml File","Data Model","Executing HDFS commands","Math Functions and Operators","Tajo Master Configuration","Preliminary","Compression","FAQ","Executing a single command","Introduction to Partitioning","High Availability for TajoMaster","Table Partitioning","Overview of Tajo Tables","Table Management","Parquet","SQL Language","Configuration","Tajo Shell (TSQL)","Getting Started","Introducing to TSQL","HCatalog Integration","Tajo JDBC Driver","Cluster Setup","Time Zone","File Formats","Adm inistration Commands","Tajo Client API","Catalog Configuration","Session Variables","Data Definition Language","The tajo-site.xml File","Backup and Restore Catalog","SQL Expressions"],objects:{"":{trim:[15,0,1,""],upper:[15,0,1,""],to_char:[17,0,1,""],btrim:[15,0,1,""],regexp_replace:[15,0,1,""],cbrt:[24,0,1,""],split_part:[15,0,1,""],sign:[24,0,1,""],add_months:[17,0,1,""],to_date:[17,0,1,""],tan:[24,0,1,""],extract:[17,0,1,""],current_time:[17,0,1,""],floor:[24,0,1,""],sqrt:[24,0,1,""],acos:[24,0,1,""],char_length:[15,0,1,""],current_date:[17,0,1,""],abs:[24,0,1,""],degrees:[24,0,1,""],pow:[24,0,1,""],pi:[24,0,1,""],sin:[24,0,1,""],ltrim:[15,0,1,""],atan:[24,0,1,""],asin:[24,0,1,""],cos:[24,0,1,""],ceil:[24,0,1,""],atan2:[24,0,1,""],rtrim:[15,0,1,""],now:[17,0,1,""],utc_usec_to:[17,0,1,""],geoip_in_country:[3,0,1,""],mod:[24,0,1,""],lower:[15,0,1,""],radians:[24,0,1,""],date_part:[17,0,1,""],to_timestamp:[17,0,1,""],geoip_country_code:[3,0,1,""],add_days:[17,0,1,""],exp:[24,0,1,"" ],div:[24,0,1,""],round:[24,0,1,""]}},titleterms:{code:[42,39],execut:[11,2,29,23,39],queri:[11,7,39],session:49,permiss:43,mysql:48,hcatalogstor:48,languag:[36,50],paramet:11,xml:[21,51,26],oracl:48,zone:[33,44],how:[31,42,5,18,19,35],configur:[25,31,48,37,6,10],apach:[18,12,5,19,35],window:7,local:39,match:8,real:22,sourc:[42,39],synopsi:[46,40],string:[8,53,15],format:[45,17],handl:5,faq:[28,42],terminolog:31,background:2,introduct:[16,30],insert:14,document:12,like:8,administr:[46,31],level:52,drop:50,hive:[18,5,19,35],server:44,mode:[43,10],partit:[0,32,19,30,4],each:10,fulli:43,where:7,manag:[33,34],failov:31,set:[11,42,43,31,51,39],hcatalog:41,dump:52,dowload:39,meta:9,download:39,run:10,todo:[0,27,28,4,33,47,52],time:[51,33,44,17],out:39,compat:[18,5,19,35],network:3,cast:53,databas:[50,52],preliminari:26,definit:50,state:31,directori:[43,10],channel:42,get:[42,39],method:30,math:24,common:33,qualifi:7,hash:0,compress:[50,27,33],gener:18,usag:[11,46,9],serializerdeseri:20,ba se:43,prerequisit:[3,39],releas:39,from:[11,42,7],rcfile:18,valu:[11,22,5],postgresql:48,convers:17,launch:[31,43],column:19,tajo:[12,25,18,51,42,43,6,31,33,26,47,38,39],groupbi:7,datetim:17,integr:41,backup:[31,1,52],first:39,oper:[24,17,3,15],rang:4,via:39,overview:[33,7],tajomast:[31,25],number:[22,10],automat:31,date:[51,17],api:47,size:[25,10],writer:20,git:39,java:42,memori:[25,10],data:[22,50,10],support:3,doubl:22,system:51,overwrit:14,custom:5,avail:31,start:39,call:53,basic:[11,46,9],master:[31,25,6],type:[22,7,53],"function":[24,13,15,3,17,7,53],setup:43,shell:[40,38],claus:7,worker:[43,6,10],rootdir:25,heap:[25,10],jdbc:42,unpack:39,join:7,prune:19,restor:[1,52],"default":6,servic:6,properti:[18,5,33,35],maximum:10,dev:12,orderbi:7,hdf:23,serd:20,limit:7,introduc:[40,20],parquet:35,similar:8,file:[11,21,45,51,31],creat:[50,18,5,19,35],process:2,site:[21,51,26],indic:12,high:31,cluster:[31,44,43,39,6],unresolvedaddressexcept:42,textfil:5,have:7,tabl:[12,33,44,5,18,32,19,3 4,35,50,7],serial:[18,5],"null":5,dedic:10,issu:[18,5,19,35],make:43,ilik:8,when:18,cross:7,check:39,binari:42,exampl:[42,7,44,10],build:[42,39],env:26,test:31,distribut:[42,43],csv:5,config:51,singl:29,variabl:49,express:[8,53],resourc:10,nio:42,classpath:42,enter:40,driver:42,catalog:[21,26,52,48],regular:8,temporari:10,user:12,sql:[11,36,52,53],extern:33,mariadb:48,tsql:[40,38],parallel:10,physic:[18,5,35],derbi:48,task:10,read:18,predic:8,arithmet:53,alias:7,client:[42,47,44],command:[46,23,29,9],pattern:8,model:22,sequencefil:20,latest:39}}) \ No newline at end of file Modified: tajo/site/docs/devel/sql_language/ddl.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/sql_language/ddl.html?rev=1650343&r1=1650342&r2=1650343&view=diff ============================================================================== --- tajo/site/docs/devel/sql_language/ddl.html (original) +++ tajo/site/docs/devel/sql_language/ddl.html Thu Jan 8 17:49:23 2015 @@ -186,7 +186,7 @@ <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">DATABASE</span> <span class="p">[</span><span class="n">IF</span> <span class="k">NOT</span> <span class="k">EXISTS</span><span class="p">]</span> <span class="o"><</span><span class="n">database_name</span><span class="o">></span> </pre></div> </div> -<p><code class="docutils literal"><span class="pre">IF</span> <span class="pre">NOT</span> <span class="pre">EXISTS</span></code> allows <code class="docutils literal"><span class="pre">CREATE</span> <span class="pre">DATABASE</span></code> statement to avoid an error which occurs when the database exists.</p> +<p><tt class="docutils literal"><span class="pre">IF</span> <span class="pre">NOT</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">CREATE</span> <span class="pre">DATABASE</span></tt> statement to avoid an error which occurs when the database exists.</p> </div> <div class="section" id="drop-database"> <h2>DROP DATABASE<a class="headerlink" href="#drop-database" title="Permalink to this headline">¶</a></h2> @@ -194,7 +194,7 @@ <div class="highlight-sql"><div class="highlight"><pre><span class="k">DROP</span> <span class="k">DATABASE</span> <span class="p">[</span><span class="n">IF</span> <span class="k">EXISTS</span><span class="p">]</span> <span class="o"><</span><span class="n">database_name</span><span class="o">></span> </pre></div> </div> -<p><code class="docutils literal"><span class="pre">IF</span> <span class="pre">EXISTS</span></code> allows <code class="docutils literal"><span class="pre">DROP</span> <span class="pre">DATABASE</span></code> statement to avoid an error which occurs when the database does not exist.</p> +<p><tt class="docutils literal"><span class="pre">IF</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">DATABASE</span></tt> statement to avoid an error which occurs when the database does not exist.</p> </div> <div class="section" id="create-table"> <h2>CREATE TABLE<a class="headerlink" href="#create-table" title="Permalink to this headline">¶</a></h2> @@ -206,7 +206,7 @@ <span class="k">using</span> <span class="o"><</span><span class="n">storage_type</span><span class="o">></span> <span class="p">[</span><span class="k">with</span> <span class="p">(</span><span class="o"><</span><span class="k">key</span><span class="o">></span> <span class="o">=</span> <span class="o"><</span><span class="n">value</span><span class="o">></span><span class="p">,</span> <span class="p">...)]</span> <span class="k">LOCATION</span> <span class="s1">'<path>'</span> </pre></div> </div> -<p><code class="docutils literal"><span class="pre">IF</span> <span class="pre">NOT</span> <span class="pre">EXISTS</span></code> allows <code class="docutils literal"><span class="pre">CREATE</span> <span class="pre">[EXTERNAL]</span> <span class="pre">TABLE</span></code> statement to avoid an error which occurs when the table does not exist.</p> +<p><tt class="docutils literal"><span class="pre">IF</span> <span class="pre">NOT</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">CREATE</span> <span class="pre">[EXTERNAL]</span> <span class="pre">TABLE</span></tt> statement to avoid an error which occurs when the table does not exist.</p> <div class="section" id="compression"> <h3>Compression<a class="headerlink" href="#compression" title="Permalink to this headline">¶</a></h3> <p>If you want to add an external table that contains compressed data, you should give ‘compression.code’ parameter to CREATE TABLE statement.</p> @@ -238,7 +238,7 @@ <div class="highlight-sql"><div class="highlight"><pre><span class="k">DROP</span> <span class="k">TABLE</span> <span class="p">[</span><span class="n">IF</span> <span class="k">EXISTS</span><span class="p">]</span> <span class="o"><</span><span class="k">table_name</span><span class="o">></span> <span class="p">[</span><span class="n">PURGE</span><span class="p">]</span> </pre></div> </div> -<p><code class="docutils literal"><span class="pre">IF</span> <span class="pre">EXISTS</span></code> allows <code class="docutils literal"><span class="pre">DROP</span> <span class="pre">DATABASE</span></code> statement to avoid an error which occurs when the database does not exist. <code class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></code> statement removes a table from Tajo catalog, but it does not remove the contents. If <code class="docutils literal"><span class="pre">PURGE</span></code> option is given, <code class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></code> statement will eliminate the entry in the catalog as well as the contents.</p> +<p><tt class="docutils literal"><span class="pre">IF</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">DATABASE</span></tt> statement to avoid an error which occurs when the database does not exist. <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></tt> statement removes a table from Tajo catalog, but it does not remove the contents. If <tt class="docutils literal"><span class="pre">PURGE</span></tt> option is given, <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></tt> statement will eliminate the entry in the catalog as well as the contents.</p> </div> </div> Modified: tajo/site/docs/devel/sql_language/insert.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/sql_language/insert.html?rev=1650343&r1=1650342&r2=1650343&view=diff ============================================================================== --- tajo/site/docs/devel/sql_language/insert.html (original) +++ tajo/site/docs/devel/sql_language/insert.html Thu Jan 8 17:49:23 2015 @@ -180,7 +180,7 @@ <div class="section" id="insert-overwrite-into"> <h1>INSERT (OVERWRITE) INTO<a class="headerlink" href="#insert-overwrite-into" title="Permalink to this headline">¶</a></h1> -<p>INSERT OVERWRITE statement overwrites a table data of an existing table or a data in a given directory. Tajo’s INSERT OVERWRITE statement follows <code class="docutils literal"><span class="pre">INSERT</span> <span class="pre">INTO</span> <span class="pre">SELECT</span></code> statement of SQL. The examples are as follows:</p> +<p>INSERT OVERWRITE statement overwrites a table data of an existing table or a data in a given directory. Tajo’s INSERT OVERWRITE statement follows <tt class="docutils literal"><span class="pre">INSERT</span> <span class="pre">INTO</span> <span class="pre">SELECT</span></tt> statement of SQL. The examples are as follows:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">create</span> <span class="k">table</span> <span class="n">t1</span> <span class="p">(</span><span class="n">col1</span> <span class="nb">int8</span><span class="p">,</span> <span class="n">col2</span> <span class="n">int4</span><span class="p">,</span> <span class="n">col3</span> <span class="n">float8</span><span class="p">);</span> <span class="c1">-- when a target table schema and output schema are equivalent to each other</span> Modified: tajo/site/docs/devel/sql_language/predicates.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/sql_language/predicates.html?rev=1650343&r1=1650342&r2=1650343&view=diff ============================================================================== --- tajo/site/docs/devel/sql_language/predicates.html (original) +++ tajo/site/docs/devel/sql_language/predicates.html Thu Jan 8 17:49:23 2015 @@ -230,7 +230,7 @@ <span class="n">string</span> <span class="k">NOT</span> <span class="k">SIMILAR</span> <span class="k">TO</span> <span class="n">pattern</span> </pre></div> </div> -<p>It returns true or false depending on whether its pattern matches the given string. Also like LIKE, <code class="docutils literal"><span class="pre">SIMILAR</span> <span class="pre">TO</span></code> uses <code class="docutils literal"><span class="pre">_</span></code> and <code class="docutils literal"><span class="pre">%</span></code> as metacharacters denoting any single character and any string, respectively.</p> +<p>It returns true or false depending on whether its pattern matches the given string. Also like LIKE, <tt class="docutils literal"><span class="pre">SIMILAR</span> <span class="pre">TO</span></tt> uses <tt class="docutils literal"><span class="pre">_</span></tt> and <tt class="docutils literal"><span class="pre">%</span></tt> as metacharacters denoting any single character and any string, respectively.</p> <p>In addition to these metacharacters borrowed from LIKE, ‘SIMILAR TO’ supports more powerful pattern-matching metacharacters borrowed from regular expressions:</p> <table border="1" class="docutils"> <colgroup> @@ -278,7 +278,7 @@ </tr> </tbody> </table> -<p>Note that <cite>.`</cite> is not used as a metacharacter in <code class="docutils literal"><span class="pre">SIMILAR</span> <span class="pre">TO</span></code> operator.</p> +<p>Note that <cite>.`</cite> is not used as a metacharacter in <tt class="docutils literal"><span class="pre">SIMILAR</span> <span class="pre">TO</span></tt> operator.</p> </div> <div class="section" id="regular-expressions"> <h3>Regular expressions<a class="headerlink" href="#regular-expressions" title="Permalink to this headline">¶</a></h3>
