tajo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hyun...@apache.org
Subject svn commit: r1612052 [3/7] - in /tajo/site/docs/current: ./ _sources/ _sources/backup_and_restore/ _sources/configuration/ _sources/getting_started/ backup_and_restore/ configuration/ functions/ getting_started/ partitioning/ sql_language/ table_manage...
Date Sun, 20 Jul 2014 08:06:32 GMT
Modified: tajo/site/docs/current/searchindex.js
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/searchindex.js?rev=1612052&r1=1612051&r2=1612052&view=diff
==============================================================================
--- tajo/site/docs/current/searchindex.js (original)
+++ tajo/site/docs/current/searchindex.js Sun Jul 20 08:06:30 2014
@@ -1 +1 @@
-Search.setIndex({envversion:42,terms:{represent:[32,15],all:[37,12,36,2,38,3,6,7,42,43,34],code:[3,42,23],dist:[37,14,42],c_name:34,rdbm:37,queri:[42,12,8,23],consum:32,function_nam:45,month:15,four:39,scalar:32,concept:37,per:[38,12,8],mno:43,follow:[3,5,7,8,11,12,34,16,17,18,19,20,24,42,28,30,32,14,36,37,38,39,25,43],disk:[3,8],row:[12,32,5,16,7,42,43,18],profil:36,privat:37,depend:[36,7],c_acctbal:34,zone:20,getconnect:37,decim:20,init:43,program:[25,32],drivermanag:37,sql_languag:12,backup_and_restor:12,"case":[25,35,37,16,7,42,18],digit:20,sourc:[12,42,23],string:[10,3,25,15],geoip_country_cod:3,fals:[20,32,3,7],"void":37,csvfile:[43,30,5],volum:[12,43],veri:[2,38,7],affect:[42,8],hdfs_locat:16,exact:20,dbname:12,tri:37,recordcompresswrit:18,list:[9,43,38,12,19],hive:[9,36,42],"try":[37,12],item:7,adjust:[16,24,32,8,5],form:[16,24],progress:13,geoip:3,println:37,tajo_src:14,locat:[11,3,16,30,43,34,8],tajo_hom:[25,37,12,2,38,42,43],dir:[38,11],pleas:[37,2,38,3,5,16,43,32,34,8],u
 pper:35,templet:25,smaller:11,ten:[36,23],shut:23,annot:37,enjoi:43,dowload:23,second:[35,42],cost:13,design:[13,17,25,32],val3:12,val2:[7,12],val1:[7,12],port:[24,37,38,12,42],tmpdir:8,compat:[9,8],index:9,abc:[7,43],addr:[3,42],compar:20,cast:9,section:[36,37,38,5,16,23,8],xtajoxx:35,access:[36,37,38,32],c_phone:34,"19th":15,version:[12,42],directori:42,supplier:12,"new":12,method:[9,34],metadata:16,elimin:30,hash:9,valn:7,gener:[12,5],o_totalpric:12,here:[2,7,43,18],let:18,address:[20,40,38,3,42],path:[24,12,36,37,3,30,42,43,34],o_orderprior:12,strong:34,sinc:16,valu:[25,24,12,36,38,3,42,8],convert:[3,45],aaabc:7,deterior:32,derbi:42,shift:15,larger:[20,32],table_backup:34,precis:20,datetim:10,codebas:19,implement:[2,12],commonli:5,sequencefil:[9,39,16],host2:38,via:[38,23],regardless:[16,32],data_typ:30,apach:[23,3,42,12],modul:[9,25],sign:7,filenam:12,unix:15,"boolean":[20,3,32],namenode_hostnam:24,wip:[42,19],instal:[3,14],total:8,unit:[42,32],from:[9,11,35,37,15,30,7,19,34,43
 ],describ:[36,12],would:[36,14],memori:42,distinct:6,two:[2,28,16,7,25,34,45,18],next:[36,37],connector:[36,42],few:25,call:9,usr:42,compressiontyp:18,type:[9,12,3,15,25,43,34,8,35],until:12,more:[36,32,38,7,42,43,23,8],flat:[16,18,32],discompress:14,l_quantiti:11,hiveql:36,claus:[9,43,17,7,20],tbname:12,trail:35,rootdir:38,appendix:9,name2:12,name3:12,name1:12,known:17,git:42,editor:38,unpack:23,must:[20,24,37,42,32],word:[16,5],hour:15,alia:[20,6,35,15],setup:33,work:[20,12,32],uniqu:12,dev:3,cat:[38,34,43],other:[13,16,11,25,5],archiv:[14,42],can:[25,37,12,36,2,38,43,5,16,17,7,42,19,30,32,14,8,18],parquet:[9,39],purpos:[36,25],root:38,def:43,bewtween:20,dayofweek:15,prompt:12,tab:5,tar:[14,42,19],give:[30,8],process:[12,13,5,16,17,32],share:[16,37],backslash:12,indic:12,tabular:5,liter:[25,5],want:[25,24,37,11,12,36,2,38,17,18,42,43,30,34,8],tcp:12,occur:[16,30,15],timestamptz:20,sundai:15,end:[35,19],goal:13,quot:12,str2:35,str1:35,hdf:[24,12,13,37,38,30,43,23],mapr:18,how:[9,36
 ,2,38,23,8],purg:30,env:42,c_address:34,instead:[12,43,7,5],csv:[9,43,30,12,34],simpl:[2,43],lazybinaryserd:18,blockcompresswrit:18,map:20,recogn:5,ltrim:35,clone:[42,19],after:14,resultset:37,concatnen:35,befor:38,catalog:1,mai:[37,25,15],multipl:[8,5],underscor:7,data:38,parallel:38,physic:38,tajo_worker_heaps:8,"short":16,third:[42,15],host:[37,38,12,42],grant:42,favorit:38,correspond:16,element:25,issu:9,inform:[12,42],preced:3,environ:[25,24,2,36,8],allow:[24,36,32,38,5,16,30,43,8],anoth:45,worst:13,order:[12,13,36,37,38,5,16,6,42,20,17,32,8,43],oper:10,help:12,shorten:42,move:14,midnight:15,becaus:5,comma:5,vari:20,dynam:13,paramet:[35,3,15,16,30,32,5],joda:37,write:[16,32,18,5],style:7,group:[6,7,32],cli:[37,12],html:12,persist:42,main:[13,37,7,25],non:32,lastli:42,"return":[35,15,7,3,5],thei:[16,37,7],timestamp:[20,15],col2:[11,7],col3:11,auth:37,nation:12,framework:32,lzo:32,item_nam:17,binaryserializerdeseri:[16,18],utc_usec_to:15,nor:7,introduct:9,choic:32,hive_jdbc_drive
 r_dir:[36,42],name:[25,24,12,36,37,38,3,5,16,40,6,18,42,43,20,32,34,8],anyth:12,config:[25,12,36,38,40,42,8],drop:9,regexp_replac:35,o_orderd:12,guava:37,easili:[37,38],mode:42,each:[38,12,25],clsspath:37,compatibl:34,side:[37,35],mean:7,compil:[36,14,42],domain:[38,7,5],due:8,replac:35,saturdai:15,procedur:14,"static":37,connect:[36,37,12,42],year:15,resourc:38,o_clerk:12,out:[37,8,19],unquot:12,network:10,space:35,develop:19,o_orderkei:12,xxtajo:35,content:[9,30],hivemetastor:[36,42],current:[24,12,36,37,28,39,7,42,32,8],math:10,integr:42,qualifi:[16,5],advanc:13,manipul:12,given:[11,12,3,30,7,43,20,35],free:43,standard:[13,20,7,43],asc:6,small:[20,32],base:42,asf:[42,19],dictionari:32,org:[12,36,37,5,16,30,18,42,19],"byte":[20,32,12,43],fridai:15,card:17,care:5,val:12,launch:42,guarante:37,could:15,omit:16,retriv:37,filter:7,length:20,rcfile:[9,39],umbil:[40,38],interact:[13,12,43],mvn:[36,37,14,42],first:[35,23,25,15,14,42],feed:5,rang:[9,28],directli:[17,5],resourceconfigur:8,f
 eel:43,onc:[3,19],arrai:7,independ:32,applciat:37,number:[38,12],capac:[38,8],o_com:12,instruct:[36,3,19],set:[12,42],done:14,submit:[23,43],tpch:[12,34],open:13,primari:24,differ:7,"long":[13,15],script:[14,25],licens:12,mkdir:[38,43],system:[37,13,2,38,16,25,14,8],least:7,master:[33,38,12,42],too:32,statement:[11,12,37,5,16,30,7,43,32,18],l_partkei:[30,11],scheme:[24,43],"final":[36,37,42,43],store:[12,13,36,5,16,18,42,43,8],listen:[37,38],mysql_jdbc_driv:[36,42],incub:[37,19],option:[34,30,12,14,15],especi:20,namespac:37,copi:[25,42],inexact:20,specifi:[24,11,12,36,37,3,5,16,7,42,32,20,45,8,18],github:19,mostli:16,rtrim:35,standalon:23,exactli:7,than:[36,11,7,23],target:[37,11,14,42],keyword:18,provid:[37,12,13,2,3,28,5,16,7,42,43,32,39,8,18],remov:[30,35],tree:14,zero:7,charact:[35,5,16,17,7,20],project:[13,32],serd:[16,5],posix:7,balanc:13,entri:[38,30],sec:[42,43],minut:[36,23],schema:[17,32,11,12,43],createdatabaseifnotexist:42,textserd:18,ran:42,respons:[13,43],argument:15,p
 ackag:[36,37,14,42],manner:37,have:[24,36,30,42,19,6],further:5,need:[37,36,2,5,16,18,42,43,32,34],maxmind:3,predic:[9,17,44],featur:[16,36,32,5],date:[20,34],techniqu:13,equival:11,partsupp:12,click:19,note:[7,42],also:[12,43,5,17,18,19,7],without:[13,17,5],build:[23,42],xxxxxx:42,prepar:[36,14,42,43],singl:[38,7,32],begin:[12,15],c_nationkei:34,distribut:42,preliminari:33,buffer:[21,32],price:17,filesystem:[23,19],compress:9,deflatecodec:30,most:[42,5],microsecond:15,plan:[13,17,5],arithmet:9,phase:17,metacharact:7,"class":[36,37,5,16,7,42,18],dai:15,don:[37,34,25],url:[24,37],doc:12,later:23,request:8,uri:42,ghi:43,part:12,snapshot:[37,14,42],"1gb":[24,8],determin:8,pattern:[9,35],querymast:8,think:43,show:[37,12,43,23],text:[12,35,43,38,3,15,16,17,7,20,30,32,5,34,18],hostnam:[24,37,38,12],syntax:45,column_refer:7,identifi:42,ship_dat:17,xml:[38,12,42],absolut:43,onli:[24,25,2,28,15,16,18,42,19,32,5],explicitli:25,ratio:8,just:[34,7,42,12],copyright:12,explain:[37,2,38,5,16,23],c
 onfigur:12,jar:[9,36,42],enough:42,haven:17,score:[16,32,43,18,5],templat:42,local:[23,42,3,8,19],info:40,unresolvedaddressexcept:9,variou:12,get:42,necesssari:37,familiar:[16,32,5],express:[9,35,44],repo:[42,19],cannot:5,java_hom:2,"import":37,increas:38,requir:[2,15],prune:9,bar:5,enabl:[16,32,37,38,5],termin:5,borrow:7,"public":37,remot:38,common:37,partit:9,contain:[38,37,30],where:[9,2,38,17,7,43,20,8],bytea:20,legaci:3,knowledg:5,startup:12,memstor:42,c_custkei:34,see:[2,38,42,8,43],num:12,float8:[20,11,12,34],result:[32,37,43],arg:37,float4:20,close:37,rlike:7,unqualifi:17,o_orderstatu:12,concern:[34,25],slf4j:37,kei:[12,28,16,30,18,17],correctli:20,netti:37,ieee:20,char_length:35,state:43,smallest:32,subdir:11,between:[37,7],"\u02c6ab":35,l_orderkei:[30,11],neither:7,approach:34,across:38,altern:7,smallint:20,accord:20,parent:14,hadoop_hom:[38,2,37],snappi:32,stmt:37,outfil:34,disconnect:12,addit:[37,11,7,8],both:[13,16,35,18,5],last:6,delimit:[43,30,35,5],fault:13,region:12
 ,gzipcodec:30,c_comment:34,groupbi:9,against:23,eta:37,compressioncodec:[16,5],logic:7,improv:32,whole:8,load:[13,43],simpli:14,point:16,overview:9,"4028235e":20,split_part:35,header:16,rpc:[40,37,38],written:[16,18],toler:13,respect:[20,7],tuesdai:15,guid:12,assum:[17,8,43],quit:12,xzvf:[14,19],vertic:5,java:[9,25,36,2,42,21],compos:[17,32],empti:[16,5],json:5,much:8,besid:5,newinst:37,basic:34,columnar:[16,32],c_mktsegment:34,pdist:[36,37,14,42],derbystor:42,o_custkei:12,host1:38,xxx:12,worker:33,search:9,ani:[32,37,7,5],tajojdbccli:37,work1:12,repetit:7,countri:3,those:[16,32,5],emploi:13,bye:43,look:19,implementaion:24,plain:[16,18],servic:[40,42],properti:[24,25,36,38,3,40,42,8],batch:13,durat:42,defin:5,"while":37,abov:[16,18,43],error:30,wild:17,howev:32,lazybinarycolumnarserd:16,textserializerdeseri:[16,18,5],table_nam:[30,34],layer:24,file:[9,24,12,25,36,2,38,3,14,42,19,34,8,43],advantag:32,ctrl:[38,43],key1:12,tabl:[36,34,43,12,23],site:[38,12,42],cluster:[33,42],itself:12
 ,warehous:[13,30],textfil:9,conf:[25,24,37,12,36,2,38,3,42,8],march:15,abcdef:35,conn:37,"null":[37,6],present:23,"35b":43,minim:9,suggest:19,format:[9,31,5],classpath:9,hadoop:[37,13,2,38,5,16,30,7,25,43,32,21,23,18],same:[36,15,3,7],binari:[16,14,18,42,20],instanc:[24,2,38,23],split:35,document:[12,19],log4j:37,log4j12:37,higher:21,week:15,varbit:20,lineitem:[30,11,12],http:[40,19,3,42,12],nio:9,optim:13,nest:32,driver:[9,36,42],geoip_in_countri:3,decompress:[32,19],jkl:43,column_nam:30,moment:[32,5],dskiptest:[36,37,14,42],user:[24,43,12,8,42],tajo_classpath:42,mani:[16,37,8],extern:[30,16,17,34,43],col1:[11,7],tsql:34,chang:[37,38,12,42,19],built:[16,37],lower:35,appropri:[25,43],lib:42,mention:16,com:[38,3],well:[30,11,20],parenthes:7,inherit:[16,5],exampl:[38,34],command:34,thi:[32,25,36,37,38,14,15,18,42,19,43,34,5,23,8,7],choos:[14,19],gzip:32,model:[9,44],usual:[37,25,5],explan:43,protocol:21,execut:[38,12,8,23],when:[30,32,37,11,5],dtar:[36,37,14,42],rest:19,detail:[32,38,
 42,43],q_1363768615503_0001_000001:43,mysql:[36,42],simultan:8,yet:17,languag:[13,9,12,43],inet4:[20,3],web:13,now:[12,14,16,32,5,34],all_backup:34,easi:[34,28],field:[35,5],disk1:8,disk2:8,disk3:8,except:37,littl:38,add:[2,25,36,37,38,30,42,8],codec:[16,30,18,5],blob:20,exercis:23,primit:20,input:35,approxim:20,match:[9,35,20],take:[36,23,19],bin:[37,12,36,2,38,42,43,34],varchar:20,which:[12,13,37,16,30,18,42,43],serde2:[16,18],read:[32,19,38,5],bzip2codec:30,workload:8,phcatalog:[36,42],chmod:38,lineitem_100_snappi:30,insert:[9,44],bit:20,password:42,desc:6,u0001:5,storage_typ:30,table1:[37,5,16,7,43,32,18],resid:43,like:[24,37,17,14],specif:[20,24,11],substr:35,should:[24,32,12,36,37,38,3,5,16,17,42,43,30,34,23,8],reoptim:13,manual:16,integ:[20,8],server:[25,42],query_succeed:43,collect:18,benefit:28,api:[9,37],necessari:[13,37],either:[20,36,32,7,19],output:[11,18],timetz:20,tajo:34,page:[9,38,32],versa:16,order_d:17,createstat:37,"1st":15,some:[36,37,5,16,25,43,20,32,14],tajowo
 rk:[25,8],certain:[16,32,11,5],intern:25,previou:7,"export":[36,2,42],mirror:19,proper:[24,14,8],home:[36,2,34,42,43],tmp:[24,43],separ:[18,5],scale:13,lead:[17,35],channel:9,"512mb":8,avoid:[13,30],exec:18,definit:[9,44],best:5,tracker:38,exit:43,select:[9,11,35,37,3,15,7,43],bigint:[20,30],ddl:[34,43],condit:6,fornam:37,localhost:[38,40,30,12,42],refer:[37,38,3,5,16,18,43,32],machin:[12,42],core:8,who:5,run:[38,12],power:7,uncompress:[18,32],ab_bc_cd:35,usag:34,hive_hom:[36,42],maven:[36,37],broken:5,step:14,character_length:35,repositori:19,peer:40,regexp:7,unicod:20,stage:43,comparison:[20,7],postgresql:7,column:9,varbinari:20,manag:[9,36,28],degre:38,regular:35,disabl:[16,32,5],block:[18,32],columnarserd:16,client:[9,40,38,12],own:5,effici:32,"float":[32,5,16,17,18,43,20,8],encod:32,lazybinari:18,three:[18,42],down:[7,23],pair:[16,18,25],storag:[24,37,5,16,18,42,32,34],your:[24,25,36,37,38,14,23,16,42,19,32,5,34],jdbc:[9,36,42],log:37,wai:[34,5],support:[24,34,42],overwrit:[9,4
 4],custom:[12,42,34],avail:[37,8,32],start:[38,35],current_databas:12,interfac:5,includ:[37,8],unix_timestamp:15,ipv4:[20,3],"function":12,snappycodec:[16,30,18,5],untar:19,tajoxx:35,l_comment:30,int4:[20,11,12,35],link:19,select_stat:30,int2:20,line:[38,5],"true":[3,18,42,32,20,8,7],int8:[20,11,12,34],count:35,"throw":37,consist:[16,18,25,5],possibl:8,whether:[16,7],ecosystem:32,day_of_week:15,record:[16,32,7,18,5],below:[37,23,16,32,5,34],limit:[8,32],otherwis:[12,3,7],executequeri:37,defaultport:42,trim:35,binaryserd:18,creat:[9,12,38,23,42,43,34],btrim:35,"int":[35,32,15,16,17,18,43,20,5],sequecnefil:18,dure:17,forgot:37,repres:[15,5],"char":20,exist:[30,16,11,12],o_shipprior:12,our:5,download:[3,19],doe:[32,37,30,5],check:19,denot:7,know:[38,43],percent:7,tinyint:20,getstr:37,"default":[33,38,12,42],bracket:7,bool:20,special:5,varieti:25,test:[37,12,42],you:[2,3,5,7,15,8,11,12,34,16,17,18,19,23,24,42,30,32,14,36,37,38,25,43],node:[37,38],relat:32,database_nam:[30,12],clean:[36,
 37,14,42],customserializerdeseri:5,sequenc:7,insensit:7,tajo_dump:34,protobuf:37,tajomast:[25,38,12,42],hurt:13,lang:37,algorithm:[16,32,8,5],vice:16,hyunsik:[12,34],descript:[12,40,7,42,43,20,8],tajo_master_heaps:24,carriag:5,time:[12,13,37,7,43,20],backward:8,cpu:8,unset:12,tajodriv:37},objtypes:{"0":"py:function"},objnames:{"0":["py","function","Python function"]},filenames:["partitioning/hash_partitioning","backup_and_restore","getting_started/local_setup","functions/network_func_and_operators","partitioning/range_partitioning","table_management/csv","sql_language/queries","sql_language/predicates","configuration/worker_configuration","index","functions","sql_language/insert","cli","introduction","getting_started/building","functions/datetime_func_and_operators","table_management/rcfile","partitioning/column_partitioning","table_management/sequencefile","getting_started/downloading_source","sql_language/data_model","getting_started/prerequisites","functions/math_func_and_operato
 rs","getting_started","configuration/tajo_master_configuration","configuration/preliminary","table_management/compression","faq","partitioning/intro_to_partitioning","table_partitioning","sql_language/ddl","table_management","table_management/parquet","configuration","backup_and_restore/catalog","functions/string_func_and_operators","hcatalog_integration","jdbc_driver","configuration/cluster_setup","table_management/file_formats","configuration/configuration_defaults","tajo_client_api","configuration/catalog_configuration","getting_started/first_query","sql_language","sql_language/sql_expression"],titles:["Hash Partitioning","Backup and Restore","Setting up a local Tajo cluster","Network Functions and Operators","Range Partitioning","CSV (TextFile)","Queries","Predicates","Worker Configuration","Apache Tajo\u2122 0.8.0 (dev) - User documentation","Functions","INSERT (OVERWRITE) INTO","Tajo Shell (TSQL)","Introduction","Build source code","DateTime Functions and Operators","RCFile","
 Column Partitioning","SequenceFile","Dowload and unpack the source code of Apache Tajo","Data Model","Prerequisites","Math Functions and Operators","Getting Started","Tajo Master Configuration","Preliminary","Compression","FAQ","Introduction to Partitioning","Table Partitioning","Data Definition Language","Table Management","Parquet","Configuration","Backup and Restore Catalog","String Functions and Operators","HCatalog Integration","Tajo JDBC Driver","Cluster Setup","File Formats","Configuration Defaults","Tajo Client API","Catalog Configuration","First query execution","SQL Language","SQL Expressions"],objects:{"":{trim:[35,0,1,""],upper:[35,0,1,""],lower:[35,0,1,""],ltrim:[35,0,1,""],btrim:[35,0,1,""],regexp_replace:[35,0,1,""],split_part:[35,0,1,""],char_length:[35,0,1,""],geoip_country_code:[3,0,1,""],rtrim:[35,0,1,""],utc_usec_to:[15,0,1,""],geoip_in_country:[3,0,1,""]}},titleterms:{code:[14,19],execut:43,queri:[6,43],session:12,permiss:38,hcatalogstor:42,ilik:7,languag:[44,30
 ],xml:25,writer:18,jar:37,overview:6,local:2,match:7,real:20,sourc:[14,19],synopsi:12,string:[7,45,35],format:39,handl:5,faq:[27,37],insert:11,introduct:[13,28],mysqlstor:42,document:9,like:7,level:34,drop:30,list:[37,6],hive:[16,32,17,5],mode:[38,8],partit:[0,29,17,28,4],each:8,fulli:38,where:6,manag:31,set:[38,2,37],hcatalog:36,dump:34,dowload:19,meta:12,run:8,todo:[0,22,26,27,4,41,34],distribut:38,variabl:12,network:3,cast:45,databas:[30,34],preliminari:25,definit:30,directori:[38,8],method:28,math:22,integr:36,hash:0,driver:37,gener:16,usag:12,serializerdeseri:18,base:38,prerequisit:[21,3],releas:19,java:37,rcfile:16,valu:[20,5],launch:38,via:19,tajo:[9,24,37,12,2,38,16,40,41,25,19],groupbi:6,datetim:15,backup:[1,34],first:43,oper:[22,35,3,15],rang:4,configur:[40,24,33,42,8],apach:[9,19,5,16,17,32],tajomast:24,number:[20,8],api:41,select:6,size:[24,8],git:19,from:6,memori:[24,8],tsql:12,support:3,doubl:20,overwrit:11,custom:5,start:23,call:45,basic:12,master:[24,40],type:[20,45]
 ,"function":[22,10,35,3,15,45],shell:12,claus:6,worker:[40,38,8],rootdir:24,appendix:37,heap:[24,8],jdbc:37,unpack:19,prune:17,restor:[1,34],"default":40,setup:38,properti:[16,32,5],maximum:8,dev:9,column:17,serd:18,introduc:18,parquet:32,similar:7,creat:[30,16,32,17,5],site:25,indic:9,cluster:[2,38],unresolvedaddressexcept:37,textfil:5,file:[37,39],tabl:[9,5,16,29,17,31,32,30],dedic:8,"null":5,serial:[16,5],issu:[16,32,17,5],minim:37,make:38,get:[37,23,19],when:16,how:[16,32,37,17,5],exampl:[37,8],build:14,env:25,csv:5,channel:37,compat:[16,32,17,5],express:[7,45],resourc:8,nio:37,classpath:37,enter:12,compress:[26,30],catalog:[25,34,42],regular:7,temporari:8,user:9,sql:[44,34,45],data:[20,30,8],parallel:8,physic:[16,32,5],task:8,read:16,predic:7,arithmet:45,client:[37,41],command:12,pattern:7,model:20,sequencefil:18,latest:19}})
