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