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