\ No newline at end of file
+Search.setIndex({envversion:42,terms:{represent:[32,14],all:[37,12,36,2,38,3,6,7,25,43,20],code:[3,23],dist:[37,34,25],c_name:20,queri:[12,8,23],consum:32,month:14,four:39,scalar:32,concept:37,mno:43,follow:[3,5,7,8,11,12,34,15,16,17,18,19,24,25,28,30,32,20,36,37,38,39,42,43],disk:[3,8],row:[12,43,5,15,7,25,32,17],content:[9,30],privat:37,depend:[36,37,7],zone:19,getconnect:37,decim:19,init:43,program:[42,32],those:[15,32,37,5],sql_languag:12,emploi:13,digit:19,sourc:[12,23],string:[10,3,42,14],geoip_country_cod:3,fals:[19,32,3,7],"void":37,csvfile:[43,30,5],volum:[12,43],condit:6,veri:[2,38,7],affect:[25,8],hdfs_locat:15,exact:19,dbname:12,tri:37,recordcompresswrit:17,list:[12,43,38,16,7,18],hive:36,unquot:12,item:7,interfac:5,adjust:[15,24,32,8,5],plain:[15,17],println:37,tajo_src:34,tajo_hom:[37,12,2,38,42,43,25],dir:[38,11,8],pleas:[37,2,38,3,5,15,32,20,8,43],upper:35,templet:42,smaller:11,ten:[36,23],resourc:[40,38],shut:23,sign:7,enjoi:43,dowload:23,second:[35,25],cost:13,desi
 gn:[13,16,42,32],val3:12,val2:[7,12],val1:[7,12],port:[24,37,38,12,25],tmpdir:8,compat:8,index:9,abc:[7,43],addr:[3,25],compar:19,cast:[],section:[36,37,38,5,15,23,8],uncompress:[17,32],current:[24,12,36,37,28,39,7,25,32,8],c_phone:20,"19th":14,version:[12,25],decompress:[32,18],supplier:12,"new":12,method:20,metadata:15,elimin:30,hash:[],valn:7,gener:[12,5],o_totalpric:12,here:[2,7,43,17],let:17,address:[19,40,38,3,25],path:[24,12,36,37,3,30,25,43,20],o_orderprior:12,strong:20,sinc:15,valu:[24,12,36,38,3,42,8],convert:[3,45],aaabc:7,deterior:32,derbi:25,shift:14,larger:[19,32],table_backup:20,precis:19,datetim:10,codebas:18,implement:[9,2,12],commonli:5,sequencefil:[15,39],via:[38,23],regardless:[15,32],data_typ:30,jar:[36,37,25],modul:[9,42],filenam:12,unix:14,"boolean":[19,3,32],namenode_hostnam:24,wip:[25,18],instal:[3,25,34],total:8,u0001:5,select:[11,35,37,3,14,7,43],compatibl:20,from:[35,18,20,43,14],describ:[36,12],would:[36,34],distinct:6,two:[2,28,15,7,42,20,45,17],next:[3
 6,37],connector:[36,25],few:42,call:[],usr:25,compressiontyp:17,stage:43,type:[12,3,14,42,43,20,8,35],until:12,more:[36,43,38,7,25,32,23,8],flat:[15,17,32],discompress:34,hiveql:36,claus:[19,16,7,43],mismatch:9,hurt:13,function_nam:45,rootdir:38,name2:12,name3:12,name1:12,known:16,postgresql:7,unpack:23,must:[19,24,37,25,32],hyunsik:[12,20],word:[15,8,5],hour:14,alia:[19,6,35,14],setup:[],work:[19,12,32],timestamptz:19,dev:3,cat:[38,20,43],itself:12,can:[9,37,12,36,2,38,43,5,15,25,16,7,42,18,30,32,34,8,17],parquet:39,purpos:[36,42],root:38,def:43,bewtween:19,dayofweek:14,prompt:12,tab:5,tar:[37,34,25,18],give:[30,8],process:[12,13,5,15,16,32],share:[15,37],backslash:12,indic:12,tabular:5,liter:[42,5],want:[24,37,11,12,36,2,38,16,17,42,43,30,20,8,25],occur:[15,30,14],ratio:8,sundai:14,end:[35,18],goal:13,quot:12,str2:35,str1:35,mapr:17,how:[36,2,38,23,8],purg:30,env:[],c_address:20,instead:[12,43,7,5],csv:[43,30,12,20],config:[12,36,37,38,40,42,25,8],lazybinaryserd:17,blockcompresswr
 it:17,map:19,recogn:5,ltrim:35,clone:[25,18],after:34,resultset:37,concatnen:35,befor:38,catalog:1,mai:[42,14],multipl:[8,5],underscor:7,mariadb:25,data:38,parallel:38,physic:38,"short":15,third:[25,14],favorit:38,correspond:15,element:42,issu:[],inform:[12,25],preced:3,environ:[36,24,2,42,8],allow:[24,36,43,38,5,15,30,32,8],anoth:45,worst:13,order:[37,12,13,36,32,38,5,15,6,25,19,16,8,43],feed:5,help:12,classpath:[],move:34,midnight:14,becaus:5,comma:5,vari:19,dynam:13,paramet:[35,3,14,15,30,32,5],smallint:19,write:[15,32,17,5],style:7,group:[6,7,32],cli:12,overwrit:44,snappycodec:[15,30,17,5],defin:5,whole:8,persist:25,main:[13,37,7,42],non:32,"float":[43,5,15,16,17,32,19,8],"return":[35,14,7,3,5],thei:[15,7],handl:37,timestamp:[19,14],nio:[],col2:[11,7],col3:11,nation:12,framework:32,lzo:32,bar:5,binaryserializerdeseri:[15,17],utc_usec_to:14,nor:7,introduct:[],choic:32,hive_jdbc_driver_dir:[36,25],name:[24,12,36,37,38,3,43,5,15,40,6,17,42,32,19,20,8,25],anyth:12,simpl:[2,43],drop:
 [],regexp_replac:35,instruct:[36,3,18],separ:[17,5],easili:[37,38],mode:[],each:[38,12,42],clsspath:37,tajo_worker_heaps:8,side:[37,35],mean:7,compil:[36,34,25],domain:[38,7,5],replac:35,saturdai:14,procedur:34,"static":37,connect:[36,37,12,25],year:14,our:5,now:[12,34,15,32,5,20],special:5,out:[37,8,18],"try":[37,12],network:10,part:12,space:35,o_orderkei:12,xxtajo:35,profil:[36,25],hivemetastor:[36,25],math:10,qualifi:[15,5],advanc:13,manipul:12,differ:7,free:43,standard:[13,19,7,43],asc:6,standalon:23,jdbc:36,asf:[25,18],dictionari:32,org:[12,36,37,5,15,30,17,25,18],"byte":[19,43,12,32],fridai:14,card:16,care:5,wai:[20,5],launch:[],could:14,omit:15,moment:[32,5],filter:7,length:19,licens:12,mvn:[36,37,34,25],first:[35,23,34,42,14],oper:10,ieee:19,rang:28,directli:[16,5],resourceconfigur:8,feel:43,onc:[3,18],arrai:7,independ:32,applciat:37,number:[38,12],system:[37,13,2,38,15,42,34,8],o_com:12,o_orderd:12,legaci:3,done:34,"long":[13,14],tpch:[12,20],open:13,primari:24,given:[11,12
 ,3,30,7,43,19,35],script:[34,42],interact:[13,12,43],mkdir:[38,43],capac:[38,8],least:7,master:[38,12],too:32,statement:[11,12,37,43,5,15,30,7,32,17],l_partkei:[30,11],scheme:[24,43],"final":[36,37,25,43],store:[12,13,36,5,15,17,25,43,8],listen:[37,38],mysql_jdbc_driv:[36,25],option:[20,14,30,12,34],especi:19,namespac:37,copi:[25,42],inexact:19,specifi:[24,11,12,36,37,3,5,15,7,25,32,19,45,8,17],github:18,mostli:15,rtrim:35,exactli:7,than:[36,11,7,23],target:[37,11,34,25],keyword:17,provid:[37,12,13,2,3,28,5,15,7,25,32,43,39,8,17],remov:[30,35],tree:34,zero:7,charact:[35,5,15,16,7,19],project:[13,32],serd:[15,5],l_orderkei:[30,11],balanc:13,float8:[19,11,12,20],minut:[36,23],schema:[16,43,11,12,32],unix_timestamp:14,textserd:17,ran:25,arg:37,argument:14,download:[3,18],manner:37,have:[24,36,30,25,18,6],further:5,need:[37,36,2,5,15,17,25,32,20,43],maxmind:3,predic:[44,16],packag:[36,37],date:[19,20],techniqu:13,equival:11,partsupp:12,serde2:[15,17],click:18,note:[7,25],also:[12,43,5,1
 6,17,18,7],exampl:[38,20],take:[36,23,18],xxxxxx:25,prepar:[36,34,25,43],singl:[38,7,32],begin:[12,14],c_nationkei:20,distribut:[],preliminari:[],buffer:[21,32],price:16,choos:[34,18],compress:[],deflatecodec:30,most:[25,5],microsecond:14,plan:[13,16,5],unicod:19,phase:16,metacharact:7,"class":[36,37,5,15,7,25,17],don:[37,20,42],url:[24,37],doc:12,later:23,request:8,uri:25,ghi:43,bracket:7,snapshot:[34,25],classnotfoundexcept:37,determin:8,querymast:8,think:43,show:[37,12,43,23],text:[12,35,43,38,3,14,15,16,7,32,30,19,5,20,17],syntax:45,column_refer:7,protocol:21,ship_dat:16,xml:[38,12],absolut:43,onli:[24,25,2,28,14,15,17,42,18,32,5],explicitli:42,locat:[11,37,3,15,30,43,20,8],execut:[38,12,8,23],copyright:12,explain:[37,2,38,5,15,23],configur:12,apach:[23,3,12],state:43,haven:16,smallest:32,l_quantiti:11,local:[23,3,8,18],count:35,unresolvedaddressexcept:[],variou:12,get:[],familiar:[15,32,5],express:[44,35],repo:[25,18],cannot:5,java_hom:2,progress:13,increas:38,requir:[2,14],pru
 ne:[],item_nam:16,enabl:[37,38,5,15,25,32],termin:5,borrow:7,"public":37,remot:38,integr:[],partit:[],contain:[38,37,30],clean:[36,37,34,25],where:[2,38,16,7,43,19,8],bytea:19,set:12,knowledg:5,startup:12,memstor:25,see:[2,38,25,8,43],num:12,sec:[25,43],result:[9,37,43,32],respons:[13,43],float4:19,close:37,rlike:7,unqualifi:16,o_orderstatu:12,concern:[20,42],awar:8,parent:34,correctli:19,pattern:35,char_length:35,enough:25,score:[15,32,17,43,5],subdir:11,between:[37,7],"\u02c6ab":35,posix:7,neither:7,approach:20,c_custkei:20,altern:7,accord:19,kei:[12,28,15,30,17,16],hadoop_hom:[2,38],stmt:37,outfil:20,disconnect:12,addit:[37,11,7,8],both:[13,15,35,17,5],last:6,delimit:[43,30,35,5],fault:13,region:12,gzipcodec:30,c_comment:20,groupbi:[],against:23,instanc:[24,2,38,23],compressioncodec:[15,5],logic:7,mani:[15,37,8],com:[38,3],load:[13,43],simpli:34,point:15,overview:[],"4028235e":19,split_part:35,header:15,rpc:[40,37,38],written:[15,17],toler:13,respect:[19,7],tuesdai:14,guid:12,ass
 um:[16,8,43],o_clerk:12,quit:12,xzvf:[37,34,18],vertic:5,java:[21,36,2,42],compos:[16,32],empti:[15,5],json:5,much:8,besid:5,basic:20,templat:25,c_mktsegment:20,blob:19,derbystor:25,bit:19,exercis:23,xxx:12,worker:[],search:9,ani:[32,37,7,5],tajojdbccli:37,input:35,"catch":37,repetit:7,countri:3,present:23,"case":[35,37,15,7,42,25,17],bye:43,look:18,implementaion:24,geoip:3,servic:[40,25],properti:[24,36,38,3,40,42,8],batch:13,durat:25,hdf:[24,12,13,37,38,30,43,23,8],"while":37,uniqu:12,abov:[15,17,43],error:30,wild:16,vice:15,howev:32,lazybinarycolumnarserd:15,textserializerdeseri:[15,17,5],bin:[12,36,2,38,25,43,20],layer:24,file:[24,37,31,12,36,2,38,3,5,42,18,20,34,8,43],advantag:32,ctrl:[38,43],best:5,key1:12,tabl:[36,20,43,12,23],tbname:12,cluster:[],archiv:[34,25],warehous:[13,30],textfil:[],conf:[24,12,36,2,38,3,42,25,8],varchar:19,abcdef:35,primit:19,conn:37,"null":[37,6],develop:[9,18],"35b":43,grant:25,suggest:18,shorten:25,hadoop:[37,13,2,38,43,5,15,30,7,42,32,21,23,17],sa
 me:[36,14,3,7],binaryserd:17,binari:34,html:12,split:35,document:[12,18],higher:21,week:14,varbit:19,lineitem:[30,11,12],http:[40,18,3,25,12],hostnam:[24,37,38,12],optim:13,nest:32,driver:36,geoip_in_countri:3,dai:14,jkl:43,column_nam:30,retriv:37,dskiptest:[36,37,34,25],user:[24,12,8,43],tajo_classpath:25,improv:32,extern:[30,15,16,20,43],col1:[11,7],tsql:20,chang:[37,38,12,25,18],built:[15,37],lower:35,appropri:[42,43],lib:25,mention:15,entri:[38,30],well:[30,19,11],parenthes:7,inherit:[15,5],without:[13,16,5],command:20,thi:[9,23,37,25,36,32,38,43,14,7,42,18,20,5,34,8,17],filesystem:[23,18],gzip:32,model:44,usual:[42,5],explan:43,identifi:25,just:[20,7,25,12],percent:7,dtar:[36,37,34,25],tcp:12,q_1363768615503_0001_000001:43,drivermanag:37,mysql:[36,25],rest:18,simultan:8,yet:16,languag:[13,12,43],inet4:[19,3],web:13,snappi:32,all_backup:20,easi:[20,28],field:[35,5],disk1:8,disk2:8,disk3:8,except:[37,25],littl:38,add:[2,25,36,37,38,30,42,8],codec:[15,30,17,5],host2:38,host1:38,ba
 ckup_and_restor:12,work1:12,approxim:19,match:[19,35],build:23,table_nam:[30,20],march:14,which:[12,13,37,15,30,17,25,43],format:[31,5],read:[32,18,38,5],bzip2codec:30,workload:8,phcatalog:[36,25],chmod:38,step:34,createdatabaseifnotexist:25,password:25,desc:6,insert:44,storage_typ:30,table1:[37,43,5,15,7,32,17],resid:43,like:[24,37,16,34],specif:[19,24,11],substr:35,should:[24,12,36,37,38,3,5,15,16,25,32,30,20,23,8,43],reoptim:13,manual:15,integ:[19,8],server:[25,42],query_succeed:43,collect:17,benefit:28,api:[],necessari:13,either:[19,36,32,7,18],output:[11,17],timetz:19,tajo:20,page:[9,38,32],versa:15,order_d:16,carriag:5,createstat:37,"1st":14,some:[9,36,43,5,15,42,32,19,34],tajowork:[42,8],sequecnefil:17,intern:42,previou:7,"export":[36,2,25],mirror:18,proper:[24,34,8],small:[19,32],tmp:[24,43],scale:13,lead:[16,35],channel:[],"512mb":8,avoid:[13,30],exec:17,definit:44,per:[38,12,8],tracker:[40,38],unit:[25,32],bigint:[19,30],ddl:[20,43],lineitem_100_snappi:30,fornam:37,three:[
 17,25],localhost:[38,40,30,12,25],refer:[37,38,3,5,15,17,32,43],machin:[12,25],core:[37,8],who:5,run:[38,12],power:7,xtajoxx:35,ab_bc_cd:35,usag:20,hive_hom:[36,25],maven:[36,25],broken:5,host:[37,38,12,25],character_length:35,repositori:18,peer:40,regexp:7,rcfile:39,c_acctbal:20,comparison:[19,7],actual:9,datanod:8,column:[],varbinari:19,manag:[36,28],degre:38,regular:35,includ:[37,8],disabl:[15,32,5],"1gb":[24,8],block:[17,32],columnarserd:15,client:[40,38,12],own:5,effici:32,lastli:25,encod:32,lazybinari:17,due:8,down:[7,23],pair:[15,17,42],"import":37,storag:[24,5,15,17,25,32,20],your:[24,37,25,36,32,38,34,15,42,18,20,5,23],git:[],val:12,support:[24,20],submit:[23,43],custom:[12,20],avail:[37,8,32],start:[38,35],current_databas:12,arithmet:[],editor:38,o_custkei:12,ipv4:[19,3],across:38,"function":12,form:[15,24],untar:18,tajoxx:35,l_comment:30,int4:[19,11,12,35],link:18,select_stat:30,int2:19,line:[38,5],"true":[3,17,25,32,19,8,7],int8:[19,11,12,20],info:40,"throw":37,columnar:
 [15,32],consist:[15,17,42,5],possibl:8,whether:[15,7],ecosystem:32,access:[36,37,38,32],day_of_week:14,record:[15,32,7,17,5],below:[15,20,32,23,5],limit:[8,32],site:[38,12],otherwis:[12,3,7],executequeri:37,defaultport:25,trim:35,featur:[15,36,32,5],creat:[20,43,38,12,23],btrim:35,"int":[35,43,14,15,16,17,32,19,5],certain:[15,32,11,5],dure:16,repres:[14,5],"char":19,exist:[30,15,11,12],o_shipprior:12,home:[36,2,20,25,43],doe:[37,32,30,5],check:18,fill:37,denot:7,know:[38,43],when:[37,30,32,11,5],detail:[43,38,25,32],getstr:37,"default":[38,12],other:[11,13,5,15,42,8],bool:19,rdbm:37,branch:9,varieti:42,test:[12,25],you:[2,3,5,7,14,8,11,12,34,23,15,16,17,18,24,25,30,32,20,36,37,38,42,43],node:[37,38,8],relat:32,database_nam:[30,12],umbil:[40,38],customserializerdeseri:5,sequenc:7,insensit:7,tajomast:[38,12,42],src:[37,18],algorithm:[15,32,8,5],trail:35,directori:[],descript:[12,40,7,25,43,19,8],tajo_master_heaps:24,tinyint:19,ignor:8,time:[13,19,43,7,12],pdist:[36,37,34,25],backward:
 8,cpu:8,unset:12,tajodriv:37},objtypes:{"0":"py:function"},objnames:{"0":["py","function","Python function"]},filenames:["partitioning/hash_partitioning","backup_and_restore","getting_started/local_setup","functions/network_func_and_operators","partitioning/range_partitioning","table_management/csv","sql_language/queries","sql_language/predicates","configuration/worker_configuration","index","functions","sql_language/insert","cli","introduction","functions/datetime_func_and_operators","table_management/rcfile","partitioning/column_partitioning","table_management/sequencefile","getting_started/downloading_source","sql_language/data_model","backup_and_restore/catalog","getting_started/prerequisites","functions/math_func_and_operators","getting_started","configuration/tajo_master_configuration","configuration/catalog_configuration","table_management/compression","faq","partitioning/intro_to_partitioning","table_partitioning","sql_language/ddl","table_management","table_management/parqu
 et","configuration","getting_started/building","functions/string_func_and_operators","hcatalog_integration","jdbc_driver","configuration/cluster_setup","table_management/file_formats","configuration/configuration_defaults","tajo_client_api","configuration/preliminary","getting_started/first_query","sql_language","sql_language/sql_expression"],titles:["Hash Partitioning","Backup and Restore","Setting up a local Tajo cluster","Network Functions and Operators","Range Partitioning","CSV (TextFile)","Queries","Predicates","Worker Configuration","Apache Tajo\u2122 (dev) - User documentation","Functions","INSERT (OVERWRITE) INTO","Tajo Shell (TSQL)","Introduction","DateTime Functions and Operators","RCFile","Column Partitioning","SequenceFile","Dowload and unpack the source code of Apache Tajo","Data Model","Backup and Restore Catalog","Prerequisites","Math Functions and Operators","Getting Started","Tajo Master Configuration","Catalog Configuration","Compression","FAQ","Introduction to Pa
 rtitioning","Table Partitioning","Data Definition Language","Table Management","Parquet","Configuration","Build source code","String Functions and Operators","HCatalog Integration","Tajo JDBC Driver","Cluster Setup","File Formats","Configuration Defaults","Tajo Client API","Preliminary","First query execution","SQL Language","SQL Expressions"],objects:{"":{trim:[35,0,1,""],upper:[35,0,1,""],lower:[35,0,1,""],ltrim:[35,0,1,""],btrim:[35,0,1,""],regexp_replace:[35,0,1,""],split_part:[35,0,1,""],char_length:[35,0,1,""],geoip_country_code:[3,0,1,""],rtrim:[35,0,1,""],utc_usec_to:[14,0,1,""],geoip_in_country:[3,0,1,""]}},titleterms:{code:[37,34,18],execut:43,queri:[6,43],session:12,permiss:38,hcatalogstor:25,languag:[44,30],xml:42,call:45,writer:17,apach:[9,18,5,15,16,32],configur:[24,33,40,8,25],binari:37,local:2,match:7,real:19,sourc:[37,34,18],synopsi:12,string:[7,45,35],get:[37,23,18],handl:5,faq:[27,37],insert:11,introduct:[13,28],mysqlstor:25,csv:5,like:7,level:20,drop:30,list:6,hi
 ve:[15,32,16,5],integr:36,partit:[0,29,16,28,4],each:8,fulli:38,tajo:[9,24,37,12,2,38,15,40,41,42,18],manag:31,set:[38,2,37],hcatalog:36,dump:20,dowload:18,meta:12,run:8,todo:[0,22,26,27,4,41,20],nio:37,variabl:12,network:3,databas:[30,20],preliminari:42,definit:30,pattern:7,method:28,math:22,mode:[38,8],hash:0,compress:[26,30],gener:15,usag:12,serializerdeseri:17,base:38,prerequisit:[21,3],releas:18,java:37,rcfile:15,valu:[19,5],launch:38,column:16,where:6,groupbi:6,datetim:14,backup:[1,20],first:43,oper:[22,35,3,14],rang:4,via:18,overview:6,format:39,sql:[44,20,45],number:[19,8],api:41,select:6,size:[24,8],git:18,from:[37,6],memori:[24,8],data:[19,30,8],support:3,doubl:19,overwrit:11,custom:5,start:23,master:[24,40],basic:12,arithmet:45,type:[19,45],"function":[22,10,35,3,14,45],shell:12,claus:6,worker:[40,38,8],rootdir:24,heap:[24,8],jdbc:37,unpack:18,prune:16,restor:[1,20],"default":40,setup:38,properti:[15,32,5],maximum:8,dev:9,cast:45,serd:17,introduc:17,parquet:32,similar:7,c
 reat:[30,15,32,16,5],site:42,indic:9,cluster:[2,38],unresolvedaddressexcept:37,textfil:5,file:39,tabl:[9,5,15,29,16,31,32,30],dedic:8,"null":5,serial:[15,5],make:38,ilik:7,when:15,how:[37,15,32,16,5],client:[37,41],read:15,build:[37,34],env:42,document:9,channel:37,compat:[15,32,16,5],express:[7,45],resourc:8,distribut:[37,38],classpath:37,driver:37,catalog:[20,42,25],regular:7,temporari:8,user:9,tajomast:24,tsql:12,parallel:8,physic:[15,32,5],task:8,directori:[38,8],predic:7,issu:[15,32,16,5],exampl:[37,8],command:12,enter:12,model:19,sequencefil:17,mariadbstor:25,latest:18}})
