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