text: Search.setIndex({terms:{expect:[15,28,31,37],string2:46,place:5,bit:39,actual:31,predic:[10,15,31],also:[20,22,13,1,32,42,31],xbootclasspath:20,whole:10,extend:1,previous:15,heap:20,collector:20,ffff:[20,12],iso:4,sun:4,ordinalposit:34,data_1_week:31,client:15,uniqu:[20,12,26],ascii:46,pad:3,approx_distinct:[16,40,35],"2nd":4,regexp_extract:28,show:[6,0,24,25,41,42,43,30,31,45,33,34],deploy:20,union:[13,15],count:[16,13,15,34,35,31,36],bin:20,style:3,rank:26,lineitems_sampl:36,subqueri:10,"150m":20,self:14,doubl:[3,10,4,5,39,35],foreground:20,local:20,string:[21,3,22,10,15,4,38,32,28,34,30,46],absolut:[13,5],compress:[20,42],table_nam:[7,13,47,25],semant:10,further:[13,31],json_array_contain:22,squar:5,restrict:[13,45],oppos:22,differ:[14,20,12,13,10,26],truncat:[3,5],full:[42,31],caus:20,localhost:14,parenthesi:4,frame:26,empti:14,unix:[14,4],rescal:36,perman:20,record:[13,31],structur:13,describ:[20,6,4,25,42,30],finit:5,lazybinarycolumnarserd:[1,31],stopgap:2,url_extract_paramet:38,continu:15,hadoop:[16,20,15,42,36],mai:[20,13,18,32,28,31],across:[20,15,26,31],interact:14,automat:[20,37],coordin:[20,15,40,27,42,31],hivetyp:34,getschema:15,content:[20,15,42],detect:[15,31],analyz:[15,36],succe:15,januari:4,thu:[20,26],csv:42,orders_by_d:[7,1,47],incompat:[13,1,15,31],cli:[14,31],mktid:25,replac:[20,28,46],effici:31,referenc:[22,28],manag:15,below:[20,3],instead:10,hadoop2:[16,20],reliabl:36,deviat:35,whenev:16,sum:[1,47,35],would:[20,15,31],"3rd":4,sql:[6,1,10,4,32,40,29,30,36,46],"void":15,teardown:15,onoutofmemoryerror:[20,12],instanc:[20,12,28,46],jan:4,join:[20,13,1,10,15,31,36],good:20,filenam:20,supervis:20,although:31,url_extract_protocol:38,output:[20,3,13,10,15,34],amount:20,yet:[2,4],optim:[16,15,27,31],ringo:32,altern:[20,36],here:20,evenli:15,write:[20,42,36],bytecod:20,sundai:4,compar:[32,31],counter:40,sat:4,veri:[20,10,15],replic:35,"_col0":[13,18,32,34,36],john:32,suffix:4,bigint:[3,22,13,10,4,38,39,26,46,34,35,37],onli:[20,13,15,4,28,31],rest:46,ident:13,backquot:10,"var":[20,12],number:[16,13,5,20,22,10,15,38,40,26,28,31,46,35],book:22,field:[4,46],"0xff0000":3,reserv:31,queu:15,mean:[14,35,31],vice:[10,37],simpli:[20,15],css:3,date_diff:4,remain:20,schema:[16,17,14,20,6,9,15,33,42,30,31,36,45],correctli:[40,31],substr:[10,28,46],fix:[16,2,23,15,40,31,36],specifi:[16,17,3,13,4,20,8,22,38,32,26],command:[14,20,15,19,42,30],unpartit:1,tablescan:34,"true":[20,3,1,18,25,39,32,34,35,36],alwai:[10,15],lz4:42,some:[20,15,27],day_of_week:4,undefin:32,width:3,json_extract:22,tabl:[0,13,1,18,4,20,6,7,23,10,15,24,25,42,30,31,45,47,32,36],identifi:[20,10,38,31],permsiz:20,modulu:5,split_part:46,wherea:10,negat:18,main:20,renam:14,getservic:15,truth:[18,32],remov:[28,46],too:20,remaind:[3,5],interpret:[20,46],unit:4,"break":4,hand:20,classifi:15,previou:31,get:10,pseudo:5,semaphor:2,variabl:[14,39],laid:13,chart:3,necessari:37,centuri:4,"catch":15,is_finit:5,sort:[0,13],part:[2,10],declar:31,sqrt:5,quarter:[4,25],horizont:3,appl:36,trigonometr:5,utf:46,your:[16,20,1,9,10,15,31,36],termin:[14,20],rang:[3,15,4,5,32,31],intern:[20,2],var_pop:35,dure:[20,15,31],unless:1,line:[14,20,3,15,19,42,30],compat:[13,4],from_item:13,start:[20,0,10,15,4,26,46],hang:[23,42],simpledateformat:4,larg:[23,15,40,36],executor:15,longer:31,roadmap:31,avoid:[20,27],improv:[16,20,15,40,27,31,36],bind:42,avail:[14,41,43,31],given:26,code:[3,1,15,42,31,46],inexact:39,impact:13,earli:15,cyan:3,lower:46,warn:[20,4,46],percent_rank:26,cbrt:5,larger:[20,31,46],group:[16,20,13,1,15,47,26,28,31],found:[15,46],synthet:15,stderr:20,thi:[13,1,14,2,15,16,3,4,5,20,6,22,10,39,26,28,31,46,35,36,37],radian:5,build:15,infin:5,lai:31,regexp_lik:28,weekdai:4,originaptind:25,state:[20,42],date:[21,0,4,30,31],within:[3,32,26,28],redund:27,argument:[16,3,13,4,5,32,31],insid:[20,12],underscor:15,granular:13,futur:[4,36],doe:[16,13,15,4,42,35,31],approxim:[16,35,36],count_if:35,to_unixtim:4,second:[13,15,4],first:[20,2,13,10,15,4,38,28,46],mathemat:[21,5,30],"0th":4,zone:4,cross:1,normal:[14,35,31],row:[20,13,10,15,25,26,33,35,31,36],integ:[10,4,5,39,35],timestamp2:4,signifi:32,push:15,"abstract":[1,10],partit:[6,0,1,15,25,40,26,30,31],now:[16,15,4,31,36],year:[0,4,25],represent:46,add:[20,2,9,15,4,42,36],event:31,stddev:[35,36],item:[16,15,35],access:[16,20,9,15,42,31],set:[14,20,13,39,35,31],machin:[20,31],connectormetadata:1,requir:[16,20,13,26,42],version:[20,2,15,36],logarithm:5,attribut:24,each:[16,20,13,15,26,31],classif:27,document:[42,30,31],"import":[20,15],"_col1":36,parse_datetim:4,leav:20,bear:36,orderd:[1,47],price:[1,47,26],sequenc:[26,46],left:10,lineitem:36,"0xffff00":3,section:4,initi:[20,31],specif:[20,3,13,15,26,35,31,36],statist:35,purpos:42,transfer:16,method:[13,15],determinist:13,develop:[20,2],versa:[10,37],creat:[20,6,12,3,1,15,47,42,30,36],stddev_pop:35,hold:[20,12],lib:20,resourc:[12,15,42],suffic:20,"0xaa":3,packag:[20,15],info:20,hyperloglog:35,align:31,cde:3,decim:[5,36],alia:[13,4,5,25,35],join_column:13,relev:20,probabl:13,fetch:[22,31],stddev_samp:35,miscellan:[16,36],point:[20,10,5,39,46],effect:[18,35],str_to_dat:4,product:[20,12],typic:[20,38],node:[20,12,15,42],floor:5,length:[22,39,46],manner:38,cosin:5,cume_dist:26,occur:20,greater:32,finish:15,lone:12,minimum:[20,39,35],must:[16,20,2,22,10,32,35,36],hyperbol:5,constructor:36,com:[20,42],substanti:[16,20,2],serd:[1,31],batch:15,safer:31,certain:[16,13,15],unpack:[20,12],occurr:28,interfac:[14,15,19,42,30],root:5,where:[20,0,13,10,4,26,34,31],pattern:[4,28,45],amazonaw:42,var_samp:35,inner:1,option:[14,20,0,12,34,31],"class":[20,1,9,15],fast:31,wrong:31,paramet:[8,3,25,38,32,33],user:[16,2,10,15,31],activ:40,incorrectli:[15,46],hivesplitsourc:23,captur:[20,3,39,28],soon:15,splittabl:2,term:[13,4],more:[16,14,13],addition:15,top:[20,36],information_schema:33,timestamp1:4,path:[20,9,38,31],arithmet:[39,35],illustr:13,green:3,driver:[16,9,15,19,30,36],spec:10,json:[21,22,15,42,30,31],encod:[22,31],constraint:[34,31],influenc:13,word:28,upgrad:[20,42],creation:[1,15],"long":[15,40],exp:5,cassandra:[2,31,36],includ:[20,13,15,32,28,35,31],analog:26,incorrect:40,catalog:[16,14,20,6,8,9,15,41,33,42,30,31],seqnum:25,dow:4,end:[20,3,22,35,46],lowercas:46,airline_data:34,black:3,featur:[20,2,36],move:10,few:[20,31],citi:16,file:[14,20,2,12,15,42,31],total:[13,26],introduc:[23,15],micro:31,than:[12,13,32,28,35,31,46],inject:15,recent:0,criteria:1,fragment:[20,38],jsonpath:22,call:[20,13,10,36],mani:[16,20,10,15],tpch:[15,36],million:13,note:[16,13,1,15,4,30,44,31,36],valu:[12,3,13,4,5,14,20,22,38,39,26,42,31,32,35,36,37],want:[20,1,10],concept:10,format_datetim:4,json_arrai:22,"0xff":3,filesystem:[20,36],support:[16,1,18,4,20,2,22,9,10,15,38,39,32,42,31,36],maximum:[20,39,35,31],unicod:46,pow:5,hbase:31,banana:36,saturdai:4,dynam:15,launch:20,nor:13,arc:5,current_timestamp:4,tangent:5,sure:[20,12],respect:[10,36],encourag:15,analysi:1,measur:31,propag:[16,15],verifi:42,rgb:3,pass:3,written:[20,1,15,31],centri:4,order:[20,0,13,1,47,26,36,46],fit:3,simplifi:20,connector:[16,20,2,13,1,15,42,31,36],slash:20,contain:[20,3,22,13,47,38,28,31],plu:26,addit:[16,20,5,31],seen:42,constant:[10,5,35],servic:[20,12,15,19,42,30],issu:[15,40,36],overridden:14,white:3,explain:[6,34,30],manual:4,guarante:[13,4,32,35],percentag:[26,35],timestamp:[4,31,36],averag:35,over:[16,23,40,26,35,31],chapter:[6,4],url:[16,21,9,38,30],samplepercentag:13,provid:[14,20,42,35,46],sequenti:26,escap:28,prefer:16,planner:27,still:[20,2],vari:3,letter:36,"public":15,sinc:[15,31],apach:[20,42],preced:26,anim:36,rais:5,plugin:[2,15],repres:[4,5],memori:[16,20,31,36],leak:15,data_1_year:31,distribut:[15,26,34,35,31],akiaiosfodnn7exampl:16,least:[18,35],dot:[20,15],author:22,cube:5,foo:[20,10],round:5,convert:[3,10,15,35,37,46],same:[20,0,12,13,5,32,26,35,31,46],hadoop1:[20,42],tanh:5,minim:20,tan:5,column:[6,13,24,25,30,31,36],reproduc:15,drawn:3,forcibl:20,environment:20,workload:15,factor:10,"boolean":[3,22,13,10,18,5,39,28],kill:[20,12],invok:26,"1st":4,rand:[5,36],text:[20,34],fall:[3,32],url_extract_queri:38,how:[13,15,26,42],json_path:22,day_of_year:4,easili:20,determin:[22,10,5,26,28],magenta:3,awai:42,form:15,select:[16,0,13,1,18,14,6,22,10,15,26,30,31,47,32,34,36],inconsist:20,opaqu:4,table1:13,explicitgcinvokesconcurr:[20,12],rather:[28,35,46],url_extract_path:38,common:31,test:[15,32],extract:[4,38],backward:[1,15,31],clarifi:13,cpu:31,low_color:3,complex:[20,10,15],url_extract_host:38,messag:[20,42],current_d:4,behavior:[14,13,10,15],sine:5,dim_all_us:13,eas:15,metastor:[20,36],down:[20,15,5],properti:[16,20,12,15,42,31],custom:[16,31],languag:[10,29,30],shell:[14,20,31],loos:10,bug:[2,23,15,36],cumul:26,rnk:26,"0xcc":3,store:[20,22],need:[20,1,10,15,28,31],diagnost:20,session:[17,8],ani:[16,20,13,10,15,4,38,32,26,35,31],select_stat:13,result:[13,1,18,14,22,10,15,47,32,26,35,31,36],properli:[15,31],bundl:2,sin:5,port:[20,12,9,38],two:[16,13,10,15,4,39],discoveri:[20,12,23,19,42,30],releas:[16,2,23,1,15,4,40,27,42,30,44,31,36],similar:[26,28],special:[20,4,26],back:31,express:[13,18,4,5,21,22,10,15,28,30,31],applic:9,xmx16g:20,signific:31,origin:[25,34],between:[2,3,13,15,32,35,31,37],often:[2,15],expos:36,equal:[32,31],out:[20,13,10,36],totalpric:[1,47,26],unload:20,unbalanc:15,amazon:[16,36],jdk:20,doi:4,wait:15,aco:5,high:[20,3],api:[2,31,36],wjalrxutnfemi:16,process:[16,20,13,15,26],right:[20,10],readonlyconnectormetadata:1,mismatch:13,fewer:12,split:[20,23,15,46],level:[20,36],program:14,pagin:14,them:[0,10],"short":3,statment:13,task:[20,15,31],aggreg:[16,21,26,34,35,30,31,36],when:[20,13,10,15,40,42,31,32,36,35,37],startup:[20,12,42],mainli:20,directori:[20,2,12],serv:42,tablesampl:[13,36],regular:[21,28,30],window:[20,21,15,26,30],accept:3,jvm:[20,12,42],compil:[20,15],gener:[20,15,35,31,36],databas:20,mysql:[10,4],thrift:20,poisson:36,atan:5,"int":3,work:[16,20,0,15,32,31,46],control:[13,31],complement:[18,39],sampl:[13,35,36],rfc:38,host:[20,9,38],pushdown:31,correct:[20,42,31,37],type:[20,13,10,15,4,24,25,39,29,30,32,34,36,37],suppli:[3,15],anchor:28,day_of_month:4,consist:20,standalon:15,struct:15,"0xccddee":3,origincitynum:25,arrai:[22,15,31],keep:16,precis:39,ceil:5,atan2:5,implement:[16,2,15,39,31,36],"20140209_174939_00046_qhay4":13,"while":[20,15],our:31,handl:[2,18,15,38,32,27,36],getcatalog:15,week:4,act:14,claus:[0,13,10,15,26,31,36,45],you:[20,1,10,15,32,28,31,36],ffffffff:[20,12],stop:15,problem:15,particular:[20,13,10,37],protocol:38,download:[14,20,12,9],percentil:35,decod:[3,40,31],system:[20,13,15,31],appear:15,time:[21,13,1,4,30,31],inspect:15,"new":[1,15,47],advanc:2,scalar:[22,31],independ:13,preserv:20,databasemetadata:15,know:15,stream:20,keyword:31,list:[20,0,4,24,41,33,43,36,45],rel:46,hidden:15,userid:10,high_color:3,cosh:5,conform:38,syntax:[6,13,1,10,4,38,26,28,30,31,32,36],allow:[16,20,13,15,42,36],recommend:[20,1],filter:[0,10,15],intend:2,nodemanag:15,queri:[13,1,4,14,20,23,10,15,38,40,26,43,31,47,34,36,37],exchang:15,portion:31,coupon:25,useconcmarksweepgc:[20,12],report:[15,40,31],network:[16,31],standard:[12,1,10,4,39,35,46],inform:20,involv:[15,32],depend:[13,15],regress:[16,15,40],sometim:31,exampl:[0,12,13,16,3,18,4,20,7,8,22,9,10,25,26,42,31,46,47,32,33,34,35,36,37],less:[14,32],divis:[10,5,36],codec:42,artifact:15,disabl:14,without:[2,1,15,31],distinct:[16,13,15,32,35,31,36],unknown:32,json_array_get:[22,31],serial:16,garbag:20,abov:[20,13,4,32],countri:[16,31],physic:13,receiv:[20,31],simplest:13,uuid:42,region:20,environ:[14,20,12],after:[20,10,26],recordread:16,failur:[15,42,36],log2:5,"function":[16,3,13,4,5,20,6,21,22,15,38,26,43,28,30,31,46,35,36,37],except:[16,15,26,35],"7day_act":10,deploi:[16,20,1,15,19,30,31],presenc:32,like:[14,20,22,10,15,28,36,45],mount:[20,42],charact:[20,3,13,4,39,37,46],url_extract_frag:38,conveni:4,scan:[13,31],hive:[16,13,1,14,20,2,8,9,10,15,11,40,42,34,30,31,36],fallback:31,date_add:4,summar:[15,47],timezone_hour:4,most:[0,31],ask:32,increas:[20,15],itinid:[25,34],anoth:[20,13],stdout:20,primari:42,overflow:15,howev:20,chang:[20,2,1,15,4,31,36],next:13,known:32,search:46,logger:20,fail:[20,13,15,42,31],migrat:[10,11,30,31],perform:[16,20,10,4,5,40,26,28,31,36,46],join_typ:13,concurr:20,rewrit:31,dir:[20,12],date_format:4,dense_rank:26,explicit:15,zero:[13,15,35,36],other:[20,13,15,24,28,31],reduct:31,infinit:5,min:[32,35],connect:[20,9],torn:15,trim:46,with_queri:13,xmx1g:12,airline_origin_destin:25,per:[20,35],non:[2,42,35,31,46],equival:[13,10,32,35,37],find:[20,12,28],which:[3,13,14,20,2,10,15,32,26,42,35],plan:[20,40,34],easier:31,hivecolumnhandl:34,cloudera:20,varchar:[3,22,13,10,15,4,25,38,39,28,46,35,37],table2:13,maven:15,compound:15,"float":[20,10,5,39],model:10,hiveql:10,o_orderd:13,random:[13,5],render:3,made:15,drop:[6,7,30],english:4,tarbal:20,daemon:20,displai:40,subsequ:13,via:[20,42,36],json_array_length:22,sale:9,unixtim:4,should:[16,20,3,4,35,31],runtim:[20,13],k7mdeng:16,json_extract_scalar:22,side:[18,15,31],math:4,tpc:15,instal:[20,12,19,30],interv:[4,31],proper:[20,15],whether:[10,32],cach:42,setnodemanag:15,comparison:[21,13,18,32,30],power:5,digit:4,appli:10,"final":13,blue:3,orderid:26,yellow:3,log:[20,15,5,42],"case":[13,15,27,35,31,36],race:15,contrast:10,explicitli:37,clerk:26,outsid:[20,3],mondai:4,answer:16,avg:35,directli:42,abbrevi:4,defin:3,neg:[22,4,46],binari:[1,39,40,31],element:[22,13,31],cdh4:[20,42],from_unixtim:4,aggressiveopt:[20,12],updat:[17,8,1,15,31],retriev:13,concaten:[10,46],facebook:20,weight:35,bpxrficyexamplekei:16,bound:[13,35,31,36],"byte":46,hierarchi:20,offset:4,last:20,bucket:[35,31],cast:[13,10,18,15,39,37],launcher:20,mod:5,latenc:[15,31,36],timezone_minut:4,"null":[22,18,15,25,32,35,46],metadata:[20,42,31,36],engin:[16,15],logic:[21,13,18,34,30,31],current:[20,1,4,39,33,31,45,46],virtual:20,make:[20,12,13,15,31],detail:[16,20,2,12],tie:26,gap:26,all:[16,0,12,13,5,20,10,15,42,43,28,31,46,32,35],input:[3,5,32,26,35,31],faster:16,outcom:32,datasourc:[20,15],ltrim:46,dedic:20,schedul:[15,31],convers:[21,15,30,37],dai:[4,31],either:[3,13,10,18,32,31],posit:[5,46],select_expr:13,reboot:20,extern:20,rcfile:[1,31],upper:[35,36,46],url_extract_port:38,cluster:[20,12,15,31],microsecond:4,rotat:20,is_nan:5,five:13,confid:[35,36],presto:[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47],gain:31,attempt:[13,31],jar:[14,20,9,15],join_condit:13,kei:[16,15,25,40],carefulli:14,maxperms:20,embed:[20,42],reduc:[13,15],along:24,comput:[27,35],statement:[6,0,13,32,34,30,31,36],synopsi:[7,0,17,8,13,24,25,41,43,45,47,33,34],instrument:36,doesn:[22,13,32],delimit:[10,46],slide:26,row_numb:26,nan:5,index:[22,46],await:15,decemb:4,follow:[12,3,13,18,4,20,9,10,15,38,32,26,42,36],column_alia:13,everyth:20,approx_percentil:35,exist:[7,22,15,42],hdf:[13,31,36],demonstr:[20,18,32],strpo:46,load:20,varianc:[35,36],close:15,lot:15,sdk:36,complet:[14,31,36],produc:[20,3,13,10,15,32,26,35],outofmemoryerror:20,commun:[20,31],account:31,fruit:36,ansi:[3,1,10],refer:10,target:10,week_of_year:4,benchmark:31,accord:[3,26],"return":[3,13,18,4,5,22,10,15,38,26,42,28,46,35,36],floatingdecim:20,net:[20,9],rewritten:36,peer:26,ignor:[15,35],data:[16,20,12,13,15,24,39,42,29,30,31,32,36],locat:20,run:[14,20,12,9,26,36],modifi:31,snappi:42,fulli:[16,20],consid:[20,13,32],have:[16,20,13,1,15,26,31,36],wai:[0,12],take:18,inputformat:16,share:20,udf:2,simpl:31,incomplet:15,unfortun:31,space:[20,3,15,46],sf10:36,dump:20,separ:[38,26],config:[20,12,15,31,36],inlin:[10,36],gettabl:15,name:[13,4,14,20,8,10,15,25,38,42,28,31,45,33,34,36],were:[10,15,40,31],multipl:[20,13,5],revers:[0,46],weird:16,enabl:[20,36],bernoulli:13,etc:[20,12,15,42,31,36],singl:[20,3,13,10,35,31,46],grammar:31,limit:[16,20,0,13,15,39,31],base:[13,1,4,5,14,20,22,15],script:[20,31],fraction:3,color:[21,3,30],ffffffffffff:[20,12],approx_avg:35,neither:13,experiment:36,itself:[20,12,10],format:[20,3,1,9,4,34,31],error:[20,13,15,32,27,42,35,36],oper:[21,10,18,15,4,5,39,32,28,35,30,46],block:[2,13,15],divid:[13,10,15,5,26],red:3,track:36,"default":[14,20,3,13,18,25,32,33,34,31],mapreduc:15,possibl:[13,35,31,37],skip:13,against:13,minut:4,befor:[1,15,26,31],rtrim:46,see:[16,14,20,2,12,42,31],backslash:28,natur:5,readm:2,calcul:[3,13,26],verbos:20,metric:36,coalesc:35,best:[20,1],hash:[15,31],goe:42,could:[15,31],algorithm:31,evalu:[22,13,1,10,18,32,26,28],four:[20,4],qualifi:[16,20,31],regist:[20,12],ieee:39,graphviz:34,hour:4,descript:[0,17,13,4,5,7,8,24,25,41,43,45,47,33,34],interpol:3,lead:46,configur:[14,20,12,35],daemontool:20,request:[20,15],"1gb":20,entir:28,uppercas:46,desc:[0,13,26],detector:42,read:[16,13,42],is_infinit:5,patch:20,asc:13,bar:[20,3],distinguish:31,match:[20,15,28,31],debug:20,server:[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47],secret:16,execut:[16,14,34],help:[14,20],dataset:15,trail:46,paul:32,spi:[2,1,15,31],nearest:5,quot:[20,10,31],hexadecim:3,prevent:[15,42],valid:38,size:[20,31],jmx:[20,8,40,33,36],easi:15,presto_pag:14,uri:[20,38,42],even:[13,32],tune:20,popul:35,outer:10,month:4,map:[20,15,40,36],ground:31,publish:15,"0xffccaa":3,sourc:[20,2,31],from:[0,13,1,15,16,3,4,20,22,10,9,11,24,26,28,30,31,32,33,34,36,38,42,45,46,47],combin:[13,31],clientid:34,current_tim:4,legal:10,asin:5,implic:37,reservedcodecaches:20,rememb:10,weigh:35,heapdumponoutofmemoryerror:[20,12],jdbc:[16,9,15,19,30,31,36],regexp_replac:28,cmsclassunloadingen:20,slow:[20,31],low:[20,3],"char":46,anymor:15,subtract:[4,5],max:[20,32,35,31],can:[16,3,13,1,4,14,20,23,9,10,15,39,42,28,31,45,32,34,35,36,37],java:[20,9,4,28],adher:10,http:[20,12,15,38,42],pars:[20,4],methodhandl:16,shown:[3,13,18,32,31],object:15,everi:[16,20,12,28],"991790345e7":36,treat:[10,4,32],compon:[3,4,38,26],numer:[13,15,4,37],worker:[20,15,31],design:36,log10:5,string1:46,offer:32,due:[23,1,15],disk:[13,15,31],becaus:20,interfer:20,euler:5,anywher:36,invalid:15,both:[20,18,15,32,31],three:[3,13,26],segment:13,sign:[39,28],"0x00ff00":3,tar:[20,12],explan:20,condit:[13,15],commut:18,restor:42,major:[31,36],thei:[0,26,46],fals:[20,3,18,25,39,32],minor:[40,27],liter:[15,4],concat:46,date_pars:4,dec:4,dollar:28},filenames:["sql/show-partitions","release/release-0.56","release/release-0.58","functions/color","functions/datetime","functions/math","sql","sql/drop-table","sql/use-catalog","installation/jdbc","migration/from-hive","migration","installation/discovery","sql/select","installation/cli","release/release-0.60","release/release-0.57","sql/use-schema","operators/logical","installation","installation/deployment","functions","functions/json","release/release-0.59","sql/show-columns","sql/describe","functions/window","release/release-0.63","functions/regexp","language","index","release/release-0.55","operators/comparison","sql/show-schemas","sql/explain","functions/aggregate","release/release-0.61","functions/conversion","functions/url","language/types","release/release-0.62","sql/show-catalogs","release/release-0.54","sql/show-functions","release","sql/show-tables","functions/string","sql/create-table"],titles:["4.5. SHOW PARTITIONS","6.8. Release 0.56","6.6. Release 0.58","2.11. Color Functions","2.5. Date and Time Functions and Operators","2.3. Mathematical Functions and Operators","4. SQL Statement Syntax","4.9. DROP TABLE","4.12. USE CATALOG","1.4. JDBC Driver","5.1. Migrating From Hive","5. Migration","1.2. Discovery Service","4.1. SELECT","1.3. Command Line Interface","6.4. Release 0.60","6.7. Release 0.57","4.13. USE SCHEMA","2.1. Logical Operators","1. Installation","1.1. Deploying Presto","2. Functions and Operators","2.7. JSON Functions","6.5. Release 0.59","4.3. SHOW COLUMNS","4.11. DESCRIBE","2.10. Window Functions","6.1. Release 0.63","2.6. Regular Expression Functions","3. SQL Language","Presto Documentation","6.9. Release 0.55","2.2. Comparison Operators","4.6. SHOW SCHEMAS","4.10. EXPLAIN","2.9. Aggregate Functions","6.3. Release 0.61","2.12. Conversion Functions","2.8. URL Functions","3.1. Data Types","6.2. Release 0.62","4.2. SHOW CATALOGS","6.10. Release 0.54","4.4. SHOW FUNCTIONS","6. Release Notes","4.7. SHOW TABLES","2.4. String Functions and Operators","4.8. CREATE TABLE"],objnames:{"0":["py","function","Python function"]},objects:{"":{day_of_week:[4,0,1,""],rand:[5,0,1,""],json_extract:[22,0,1,""],century:[4,0,1,""],day_of_year:[4,0,1,""],approx_percentile:[35,0,1,""],split_part:[46,0,1,""],sum:[35,0,1,""],to_unixtime:[4,0,1,""],rgb:[3,0,1,""],exp:[5,0,1,""],url_extract_path:[38,0,1,""],is_finite:[5,0,1,""],stddev_pop:[35,0,1,""],dow:[4,0,1,""],url_extract_protocol:[38,0,1,""],count_if:[35,0,1,""],extract:[4,0,1,""],approx_distinct:[35,0,1,""],second:[4,0,1,""],regexp_extract:[28,0,1,""],url_extract_host:[38,0,1,""],count:[35,0,1,""],rank:[26,0,1,""],stddev_samp:[35,0,1,""],parse_datetime:[4,0,1,""],acos:[5,0,1,""],url_extract_query:[38,0,1,""],strpos:[46,0,1,""],url_extract_parameter:[38,0,1,""],floor:[5,0,1,""],sqrt:[5,0,1,""],quarter:[4,0,1,""],length:[46,0,1,""],regexp_like:[28,0,1,""],cume_dist:[26,0,1,""],now:[4,0,1,""],year:[4,0,1,""],var_pop:[35,0,1,""],day:[4,0,1,""],stddev:[35,0,1,""],sin:[5,0,1,""],round:[5,0,1,""],minute:[4,0,1,""],var_samp:[35,0,1,""],row_number:[26,0,1,""],tanh:[5,0,1,""],date_diff:[4,0,1,""],tan:[5,0,1,""],substr:[46,0,1,""],lower:[46,0,1,""],pow:[5,0,1,""],percent_rank:[26,0,1,""],cbrt:[5,0,1,""],e:[5,0,1,""],abs:[5,0,1,""],log2:[5,0,1,""],random:[5,0,1,""],render:[3,0,1,""],week_of_year:[4,0,1,""],month:[4,0,1,""],is_infinite:[5,0,1,""],json_array_length:[22,0,1,""],date_add:[4,0,1,""],asin:[5,0,1,""],json_extract_scalar:[22,0,1,""],rtrim:[46,0,1,""],ltrim:[46,0,1,""],pi:[5,0,1,""],"char":[46,0,1,""],reverse:[46,0,1,""],max:[35,0,1,""],cosh:[5,0,1,""],url_extract_fragment:[38,0,1,""],ln:[5,0,1,""],upper:[46,0,1,""],url_extract_port:[38,0,1,""],format_datetime:[4,0,1,""],replace:[46,0,1,""],is_nan:[5,0,1,""],log10:[5,0,1,""],date_format:[4,0,1,""],dense_rank:[26,0,1,""],log:[5,0,1,""],hour:[4,0,1,""],atan:[5,0,1,""],min:[35,0,1,""],avg:[35,0,1,""],CAST:[37,0,1,""],trim:[46,0,1,""],json_array_contains:[22,0,1,""],bar:[3,0,1,""],regexp_replace:[28,0,1,""],json_array_get:[22,0,1,""],nan:[5,0,1,""],color:[3,0,1,""],date_parse:[4,0,1,""],day_of_month:[4,0,1,""],approx_avg:[35,0,1,""],doy:[4,0,1,""],cos:[5,0,1,""],from_unixtime:[4,0,1,""],variance:[35,0,1,""],ceil:[5,0,1,""],atan2:[5,0,1,""],concat:[46,0,1,""],week:[4,0,1,""],infinity:[5,0,1,""],ceiling:[5,0,1,""],mod:[5,0,1,""]}},objtypes:{"0":"py:function"}})