\ 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=1612052&r1=1612051&r2=1612052&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language.html (original)
+++ tajo/site/docs/current/sql_language.html Sun Jul 20 08:06:30 2014
@@ -119,7 +119,6 @@
 <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#appendix">Appendix</a></li>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#faq">FAQ</a></li>
 </ul>
 </li>

Added: tajo/site/docs/current/sql_language.rst
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language.rst?rev=1612052&view=auto
==============================================================================
--- tajo/site/docs/current/sql_language.rst (added)
+++ tajo/site/docs/current/sql_language.rst Sun Jul 20 08:06:30 2014
@@ -0,0 +1,13 @@
+************
+SQL Language
+************
+
+.. toctree::
+    :maxdepth: 1
+
+    sql_language/data_model
+    sql_language/ddl
+    sql_language/insert
+    sql_language/queries    
+    sql_language/sql_expression
+    sql_language/predicates
\ No newline at end of file

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=1612052&r1=1612051&r2=1612052&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/data_model.html (original)
+++ tajo/site/docs/current/sql_language/data_model.html Sun Jul 20 08:06:30 2014
@@ -120,7 +120,6 @@
 <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#appendix">Appendix</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
 </ul>
 </li>

Added: tajo/site/docs/current/sql_language/data_model.rst
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/data_model.rst?rev=1612052&view=auto
==============================================================================
--- tajo/site/docs/current/sql_language/data_model.rst (added)
+++ tajo/site/docs/current/sql_language/data_model.rst Sun Jul 20 08:06:30 2014
@@ -0,0 +1,66 @@
+**********
+Data Model
+**********
+
+===============
+Data Types
+===============
+
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+| Supported | SQL Type Name  |  Alias                     | Size (byte) | Description                                       | Range                                                                    |
++===========+================+============================+=============+===================================================+==========================================================================+ 
+| O         | boolean        |  bool                      |  1          |                                                   | true/false                                                               |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+  
+|           | bit            |                            |  1          |                                                   | 1/0                                                                      | 
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+|           | varbit         |  bit varying               |             |                                                   |                                                                          |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+| O         | smallint       |  tinyint, int2             |  2          | small-range integer value                         | -2^15 (-32,768) to 2^15 (32,767)                                         |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+| O         | integer        |  int, int4                 |  4          | integer value                                     | -2^31 (-2,147,483,648) to 2^31 - 1 (2,147,483,647)                       |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+| O         | bigint         |  bit varying               |  8          | larger range integer value                        | -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807) |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+| O         | real           |  int8                      |  4          | variable-precision, inexact, real number value    | -3.4028235E+38 to 3.4028235E+38 (6 decimal digits precision)             |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+| O         | float[(n)]     |  float4                    |  4 or 8     | variable-precision, inexact, real number value    |                                                                          |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+| O         | double         |  float8, double precision  |  8          | variable-precision, inexact, real number value    | 1 .7E–308 to 1.7E+308 (15 decimal digits precision)                      |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+|           | number         |  decimal                   |             |                                                   |                                                                          |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+|           | char[(n)]      |  character                 |             |                                                   |                                                                          |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+|           | varchar[(n)]   |  character varying         |             |                                                   |                                                                          |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+| O         | text           |  text                      |             | variable-length unicode text                      |                                                                          |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+|           | binary         |  binary                    |             |                                                   |                                                                          |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+|           | varbinary[(n)] |  binary varying            |             |                                                   |                                                                          |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+| O         | blob           |  bytea                     |             | variable-length binary string                     |                                                                          |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+|           | date           |                            |             |                                                   |                                                                          | 
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+|           | time           |                            |             |                                                   |                                                                          | 
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+|           | timetz         |  time with time zone       |             |                                                   |                                                                          |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+|           | timestamp      |                            |             |                                                   |                                                                          |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+|           | timestamptz    |                            |             |                                                   |                                                                          |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+ 
+| O         | inet4          |                            | 4           | IPv4 address                                      |                                                                          |
++-----------+----------------+----------------------------+-------------+---------------------------------------------------+--------------------------------------------------------------------------+
+
+-----------------------------------------
+Using real number value (real and double)
+-----------------------------------------
+
+The real and double data types are mapped to float and double of java primitives respectively. Java primitives float and double follows the IEEE 754 specification. So, these types are correctly matched to SQL standard data types.
+
++ float[( n )] is mapped to either float or double according to a given length n. If n is specified, it must be bewtween 1 and 53. The default value of n is 53.
++ If 1 <- n <- 24, a value is mapped to float (6 decimal digits precision).
++ If 25 <- n <- 53, a value is mapped to double (15 decimal digits precision). 
++ Do not use approximate real number columns in WHERE clause in order to compare some exact matches, especially the - and <> operators. The > or < comparisons work well. 
\ No newline at end of file

