You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@tajo.apache.org by hy...@apache.org on 2014/04/01 12:22:26 UTC
svn commit: r1583596 [14/19] - in /tajo/site: ./ docs/0.8.0/
docs/0.8.0/_sources/ docs/0.8.0/_sources/configuration/
docs/0.8.0/_sources/functions/ docs/0.8.0/_sources/getting_started/
docs/0.8.0/_sources/table_management/ docs/0.8.0/_static/ docs/0.8....
Added: tajo/site/docs/current/searchindex.js
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/searchindex.js?rev=1583596&view=auto
==============================================================================
--- tajo/site/docs/current/searchindex.js (added)
+++ tajo/site/docs/current/searchindex.js Tue Apr 1 10:22:23 2014
@@ -0,0 +1 @@
+Search.setIndex({envversion:42,terms:{represent:15,all:[37,12,36,2,3,6,7,42,43,34],code:[3,42,23],dist:[37,14,42],c_name:34,queri:[42,12,8,23],month:15,four:39,concept:37,mno:43,follow:[25,24,11,12,36,37,38,3,28,14,30,18,42,19,43,20,39,34,8,7],disk:[3,8],row:[18,43,7,42,12],profil:36,privat:37,depend:[36,7],c_acctbal:34,zone:20,getconnect:37,decim:20,init:43,program:25,drivermanag:37,sql_languag:12,backup_and_restor:12,"case":[35,37,7,25,42,18],digit:20,sourc:[12,42,23],string:[10,3,25,15],fals:[20,3,7],"void":37,csvfile:[30,43],volum:[12,43],veri:[2,38,7],affect:[42,8],exact:20,dbname:12,tri:37,recordcompresswrit:18,list:[9,43,12,19],hive:[36,18,42],"try":[37,12],item:7,adjust:[24,8],form:24,progress:13,geoip:3,println:37,tajo_src:14,locat:[11,3,30,43,34,8],tajo_hom:[25,37,12,2,38,42,43],dir:[38,11],pleas:[37,2,38,3,43,34,8],upper:35,templet:25,smaller:11,ten:[36,23],annot:37,enjoi:43,dowload:23,second:[35,42],cost:13,design:[13,25],val3:12,val2:[7,12],val1:[7,12],port:[24,37,38,12
,42],tmpdir:8,compat:[18,8],index:9,abc:[7,43],addr:[3,42],compar:20,hdf:[24,12,13,37,38,30,43,23],section:[36,37,38,23,8],xtajoxx:35,access:[36,37,38],c_phone:34,"19th":15,version:[12,42],directori:42,supplier:12,"new":12,method:[9,34],elimin:30,hash:9,valn:7,gener:12,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,valu:[25,24,12,36,38,3,42,8],convert:[3,45],aaabc:7,derbi:42,shift:15,larger:20,table_backup:34,precis:20,datetim:10,codebas:19,implement:[2,12],sequencefil:[9,39],via:23,data_typ:30,apach:[23,3,42,12],modul:[9,25],sign:7,filenam:12,unix:15,"boolean":[20,3],namenode_hostnam:24,wip:[42,19],instal:[3,14],total:8,unit:42,from:[9,11,35,37,15,30,7,19,34,43],describ:[36,12],would:[36,14],memori:42,distinct:6,two:[2,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,38,7,42,43,23,8],flat:18,discompress:14,l_quantiti:11,hive
ql:36,claus:[9,43,7,20],tbname:12,trail:35,rootdir:38,appendix:9,name2:12,name3:12,name1:12,git:42,unpack:23,must:[20,24,37,42],hour:15,alia:[20,6,35,15],setup:33,work:[20,12],uniqu:12,dev:3,cat:[34,43],archiv:[14,42],can:[25,37,12,36,2,43,30,18,42,19,14,8,7],parquet:[9,39],purpos:[36,25],root:38,def:43,bewtween:20,dayofweek:15,prompt:12,tar:[14,42,19],give:[30,8],process:[13,12],share:37,backslash:12,indic:12,liter:25,want:[25,24,37,11,12,36,2,38,30,18,42,43,34,8],tcp:12,occur:[30,15],timestamptz:20,sundai:15,end:[35,19],goal:13,quot:12,str2:35,str1:35,mapr:18,how:[9,36,2,38,23,8],purg:30,env:42,c_address:34,instead:[43,7,12],csv:[9,43,30,12,34],simpl:[2,43],lazybinaryserd:18,blockcompresswrit:18,map:20,resourc:38,ltrim:35,clone:[42,19],after:14,resultset:37,concatnen:35,befor:38,catalog:1,date:[20,34],multipl:8,underscor:7,data:38,parallel:38,physic:38,tajo_worker_heaps:8,github:19,third:[42,15],host:[37,12,42],grant:42,element:25,inform:[12,42],preced:3,environ:[25,24,2,36,8],all
ow:[24,36,38,30,43,8],anoth:45,worst:13,order:[12,13,36,37,38,6,42,43,20,8],help:12,shorten:42,move:14,midnight:15,vari:20,dynam:13,paramet:[35,30,3,15],joda:37,write:18,style:7,group:[6,7],cli:[37,12],html:12,persist:42,main:[13,37,7,25],lastli:42,"return":[35,15,3,7],thei:[37,7],timestamp:[20,15],col2:[11,7],col3:11,auth:37,nation:12,now:[12,14,34],utc_usec_to:15,nor:7,introduct:9,serde2:18,hive_jdbc_driver_dir:[36,42],name:[25,24,12,36,37,38,3,40,6,18,42,43,20,34,8],anyth:12,config:[25,12,36,38,40,42,8],drop:9,regexp_replac:35,instruct:[36,3,19],guava:37,easili:37,mode:42,each:[38,12,25],clsspath:37,compatibl:34,side:[37,35],mean:7,compil:[36,14,42],domain:7,replac:35,saturdai:15,procedur:14,"static":37,connect:[36,37,12,42],year:15,o_clerk:12,out:[37,8,19],unquot:12,network:10,space:35,o_orderkei:12,xxtajo:35,content:[9,30],com:3,hivemetastor:[36,42],current:[24,12,36,37,39,7,42,8],math:10,integr:42,shut:23,advanc:13,manipul:12,differ:7,free:43,standard:[13,20,7,43],asc:6,small:
20,base:42,asf:[42,19],org:[12,36,37,30,18,42,19],"byte":[20,12,43],fridai:15,refer:[37,38,3,43,18],val:12,launch:42,could:15,filter:7,length:20,umbil:[40,38],licens:12,mvn:[36,37,14,42],first:[35,23,25,15,14,42],oper:10,rang:[9,28],resourceconfigur:8,feel:43,onc:[3,19],arrai:7,applciat:37,number:[38,12],capac:[38,8],mai:[37,25,15],o_orderd:12,set:[12,42],done:14,overwrit:[9,44],tpch:[12,34],open:13,primari:24,given:[11,12,3,30,7,43,20,35],"long":[13,15],script:[14,25],interact:[13,12,43],mkdir:[38,43],system:[37,13,2,38,25,14,8],least:7,master:[33,38,12,42],statement:[11,12,37,30,18,43,7],l_partkei:[30,11],scheme:[24,43],"final":[36,37,42,43],store:[12,13,36,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,18,42,20,45,8,7],part:12,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,39,7,42,43,8,18],remov:[30,35],tree:1
4,zero:7,charact:[20,7,35],project:13,posix:7,balanc:13,sec:[42,43],minut:[36,23],schema:[11,12,43],createdatabaseifnotexist:42,textserd:18,ran:42,respons:[13,43],argument:15,packag:[36,37,14,42],manner:37,have:[24,36,30,42,19,6],tabl:[36,34,43,12,23],need:[37,36,2,18,42,43,34],maxmind:3,predic:[9,44],featur:36,rcfile:[9,39],techniqu:13,equival:11,partsupp:12,click:19,note:[7,42],also:[18,19,7,43,12],without:13,build:[23,42],xxxxxx:42,prepar:[36,14,42,43],channel:9,begin:[12,15],c_nationkei:34,distribut:42,preliminari:33,buffer:21,filesystem:[23,19],compress:9,deflatecodec:30,most:42,microsecond:15,plan:13,pair:[18,25],metacharact:7,"class":[36,37,7,42,18],dai:15,don:[37,34,25],url:[24,37],doc:12,later:23,request:8,uri:42,ghi:43,bracket:7,snapshot:[37,14,42],determin:8,pattern:[9,35],querymast:8,think:43,show:[37,12,43,23],text:[12,3,15,35,30,18,43,20,34,7],hostnam:[24,37,38,12],syntax:45,column_refer:7,identifi:42,xml:[38,12,42],absolut:43,onli:[24,25,2,15,18,42,19],explicitli:25,r
atio:8,just:[34,7,42,12],copyright:12,explain:[38,2,37,23],configur:12,jar:[9,36,42],enough:42,geoip_country_cod:3,templat:42,local:[23,42,3,8,19],info:40,unresolvedaddressexcept:9,variou:12,get:42,necesssari:37,express:[9,35,44],repo:[42,19],java_hom:2,"import":37,increas:38,requir:[2,15],enabl:[37,38],borrow:7,"public":37,remot:38,common:37,partit:9,contain:[37,30],where:[9,2,38,7,43,20,8],bytea:20,legaci:3,startup:12,memstor:42,c_custkei:34,see:[2,38,42,8,43],num:12,float8:[20,11,12,34],result:[37,43],arg:37,float4:20,close:37,rlike:7,o_orderstatu:12,concern:[34,25],slf4j:37,kei:[9,12],correctli:20,netti:37,ieee:20,char_length:35,state:43,score:[18,43],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],stmt:37,outfil:34,disconnect:12,addit:[37,11,7,8],both:[13,18,35],last:6,delimit:[30,35,43],fault:13,region:12,gzipcodec:30,c_comment:34,groupbi:9,against:23,eta:37,logic:7,mani:[37
,8],whole:8,load:[13,43],simpli:14,overview:9,"4028235e":20,split_part:35,rpc:[40,37,38],written:18,toler:13,respect:[20,7],tuesdai:15,guid:12,assum:[8,43],quit:12,xzvf:[14,19],o_com:12,three:[18,42],much:8,newinst:37,basic:34,c_mktsegment:34,pdist:[36,37,14,42],derbystor:42,o_custkei:12,xxx:12,worker:[33,38],search:9,ani:[37,7],tajojdbccli:37,work1:12,repetit:7,present:23,emploi:13,bye:43,look:19,implementaion:24,plain:18,servic:[40,42],properti:[24,25,36,38,3,40,42,8],batch:13,durat:42,cast:9,"while":37,abov:[18,43],error:30,textserializerdeseri:18,table_nam:[30,34],layer:24,file:[9,24,12,25,36,2,38,3,14,42,19,34,8,43],ctrl:43,key1:12,site:[38,12,42],cluster:[33,42],itself:12,warehous:[13,30],conf:[25,24,37,12,36,2,3,42,8],march:15,abcdef:35,conn:37,"null":[37,6],develop:19,"35b":43,minim:9,suggest:19,classpath:9,hadoop:[37,13,2,38,30,7,25,43,21,23,18],same:[36,15,3,7],binari:[20,18,42,14],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,driver:[9,36,42],geoip_in_countri:3,decompress:19,jkl:43,column_nam:30,retriv:37,dskiptest:[36,37,14,42],user:[24,43,12,8,42],tajo_classpath:42,countri:3,extern:[30,34,43],col1:[11,7],tsql:34,chang:[37,38,12,42,19],built:37,lower:35,appropri:[25,43],lib:42,entri:30,well:[30,11,20],parenthes:7,know:[38,43],exampl:34,command:34,thi:[25,36,37,38,14,15,18,42,19,43,34,23,8,7],choos:[14,19],model:[9,44],usual:[37,25],explan:43,protocol:21,execut:[38,12,8,23],when:[30,37,11],dtar:[36,37,14,42],rest:19,q_1363768615503_0001_000001:43,mysql:[36,42],simultan:8,database_nam:[30,12],languag:[13,9,12,43],inet4:[20,3],web:13,binaryserializerdeseri:18,all_backup:34,easi:34,field:35,disk1:8,disk2:8,disk3:8,except:37,littl:38,add:[2,25,36,37,38,30,42,8],other:[13,11,25],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,30,18,42,43],format:[9,31],read:[38,1
8,19],bzip2codec:30,workload:8,phcatalog:[36,42],chmod:38,lineitem_100_snappi:30,bit:20,password:42,desc:6,insert:[9,44],storage_typ:30,table1:[37,7,43,18],resid:43,like:[24,37,14],specif:[20,24,11],substr:35,should:[24,12,36,37,38,3,23,30,42,43,34,8],reoptim:13,integ:[20,8],server:[25,42],query_succeed:43,collect:18,api:[9,37],necessari:[13,37],singl:7,output:[11,18],timetz:20,tajo:34,page:[9,38],createstat:37,"1st":15,some:[36,37,25,43,20,14],tajowork:[25,8],certain:11,intern:25,"export":[36,2,42],mirror:19,proper:[24,14,8],home:[36,2,34,42,43],tmp:[24,43],separ:18,scale:13,lead:35,"512mb":8,avoid:[13,30],exec:18,definit:[9,44],per:[12,8],exit:43,select:[9,11,35,37,3,15,7,43],bigint:[20,30],ddl:[34,43],condit:6,fornam:37,localhost:[40,30,12,42],either:[20,36,7,19],machin:[12,42],core:8,previou:7,run:[38,12],power:7,uncompress:18,ab_bc_cd:35,usag:34,hive_hom:[36,42],maven:[36,37],step:14,character_length:35,repositori:19,peer:40,java:[9,25,36,2,42,21],unicod:20,stage:43,comparison:
[20,7],postgresql:7,column:9,varbinari:20,manag:[9,36],degre:38,regular:35,"1gb":[24,8],block:18,client:[9,40,38,12],"float":[20,18,8,43],lazybinari:18,due:8,down:[7,23],defaultport:42,storag:[24,37,18,42,34],your:[24,25,36,37,34,42,19,23,14],jdbc:[9,36,42],log:37,wai:34,support:[24,34,42],submit:[23,43],custom:[12,42,34],avail:[37,8],start:[38,35],current_databas:12,arithmet:9,includ:[37,8],unix_timestamp:15,ipv4:[20,3],"function":12,snappycodec:[30,18],untar:19,tajoxx:35,l_comment:30,int4:[20,11,12,35],link:19,select_stat:30,int2:20,"true":[3,18,42,20,8,7],int8:[20,11,12,34],count:35,"throw":37,consist:[18,25],possibl:8,whether:7,day_of_week:15,record:[7,18],below:[37,23,34],limit:8,otherwis:[12,3,7],executequeri:37,trim:35,binaryserd:18,creat:[9,12,38,23,42,43,34],btrim:35,"int":[20,43,35,18,15],sequecnefil:18,forgot:37,repres:15,"char":20,exist:[30,11,12],o_shipprior:12,guarante:37,download:[3,19],doe:[37,30],check:19,denot:7,percent:7,detail:[38,42,43],getstr:37,"default":[33,3
8,12,42],codec:[30,18],bool:20,rdbm:37,varieti:25,test:[37,12,42],you:[25,24,37,11,12,36,2,38,3,14,15,30,7,42,19,43,34,23,8,18],node:[37,38],clean:[36,37,14,42],sequenc:7,insensit:7,tajo_dump:34,protobuf:37,tajomast:[25,38,12,42],hurt:13,lang:37,algorithm:8,function_nam:45,hyunsik:[12,34],regexp:7,descript:[12,40,7,42,43,20,8],tajo_master_heaps:24,tinyint:20,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/sequenc
efile","getting_started/downloading_source","sql_language/data_model","getting_started/prerequisites","functions/math_func_and_operators","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","Queries","Predicates","Worker Configuration","Apache Tajo\u2122 0.8.0 (dev) - User documentation","Functions","IN
SERT (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_count
ry:[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,configur:[40,24,33,42,8],jar:37,overview:6,local:2,match:7,real:20,sourc:[14,19],synopsi:12,string:[7,45,35],format:39,faq:[27,37],insert:11,introduct:[13,28],mysqlstor:42,document:9,like:7,level:34,drop:30,list:[37,6],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,17,41,34],distribut:38,variabl:12,network:3,cast:45,databas:[30,34],definit:30,method:28,math:22,integr:36,hash:0,kei:28,driver:37,usag:12,serializerdeseri:18,base:38,prerequisit:[21,3],releas:19,java:37,rcfile:16,valu:20,launch:38,via:19,tajo:[9,24,37,12,2,38,40,41,25,19],groupbi:6,datetim:15,backup:[1,34],first:43,oper:[22,35,3,15],rang:4,writer:18,apach:[9,19],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,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,8],rootdir:24,appendix:37,heap:[24,8],jdbc:37,unpack:19,restor:[1,34],"default":40,setup:38,maximum:8,dev:9,column:17,serd:18,introduc:18,parquet:32,similar:7,creat:30,site:25,indic:9,cluster:[2,38],unresolvedaddressexcept:37,file:[37,39],tabl:[9,29,30,31],dedic:8,minim:37,make:38,get:[37,23,19],classpath:37,how:37,exampl:[37,8],build:14,env:25,csv:5,channel:37,express:[7,45],resourc:8,nio:37,preliminari:25,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,task:8,directori:[38,8],predic:7,arithmet:45,client:[37,41],command:12,pattern:7,model:20,sequencefil:18,latest:19}})
\ No newline at end of file
Added: tajo/site/docs/current/sql_language.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language.html?rev=1583596&view=auto
==============================================================================
--- tajo/site/docs/current/sql_language.html (added)
+++ tajo/site/docs/current/sql_language.html Tue Apr 1 10:22:23 2014
@@ -0,0 +1,241 @@
+
+
+<!DOCTYPE html>
+<!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
+<!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
+<head>
+ <meta charset="utf-8">
+ <meta name="viewport" content="width=device-width, initial-scale=1.0">
+
+ <title>SQL Language — Apache Tajo 0.8.0 documentation</title>
+
+
+
+
+
+
+ <link href='https://fonts.googleapis.com/css?family=Lato:400,700|Roboto+Slab:400,700|Inconsolata:400,700' rel='stylesheet' type='text/css'>
+
+
+
+
+
+
+
+
+
+ <link rel="stylesheet" href="_static/css/theme.css" type="text/css" />
+
+
+
+ <link rel="top" title="Apache Tajo 0.8.0 documentation" href="index.html"/>
+ <link rel="next" title="Data Model" href="sql_language/data_model.html"/>
+ <link rel="prev" title="Tajo Shell (TSQL)" href="cli.html"/>
+
+
+ <script src="https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js"></script>
+
+</head>
+
+<body class="wy-body-for-nav" role="document">
+
+ <div class="wy-grid-for-nav">
+
+
+ <nav data-toggle="wy-nav-shift" class="wy-nav-side">
+ <div class="wy-side-nav-search">
+ <a href="index.html" class="fa fa-home"> Apache Tajo</a>
+ <div role="search">
+ <form id ="rtd-search-form" class="wy-form" action="search.html" method="get">
+ <input type="text" name="q" placeholder="Search docs" />
+ <input type="hidden" name="check_keywords" value="yes" />
+ <input type="hidden" name="area" value="default" />
+ </form>
+</div>
+ </div>
+
+ <div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation" aria-label="main navigation">
+
+
+ <ul class="current">
+<li class="toctree-l1"><a class="reference internal" href="introduction.html">Introduction</a></li>
+<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="getting_started/prerequisites.html">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" href="getting_started/downloading_source.html">Dowload and unpack the source code of Apache Tajo</a></li>
+<li class="toctree-l2"><a class="reference internal" href="getting_started/building.html">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" href="getting_started/local_setup.html">Setting up a local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" href="getting_started/first_query.html">First query execution</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="configuration.html">Configuration</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="configuration/preliminary.html">Preliminary</a></li>
+<li class="toctree-l2"><a class="reference internal" href="configuration/cluster_setup.html">Cluster Setup</a></li>
+<li class="toctree-l2"><a class="reference internal" href="configuration/tajo_master_configuration.html">Tajo Master Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="configuration/worker_configuration.html">Worker Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="configuration/catalog_configuration.html">Catalog Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="configuration/configuration_defaults.html">Configuration Defaults</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="cli.html">Tajo Shell (TSQL)</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="cli.html#synopsis">Synopsis</a></li>
+<li class="toctree-l2"><a class="reference internal" href="cli.html#entering-tsql-shell">Entering tsql shell</a></li>
+<li class="toctree-l2"><a class="reference internal" href="cli.html#meta-commands">Meta Commands</a></li>
+</ul>
+</li>
+<li class="toctree-l1 current"><a class="current reference internal" href="">SQL Language</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="sql_language/data_model.html">Data Model</a></li>
+<li class="toctree-l2"><a class="reference internal" href="sql_language/ddl.html">Data Definition Language</a></li>
+<li class="toctree-l2"><a class="reference internal" href="sql_language/insert.html">INSERT (OVERWRITE) INTO</a></li>
+<li class="toctree-l2"><a class="reference internal" href="sql_language/queries.html">Queries</a></li>
+<li class="toctree-l2"><a class="reference internal" href="sql_language/sql_expression.html">SQL Expressions</a></li>
+<li class="toctree-l2"><a class="reference internal" href="sql_language/predicates.html">Predicates</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="functions.html">Functions</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="functions/math_func_and_operators.html">Math Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="functions/string_func_and_operators.html">String Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="functions/network_func_and_operators.html">Network Functions and Operators</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="table_management.html">Table Management</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="table_management/file_formats.html">File Formats</a></li>
+<li class="toctree-l2"><a class="reference internal" href="table_management/compression.html">Compression</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="table_partitioning.html">Table Partitioning</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="partitioning/intro_to_partitioning.html">Introduction to Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal" href="partitioning/column_partitioning.html">Column Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal" href="partitioning/range_partitioning.html">Range Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal" href="partitioning/hash_partitioning.html">Hash Partitioning</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="backup_and_restore/catalog.html">Backup and Restore Catalog</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="hcatalog_integration.html">HCatalog Integration</a></li>
+<li class="toctree-l1"><a class="reference internal" href="jdbc_driver.html">Tajo JDBC Driver</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li>
+<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li>
+<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#appendix">Appendix</a></li>
+<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#faq">FAQ</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="tajo_client_api.html">Tajo Client API</a></li>
+<li class="toctree-l1"><a class="reference internal" href="faq.html">FAQ</a></li>
+</ul>
+
+
+ </div>
+
+ </nav>
+
+ <section data-toggle="wy-nav-shift" class="wy-nav-content-wrap">
+
+
+ <nav class="wy-nav-top" role="navigation" aria-label="top navigation">
+ <i data-toggle="wy-nav-top" class="fa fa-bars"></i>
+ <a href="index.html">Apache Tajo</a>
+ </nav>
+
+
+
+ <div class="wy-nav-content">
+ <div class="rst-content">
+ <div role="navigation" aria-label="breadcrumbs navigation">
+ <ul class="wy-breadcrumbs">
+ <li><a href="index.html">Docs</a> »</li>
+
+ <li>SQL Language</li>
+ <li class="wy-breadcrumbs-aside">
+
+ <a href="_sources/sql_language.txt" rel="nofollow"> View page source</a>
+
+ </li>
+ </ul>
+ <hr/>
+</div>
+ <div role="main">
+
+ <div class="section" id="sql-language">
+<h1>SQL Language<a class="headerlink" href="#sql-language" title="Permalink to this headline">¶</a></h1>
+<div class="toctree-wrapper compound">
+<ul>
+<li class="toctree-l1"><a class="reference internal" href="sql_language/data_model.html">Data Model</a></li>
+<li class="toctree-l1"><a class="reference internal" href="sql_language/ddl.html">Data Definition Language</a></li>
+<li class="toctree-l1"><a class="reference internal" href="sql_language/insert.html">INSERT (OVERWRITE) INTO</a></li>
+<li class="toctree-l1"><a class="reference internal" href="sql_language/queries.html">Queries</a></li>
+<li class="toctree-l1"><a class="reference internal" href="sql_language/sql_expression.html">SQL Expressions</a></li>
+<li class="toctree-l1"><a class="reference internal" href="sql_language/predicates.html">Predicates</a></li>
+</ul>
+</div>
+</div>
+
+
+ </div>
+ <footer>
+
+ <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
+
+ <a href="sql_language/data_model.html" class="btn btn-neutral float-right" title="Data Model"/>Next <span class="fa fa-arrow-circle-right"></span></a>
+
+
+ <a href="cli.html" class="btn btn-neutral" title="Tajo Shell (TSQL)"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+
+ </div>
+
+
+ <hr/>
+
+ <div role="contentinfo">
+ <p>
+ © Copyright 2014, Apache Tajo Team.
+ </p>
+ </div>
+
+ <a href="https://github.com/snide/sphinx_rtd_theme">Sphinx theme</a> provided by <a href="https://readthedocs.org">Read the Docs</a>
+</footer>
+ </div>
+ </div>
+
+ </section>
+
+ </div>
+
+
+
+
+
+ <script type="text/javascript">
+ var DOCUMENTATION_OPTIONS = {
+ URL_ROOT:'./',
+ VERSION:'0.8.0',
+ COLLAPSE_INDEX:false,
+ FILE_SUFFIX:'.html',
+ HAS_SOURCE: true
+ };
+ </script>
+ <script type="text/javascript" src="_static/jquery.js"></script>
+ <script type="text/javascript" src="_static/underscore.js"></script>
+ <script type="text/javascript" src="_static/doctools.js"></script>
+
+
+
+
+
+ <script type="text/javascript" src="_static/js/theme.js"></script>
+
+
+
+
+ <script type="text/javascript">
+ jQuery(function () {
+ SphinxRtdTheme.StickyNav.enable();
+ });
+ </script>
+
+
+</body>
+</html>
\ No newline at end of file
Added: 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=1583596&view=auto
==============================================================================
--- tajo/site/docs/current/sql_language/data_model.html (added)
+++ tajo/site/docs/current/sql_language/data_model.html Tue Apr 1 10:22:23 2014
@@ -0,0 +1,422 @@
+
+
+<!DOCTYPE html>
+<!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
+<!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
+<head>
+ <meta charset="utf-8">
+ <meta name="viewport" content="width=device-width, initial-scale=1.0">
+
+ <title>Data Model — Apache Tajo 0.8.0 documentation</title>
+
+
+
+
+
+
+ <link href='https://fonts.googleapis.com/css?family=Lato:400,700|Roboto+Slab:400,700|Inconsolata:400,700' rel='stylesheet' type='text/css'>
+
+
+
+
+
+
+
+
+
+ <link rel="stylesheet" href="../_static/css/theme.css" type="text/css" />
+
+
+
+ <link rel="top" title="Apache Tajo 0.8.0 documentation" href="../index.html"/>
+ <link rel="up" title="SQL Language" href="../sql_language.html"/>
+ <link rel="next" title="Data Definition Language" href="ddl.html"/>
+ <link rel="prev" title="SQL Language" href="../sql_language.html"/>
+
+
+ <script src="https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js"></script>
+
+</head>
+
+<body class="wy-body-for-nav" role="document">
+
+ <div class="wy-grid-for-nav">
+
+
+ <nav data-toggle="wy-nav-shift" class="wy-nav-side">
+ <div class="wy-side-nav-search">
+ <a href="../index.html" class="fa fa-home"> Apache Tajo</a>
+ <div role="search">
+ <form id ="rtd-search-form" class="wy-form" action="../search.html" method="get">
+ <input type="text" name="q" placeholder="Search docs" />
+ <input type="hidden" name="check_keywords" value="yes" />
+ <input type="hidden" name="area" value="default" />
+ </form>
+</div>
+ </div>
+
+ <div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation" aria-label="main navigation">
+
+
+ <ul class="current">
+<li class="toctree-l1"><a class="reference internal" href="../introduction.html">Introduction</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../getting_started.html">Getting Started</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../getting_started/prerequisites.html">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../getting_started/downloading_source.html">Dowload and unpack the source code of Apache Tajo</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../getting_started/building.html">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../getting_started/local_setup.html">Setting up a local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../getting_started/first_query.html">First query execution</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../configuration.html">Configuration</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/preliminary.html">Preliminary</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/cluster_setup.html">Cluster Setup</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/tajo_master_configuration.html">Tajo Master Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/worker_configuration.html">Worker Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/catalog_configuration.html">Catalog Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/configuration_defaults.html">Configuration Defaults</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../cli.html">Tajo Shell (TSQL)</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../cli.html#synopsis">Synopsis</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../cli.html#entering-tsql-shell">Entering tsql shell</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../cli.html#meta-commands">Meta Commands</a></li>
+</ul>
+</li>
+<li class="toctree-l1 current"><a class="reference internal" href="../sql_language.html">SQL Language</a><ul class="current">
+<li class="toctree-l2 current"><a class="current reference internal" href="">Data Model</a></li>
+<li class="toctree-l2"><a class="reference internal" href="ddl.html">Data Definition Language</a></li>
+<li class="toctree-l2"><a class="reference internal" href="insert.html">INSERT (OVERWRITE) INTO</a></li>
+<li class="toctree-l2"><a class="reference internal" href="queries.html">Queries</a></li>
+<li class="toctree-l2"><a class="reference internal" href="sql_expression.html">SQL Expressions</a></li>
+<li class="toctree-l2"><a class="reference internal" href="predicates.html">Predicates</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../functions.html">Functions</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../functions/math_func_and_operators.html">Math Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../functions/string_func_and_operators.html">String Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../functions/network_func_and_operators.html">Network Functions and Operators</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../table_partitioning.html">Table Partitioning</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../partitioning/intro_to_partitioning.html">Introduction to Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../partitioning/column_partitioning.html">Column Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../partitioning/range_partitioning.html">Range Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../partitioning/hash_partitioning.html">Hash Partitioning</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../backup_and_restore.html">Backup and Restore</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../backup_and_restore/catalog.html">Backup and Restore Catalog</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../hcatalog_integration.html">HCatalog Integration</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#appendix">Appendix</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../tajo_client_api.html">Tajo Client API</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../faq.html">FAQ</a></li>
+</ul>
+
+
+ </div>
+
+ </nav>
+
+ <section data-toggle="wy-nav-shift" class="wy-nav-content-wrap">
+
+
+ <nav class="wy-nav-top" role="navigation" aria-label="top navigation">
+ <i data-toggle="wy-nav-top" class="fa fa-bars"></i>
+ <a href="../index.html">Apache Tajo</a>
+ </nav>
+
+
+
+ <div class="wy-nav-content">
+ <div class="rst-content">
+ <div role="navigation" aria-label="breadcrumbs navigation">
+ <ul class="wy-breadcrumbs">
+ <li><a href="../index.html">Docs</a> »</li>
+
+ <li><a href="../sql_language.html">SQL Language</a> »</li>
+
+ <li>Data Model</li>
+ <li class="wy-breadcrumbs-aside">
+
+ <a href="../_sources/sql_language/data_model.txt" rel="nofollow"> View page source</a>
+
+ </li>
+ </ul>
+ <hr/>
+</div>
+ <div role="main">
+
+ <div class="section" id="data-model">
+<h1>Data Model<a class="headerlink" href="#data-model" title="Permalink to this headline">¶</a></h1>
+<div class="section" id="data-types">
+<h2>Data Types<a class="headerlink" href="#data-types" title="Permalink to this headline">¶</a></h2>
+<table border="1" class="docutils">
+<colgroup>
+<col width="6%" />
+<col width="8%" />
+<col width="15%" />
+<col width="7%" />
+<col width="26%" />
+<col width="38%" />
+</colgroup>
+<thead valign="bottom">
+<tr class="row-odd"><th class="head">Supported</th>
+<th class="head">SQL Type Name</th>
+<th class="head">Alias</th>
+<th class="head">Size (byte)</th>
+<th class="head">Description</th>
+<th class="head">Range</th>
+</tr>
+</thead>
+<tbody valign="top">
+<tr class="row-even"><td>O</td>
+<td>boolean</td>
+<td>bool</td>
+<td>1</td>
+<td> </td>
+<td>true/false</td>
+</tr>
+<tr class="row-odd"><td> </td>
+<td>bit</td>
+<td> </td>
+<td>1</td>
+<td> </td>
+<td>1/0</td>
+</tr>
+<tr class="row-even"><td> </td>
+<td>varbit</td>
+<td>bit varying</td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="row-odd"><td>O</td>
+<td>smallint</td>
+<td>tinyint, int2</td>
+<td>2</td>
+<td>small-range integer value</td>
+<td>-2^15 (-32,768) to 2^15 (32,767)</td>
+</tr>
+<tr class="row-even"><td>O</td>
+<td>integer</td>
+<td>int, int4</td>
+<td>4</td>
+<td>integer value</td>
+<td>-2^31 (-2,147,483,648) to 2^31 - 1 (2,147,483,647)</td>
+</tr>
+<tr class="row-odd"><td>O</td>
+<td>bigint</td>
+<td>bit varying</td>
+<td>8</td>
+<td>larger range integer value</td>
+<td>-2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)</td>
+</tr>
+<tr class="row-even"><td>O</td>
+<td>real</td>
+<td>int8</td>
+<td>4</td>
+<td>variable-precision, inexact, real number value</td>
+<td>-3.4028235E+38 to 3.4028235E+38 (6 decimal digits precision)</td>
+</tr>
+<tr class="row-odd"><td>O</td>
+<td>float[(n)]</td>
+<td>float4</td>
+<td>4 or 8</td>
+<td>variable-precision, inexact, real number value</td>
+<td> </td>
+</tr>
+<tr class="row-even"><td>O</td>
+<td>double</td>
+<td>float8, double precision</td>
+<td>8</td>
+<td>variable-precision, inexact, real number value</td>
+<td>1 .7Eâ308 to 1.7E+308 (15 decimal digits precision)</td>
+</tr>
+<tr class="row-odd"><td> </td>
+<td>number</td>
+<td>decimal</td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="row-even"><td> </td>
+<td>char[(n)]</td>
+<td>character</td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="row-odd"><td> </td>
+<td>varchar[(n)]</td>
+<td>character varying</td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="row-even"><td>O</td>
+<td>text</td>
+<td>text</td>
+<td> </td>
+<td>variable-length unicode text</td>
+<td> </td>
+</tr>
+<tr class="row-odd"><td> </td>
+<td>binary</td>
+<td>binary</td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="row-even"><td> </td>
+<td>varbinary[(n)]</td>
+<td>binary varying</td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="row-odd"><td>O</td>
+<td>blob</td>
+<td>bytea</td>
+<td> </td>
+<td>variable-length binary string</td>
+<td> </td>
+</tr>
+<tr class="row-even"><td> </td>
+<td>date</td>
+<td> </td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="row-odd"><td> </td>
+<td>time</td>
+<td> </td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="row-even"><td> </td>
+<td>timetz</td>
+<td>time with time zone</td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="row-odd"><td> </td>
+<td>timestamp</td>
+<td> </td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="row-even"><td> </td>
+<td>timestamptz</td>
+<td> </td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="row-odd"><td>O</td>
+<td>inet4</td>
+<td> </td>
+<td>4</td>
+<td>IPv4 address</td>
+<td> </td>
+</tr>
+</tbody>
+</table>
+<div class="section" id="using-real-number-value-real-and-double">
+<h3>Using real number value (real and double)<a class="headerlink" href="#using-real-number-value-real-and-double" title="Permalink to this headline">¶</a></h3>
+<p>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.</p>
+<ul class="simple">
+<li>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.</li>
+<li>If 1 <- n <- 24, a value is mapped to float (6 decimal digits precision).</li>
+<li>If 25 <- n <- 53, a value is mapped to double (15 decimal digits precision).</li>
+<li>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.</li>
+</ul>
+</div>
+</div>
+</div>
+
+
+ </div>
+ <footer>
+
+ <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
+
+ <a href="ddl.html" class="btn btn-neutral float-right" title="Data Definition Language"/>Next <span class="fa fa-arrow-circle-right"></span></a>
+
+
+ <a href="../sql_language.html" class="btn btn-neutral" title="SQL Language"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+
+ </div>
+
+
+ <hr/>
+
+ <div role="contentinfo">
+ <p>
+ © Copyright 2014, Apache Tajo Team.
+ </p>
+ </div>
+
+ <a href="https://github.com/snide/sphinx_rtd_theme">Sphinx theme</a> provided by <a href="https://readthedocs.org">Read the Docs</a>
+</footer>
+ </div>
+ </div>
+
+ </section>
+
+ </div>
+
+
+
+
+
+ <script type="text/javascript">
+ var DOCUMENTATION_OPTIONS = {
+ URL_ROOT:'../',
+ VERSION:'0.8.0',
+ COLLAPSE_INDEX:false,
+ FILE_SUFFIX:'.html',
+ HAS_SOURCE: true
+ };
+ </script>
+ <script type="text/javascript" src="../_static/jquery.js"></script>
+ <script type="text/javascript" src="../_static/underscore.js"></script>
+ <script type="text/javascript" src="../_static/doctools.js"></script>
+
+
+
+
+
+ <script type="text/javascript" src="../_static/js/theme.js"></script>
+
+
+
+
+ <script type="text/javascript">
+ jQuery(function () {
+ SphinxRtdTheme.StickyNav.enable();
+ });
+ </script>
+
+
+</body>
+</html>
\ No newline at end of file
Added: tajo/site/docs/current/sql_language/ddl.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/ddl.html?rev=1583596&view=auto
==============================================================================
--- tajo/site/docs/current/sql_language/ddl.html (added)
+++ tajo/site/docs/current/sql_language/ddl.html Tue Apr 1 10:22:23 2014
@@ -0,0 +1,294 @@
+
+
+<!DOCTYPE html>
+<!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
+<!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
+<head>
+ <meta charset="utf-8">
+ <meta name="viewport" content="width=device-width, initial-scale=1.0">
+
+ <title>Data Definition Language — Apache Tajo 0.8.0 documentation</title>
+
+
+
+
+
+
+ <link href='https://fonts.googleapis.com/css?family=Lato:400,700|Roboto+Slab:400,700|Inconsolata:400,700' rel='stylesheet' type='text/css'>
+
+
+
+
+
+
+
+
+
+ <link rel="stylesheet" href="../_static/css/theme.css" type="text/css" />
+
+
+
+ <link rel="top" title="Apache Tajo 0.8.0 documentation" href="../index.html"/>
+ <link rel="up" title="SQL Language" href="../sql_language.html"/>
+ <link rel="next" title="INSERT (OVERWRITE) INTO" href="insert.html"/>
+ <link rel="prev" title="Data Model" href="data_model.html"/>
+
+
+ <script src="https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js"></script>
+
+</head>
+
+<body class="wy-body-for-nav" role="document">
+
+ <div class="wy-grid-for-nav">
+
+
+ <nav data-toggle="wy-nav-shift" class="wy-nav-side">
+ <div class="wy-side-nav-search">
+ <a href="../index.html" class="fa fa-home"> Apache Tajo</a>
+ <div role="search">
+ <form id ="rtd-search-form" class="wy-form" action="../search.html" method="get">
+ <input type="text" name="q" placeholder="Search docs" />
+ <input type="hidden" name="check_keywords" value="yes" />
+ <input type="hidden" name="area" value="default" />
+ </form>
+</div>
+ </div>
+
+ <div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation" aria-label="main navigation">
+
+
+ <ul class="current">
+<li class="toctree-l1"><a class="reference internal" href="../introduction.html">Introduction</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../getting_started.html">Getting Started</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../getting_started/prerequisites.html">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../getting_started/downloading_source.html">Dowload and unpack the source code of Apache Tajo</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../getting_started/building.html">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../getting_started/local_setup.html">Setting up a local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../getting_started/first_query.html">First query execution</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../configuration.html">Configuration</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/preliminary.html">Preliminary</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/cluster_setup.html">Cluster Setup</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/tajo_master_configuration.html">Tajo Master Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/worker_configuration.html">Worker Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/catalog_configuration.html">Catalog Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/configuration_defaults.html">Configuration Defaults</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../cli.html">Tajo Shell (TSQL)</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../cli.html#synopsis">Synopsis</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../cli.html#entering-tsql-shell">Entering tsql shell</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../cli.html#meta-commands">Meta Commands</a></li>
+</ul>
+</li>
+<li class="toctree-l1 current"><a class="reference internal" href="../sql_language.html">SQL Language</a><ul class="current">
+<li class="toctree-l2"><a class="reference internal" href="data_model.html">Data Model</a></li>
+<li class="toctree-l2 current"><a class="current reference internal" href="">Data Definition Language</a></li>
+<li class="toctree-l2"><a class="reference internal" href="insert.html">INSERT (OVERWRITE) INTO</a></li>
+<li class="toctree-l2"><a class="reference internal" href="queries.html">Queries</a></li>
+<li class="toctree-l2"><a class="reference internal" href="sql_expression.html">SQL Expressions</a></li>
+<li class="toctree-l2"><a class="reference internal" href="predicates.html">Predicates</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../functions.html">Functions</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../functions/math_func_and_operators.html">Math Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../functions/string_func_and_operators.html">String Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../functions/network_func_and_operators.html">Network Functions and Operators</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../table_partitioning.html">Table Partitioning</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../partitioning/intro_to_partitioning.html">Introduction to Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../partitioning/column_partitioning.html">Column Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../partitioning/range_partitioning.html">Range Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../partitioning/hash_partitioning.html">Hash Partitioning</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../backup_and_restore.html">Backup and Restore</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../backup_and_restore/catalog.html">Backup and Restore Catalog</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../hcatalog_integration.html">HCatalog Integration</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#appendix">Appendix</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../tajo_client_api.html">Tajo Client API</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../faq.html">FAQ</a></li>
+</ul>
+
+
+ </div>
+
+ </nav>
+
+ <section data-toggle="wy-nav-shift" class="wy-nav-content-wrap">
+
+
+ <nav class="wy-nav-top" role="navigation" aria-label="top navigation">
+ <i data-toggle="wy-nav-top" class="fa fa-bars"></i>
+ <a href="../index.html">Apache Tajo</a>
+ </nav>
+
+
+
+ <div class="wy-nav-content">
+ <div class="rst-content">
+ <div role="navigation" aria-label="breadcrumbs navigation">
+ <ul class="wy-breadcrumbs">
+ <li><a href="../index.html">Docs</a> »</li>
+
+ <li><a href="../sql_language.html">SQL Language</a> »</li>
+
+ <li>Data Definition Language</li>
+ <li class="wy-breadcrumbs-aside">
+
+ <a href="../_sources/sql_language/ddl.txt" rel="nofollow"> View page source</a>
+
+ </li>
+ </ul>
+ <hr/>
+</div>
+ <div role="main">
+
+ <div class="section" id="data-definition-language">
+<h1>Data Definition Language<a class="headerlink" href="#data-definition-language" title="Permalink to this headline">¶</a></h1>
+<div class="section" id="create-database">
+<h2>CREATE DATABASE<a class="headerlink" href="#create-database" title="Permalink to this headline">¶</a></h2>
+<p><em>Synopsis</em></p>
+<div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">DATABASE</span> <span class="p">[</span><span class="n">IF</span> <span class="k">NOT</span> <span class="k">EXISTS</span><span class="p">]</span> <span class="o"><</span><span class="n">database_name</span><span class="o">></span>
+</pre></div>
+</div>
+<p><tt class="docutils literal"><span class="pre">IF</span> <span class="pre">NOT</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">CREATE</span> <span class="pre">DATABASE</span></tt> statement to avoid an error which occurs when the database exists.</p>
+</div>
+<div class="section" id="drop-database">
+<h2>DROP DATABASE<a class="headerlink" href="#drop-database" title="Permalink to this headline">¶</a></h2>
+<p><em>Synopsis</em></p>
+<div class="highlight-sql"><div class="highlight"><pre><span class="k">DROP</span> <span class="k">DATABASE</span> <span class="p">[</span><span class="n">IF</span> <span class="k">EXISTS</span><span class="p">]</span> <span class="o"><</span><span class="n">database_name</span><span class="o">></span>
+</pre></div>
+</div>
+<p><tt class="docutils literal"><span class="pre">IF</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">DATABASE</span></tt> statement to avoid an error which occurs when the database does not exist.</p>
+</div>
+<div class="section" id="create-table">
+<h2>CREATE TABLE<a class="headerlink" href="#create-table" title="Permalink to this headline">¶</a></h2>
+<p><em>Synopsis</em></p>
+<div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="p">[</span><span class="n">IF</span> <span class="k">NOT</span> <span class="k">EXISTS</span><span class="p">]</span> <span class="o"><</span><span class="k">table_name</span><span class="o">></span> <span class="p">[(</span><span class="o"><</span><span class="k">column_name</span><span class="o">></span> <span class="o"><</span><span class="n">data_type</span><span class="o">></span><span class="p">,</span> <span class="p">...</span> <span class="p">)]</span>
+<span class="p">[</span><span class="k">using</span> <span class="o"><</span><span class="n">storage_type</span><span class="o">></span> <span class="p">[</span><span class="k">with</span> <span class="p">(</span><span class="o"><</span><span class="k">key</span><span class="o">></span> <span class="o">=</span> <span class="o"><</span><span class="n">value</span><span class="o">></span><span class="p">,</span> <span class="p">...)]]</span> <span class="p">[</span><span class="k">AS</span> <span class="o"><</span><span class="n">select_statement</span><span class="o">></span><span class="p">]</span>
+
+<span class="k">CREATE</span> <span class="k">EXTERNAL</span> <span class="k">TABLE</span> <span class="p">[</span><span class="n">IF</span> <span class="k">NOT</span> <span class="k">EXISTS</span><span class="p">]</span> <span class="o"><</span><span class="k">table_name</span><span class="o">></span> <span class="p">(</span><span class="o"><</span><span class="k">column_name</span><span class="o">></span> <span class="o"><</span><span class="n">data_type</span><span class="o">></span><span class="p">,</span> <span class="p">...</span> <span class="p">)</span>
+<span class="k">using</span> <span class="o"><</span><span class="n">storage_type</span><span class="o">></span> <span class="p">[</span><span class="k">with</span> <span class="p">(</span><span class="o"><</span><span class="k">key</span><span class="o">></span> <span class="o">=</span> <span class="o"><</span><span class="n">value</span><span class="o">></span><span class="p">,</span> <span class="p">...)]</span> <span class="k">LOCATION</span> <span class="s1">'<path>'</span>
+</pre></div>
+</div>
+<p><tt class="docutils literal"><span class="pre">IF</span> <span class="pre">NOT</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">CREATE</span> <span class="pre">[EXTERNAL]</span> <span class="pre">TABLE</span></tt> statement to avoid an error which occurs when the table does not exist.</p>
+<div class="section" id="compression">
+<h3>Compression<a class="headerlink" href="#compression" title="Permalink to this headline">¶</a></h3>
+<p>If you want to add an external table that contains compressed data, you should give ‘compression.code’ parameter to CREATE TABLE statement.</p>
+<div class="highlight-sql"><div class="highlight"><pre><span class="k">create</span> <span class="k">EXTERNAL</span> <span class="k">table</span> <span class="n">lineitem</span> <span class="p">(</span>
+<span class="n">L_ORDERKEY</span> <span class="nb">bigint</span><span class="p">,</span>
+<span class="n">L_PARTKEY</span> <span class="nb">bigint</span><span class="p">,</span>
+<span class="p">...</span>
+<span class="n">L_COMMENT</span> <span class="nb">text</span><span class="p">)</span>
+
+<span class="k">USING</span> <span class="n">csv</span> <span class="k">WITH</span> <span class="p">(</span><span class="s1">'csvfile.delimiter'</span><span class="o">=</span><span class="s1">'|'</span><span class="p">,</span><span class="s1">'compression.codec'</span><span class="o">=</span><span class="s1">'org.apache.hadoop.io.compress.DeflateCodec'</span><span class="p">)</span>
+<span class="k">LOCATION</span> <span class="s1">'hdfs://localhost:9010/tajo/warehouse/lineitem_100_snappy'</span><span class="p">;</span>
+</pre></div>
+</div>
+<dl class="docutils">
+<dt><cite>compression.codec</cite> parameter can have one of the following compression codecs:</dt>
+<dd><ul class="first last simple">
+<li>org.apache.hadoop.io.compress.BZip2Codec</li>
+<li>org.apache.hadoop.io.compress.DeflateCodec</li>
+<li>org.apache.hadoop.io.compress.GzipCodec</li>
+<li>org.apache.hadoop.io.compress.SnappyCodec</li>
+</ul>
+</dd>
+</dl>
+</div>
+</div>
+<div class="section" id="drop-table">
+<h2>DROP TABLE<a class="headerlink" href="#drop-table" title="Permalink to this headline">¶</a></h2>
+<p><em>Synopsis</em></p>
+<div class="highlight-sql"><div class="highlight"><pre><span class="k">DROP</span> <span class="k">TABLE</span> <span class="p">[</span><span class="n">IF</span> <span class="k">EXISTS</span><span class="p">]</span> <span class="o"><</span><span class="k">table_name</span><span class="o">></span> <span class="p">[</span><span class="n">PURGE</span><span class="p">]</span>
+</pre></div>
+</div>
+<p><tt class="docutils literal"><span class="pre">IF</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">DATABASE</span></tt> statement to avoid an error which occurs when the database does not exist. <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></tt> statement removes a table from Tajo catalog, but it does not remove the contents. If <tt class="docutils literal"><span class="pre">PURGE</span></tt> option is given, <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></tt> statement will eliminate the entry in the catalog as well as the contents.</p>
+</div>
+</div>
+
+
+ </div>
+ <footer>
+
+ <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
+
+ <a href="insert.html" class="btn btn-neutral float-right" title="INSERT (OVERWRITE) INTO"/>Next <span class="fa fa-arrow-circle-right"></span></a>
+
+
+ <a href="data_model.html" class="btn btn-neutral" title="Data Model"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+
+ </div>
+
+
+ <hr/>
+
+ <div role="contentinfo">
+ <p>
+ © Copyright 2014, Apache Tajo Team.
+ </p>
+ </div>
+
+ <a href="https://github.com/snide/sphinx_rtd_theme">Sphinx theme</a> provided by <a href="https://readthedocs.org">Read the Docs</a>
+</footer>
+ </div>
+ </div>
+
+ </section>
+
+ </div>
+
+
+
+
+
+ <script type="text/javascript">
+ var DOCUMENTATION_OPTIONS = {
+ URL_ROOT:'../',
+ VERSION:'0.8.0',
+ COLLAPSE_INDEX:false,
+ FILE_SUFFIX:'.html',
+ HAS_SOURCE: true
+ };
+ </script>
+ <script type="text/javascript" src="../_static/jquery.js"></script>
+ <script type="text/javascript" src="../_static/underscore.js"></script>
+ <script type="text/javascript" src="../_static/doctools.js"></script>
+
+
+
+
+
+ <script type="text/javascript" src="../_static/js/theme.js"></script>
+
+
+
+
+ <script type="text/javascript">
+ jQuery(function () {
+ SphinxRtdTheme.StickyNav.enable();
+ });
+ </script>
+
+
+</body>
+</html>
\ No newline at end of file
Added: tajo/site/docs/current/sql_language/insert.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/current/sql_language/insert.html?rev=1583596&view=auto
==============================================================================
--- tajo/site/docs/current/sql_language/insert.html (added)
+++ tajo/site/docs/current/sql_language/insert.html Tue Apr 1 10:22:23 2014
@@ -0,0 +1,253 @@
+
+
+<!DOCTYPE html>
+<!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
+<!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
+<head>
+ <meta charset="utf-8">
+ <meta name="viewport" content="width=device-width, initial-scale=1.0">
+
+ <title>INSERT (OVERWRITE) INTO — Apache Tajo 0.8.0 documentation</title>
+
+
+
+
+
+
+ <link href='https://fonts.googleapis.com/css?family=Lato:400,700|Roboto+Slab:400,700|Inconsolata:400,700' rel='stylesheet' type='text/css'>
+
+
+
+
+
+
+
+
+
+ <link rel="stylesheet" href="../_static/css/theme.css" type="text/css" />
+
+
+
+ <link rel="top" title="Apache Tajo 0.8.0 documentation" href="../index.html"/>
+ <link rel="up" title="SQL Language" href="../sql_language.html"/>
+ <link rel="next" title="Queries" href="queries.html"/>
+ <link rel="prev" title="Data Definition Language" href="ddl.html"/>
+
+
+ <script src="https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js"></script>
+
+</head>
+
+<body class="wy-body-for-nav" role="document">
+
+ <div class="wy-grid-for-nav">
+
+
+ <nav data-toggle="wy-nav-shift" class="wy-nav-side">
+ <div class="wy-side-nav-search">
+ <a href="../index.html" class="fa fa-home"> Apache Tajo</a>
+ <div role="search">
+ <form id ="rtd-search-form" class="wy-form" action="../search.html" method="get">
+ <input type="text" name="q" placeholder="Search docs" />
+ <input type="hidden" name="check_keywords" value="yes" />
+ <input type="hidden" name="area" value="default" />
+ </form>
+</div>
+ </div>
+
+ <div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation" aria-label="main navigation">
+
+
+ <ul class="current">
+<li class="toctree-l1"><a class="reference internal" href="../introduction.html">Introduction</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../getting_started.html">Getting Started</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../getting_started/prerequisites.html">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../getting_started/downloading_source.html">Dowload and unpack the source code of Apache Tajo</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../getting_started/building.html">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../getting_started/local_setup.html">Setting up a local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../getting_started/first_query.html">First query execution</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../configuration.html">Configuration</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/preliminary.html">Preliminary</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/cluster_setup.html">Cluster Setup</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/tajo_master_configuration.html">Tajo Master Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/worker_configuration.html">Worker Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/catalog_configuration.html">Catalog Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../configuration/configuration_defaults.html">Configuration Defaults</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../cli.html">Tajo Shell (TSQL)</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../cli.html#synopsis">Synopsis</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../cli.html#entering-tsql-shell">Entering tsql shell</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../cli.html#meta-commands">Meta Commands</a></li>
+</ul>
+</li>
+<li class="toctree-l1 current"><a class="reference internal" href="../sql_language.html">SQL Language</a><ul class="current">
+<li class="toctree-l2"><a class="reference internal" href="data_model.html">Data Model</a></li>
+<li class="toctree-l2"><a class="reference internal" href="ddl.html">Data Definition Language</a></li>
+<li class="toctree-l2 current"><a class="current reference internal" href="">INSERT (OVERWRITE) INTO</a></li>
+<li class="toctree-l2"><a class="reference internal" href="queries.html">Queries</a></li>
+<li class="toctree-l2"><a class="reference internal" href="sql_expression.html">SQL Expressions</a></li>
+<li class="toctree-l2"><a class="reference internal" href="predicates.html">Predicates</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../functions.html">Functions</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../functions/math_func_and_operators.html">Math Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../functions/string_func_and_operators.html">String Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../functions/network_func_and_operators.html">Network Functions and Operators</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../table_management.html">Table Management</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../table_management/file_formats.html">File Formats</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../table_management/compression.html">Compression</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../table_partitioning.html">Table Partitioning</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../partitioning/intro_to_partitioning.html">Introduction to Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../partitioning/column_partitioning.html">Column Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../partitioning/range_partitioning.html">Range Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../partitioning/hash_partitioning.html">Hash Partitioning</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../backup_and_restore.html">Backup and Restore</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../backup_and_restore/catalog.html">Backup and Restore Catalog</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../hcatalog_integration.html">HCatalog Integration</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#appendix">Appendix</a></li>
+<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#faq">FAQ</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../tajo_client_api.html">Tajo Client API</a></li>
+<li class="toctree-l1"><a class="reference internal" href="../faq.html">FAQ</a></li>
+</ul>
+
+
+ </div>
+
+ </nav>
+
+ <section data-toggle="wy-nav-shift" class="wy-nav-content-wrap">
+
+
+ <nav class="wy-nav-top" role="navigation" aria-label="top navigation">
+ <i data-toggle="wy-nav-top" class="fa fa-bars"></i>
+ <a href="../index.html">Apache Tajo</a>
+ </nav>
+
+
+
+ <div class="wy-nav-content">
+ <div class="rst-content">
+ <div role="navigation" aria-label="breadcrumbs navigation">
+ <ul class="wy-breadcrumbs">
+ <li><a href="../index.html">Docs</a> »</li>
+
+ <li><a href="../sql_language.html">SQL Language</a> »</li>
+
+ <li>INSERT (OVERWRITE) INTO</li>
+ <li class="wy-breadcrumbs-aside">
+
+ <a href="../_sources/sql_language/insert.txt" rel="nofollow"> View page source</a>
+
+ </li>
+ </ul>
+ <hr/>
+</div>
+ <div role="main">
+
+ <div class="section" id="insert-overwrite-into">
+<h1>INSERT (OVERWRITE) INTO<a class="headerlink" href="#insert-overwrite-into" title="Permalink to this headline">¶</a></h1>
+<p>INSERT OVERWRITE statement overwrites a table data of an existing table or a data in a given directory. Tajo’s INSERT OVERWRITE statement follows <tt class="docutils literal"><span class="pre">INSERT</span> <span class="pre">INTO</span> <span class="pre">SELECT</span></tt> statement of SQL. The examples are as follows:</p>
+<div class="highlight-sql"><div class="highlight"><pre><span class="k">create</span> <span class="k">table</span> <span class="n">t1</span> <span class="p">(</span><span class="n">col1</span> <span class="nb">int8</span><span class="p">,</span> <span class="n">col2</span> <span class="n">int4</span><span class="p">,</span> <span class="n">col3</span> <span class="n">float8</span><span class="p">);</span>
+
+<span class="c1">-- when a target table schema and output schema are equivalent to each other</span>
+<span class="k">INSERT</span> <span class="n">OVERWRITE</span> <span class="k">INTO</span> <span class="n">t1</span> <span class="k">SELECT</span> <span class="n">l_orderkey</span><span class="p">,</span> <span class="n">l_partkey</span><span class="p">,</span> <span class="n">l_quantity</span> <span class="k">FROM</span> <span class="n">lineitem</span><span class="p">;</span>
+<span class="c1">-- or</span>
+<span class="k">INSERT</span> <span class="n">OVERWRITE</span> <span class="k">INTO</span> <span class="n">t1</span> <span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">lineitem</span><span class="p">;</span>
+
+<span class="c1">-- when the output schema are smaller than the target table schema</span>
+<span class="k">INSERT</span> <span class="n">OVERWRITE</span> <span class="k">INTO</span> <span class="n">t1</span> <span class="k">SELECT</span> <span class="n">l_orderkey</span> <span class="k">FROM</span> <span class="n">lineitem</span><span class="p">;</span>
+
+<span class="c1">-- when you want to specify certain target columns</span>
+<span class="k">INSERT</span> <span class="n">OVERWRITE</span> <span class="k">INTO</span> <span class="n">t1</span> <span class="p">(</span><span class="n">col1</span><span class="p">,</span> <span class="n">col3</span><span class="p">)</span> <span class="k">SELECT</span> <span class="n">l_orderkey</span><span class="p">,</span> <span class="n">l_quantity</span> <span class="k">FROM</span> <span class="n">lineitem</span><span class="p">;</span>
+</pre></div>
+</div>
+<p>In addition, INSERT OVERWRITE statement overwrites table data as well as a specific directory.</p>
+<div class="highlight-sql"><div class="highlight"><pre><span class="k">INSERT</span> <span class="n">OVERWRITE</span> <span class="k">INTO</span> <span class="k">LOCATION</span> <span class="s1">'/dir/subdir'</span> <span class="k">SELECT</span> <span class="n">l_orderkey</span><span class="p">,</span> <span class="n">l_quantity</span> <span class="k">FROM</span> <span class="n">lineitem</span><span class="p">;</span>
+</pre></div>
+</div>
+</div>
+
+
+ </div>
+ <footer>
+
+ <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
+
+ <a href="queries.html" class="btn btn-neutral float-right" title="Queries"/>Next <span class="fa fa-arrow-circle-right"></span></a>
+
+
+ <a href="ddl.html" class="btn btn-neutral" title="Data Definition Language"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+
+ </div>
+
+
+ <hr/>
+
+ <div role="contentinfo">
+ <p>
+ © Copyright 2014, Apache Tajo Team.
+ </p>
+ </div>
+
+ <a href="https://github.com/snide/sphinx_rtd_theme">Sphinx theme</a> provided by <a href="https://readthedocs.org">Read the Docs</a>
+</footer>
+ </div>
+ </div>
+
+ </section>
+
+ </div>
+
+
+
+
+
+ <script type="text/javascript">
+ var DOCUMENTATION_OPTIONS = {
+ URL_ROOT:'../',
+ VERSION:'0.8.0',
+ COLLAPSE_INDEX:false,
+ FILE_SUFFIX:'.html',
+ HAS_SOURCE: true
+ };
+ </script>
+ <script type="text/javascript" src="../_static/jquery.js"></script>
+ <script type="text/javascript" src="../_static/underscore.js"></script>
+ <script type="text/javascript" src="../_static/doctools.js"></script>
+
+
+
+
+
+ <script type="text/javascript" src="../_static/js/theme.js"></script>
+
+
+
+
+ <script type="text/javascript">
+ jQuery(function () {
+ SphinxRtdTheme.StickyNav.enable();
+ });
+ </script>
+
+
+</body>
+</html>
\ No newline at end of file