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/03/05 09:14:36 UTC
svn commit: r1574393 [11/13] - in /incubator/tajo/site: ./ docs/ docs/0.8.0/
docs/0.8.0/_sources/ docs/0.8.0/_sources/backup_and_restore/
docs/0.8.0/_sources/configuration/ docs/0.8.0/_sources/functions/
docs/0.8.0/_sources/getting_started/ docs/0.8.0/...
Added: incubator/tajo/site/docs/0.8.0/search.html
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/search.html?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/search.html (added)
+++ incubator/tajo/site/docs/0.8.0/search.html Wed Mar 5 08:14:33 2014
@@ -0,0 +1,203 @@
+
+
+<!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>Search — 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'>
+
+
+
+
+ <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/searchtools.js"></script>
+
+
+
+
+
+
+
+ <link rel="stylesheet" href="_static/css/theme.css" type="text/css" />
+ <script type="text/javascript" src="_static/js/theme.js"></script>
+
+
+
+ <link rel="top" title="Apache Tajo 0.8.0 documentation" href="index.html"/>
+ <script type="text/javascript">
+ jQuery(function() { Search.loadIndex("searchindex.js"); });
+ </script>
+
+ <script type="text/javascript" id="searchindexloader"></script>
+
+
+
+ <script src="//cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js"></script>
+
+</head>
+
+<body class="wy-body-for-nav">
+
+ <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="icon icon-home"> Apache Tajo</a>
+ <form class="wy-form" action="#" 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 class="wy-menu wy-menu-vertical" data-spy="affix">
+
+
+ <ul>
+<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">Tajo run modes: Standalone and Distributed</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">Command Line Interface (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>
+<li class="toctree-l2"><a class="reference internal" href="cli.html#examples">Examples</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="sql_language.html">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>
+</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>
+</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">
+ <i data-toggle="wy-nav-top" class="icon icon-reorder"></i>
+ <a href="/">Apache Tajo</a>
+ </nav>
+
+
+
+ <div class="wy-nav-content">
+ <div class="rst-content">
+ <ul class="wy-breadcrumbs">
+ <li><a href="index.html">Docs</a> »</li>
+ <li><a href=""></a></li>
+
+</ul>
+<hr/>
+
+
+ <noscript>
+ <div id="fallback" class="admonition warning">
+ <p class="last">
+ Please activate JavaScript to enable the search
+ functionality.
+ </p>
+ </div>
+ </noscript>
+
+
+ <div id="search-results">
+
+ </div>
+
+ <footer>
+
+
+ <hr/>
+
+ <p>
+ © Copyright 2014, Apache Tajo Team.
+ </p>
+
+ <a href="https://www.github.com/snide/sphinx_rtd_theme">Sphinx theme</a> provided by <a href="http://readthedocs.org">Read the Docs</a>
+</footer>
+ </div>
+ </div>
+
+ </section>
+
+ </div>
+
+
+</body>
+</html>
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/searchindex.js
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/searchindex.js?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/searchindex.js (added)
+++ incubator/tajo/site/docs/0.8.0/searchindex.js Wed Mar 5 08:14:33 2014
@@ -0,0 +1 @@
+Search.setIndex({envversion:42,terms:{all:[10,2,4,5,38,29],code:[16,37],dist:[12,37],c_name:29,queri:[10,6,16],column_refer:5,mno:38,follow:[20,19,9,10,38,23,12,25,5,37,15,27,29,6],disk:6,row:[38,5,10],depend:5,c_acctbal:29,zone:27,decim:27,backupandrestor:10,init:38,program:20,"case":[20,5,37,30],digit:27,sourc:[10,37,16],string:[8,20],fals:[27,5],csvfile:[25,38],volum:[10,38],veri:5,affect:6,exact:27,list:[7,15,5,38,10],hive:37,"try":10,item:5,adjust:[19,6],form:19,small:27,tajo_src:12,tajo_hom:[20,2,10,37,38],dir:9,pleas:[29,6,38],upper:30,templet:20,smaller:9,ten:16,sign:5,dowload:16,second:[30,37],cost:11,design:[11,20],download:15,val2:5,val1:5,submit:16,click:15,tmpdir:6,compat:6,index:7,abc:[5,38],addr:37,compar:27,hdf:[19,10,11,25,38,16],section:[16,6],char_length:30,c_phone:29,version:[10,37],directori:[20,37],supplier:10,method:[7,29],hash:7,valn:5,gener:10,o_totalpric:10,here:5,address:[27,35,37],path:[19,10,25,37,38,29],o_orderprior:10,strong:29,valu:[20,19,37,6],search
:7,aaabc:5,derbi:37,current:[19,37,5,6,10],table_backup:29,precis:27,datetim:8,codebas:15,chang:[37,15],via:16,prerequisit:[16,12],data_typ:25,jar:37,modul:[7,20],filenam:10,api:7,namenode_hostnam:19,wip:[37,15],instal:12,total:6,unit:37,from:[7,9,30,38,5,15,29],describ:10,would:12,memori:37,distinct:4,two:[40,5,20,29],connector:37,few:20,call:7,usr:37,type:[7,30,20,38,29,6,10],more:[37,38,5,6,16],discompress:12,claus:[7,38,5,27],hurt:11,trail:30,git:37,unpack:16,must:[27,19,37],alia:[27,4,30],prepar:[12,37,38],work:27,timestamptz:27,cat:[29,38],archiv:[12,37],can:[20,2,25,5,37,15,12,6,38],purpos:20,def:38,bewtween:27,tar:[12,37,15],give:[25,6],process:[11,10],backslash:10,templat:37,liter:20,want:[20,19,9,10,2,25,37,38,29,6],tcp:10,ratio:6,concatnen:30,end:[30,15],goal:11,quot:10,anoth:40,str1:30,how:[7,2,16,6],env:37,c_address:29,instead:[38,5,10],csv:[38,25,10,29],simpl:38,map:27,ltrim:30,clone:[37,15],after:[2,12],catalog:1,date:[27,29],multipl:6,underscor:5,tajo_worker_heaps:6,
github:15,third:37,host:[10,37],predic:[7,39],inform:[10,37],environ:[19,2,20,6],allow:[19,6],str2:30,worst:11,ghi:38,help:10,move:12,vari:27,dynam:11,paramet:[25,30],smallint:27,style:5,group:[4,5],persist:37,main:[11,5,20],"float":[27,6,38],"return":[5,30],thei:5,timestamp:27,col2:[9,5],col3:9,nation:10,now:[10,12,29],nor:5,introduct:7,workload:6,name:[20,19,10,35,4,37,38,27,29,6],anyth:10,config:[20,35,37,6],drop:7,regexp_replac:30,instruct:15,mode:[28,37],each:20,unicod:27,compatibl:29,side:30,mean:5,compil:[12,37],domain:5,replac:30,procedur:12,connect:[10,37],o_clerk:10,out:[6,15],variabl:[19,20,2,37,27,6],unquot:10,space:30,o_orderkei:10,xxtajo:30,content:7,hivemetastor:37,determin:6,math:8,shut:16,advanc:11,given:[9,30,5,38,27,10],standard:[11,27,5],asc:4,standalon:28,base:[37,11,15,5,20,38],asf:[37,15],org:[25,10,37,15],"byte":[27,10,38],decompress:15,launch:[2,37],filter:5,length:27,licens:10,mvn:[12,37],first:[30,20,16,37,12],oper:8,rang:[7,23],resourceconfigur:6,querylan
guag:10,arrai:5,number:10,system:[11,20,12,6],mai:20,o_orderd:10,done:12,overwrit:[7,39],tpch:[10,29],open:11,primari:19,differ:5,script:[12,20],interact:[11,2,10],mkdir:38,capac:6,least:5,master:[28,10,37],statement:[25,38,9,5,10],l_partkei:[25,9],scheme:[19,38],"final":[37,38],store:[11,38,10,6,37],schema:[9,10,38],mysql_jdbc_driv:37,incub:[37,15],option:[10,12,29],especi:27,copi:[20,37],inexact:27,specifi:[19,9,10,5,37,27,40,6],part:10,rtrim:30,exactli:5,than:[9,5,16],target:[9,12,37],provid:[11,23,5,6,37],remov:30,tree:12,zero:5,charact:[27,5,30],project:11,l_orderkei:[25,9],balanc:11,float8:[27,9,10,29],minut:16,ran:37,ani:5,packag:[12,37],have:[25,19,4,37,15],tabl:[29,38,10,16],need:[2,29,37,38],element:20,techniqu:11,lib:37,partsupp:10,port:[19,10,37],note:[5,37],also:[38,5,15],without:11,build:[16,37],which:[11,2,10,37],singl:5,begin:10,c_nationkei:29,distribut:[28,37],preliminari:28,buffer:17,filesystem:[16,15],compress:7,deflatecodec:25,most:37,regular:30,plan:11,pair:20,m
etacharact:5,"class":[5,37],don:[29,20],url:19,later:16,request:6,uri:37,order:[10,11,4,38,27,6],bracket:5,snapshot:[12,37],clean:[12,37],pattern:[7,30],querymast:6,show:[38,10,16],text:[7,10,25,5,38,27,29,30],syntax:40,xml:[10,37],absolut:38,onli:[19,20,37,15],explicitli:20,locat:[25,9,29,6,38],just:[5,37,29],copyright:10,explain:16,configur:10,apach:[10,37,16],enough:37,should:[19,10,16,25,37,38,29,6],l_quantiti:9,local:[37,16,6,15],info:35,get:37,express:[7,30,39],repo:[37,15],java_hom:2,progress:11,requir:2,borrow:5,"default":[28,10,37],integr:37,partit:7,contain:25,where:[7,38,5,6,27],setup:16,bytea:27,wiki:10,set:[19,37,20,16,6,10],memstor:37,see:[37,6,38],num:10,sec:38,result:38,respons:[11,38],float4:27,rlike:5,concern:[29,20],parent:12,correctli:27,ieee:27,state:38,score:38,subdir:9,between:5,"\u02c6ab":30,posix:5,neither:5,approach:29,c_custkei:29,altern:5,accord:27,kei:7,hadoop_hom:2,outfil:29,toler:11,addit:[9,5,6],both:[11,30],last:4,delimit:[25,30,38],fault:11,region:1
0,gzipcodec:25,c_comment:29,groupbi:7,against:16,instanc:[19,16],logic:5,mani:6,whole:6,load:[11,38],simpli:12,overview:7,"4028235e":27,split_part:30,rpc:35,respect:[27,5],guid:10,assum:6,quit:10,xzvf:[12,15],o_com:10,due:6,much:6,basic:[11,29],c_mktsegment:29,pdist:[12,37],derbystor:37,xxx:10,worker:28,convert:40,repetit:5,present:16,emploi:11,look:[10,15],implementaion:19,servic:[35,37],properti:[35,19,20,37,6],batch:11,durat:37,cast:7,table_nam:[25,29],layer:19,larger:27,file:[7,19,26,10,20,38,12,37,15,29,6],ctrl:38,site:[10,37],cluster:[19,16,6,37],itself:10,warehous:[11,25],conf:[19,10,2,20,37,6],abcdef:30,"null":4,develop:15,"35b":38,suggest:15,make:[30,38],shorten:37,hadoop:[11,2,25,5,20,38,17,16],same:5,binari:[27,12,37],split:30,document:[2,10,15],higher:17,varbit:27,lineitem:[25,9,10],http:[35,10,37,15],hostnam:[19,10],optim:11,driver:[7,37],o_orderstatu:10,jkl:38,column_nam:25,dskiptest:[12,37],user:[19,37,6],tajo_classpath:37,extern:[25,29,38],col1:[9,5],tsql:29,implemen
t:[2,10],lower:30,appropri:[20,38],equival:9,well:[27,9],parenthes:5,exampl:29,command:29,thi:[20,38,12,16,5,37,15,29,6],choos:[12,15],model:[7,39],usual:20,protocol:17,execut:[10,6,16],when:9,dtar:[12,37],rest:15,q_1363768615503_0001_000001:38,mysql:37,simultan:6,createdatabaseifnotexist:37,languag:[11,7,10,38],inet4:27,web:11,all_backup:29,easi:29,disk1:6,disk2:6,disk3:6,add:[20,2,25,37,6],other:[11,9,20],blob:27,exercis:16,primit:27,input:30,approxim:27,match:[7,30,27],take:[16,15],bin:[38,2,10,37,29],varchar:27,format:[7,26],read:[2,15],bzip2codec:25,hive_jdbc_driver_dir:37,phcatalog:37,know:38,lineitem_100_snappi:25,bit:27,password:37,desc:4,insert:[7,39],storage_typ:25,table1:[5,38],resid:38,like:[19,12],specif:[27,19,9],substr:30,reoptim:11,integ:[27,6],server:[20,37],query_succeed:38,"boolean":27,necessari:11,either:[27,5,15],output:9,timetz:27,tajo:[28,10,37,29],manag:7,some:[27,12,20,38],tajowork:[20,6],intern:20,"export":[2,37],mirror:15,proper:[19,12,6],home:[2,29,37,38]
,tmp:[19,38],scale:11,lead:30,"512mb":6,avoid:11,definit:[7,39],per:6,select:[7,38,9,5,30],bigint:[27,25],ddl:[29,38],condit:4,localhost:[35,25,10],machin:10,core:6,previou:5,run:[28,10],power:5,xtajoxx:30,ab_bc_cd:30,usag:29,hive_hom:37,step:12,character_length:30,repositori:15,peer:35,java:[37,2,5,20,27,17],rcfile:7,stage:38,comparison:[27,5],postgresql:5,column:7,varbinari:27,page:7,"1gb":[19,6],client:[7,35],lastli:37,three:37,down:[5,16],defaultport:37,storag:[19,29,37],your:[19,20,29,37,15,16,12],jdbc:[7,37],wai:29,support:[27,19,5,37,29],"long":11,custom:[10,37,29],avail:6,start:30,arithmet:7,includ:6,o_custkei:10,ipv4:27,"function":10,snappycodec:25,untar:15,tajoxx:30,l_comment:25,int4:[27,9,10,30],link:15,select_stat:25,int2:27,"true":[27,5,6,37],int8:[27,9,10,29],count:30,consist:20,possibl:6,whether:5,record:5,below:[16,29],limit:6,otherwis:5,trim:30,creat:[7,38,16,37,29],btrim:30,"int":[27,30,38],certain:9,"char":27,exist:[9,10],o_shipprior:10,check:15,denot:5,percent:5,
detail:[37,38],field:30,codec:25,bool:27,varieti:20,test:37,you:[20,19,9,10,2,12,29,25,5,37,15,16,6,38],umbil:35,sequenc:5,insensit:5,tajo_dump:29,tajomast:[20,10,37],algorithm:6,function_nam:40,hyunsik:29,regexp:5,descript:[10,35,5,37,38,27,6],tajo_master_heaps:19,tinyint:27,time:[11,27,5,38],onc:15,backward:6,cpu:6},objtypes:{"0":"py:function"},objnames:{"0":["py","function","Python function"]},filenames:["partitioning/hash_partitioning","backup_and_restore","getting_started/local_setup","partitioning/range_partitioning","sql_language/queries","sql_language/predicates","configuration/worker_configuration","index","functions","sql_language/insert","cli","introduction","getting_started/building","functions/datetime_func_and_operators","partitioning/column_partitioning","getting_started/downloading_source","getting_started","getting_started/prerequisites","functions/math_func_and_operators","configuration/tajo_master_configuration","configuration/preliminary","table_management/compre
ssion","faq","partitioning/intro_to_partitioning","table_partitioning","sql_language/ddl","table_management","sql_language/data_model","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","Range Partitioning","Queries","Predicates","Worker Configuration","Apache Tajo\u2122 0.8.0 (dev) - User documentation","Functions","INSERT (OVERWRITE) INTO","Command Line Interface (TSQL)","Introduction","Build Source Code","DateTime Functions and Operators","Column Partitioning","Dowload and unpack the source code of Apache Tajo","Getting Started","Prerequisites","Math Functions and Operators","Tajo Master Configuration"
,"Preliminary","Compression","FAQ","Introduction to Partitioning","Table Partitioning","Data Definition Language","Table Management","Data Model","Configuration","Backup and Restore Catalog","String Functions and Operators","HCatalog Integration","Tajo JDBC Driver","Tajo run modes: Standalone and Distributed","File Formats","Configuration Defaults","Tajo Client API","Catalog Configuration","First query execution","SQL Language","SQL Expressions"],objects:{"":{trim:[30,0,1,""],upper:[30,0,1,""],lower:[30,0,1,""],ltrim:[30,0,1,""],btrim:[30,0,1,""],regexp_replace:[30,0,1,""],split_part:[30,0,1,""],char_length:[30,0,1,""],rtrim:[30,0,1,""]}},titleterms:{code:[12,15],execut:38,queri:[4,38],hcatalogstor:37,ilik:5,languag:[39,25],xml:20,call:40,configur:[35,19,28,37,6],apach:[7,15],text:34,local:2,match:5,real:27,sourc:[12,15],synopsi:10,string:[5,40,30],format:34,faq:22,introduct:[11,23],insert:9,like:5,level:29,drop:25,list:4,mode:[33,6],partit:[0,24,14,23,3],each:6,where:4,manag:26,set
:2,hcatalog:31,dump:29,dowload:15,meta:10,run:[33,6],todo:[0,18,32,21,31,22,3,13,14,36,34,29],databas:29,definit:25,method:23,math:18,integr:31,hash:0,kei:23,driver:32,standalon:33,git:15,prerequisit:17,mysqlstor:37,releas:15,rcfile:34,valu:27,column:14,tajo:[7,19,32,2,33,35,36,20,15],groupbi:4,datetim:13,backup:[1,29],first:38,oper:[18,30,13],rang:3,via:15,overview:4,tajomast:19,number:[27,6],api:36,select:4,size:[19,6],jdbc:32,from:4,memori:[19,6],data:[27,25,6],doubl:27,overwrit:9,start:16,master:[19,35],interfac:10,type:[27,40],"function":[18,8,30,40,13],shell:10,claus:4,worker:[35,6],rootdir:19,heap:[19,6],line:10,unpack:15,restor:[1,29],"default":35,maximum:6,dev:7,cast:40,similar:5,creat:25,site:20,indic:7,cluster:2,file:34,tabl:[7,24,25,26],dedic:6,get:[32,16,15],how:32,exampl:[10,6],build:12,env:20,document:7,express:[5,40],resourc:6,distribut:33,preliminari:20,enter:10,compress:[21,25],catalog:[20,29,37],regular:5,temporari:6,user:7,sql:[39,29,40],tsql:10,parallel:6,task:6
,directori:6,predic:5,arithmet:40,client:36,command:10,pattern:5,model:27,latest:15}})
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/sql_language.html
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/sql_language.html?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/sql_language.html (added)
+++ incubator/tajo/site/docs/0.8.0/sql_language.html Wed Mar 5 08:14:33 2014
@@ -0,0 +1,207 @@
+
+
+<!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'>
+
+
+
+
+ <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>
+
+
+
+
+
+
+
+ <link rel="stylesheet" href="_static/css/theme.css" type="text/css" />
+ <script type="text/javascript" src="_static/js/theme.js"></script>
+
+
+
+ <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="Command Line Interface (TSQL)" href="cli.html"/>
+
+ <script src="//cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js"></script>
+
+</head>
+
+<body class="wy-body-for-nav">
+
+ <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="icon icon-home"> Apache Tajo</a>
+ <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 class="wy-menu wy-menu-vertical" data-spy="affix">
+
+
+ <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">Tajo run modes: Standalone and Distributed</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">Command Line Interface (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>
+<li class="toctree-l2"><a class="reference internal" href="cli.html#examples">Examples</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>
+</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>
+</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">
+ <i data-toggle="wy-nav-top" class="icon icon-reorder"></i>
+ <a href="/">Apache Tajo</a>
+ </nav>
+
+
+
+ <div class="wy-nav-content">
+ <div class="rst-content">
+ <ul class="wy-breadcrumbs">
+ <li><a href="index.html">Docs</a> »</li>
+ <li><a href="">SQL Language</a></li>
+
+</ul>
+<hr/>
+
+
+ <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>
+
+
+ <footer>
+
+ <div class="rst-footer-buttons">
+
+ <a href="sql_language/data_model.html" class="btn btn-neutral float-right" title="Data Model"/>Next <span class="icon icon-circle-arrow-right"></span></a>
+
+
+ <a href="cli.html" class="btn btn-neutral" title="Command Line Interface (TSQL)"><span class="icon icon-circle-arrow-left"></span> Previous</a>
+
+ </div>
+
+
+ <hr/>
+
+ <p>
+ © Copyright 2014, Apache Tajo Team.
+ </p>
+
+ <a href="https://www.github.com/snide/sphinx_rtd_theme">Sphinx theme</a> provided by <a href="http://readthedocs.org">Read the Docs</a>
+</footer>
+ </div>
+ </div>
+
+ </section>
+
+ </div>
+
+
+</body>
+</html>
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/sql_language/data_model.html
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/sql_language/data_model.html?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/sql_language/data_model.html (added)
+++ incubator/tajo/site/docs/0.8.0/sql_language/data_model.html Wed Mar 5 08:14:33 2014
@@ -0,0 +1,386 @@
+
+
+<!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'>
+
+
+
+
+ <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>
+
+
+
+
+
+
+
+ <link rel="stylesheet" href="../_static/css/theme.css" type="text/css" />
+ <script type="text/javascript" src="_static/js/theme.js"></script>
+
+
+
+ <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="//cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js"></script>
+
+</head>
+
+<body class="wy-body-for-nav">
+
+ <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="icon icon-home"> Apache Tajo</a>
+ <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 class="wy-menu wy-menu-vertical" data-spy="affix">
+
+
+ <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">Tajo run modes: Standalone and Distributed</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">Command Line Interface (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>
+<li class="toctree-l2"><a class="reference internal" href="../cli.html#examples">Examples</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>
+</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>
+</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">
+ <i data-toggle="wy-nav-top" class="icon icon-reorder"></i>
+ <a href="/">Apache Tajo</a>
+ </nav>
+
+
+
+ <div class="wy-nav-content">
+ <div class="rst-content">
+ <ul class="wy-breadcrumbs">
+ <li><a href="../index.html">Docs</a> »</li>
+ <li><a href="">Data Model</a></li>
+
+</ul>
+<hr/>
+
+
+ <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>
+
+
+ <footer>
+
+ <div class="rst-footer-buttons">
+
+ <a href="ddl.html" class="btn btn-neutral float-right" title="Data Definition Language"/>Next <span class="icon icon-circle-arrow-right"></span></a>
+
+
+ <a href="../sql_language.html" class="btn btn-neutral" title="SQL Language"><span class="icon icon-circle-arrow-left"></span> Previous</a>
+
+ </div>
+
+
+ <hr/>
+
+ <p>
+ © Copyright 2014, Apache Tajo Team.
+ </p>
+
+ <a href="https://www.github.com/snide/sphinx_rtd_theme">Sphinx theme</a> provided by <a href="http://readthedocs.org">Read the Docs</a>
+</footer>
+ </div>
+ </div>
+
+ </section>
+
+ </div>
+
+
+</body>
+</html>
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/sql_language/ddl.html
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/sql_language/ddl.html?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/sql_language/ddl.html (added)
+++ incubator/tajo/site/docs/0.8.0/sql_language/ddl.html Wed Mar 5 08:14:33 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>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'>
+
+
+
+
+ <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>
+
+
+
+
+
+
+
+ <link rel="stylesheet" href="../_static/css/theme.css" type="text/css" />
+ <script type="text/javascript" src="_static/js/theme.js"></script>
+
+
+
+ <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="//cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js"></script>
+
+</head>
+
+<body class="wy-body-for-nav">
+
+ <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="icon icon-home"> Apache Tajo</a>
+ <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 class="wy-menu wy-menu-vertical" data-spy="affix">
+
+
+ <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">Tajo run modes: Standalone and Distributed</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">Command Line Interface (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>
+<li class="toctree-l2"><a class="reference internal" href="../cli.html#examples">Examples</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>
+</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>
+</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">
+ <i data-toggle="wy-nav-top" class="icon icon-reorder"></i>
+ <a href="/">Apache Tajo</a>
+ </nav>
+
+
+
+ <div class="wy-nav-content">
+ <div class="rst-content">
+ <ul class="wy-breadcrumbs">
+ <li><a href="../index.html">Docs</a> »</li>
+ <li><a href="">Data Definition Language</a></li>
+
+</ul>
+<hr/>
+
+
+ <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-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="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="k">CREATE</span> <span class="k">EXTERNAL</span> <span class="k">TABLE</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>
+<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>
+<div class="highlight-sql"><div class="highlight"><pre><span class="k">DROP</span> <span class="k">TABLE</span> <span class="o"><</span><span class="k">table_name</span><span class="o">></span>
+</pre></div>
+</div>
+</div>
+</div>
+
+
+ <footer>
+
+ <div class="rst-footer-buttons">
+
+ <a href="insert.html" class="btn btn-neutral float-right" title="INSERT (OVERWRITE) INTO"/>Next <span class="icon icon-circle-arrow-right"></span></a>
+
+
+ <a href="data_model.html" class="btn btn-neutral" title="Data Model"><span class="icon icon-circle-arrow-left"></span> Previous</a>
+
+ </div>
+
+
+ <hr/>
+
+ <p>
+ © Copyright 2014, Apache Tajo Team.
+ </p>
+
+ <a href="https://www.github.com/snide/sphinx_rtd_theme">Sphinx theme</a> provided by <a href="http://readthedocs.org">Read the Docs</a>
+</footer>
+ </div>
+ </div>
+
+ </section>
+
+ </div>
+
+
+</body>
+</html>
\ No newline at end of file
Added: incubator/tajo/site/docs/0.8.0/sql_language/insert.html
URL: http://svn.apache.org/viewvc/incubator/tajo/site/docs/0.8.0/sql_language/insert.html?rev=1574393&view=auto
==============================================================================
--- incubator/tajo/site/docs/0.8.0/sql_language/insert.html (added)
+++ incubator/tajo/site/docs/0.8.0/sql_language/insert.html Wed Mar 5 08:14:33 2014
@@ -0,0 +1,217 @@
+
+
+<!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'>
+
+
+
+
+ <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>
+
+
+
+
+
+
+
+ <link rel="stylesheet" href="../_static/css/theme.css" type="text/css" />
+ <script type="text/javascript" src="_static/js/theme.js"></script>
+
+
+
+ <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="//cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js"></script>
+
+</head>
+
+<body class="wy-body-for-nav">
+
+ <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="icon icon-home"> Apache Tajo</a>
+ <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 class="wy-menu wy-menu-vertical" data-spy="affix">
+
+
+ <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">Tajo run modes: Standalone and Distributed</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">Command Line Interface (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>
+<li class="toctree-l2"><a class="reference internal" href="../cli.html#examples">Examples</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>
+</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>
+</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">
+ <i data-toggle="wy-nav-top" class="icon icon-reorder"></i>
+ <a href="/">Apache Tajo</a>
+ </nav>
+
+
+
+ <div class="wy-nav-content">
+ <div class="rst-content">
+ <ul class="wy-breadcrumbs">
+ <li><a href="../index.html">Docs</a> »</li>
+ <li><a href="">INSERT (OVERWRITE) INTO</a></li>
+
+</ul>
+<hr/>
+
+
+ <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>
+
+
+ <footer>
+
+ <div class="rst-footer-buttons">
+
+ <a href="queries.html" class="btn btn-neutral float-right" title="Queries"/>Next <span class="icon icon-circle-arrow-right"></span></a>
+
+
+ <a href="ddl.html" class="btn btn-neutral" title="Data Definition Language"><span class="icon icon-circle-arrow-left"></span> Previous</a>
+
+ </div>
+
+
+ <hr/>
+
+ <p>
+ © Copyright 2014, Apache Tajo Team.
+ </p>
+
+ <a href="https://www.github.com/snide/sphinx_rtd_theme">Sphinx theme</a> provided by <a href="http://readthedocs.org">Read the Docs</a>
+</footer>
+ </div>
+ </div>
+
+ </section>
+
+ </div>
+
+
+</body>
+</html>
\ No newline at end of file