Modified: tajo/site/docs/current/sql_language/ddl.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/ddl.html?rev=1612052&r1=1612051&r2=1612052&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/ddl.html (original)
+++ tajo/site/docs/current/sql_language/ddl.html Sun Jul 20 08:06:30 2014
@@ -120,7 +120,6 @@
 <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#appendix">Appendix</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
 </ul>
 </li>

Added: tajo/site/docs/current/sql_language/ddl.rst
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/ddl.rst?rev=1612052&view=auto
==============================================================================
--- tajo/site/docs/current/sql_language/ddl.rst (added)
+++ tajo/site/docs/current/sql_language/ddl.rst Sun Jul 20 08:06:30 2014
@@ -0,0 +1,78 @@
+************************
+Data Definition Language
+************************
+
+========================
+CREATE DATABASE
+========================
+
+*Synopsis*
+
+.. code-block:: sql
+
+  CREATE DATABASE [IF NOT EXISTS] <database_name> 
+
+``IF NOT EXISTS`` allows ``CREATE DATABASE`` statement to avoid an error which occurs when the database exists.
+
+========================
+DROP DATABASE
+========================
+
+*Synopsis*
+
+.. code-block:: sql
+
+  DROP DATABASE [IF EXISTS] <database_name>
+
+``IF EXISTS`` allows ``DROP DATABASE`` statement to avoid an error which occurs when the database does not exist.
+
+========================
+CREATE TABLE
+========================
+
+*Synopsis*
+
+.. code-block:: sql
+
+  CREATE TABLE [IF NOT EXISTS] <table_name> [(<column_name> <data_type>, ... )]
+  [using <storage_type> [with (<key> = <value>, ...)]] [AS <select_statement>]
+
+  CREATE EXTERNAL TABLE [IF NOT EXISTS] <table_name> (<column_name> <data_type>, ... )
+  using <storage_type> [with (<key> = <value>, ...)] LOCATION '<path>'
+
+``IF NOT EXISTS`` allows ``CREATE [EXTERNAL] TABLE`` statement to avoid an error which occurs when the table does not exist.
+
+------------------------
+ Compression
+------------------------
+
+If you want to add an external table that contains compressed data, you should give 'compression.code' parameter to CREATE TABLE statement.
+
+.. code-block:: sql
+
+  create EXTERNAL table lineitem (
+  L_ORDERKEY bigint, 
+  L_PARTKEY bigint, 
+  ...
+  L_COMMENT text) 
+
+  USING csv WITH ('csvfile.delimiter'='|','compression.codec'='org.apache.hadoop.io.compress.DeflateCodec')
+  LOCATION 'hdfs://localhost:9010/tajo/warehouse/lineitem_100_snappy';
+
+`compression.codec` parameter can have one of the following compression codecs:
+  * org.apache.hadoop.io.compress.BZip2Codec
+  * org.apache.hadoop.io.compress.DeflateCodec
+  * org.apache.hadoop.io.compress.GzipCodec
+  * org.apache.hadoop.io.compress.SnappyCodec 
+
+========================
+ DROP TABLE
+========================
+
+*Synopsis*
+
+.. code-block:: sql
+
+  DROP TABLE [IF EXISTS] <table_name> [PURGE]
+
+``IF EXISTS`` allows ``DROP DATABASE`` statement to avoid an error which occurs when the database does not exist. ``DROP TABLE`` statement removes a table from Tajo catalog, but it does not remove the contents. If ``PURGE`` option is given, ``DROP TABLE`` statement will eliminate the entry in the catalog as well as the contents.
\ No newline at end of file

Modified: tajo/site/docs/current/sql_language/insert.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/insert.html?rev=1612052&r1=1612051&r2=1612052&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/insert.html (original)
+++ tajo/site/docs/current/sql_language/insert.html Sun Jul 20 08:06:30 2014
@@ -120,7 +120,6 @@
 <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#appendix">Appendix</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
 </ul>
 </li>

Added: tajo/site/docs/current/sql_language/insert.rst
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/insert.rst?rev=1612052&view=auto
==============================================================================
--- tajo/site/docs/current/sql_language/insert.rst (added)
+++ tajo/site/docs/current/sql_language/insert.rst Sun Jul 20 08:06:30 2014
@@ -0,0 +1,26 @@
+*************************
+INSERT (OVERWRITE) INTO
+*************************
+
+INSERT OVERWRITE statement overwrites a table data of an existing table or a data in a given directory. Tajo's INSERT OVERWRITE statement follows ``INSERT INTO SELECT`` statement of SQL. The examples are as follows:
+
+.. code-block:: sql
+
+  create table t1 (col1 int8, col2 int4, col3 float8);
+
+  -- when a target table schema and output schema are equivalent to each other
+  INSERT OVERWRITE INTO t1 SELECT l_orderkey, l_partkey, l_quantity FROM lineitem;
+  -- or
+  INSERT OVERWRITE INTO t1 SELECT * FROM lineitem;
+
+  -- when the output schema are smaller than the target table schema
+  INSERT OVERWRITE INTO t1 SELECT l_orderkey FROM lineitem;
+
+  -- when you want to specify certain target columns
+  INSERT OVERWRITE INTO t1 (col1, col3) SELECT l_orderkey, l_quantity FROM lineitem;
+
+In addition, INSERT OVERWRITE statement overwrites table data as well as a specific directory.
+
+.. code-block:: sql
+
+  INSERT OVERWRITE INTO LOCATION '/dir/subdir' SELECT l_orderkey, l_quantity FROM lineitem;
\ No newline at end of file

Modified: tajo/site/docs/current/sql_language/predicates.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/predicates.html?rev=1612052&r1=1612051&r2=1612052&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/predicates.html (original)
+++ tajo/site/docs/current/sql_language/predicates.html Sun Jul 20 08:06:30 2014
@@ -120,7 +120,6 @@
 <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#appendix">Appendix</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
 </ul>
 </li>

Added: tajo/site/docs/current/sql_language/predicates.rst
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/predicates.rst?rev=1612052&view=auto
==============================================================================
--- tajo/site/docs/current/sql_language/predicates.rst (added)
+++ tajo/site/docs/current/sql_language/predicates.rst Sun Jul 20 08:06:30 2014
@@ -0,0 +1,159 @@
+*****************
+ Predicates
+*****************
+
+=====================
+ IN Predicate
+=====================
+
+IN predicate provides row and array comparison.
+
+*Synopsis*
+
+.. code-block:: sql
+
+  column_reference IN (val1, val2, ..., valN)
+  column_reference NOT IN (val1, val2, ..., valN)
+
+
+Examples are as follows:
+
+.. code-block:: sql
+
+  -- this statement filters lists down all the records where col1 value is 1, 2 or 3:
+  SELECT col1, col2 FROM table1 WHERE col1 IN (1, 2, 3);
+
+  -- this statement filters lists down all the records where col1 value is neither 1, 2 nor 3:
+  SELECT col1, col2 FROM table1 WHERE col1 NOT IN (1, 2, 3);
+
+You can use 'IN clause' on text data domain as follows:
+
+.. code-block:: sql
+
+  SELECT col1, col2 FROM table1 WHERE col2 IN ('tajo', 'hadoop');
+
+  SELECT col1, col2 FROM table1 WHERE col2 NOT IN ('tajo', 'hadoop');
+
+
+==================================
+String Pattern Matching Predicates
+==================================
+
+--------------------
+LIKE
+--------------------
+
+LIKE operator returns true or false depending on whether its pattern matches the given string. An underscore (_) in pattern matches any single character. A percent sign (%) matches any sequence of zero or more characters.
+
+*Synopsis*
+
+.. code-block:: sql
+
+  string LIKE pattern
+  string NOT LIKE pattern
+
+
+--------------------
+ILIKE
+--------------------
+
+ILIKE is the same to LIKE, but it is a case insensitive operator. It is not in the SQL standard. We borrow this operator from PostgreSQL.
+
+*Synopsis*
+
+.. code-block:: sql
+
+  string ILIKE pattern
+  string NOT ILIKE pattern
+
+
+--------------------
+SIMILAR TO
+--------------------
+
+*Synopsis*
+
+.. code-block:: sql
+
+  string SIMILAR TO pattern
+  string NOT SIMILAR TO pattern
+
+It returns true or false depending on whether its pattern matches the given string. Also like LIKE, ``SIMILAR TO`` uses ``_`` and ``%`` as metacharacters denoting any single character and any string, respectively.
+
+In addition to these metacharacters borrowed from LIKE, 'SIMILAR TO' supports more powerful pattern-matching metacharacters borrowed from regular expressions:
+
++------------------------+-------------------------------------------------------------------------------------------+
+| metacharacter          | description                                                                               |
++========================+===========================================================================================+
+| &#124;                 | denotes alternation (either of two alternatives).                                         |
++------------------------+-------------------------------------------------------------------------------------------+
+| *                      | denotes repetition of the previous item zero or more times.                               |
++------------------------+-------------------------------------------------------------------------------------------+
+| +                      | denotes repetition of the previous item one or more times.                                |
++------------------------+-------------------------------------------------------------------------------------------+
+| ?                      | denotes repetition of the previous item zero or one time.                                 |
++------------------------+-------------------------------------------------------------------------------------------+
+| {m}                    | denotes repetition of the previous item exactly m times.                                  |
++------------------------+-------------------------------------------------------------------------------------------+
+| {m,}                   | denotes repetition of the previous item m or more times.                                  |
++------------------------+-------------------------------------------------------------------------------------------+
+| {m,n}                  | denotes repetition of the previous item at least m and not more than n times.             |
++------------------------+-------------------------------------------------------------------------------------------+
+| []                     | A bracket expression specifies a character class, just as in POSIX regular expressions.   |
++------------------------+-------------------------------------------------------------------------------------------+
+| ()                     | Parentheses can be used to group items into a single logical item.                        |
++------------------------+-------------------------------------------------------------------------------------------+
+
+Note that `.`` is not used as a metacharacter in ``SIMILAR TO`` operator.
+
+---------------------
+Regular expressions
+---------------------
+
+Regular expressions provide a very powerful means for string pattern matching. In the current Tajo, regular expressions are based on Java-style regular expressions instead of POSIX regular expression. The main difference between java-style one and POSIX's one is character class.
+
+*Synopsis*
+
+.. code-block:: sql
+
+  string ~ pattern
+  string !~ pattern
+
+  string ~* pattern
+  string !~* pattern
+
++----------+---------------------------------------------------------------------------------------------------+
+| operator | Description                                                                                       |
++==========+===================================================================================================+
+| ~        | It returns true if a given regular expression is matched to string. Otherwise, it returns false.  |
++----------+---------------------------------------------------------------------------------------------------+
+| !~       | It returns false if a given regular expression is matched to string. Otherwise, it returns true.  |
++----------+---------------------------------------------------------------------------------------------------+
+| ~*       | It is the same to '~', but it is case insensitive.                                                |
++----------+---------------------------------------------------------------------------------------------------+
+| !~*      | It is the same to '!~', but it is case insensitive.                                               |
++----------+---------------------------------------------------------------------------------------------------+
+
+Here are examples:
+
+.. code-block:: sql
+
+  'abc'   ~   '.*c'               true
+  'abc'   ~   'c'                 false
+  'aaabc' ~   '([a-z]){3}bc       true
+  'abc'   ~*  '.*C'               true
+  'abc'   !~* 'B.*'               true
+
+Regular expressions operator is not in the SQL standard. We borrow this operator from PostgreSQL.
+
+*Synopsis for REGEXP and RLIKE operators*
+
+.. code-block:: sql
+
+  string REGEXP pattern
+  string NOT REGEXP pattern
+
+  string RLIKE pattern
+  string NOT RLIKE pattern
+
+But, they do not support case-insensitive operators.
\ No newline at end of file

Modified: tajo/site/docs/current/sql_language/queries.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/queries.html?rev=1612052&r1=1612051&r2=1612052&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/queries.html (original)
+++ tajo/site/docs/current/sql_language/queries.html Sun Jul 20 08:06:30 2014
@@ -120,7 +120,6 @@
 <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#appendix">Appendix</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
 </ul>
 </li>

Added: tajo/site/docs/current/sql_language/queries.rst
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/queries.rst?rev=1612052&view=auto
==============================================================================
--- tajo/site/docs/current/sql_language/queries.rst (added)
+++ tajo/site/docs/current/sql_language/queries.rst Sun Jul 20 08:06:30 2014
@@ -0,0 +1,38 @@
+**************************
+Queries
+**************************
+
+=====================
+Overview
+=====================
+
+*Synopsis*
+
+.. code-block:: sql
+
+  SELECT [distinct [all]] * | <expression> [[AS] <alias>] [, ...]
+    [FROM <table name> [[AS] <table alias name>] [, ...]]
+    [WHERE <condition>]
+    [GROUP BY <expression> [, ...]]
+    [HAVING <condition>]
+    [ORDER BY <expression> [ASC|DESC] [NULL FIRST|NULL LAST] [, ...]]
+
+
+
+=====================
+From Clause
+=====================
+
+
+=====================
+Where Clause
+=====================
+
+
+=====================
+Groupby Clause
+=====================
+
+=====================
+Select list
+=====================
\ No newline at end of file

Modified: tajo/site/docs/current/sql_language/sql_expression.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/sql_expression.html?rev=1612052&r1=1612051&r2=1612052&view=diff
==============================================================================
--- tajo/site/docs/current/sql_language/sql_expression.html (original)
+++ tajo/site/docs/current/sql_language/sql_expression.html Sun Jul 20 08:06:30 2014
@@ -120,7 +120,6 @@
 <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#appendix">Appendix</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
 </ul>
 </li>

Added: tajo/site/docs/current/sql_language/sql_expression.rst
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/sql_expression.rst?rev=1612052&view=auto
==============================================================================
--- tajo/site/docs/current/sql_language/sql_expression.rst (added)
+++ tajo/site/docs/current/sql_language/sql_expression.rst Sun Jul 20 08:06:30 2014
@@ -0,0 +1,31 @@
+============================
+ SQL Expressions
+============================
+
+-------------------------
+ Arithmetic Expressions
+-------------------------
+
+-------------------------
+Type Casts
+-------------------------
+A type cast converts a specified-typed data to another-typed data. Tajo has two type cast syntax:
+
+.. code-block:: sql
+
+  CAST ( expression AS type )
+  expression::type
+
+
+-------------------------
+String Expressions
+-------------------------
+
+
+-------------------------
+Function Call
+-------------------------
+
+.. code-block:: sql
+
+  function_name ([expression [, expression ... ]] )
\ No newline at end of file

Modified: tajo/site/docs/current/table_management.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management.html?rev=1612052&r1=1612051&r2=1612052&view=diff
==============================================================================
--- tajo/site/docs/current/table_management.html (original)
+++ tajo/site/docs/current/table_management.html Sun Jul 20 08:06:30 2014
@@ -119,7 +119,6 @@
 <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#appendix">Appendix</a></li>
 <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#faq">FAQ</a></li>
 </ul>
 </li>

Added: tajo/site/docs/current/table_management.rst
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management.rst?rev=1612052&view=auto
==============================================================================
--- tajo/site/docs/current/table_management.rst (added)
+++ tajo/site/docs/current/table_management.rst Sun Jul 20 08:06:30 2014
@@ -0,0 +1,9 @@
+******************
+Table Management
+******************
+
+.. toctree::
+    :maxdepth: 1
+
+    table_management/file_formats
+    table_management/compression

Modified: tajo/site/docs/current/table_management/compression.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management/compression.html?rev=1612052&r1=1612051&r2=1612052&view=diff
==============================================================================
--- tajo/site/docs/current/table_management/compression.html (original)
+++ tajo/site/docs/current/table_management/compression.html Sun Jul 20 08:06:30 2014
@@ -120,7 +120,6 @@
 <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#appendix">Appendix</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
 </ul>
 </li>

Added: tajo/site/docs/current/table_management/compression.rst
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management/compression.rst?rev=1612052&view=auto
==============================================================================
--- tajo/site/docs/current/table_management/compression.rst (added)
+++ tajo/site/docs/current/table_management/compression.rst Sun Jul 20 08:06:30 2014
@@ -0,0 +1,5 @@
+*********************************
+Compression
+*********************************
+
+.. todo::
\ No newline at end of file

Modified: tajo/site/docs/current/table_management/csv.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management/csv.html?rev=1612052&r1=1612051&r2=1612052&view=diff
==============================================================================
--- tajo/site/docs/current/table_management/csv.html (original)
+++ tajo/site/docs/current/table_management/csv.html Sun Jul 20 08:06:30 2014
@@ -120,7 +120,6 @@
 <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#appendix">Appendix</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
 </ul>
 </li>

Added: tajo/site/docs/current/table_management/csv.rst
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management/csv.rst?rev=1612052&view=auto
==============================================================================
--- tajo/site/docs/current/table_management/csv.rst (added)
+++ tajo/site/docs/current/table_management/csv.rst Sun Jul 20 08:06:30 2014
@@ -0,0 +1,110 @@
+*************************************
+CSV (TextFile)
+*************************************
+
+A character-separated values (CSV) file represents a tabular data set consisting of rows and columns.
+Each row is a plan-text line. A line is usually broken by a character line feed ``\n`` or carriage-return ``\r``.
+The line feed ``\n`` is the default delimiter in Tajo. Each record consists of multiple fields, separated by
+some other character or string, most commonly a literal vertical bar ``|``, comma ``,`` or tab ``\t``.
+The vertical bar is used as the default field delimiter in Tajo.
+
+=========================================
+How to Create a CSV Table ?
+=========================================
+
+If you are not familiar with the ``CREATE TABLE`` statement, please refer to the Data Definition Language :doc:`/sql_language/ddl`.
+
+In order to specify a certain file format for your table, you need to use the ``USING`` clause in your ``CREATE TABLE``
+statement. The below is an example statement for creating a table using CSV files.
+
+.. code-block:: sql
+
+ CREATE TABLE
+  table1 (
+    id int,
+    name text,
+    score float,
+    type text
+  ) USING CSV;
+
+=========================================
+Physical Properties
+=========================================
+
+Some table storage formats provide parameters for enabling or disabling features and adjusting physical parameters.
+The ``WITH`` clause in the CREATE TABLE statement allows users to set those parameters.
+
+Now, the CSV storage format provides the following physical properties.
+
+* ``csvfile.delimiter``: delimiter character. ``|`` or ``\u0001`` is usually used, and the default field delimiter is ``|``.
+* ``csvfile.null``: NULL character. The default NULL character is an empty string ``''``. Hive's default NULL character is ``'\\N'``.
+* ``compression.codec``: Compression codec. You can enable compression feature and set specified compression algorithm. The compression algorithm used to compress files. The compression codec name should be the fully qualified class name inherited from `org.apache.hadoop.io.compress.CompressionCodec <https://hadoop.apache.org/docs/current/api/org/apache/hadoop/io/compress/CompressionCodec.html>`_. By default, compression is disabled.
+* ``csvfile.serde``: custom (De)serializer class. ``org.apache.tajo.storage.TextSerializerDeserializer`` is the default (De)serializer class.
+
+The following example is to set a custom field delimiter, NULL character, and compression codec:
+
+.. code-block:: sql
+
+ CREATE TABLE table1 (
+  id int,
+  name text,
+  score float,
+  type text
+ ) USING CSV WITH('csvfile.delimiter'='\u0001',
+                  'csvfile.null'='\\N',
+                  'compression.codec'='org.apache.hadoop.io.compress.SnappyCodec');
+
+.. warning::
+
+  Be careful when using ``\n`` as the field delimiter because CSV uses ``\n`` as the line delimiter.
+  At the moment, Tajo does not provide a way to specify the line delimiter.
+
+=========================================
+Custom (De)serializer
+=========================================
+
+The CSV storage format not only provides reading and writing interfaces for CSV data but also allows users to process custom
+plan-text file formats with user-defined (De)serializer classes.
+For example, with custom (de)serializers, Tajo can process JSON file formats or any specialized plan-text file formats.
+
+In order to specify a custom (De)serializer, set a physical property ``csvfile.serde``.
+The property value should be a fully qualified class name.
+
+For example:
+
+.. code-block:: sql
+
+ CREATE TABLE table1 (
+  id int,
+  name text,
+  score float,
+  type text
+ ) USING CSV WITH ('csvfile.serde'='org.my.storage.CustomSerializerDeserializer')
+
+
+=========================================
+Null Value Handling Issues
+=========================================
+In default, NULL character in CSV files is an empty string ``''``.
+In other words, an empty field is basically recognized as a NULL value in Tajo.
+If a field domain is ``TEXT``, an empty field is recognized as a string value ``''`` instead of NULL value.
+Besides, You can also use your own NULL character by specifying a physical property ``csvfile.null``.
+
+=========================================
+Compatibility Issues with Apache Hive™
+=========================================
+
+CSV files generated in Tajo can be processed directly by Apache Hive™ without further processing.
+In this section, we explain some compatibility issue for users who use both Hive and Tajo.
+
+If you set a custom field delimiter, the CSV tables cannot be directly used in Hive.
+In order to specify the custom field delimiter in Hive, you need to use ``ROW FORMAT DELIMITED FIELDS TERMINATED BY``
+clause in a Hive's ``CREATE TABLE`` statement as follows:
+
+.. code-block:: sql
+
+ CREATE TABLE table1 (id int, name string, score float, type string)
+ ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
+ STORED AS TEXTFILE
+
+To the best of our knowledge, there is not way to specify a custom NULL character in Hive.
\ No newline at end of file

Modified: tajo/site/docs/current/table_management/file_formats.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management/file_formats.html?rev=1612052&r1=1612051&r2=1612052&view=diff
==============================================================================
--- tajo/site/docs/current/table_management/file_formats.html (original)
+++ tajo/site/docs/current/table_management/file_formats.html Sun Jul 20 08:06:30 2014
@@ -120,7 +120,6 @@
 <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#appendix">Appendix</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
 </ul>
 </li>

Added: tajo/site/docs/current/table_management/file_formats.rst
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management/file_formats.rst?rev=1612052&view=auto
==============================================================================
--- tajo/site/docs/current/table_management/file_formats.rst (added)
+++ tajo/site/docs/current/table_management/file_formats.rst Sun Jul 20 08:06:30 2014
@@ -0,0 +1,13 @@
+*************************************
+File Formats
+*************************************
+
+Currently, Tajo provides four file formats as follows:
+
+.. toctree::
+    :maxdepth: 1
+
+    csv
+    rcfile
+    parquet
+    sequencefile
\ No newline at end of file

Modified: tajo/site/docs/current/table_management/parquet.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management/parquet.html?rev=1612052&r1=1612051&r2=1612052&view=diff
==============================================================================
--- tajo/site/docs/current/table_management/parquet.html (original)
+++ tajo/site/docs/current/table_management/parquet.html Sun Jul 20 08:06:30 2014
@@ -120,7 +120,6 @@
 <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#appendix">Appendix</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
 </ul>
 </li>

Added: tajo/site/docs/current/table_management/parquet.rst
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management/parquet.rst?rev=1612052&view=auto
==============================================================================
--- tajo/site/docs/current/table_management/parquet.rst (added)
+++ tajo/site/docs/current/table_management/parquet.rst Sun Jul 20 08:06:30 2014
@@ -0,0 +1,48 @@
+*************************************
+Parquet
+*************************************
+
+Parquet is a columnar storage format for Hadoop. Parquet is designed to make the advantages of compressed,
+efficient columnar data representation available to any project in the Hadoop ecosystem,
+regardless of the choice of data processing framework, data model, or programming language.
+For more details, please refer to `Parquet File Format <http://parquet.io/>`_.
+
+=========================================
+How to Create a Parquet Table?
+=========================================
+
+If you are not familiar with ``CREATE TABLE`` statement, please refer to Data Definition Language :doc:`/sql_language/ddl`.
+
+In order to specify a certain file format for your table, you need to use the ``USING`` clause in your ``CREATE TABLE``
+statement. Below is an example statement for creating a table using parquet files.
+
+.. code-block:: sql
+
+  CREATE TABLE table1 (
+    id int,
+    name text,
+    score float,
+    type text
+  ) USING PARQUET;
+
+=========================================
+Physical Properties
+=========================================
+
+Some table storage formats provide parameters for enabling or disabling features and adjusting physical parameters.
+The ``WITH`` clause in the CREATE TABLE statement allows users to set those parameters.
+
+Now, Parquet file provides the following physical properties.
+
+* ``parquet.block.size``: The block size is the size of a row group being buffered in memory. This limits the memory usage when writing. Larger values will improve the I/O when reading but consume more memory when writing. Default size is 134217728 bytes (= 128 * 1024 * 1024).
+* ``parquet.page.size``: The page size is for compression. When reading, each page can be decompressed independently. A block is composed of pages. The page is the smallest unit that must be read fully to access a single record. If this value is too small, the compression will deteriorate. Default size is 1048576 bytes (= 1 * 1024 * 1024).
+* ``parquet.compression``: The compression algorithm used to compress pages. It should be one of ``uncompressed``, ``snappy``, ``gzip``, ``lzo``. Default is ``uncompressed``.
+* ``parquet.enable.dictionary``: The boolean value is to enable/disable dictionary encoding. It should be one of either ``true`` or ``false``. Default is ``true``.
+
+=========================================
+Compatibility Issues with Apache Hive™
+=========================================
+
+At the moment, Tajo only supports flat relational tables.
+As a result, Tajo's Parquet storage type does not support nested schemas.
+However, we are currently working on adding support for nested schemas and non-scalar types (`TAJO-710 <https://issues.apache.org/jira/browse/TAJO-710>`_).
\ No newline at end of file

Modified: tajo/site/docs/current/table_management/rcfile.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/table_management/rcfile.html?rev=1612052&r1=1612051&r2=1612052&view=diff
==============================================================================
--- tajo/site/docs/current/table_management/rcfile.html (original)
+++ tajo/site/docs/current/table_management/rcfile.html Sun Jul 20 08:06:30 2014
@@ -120,7 +120,6 @@
 <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#appendix">Appendix</a></li>
 <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
 </ul>
 </li>



Mime
View raw message