Modified: tajo/site/docs/devel/jdbc_driver.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/jdbc_driver.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/jdbc_driver.html (original) +++ tajo/site/docs/devel/jdbc_driver.html Tue Sep 1 06:42:40 2015 @@ -110,7 +110,9 @@ </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.html#built-in-functions">Built-in Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-window-functions">Built-in Window Functions</a></li> <li class="toctree-l2"><a class="reference internal" href="functions.html#user-defined-functions">User-defined Functions</a></li> </ul> </li> @@ -210,11 +212,11 @@ In this section, we explain how to get J <h2>How to get JDBC driver<a class="headerlink" href="#how-to-get-jdbc-driver" title="Permalink to this headline">¶</a></h2> <div class="section" id="direct-download"> <h3>Direct Download<a class="headerlink" href="#direct-download" title="Permalink to this headline">¶</a></h3> -<p>You can directly download a JDBC driver jar file (<code class="docutils literal"><span class="pre">tajo-jdbc-x.y.z.jar</span></code>) from <a class="reference external" href="http://tajo.apache.org/downloads.html";>Downloads</a>.</p> +<p>You can directly download a JDBC driver jar file (<tt class="docutils literal"><span class="pre">tajo-jdbc-x.y.z.jar</span></tt>) from <a class="reference external" href="http://tajo.apache.org/downloads.html";>Downloads</a>.</p> </div> <div class="section" id="from-binary-distribution"> <h3>From Binary Distribution<a class="headerlink" href="#from-binary-distribution" title="Permalink to this headline">¶</a></h3> -<p>Tajo binary distribution provides JDBC jar file located in <code class="docutils literal"><span class="pre">${TAJO_HOME}/share/jdbc-dist/tajo-jdbc-x.y.z.jar</span></code>.</p> +<p>Tajo binary distribution provides JDBC jar file located in <tt class="docutils literal"><span class="pre">${TAJO_HOME}/share/jdbc-dist/tajo-jdbc-x.y.z.jar</span></tt>.</p> </div> <div class="section" id="from-building-source-code"> <h3>From Building Source Code<a class="headerlink" href="#from-building-source-code" title="Permalink to this headline">¶</a></h3> @@ -228,22 +230,22 @@ In this section, we explain how to get J </div> <div class="section" id="setting-the-classpath"> <h2>Setting the CLASSPATH<a class="headerlink" href="#setting-the-classpath" title="Permalink to this headline">¶</a></h2> -<p>In order to use the JDBC driver, you should add <code class="docutils literal"><span class="pre">tajo-jdbc-x.y.z.jar</span></code> in your <code class="docutils literal"><span class="pre">CLASSPATH</span></code>.</p> +<p>In order to use the JDBC driver, you should add <tt class="docutils literal"><span class="pre">tajo-jdbc-x.y.z.jar</span></tt> in your <tt class="docutils literal"><span class="pre">CLASSPATH</span></tt>.</p> <div class="highlight-bash"><div class="highlight"><pre><span class="nv">CLASSPATH</span><span class="o">=</span>path/to/tajo-jdbc-x.y.z.jar:<span class="nv">$CLASSPATH</span> </pre></div> </div> </div> <div class="section" id="an-example-jdbc-client"> <h2>An Example JDBC Client<a class="headerlink" href="#an-example-jdbc-client" title="Permalink to this headline">¶</a></h2> -<p>The JDBC driver class name is <code class="docutils literal"><span class="pre">org.apache.tajo.jdbc.TajoDriver</span></code>. -You can get the driver <code class="docutils literal"><span class="pre">Class.forName("org.apache.tajo.jdbc.TajoDriver")</span></code>. -The connection url should be <code class="docutils literal"><span class="pre">jdbc:tajo://<TajoMaster</span> <span class="pre">hostname>:<TajoMaster</span> <span class="pre">client</span> <span class="pre">rpc</span> <span class="pre">port>/<database</span> <span class="pre">name></span></code>. -The default TajoMaster client rpc port is <code class="docutils literal"><span class="pre">26002</span></code>. +<p>The JDBC driver class name is <tt class="docutils literal"><span class="pre">org.apache.tajo.jdbc.TajoDriver</span></tt>. +You can get the driver <tt class="docutils literal"><span class="pre">Class.forName("org.apache.tajo.jdbc.TajoDriver")</span></tt>. +The connection url should be <tt class="docutils literal"><span class="pre">jdbc:tajo://<TajoMaster</span> <span class="pre">hostname>:<TajoMaster</span> <span class="pre">client</span> <span class="pre">rpc</span> <span class="pre">port>/<database</span> <span class="pre">name></span></tt>. +The default TajoMaster client rpc port is <tt class="docutils literal"><span class="pre">26002</span></tt>. If you want to change the listening port, please refer <a class="reference internal" href="configuration/cluster_setup.html"><em>Cluster Setup</em></a>.</p> <div class="admonition note"> <p class="first admonition-title">Note</p> <p class="last">Currently, Tajo does not support the concept of database and namespace. -All tables are contained in <code class="docutils literal"><span class="pre">default</span></code> database. So, you don’t need to specify any database name.</p> +All tables are contained in <tt class="docutils literal"><span class="pre">default</span></tt> database. So, you don’t need to specify any database name.</p> </div> <p>The following shows an example of JDBC Client.</p> <div class="highlight-java"><div class="highlight"><pre><span class="kn">import</span> <span class="nn">java.sql.Connection</span><span class="o">;</span>
Modified: tajo/site/docs/devel/objects.inv URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/objects.inv?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== Binary files - no diff available. Modified: tajo/site/docs/devel/partitioning/column_partitioning.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/partitioning/column_partitioning.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/partitioning/column_partitioning.html (original) +++ tajo/site/docs/devel/partitioning/column_partitioning.html Tue Sep 1 06:42:40 2015 @@ -111,7 +111,9 @@ </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.html#built-in-functions">Built-in Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-window-functions">Built-in Window Functions</a></li> <li class="toctree-l2"><a class="reference internal" href="../functions.html#user-defined-functions">User-defined Functions</a></li> </ul> </li> @@ -209,15 +211,15 @@ <p>The column table partition is designed to support the partition of Apache Hiveâ¢.</p> <div class="section" id="how-to-create-a-column-partitioned-table"> <h2>How to Create a Column Partitioned Table<a class="headerlink" href="#how-to-create-a-column-partitioned-table" title="Permalink to this headline">¶</a></h2> -<p>You can create a partitioned table by using the <code class="docutils literal"><span class="pre">PARTITION</span> <span class="pre">BY</span></code> clause. For a column partitioned table, you should use -the <code class="docutils literal"><span class="pre">PARTITION</span> <span class="pre">BY</span> <span class="pre">COLUMN</span></code> clause with partition keys.</p> -<p>For example, assume there is a table <code class="docutils literal"><span class="pre">orders</span></code> composed of the following schema.</p> +<p>You can create a partitioned table by using the <tt class="docutils literal"><span class="pre">PARTITION</span> <span class="pre">BY</span></tt> clause. For a column partitioned table, you should use +the <tt class="docutils literal"><span class="pre">PARTITION</span> <span class="pre">BY</span> <span class="pre">COLUMN</span></tt> clause with partition keys.</p> +<p>For example, assume there is a table <tt class="docutils literal"><span class="pre">orders</span></tt> composed of the following schema.</p> <div class="highlight-python"><div class="highlight"><pre>id INT, item_name TEXT, price FLOAT </pre></div> </div> -<p>Also, assume that you want to use <code class="docutils literal"><span class="pre">order_date</span> <span class="pre">TEXT</span></code> and <code class="docutils literal"><span class="pre">ship_date</span> <span class="pre">TEXT</span></code> as the partition keys. +<p>Also, assume that you want to use <tt class="docutils literal"><span class="pre">order_date</span> <span class="pre">TEXT</span></tt> and <tt class="docutils literal"><span class="pre">ship_date</span> <span class="pre">TEXT</span></tt> as the partition keys. Then, you should create a table as follows:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">orders</span> <span class="p">(</span> <span class="n">id</span> <span class="nb">INT</span><span class="p">,</span> @@ -229,15 +231,15 @@ Then, you should create a table as follo </div> <div class="section" id="partition-pruning-on-column-partitioned-tables"> <h2>Partition Pruning on Column Partitioned Tables<a class="headerlink" href="#partition-pruning-on-column-partitioned-tables" title="Permalink to this headline">¶</a></h2> -<p>The following predicates in the <code class="docutils literal"><span class="pre">WHERE</span></code> clause can be used to prune unqualified column partitions without processing +<p>The following predicates in the <tt class="docutils literal"><span class="pre">WHERE</span></tt> clause can be used to prune unqualified column partitions without processing during query planning phase.</p> <ul class="simple"> -<li><code class="docutils literal"><span class="pre">=</span></code></li> -<li><code class="docutils literal"><span class="pre"><></span></code></li> -<li><code class="docutils literal"><span class="pre">></span></code></li> -<li><code class="docutils literal"><span class="pre"><</span></code></li> -<li><code class="docutils literal"><span class="pre">>=</span></code></li> -<li><code class="docutils literal"><span class="pre"><=</span></code></li> +<li><tt class="docutils literal"><span class="pre">=</span></tt></li> +<li><tt class="docutils literal"><span class="pre"><></span></tt></li> +<li><tt class="docutils literal"><span class="pre">></span></tt></li> +<li><tt class="docutils literal"><span class="pre"><</span></tt></li> +<li><tt class="docutils literal"><span class="pre">>=</span></tt></li> +<li><tt class="docutils literal"><span class="pre"><=</span></tt></li> <li>LIKE predicates with a leading wild-card character</li> <li>IN list predicates</li> </ul> Modified: tajo/site/docs/devel/partitioning/hash_partitioning.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/partitioning/hash_partitioning.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/partitioning/hash_partitioning.html (original) +++ tajo/site/docs/devel/partitioning/hash_partitioning.html Tue Sep 1 06:42:40 2015 @@ -111,7 +111,9 @@ </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.html#built-in-functions">Built-in Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-window-functions">Built-in Window Functions</a></li> <li class="toctree-l2"><a class="reference internal" href="../functions.html#user-defined-functions">User-defined Functions</a></li> </ul> </li> Modified: tajo/site/docs/devel/partitioning/intro_to_partitioning.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/partitioning/intro_to_partitioning.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/partitioning/intro_to_partitioning.html (original) +++ tajo/site/docs/devel/partitioning/intro_to_partitioning.html Tue Sep 1 06:42:40 2015 @@ -111,7 +111,9 @@ </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.html#built-in-functions">Built-in Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-window-functions">Built-in Window Functions</a></li> <li class="toctree-l2"><a class="reference internal" href="../functions.html#user-defined-functions">User-defined Functions</a></li> </ul> </li> Modified: tajo/site/docs/devel/partitioning/range_partitioning.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/partitioning/range_partitioning.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/partitioning/range_partitioning.html (original) +++ tajo/site/docs/devel/partitioning/range_partitioning.html Tue Sep 1 06:42:40 2015 @@ -111,7 +111,9 @@ </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.html#built-in-functions">Built-in Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="../functions.html#built-in-window-functions">Built-in Window Functions</a></li> <li class="toctree-l2"><a class="reference internal" href="../functions.html#user-defined-functions">User-defined Functions</a></li> </ul> </li> Modified: tajo/site/docs/devel/search.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/search.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/search.html (original) +++ tajo/site/docs/devel/search.html Tue Sep 1 06:42:40 2015 @@ -108,7 +108,9 @@ </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.html#built-in-functions">Built-in Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-window-functions">Built-in Window Functions</a></li> <li class="toctree-l2"><a class="reference internal" href="functions.html#user-defined-functions">User-defined Functions</a></li> </ul> </li> Modified: tajo/site/docs/devel/searchindex.js URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/searchindex.js?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/searchindex.js (original) +++ tajo/site/docs/devel/searchindex.js Tue Sep 1 06:42:40 2015 @@ -1 +1 @@ -Search.setIndex({envversion:46,filenames:["backup_and_restore","backup_and_restore/catalog","configuration","configuration/catalog-site-xml","configuration/catalog_configuration","configuration/cluster_setup","configuration/ha_configuration","configuration/preliminary","configuration/service_config_defaults","configuration/tajo-site-xml","configuration/tajo_master_configuration","configuration/worker_configuration","faq","functions","functions/datetime_func_and_operators","functions/json_func","functions/math_func_and_operators","functions/network_func_and_operators","functions/python","functions/string_func_and_operators","getting_started","hbase_integration","hive_integration","index","index/future_work","index/how_to_use","index/types","index_overview","introduction","jdbc_driver","partitioning/column_partitioning","partitioning/hash_partitioning","partitioning/intro_to_partitioning","partitioning/range_partitioning","sql_language","sql_language/alter_table","sql_language/data_mo del","sql_language/ddl","sql_language/insert","sql_language/joins","sql_language/predicates","sql_language/queries","sql_language/sql_expression","storage_plugin","swift_integration","table_management","table_management/compression","table_management/file_formats","table_management/parquet","table_management/rcfile","table_management/sequencefile","table_management/table_overview","table_management/tablespaces","table_management/text","table_partitioning","tajo_client_api","time_zone","tsql","tsql/admin_command","tsql/background_command","tsql/dfs_command","tsql/execute_file","tsql/intro","tsql/meta_command","tsql/single_command","tsql/variables"],objects:{"":{abs:[16,0,1,""],acos:[16,0,1,""],add_days:[14,0,1,""],add_months:[14,0,1,""],asin:[16,0,1,""],atan2:[16,0,1,""],atan:[16,0,1,""],btrim:[19,0,1,""],cbrt:[16,0,1,""],ceil:[16,0,1,""],char_length:[19,0,1,""],cos:[16,0,1,""],current_date:[14,0,1,""],current_time:[14,0,1,""],date_part:[14,0,1,""],degrees:[16,0,1,""],div:[16,0,1,""] ,exp:[16,0,1,""],extract:[14,0,1,""],floor:[16,0,1,""],geoip_country_code:[17,0,1,""],geoip_in_country:[17,0,1,""],json_extract_path_text:[15,0,1,""],lower:[19,0,1,""],ltrim:[19,0,1,""],mod:[16,0,1,""],now:[14,0,1,""],pi:[16,0,1,""],pow:[16,0,1,""],radians:[16,0,1,""],regexp_replace:[19,0,1,""],round:[16,0,1,""],rtrim:[19,0,1,""],sign:[16,0,1,""],sin:[16,0,1,""],split_part:[19,0,1,""],sqrt:[16,0,1,""],tan:[16,0,1,""],to_char:[14,0,1,""],to_date:[14,0,1,""],to_timestamp:[14,0,1,""],trim:[19,0,1,""],upper:[19,0,1,""],utc_usec_to:[14,0,1,""]}},objnames:{"0":["py","function","Python function"]},objtypes:{"0":"py:function"},terms:{"12th":14,"15gb":11,"19th":14,"1gb":[10,11],"1st":14,"20000nov31":14,"35b":20,"4028235e":36,"4th":14,"500mb":11,"52nd":14,"53rd":14,"85e7":14,"\u02c6ab":19,"__init__":18,"boolean":[17,36,41,48],"byte":[20,36,39,48,63],"case":[4,7,14,19,35,40,49,50,56],"catch":29,"char":[14,36],"class":[4,18,22,29,40,43,49,50,53],"default":[2,4,5,6,7],"export":[4,11,20,21,22,44] ,"final":[4,18,20,22,26,29,44],"float":[16,18,20,30,36,44,48,49,50,51,53],"import":[29,39],"int":[14,16,19,20,30,36,48,49,50,51,53],"long":[14,28,39,41],"new":[6,14,21,22,35,63],"null":[25,29,37,41,49,51],"public":29,"return":[14,15,16,17,18,19,35,39,40,53],"short":[41,49],"static":29,"throw":29,"true":[4,6,11,17,25,36,40,44,48,50],"try":[6,29,62],"var":4,"void":29,"while":[14,29,39],aaabc:40,ab_bc_cd:19,abbrevi:[14,53,56],abc:[20,40],abcdef:19,abil:6,abl:[21,22],about:[25,37,45,51,52],abov:[20,21,25,49,50,59,64],abscissa:16,absolut:[4,16,20,63],acceler:39,accept:[53,56],access:[5,6,21,22,29,39,44,48],accord:[36,39,41,53],aco:[16,63],across:[5,41],activ:6,actual:[21,23],add:[4,5,6,7,9,11,20,21,22,23,29],add_dai:14,add_month:14,addit:[38,39,40,41,52,56],addr:[4,17],address:[4,5,6,8,17,21,36,51],adjust:[10,11,14,48,49,51,53,56],admin:[58,63],adopt:39,advanc:[28,41],advantag:48,affect:[4,11,14,56],after:[14,18,20,21,41],against:20,algorithm:[11,48,49,53],alia:[19,36,41,63],alias_nam:41 ,all:[1,4,5,6,14,17,18,20,21,22,29,35,40,41,43,45,51,53,56,58,63,65],all_backup:1,allocat:11,allow:[5,10,11,14,20,21,22,35,37,39,41,43,48,49,51,52,53,56,61],alreadi:[6,43,51],also:[4,6,14,20,30,39,40,41,43,44,50,52,53,56,63,65],alter:[22,23,34],altern:[4,40],although:14,alwai:[14,25],amazon:[43,51],among:39,amount:6,angl:16,ani:[4,6,29,35,40,41,44,48,53,63],annot:18,anoth:[6,42],another_long_table_name_5678:41,anymor:25,apach:[4,17,20,21,22],api:[22,23,25],appear:41,applciat:29,appli:[6,14,39],applic:41,approach:1,appropri:[7,20],approxim:36,april:56,arc:16,archiv:[4,20],arg:[29,58],argument:[14,16,41,60,63,64],arithmet:[23,41],arrai:40,arriv:21,asc:[25,37,41],ascend:41,asf:[4,20,27],asia:[51,53,56],asin:16,associ:39,assum:[11,14,20,30,64],atan2:16,atan:16,attempt:14,auth:44,auth_:44,authenticaiton:44,author:21,avail:2,avgpi:18,avoid:[6,14,21,28,37,59],awar:[11,22,44],axi:16,back:6,background:[23,57],backslash:[14,63],backup_and_restor:63,backward:11,balanc:28,bar:53,base:4,basic:[1 ,23,28,39,50,53],batch:28,becaus:[6,14,21,39,41,51,53,56,59],becom:[6,14,56],been:63,befor:[5,6,21,41,59],begin:[14,63],behav:41,behavior:41,behavior_arithmetic_abort:65,belong:41,below:[1,14,20,43,48,49,53],benefit:32,besid:53,best:[39,53],better:44,between:40,bewtween:36,big:21,bigint:[36,37],bin:[1,4,5,6,20,22,59,61,62,64],binari:[4,20,23,26],binaryserd:50,binaryserializerdeseri:[49,50],bit:36,bitmap:24,blank:14,blob:[18,36],block:[26,48,50],blockcompresswrit:50,blocksiz:44,blog:21,blog_backup:21,blrunner:21,bool:36,boolean_express:41,boot:[4,20],borrow:40,both:[6,19,28,41,49,50,53],brace:61,bracket:[39,40],branch:[23,27],briefli:41,broken:53,bst:[25,26],btrim:19,bucket:51,buffer:[20,48],builtin:43,bushi:39,bye:20,bytea:36,bzip2codec:37,c_acctbal:1,c_address:1,c_comment:1,c_custkei:1,c_mktsegment:1,c_name:1,c_nationkei:1,c_phone:1,calcul:41,calendar:14,call:[23,39,41],can:[4,5,6,7,11,14,18,20,21,22,23,25,27,29,30,35,37,39,40,41,44,45,48,49,50,51,52,53,56,57,60,61,63],cannot:[18,3 9,53],capac:[5,11],capit:14,card:30,care:[14,53],carriag:53,cartesian:41,cast:[14,23],cat:[1,5,6,20,61],catalog:0,catalogstor:6,cathedr:14,caus:[6,14],cbrt:16,ceil:16,cell:21,central:6,centuri:14,certain:[21,38,48,49,53],chang:[4,5,20,29,35,39,63],char_length:19,charact:[14,19,30,36,40,49,51,53],character_length:19,characterist:45,chmod:5,choi:21,choic:48,choos:20,chosen:39,classnotfoundexcept:29,classpath:[21,23],claus:[20,21,23,30,36,39,40],clean:[4,20,29],clear:63,cli:57,cli_error_stop:65,cli_max_column:65,cli_null_char:65,cli_output_formatter_class:65,cli_print_error_trac:65,cli_print_paus:65,cli_print_pause_num_record:65,click:20,client:[4,5,6,8,21,23,25],client_session_expiry_tim:65,clientport:21,clock:14,clone:[4,20,27],close:29,cluster1:52,cluster:[2,4],cnt:[18,41],code:[4,17,18],codebas:20,codec:[35,37,49,50,51,53],codegen:65,col1:[21,35,38,40],col2:[35,38,40],col3:[21,35,38],collect:50,column:[21,23],column_family_nam:21,column_nam:[21,35,37],column_refer:40,columnar:[48,4 9],columnarserd:49,com:[5,6,17,35],combin:41,comma:[14,41,53],command:[1,20,21,22,23,56,57],common:[23,39,41],commonli:53,compar:36,comparison:[36,40],compat:[1,11,23],compil:[4,20],complaint:14,complet:[6,35],complex:[14,41],compon:6,compos:[30,48],compress:[23,35],compressioncodec:[49,53],compressiontyp:50,comput:[14,39,41,44],concat_pi:18,concatnen:19,concept:[14,29],concern:[1,7],condit:[39,41],conf:[4,5,6,7,10,11,17,20,21,22,39,43,44,52,56,62],config:[4,5,6,7,8],conflict:6,conn:29,connect:[4,22,29,62,63,65],connector:[4,22],consecut:39,consid:[6,39,56],consist:[7,14,26,41,45,49,50,53],constant:16,construct:[14,41],consum:48,contain:[5,6,14,18,29,37,44],content:[4,20,21,23,37],context:14,control:6,convert:[6,14,16,17,42],coordin:16,copi:[4,7,43],copyright:63,core:[9,11,44],correctli:[20,36],correspond:[26,41,49],cosin:[16,63],cost:[24,28,39],could:14,count:[14,19,41,58,61,64],countpi:18,countri:[14,17],cpu:11,crash:6,creat:[1,4,5,20],createdatabaseifnotexist:4,createstat:29,crea tion:[4,25],cross:39,csv:20,csvlineserd:53,ctrl:[5,6,20],cube:16,current:[4,6,10,11,14,18,22,25,26,29,32,37,39,40,41,47,48,62,63],current_d:14,current_databas:65,current_tim:14,current_timestamp:14,custom:[1,4,23],customserializerdeseri:53,dai:14,data:[4,5,6],data_typ:[21,35,37],database_nam:[37,62],datanod:11,date:1,date_ord:65,date_part:14,datetim:[9,13],day_of_week:14,dayofweek:14,dbname:63,ddd:14,ddl:[1,20],ddsp:14,ddth:14,dealt:41,debug_en:65,decad:14,decemb:14,decim:[14,36],decimaln:63,declar:39,decompress:[20,48],def:[18,20],defaultport:4,definit:[14,23,25,34],deflatecodec:37,degre:[5,16],delimit:[18,19,20,25,35,37,44,51,53,56],demo:44,denot:40,depend:[6,22,40],deploi:6,derbystor:[4,6],deriv:41,desc:[37,41,58],descend:41,describ:[21,22,27,43,63],descript:[4,6,8,9,11,14,20,36,40,44,58,63],design:[7,28,30,48],desktop:21,detail:[4,5,14,20,39,41,44,48,58,63],detect:6,deterior:48,determin:[9,11,41],dev:17,develop:[20,23],dhadoop:20,dictionari:48,did:14,differ:[14,21,35,39,40,41,51 ,52,53,56],digit:[14,36],dir:[5,11,18,38,51],direct:23,directli:[22,26,27,29,30,53],directori:4,disabl:23,disagre:14,discompress:20,disconnect:[6,65],disk1:11,disk2:11,disk3:11,disk:[11,17,26],disrupt:6,dist:[4,20,29,39],dist_query_broadcast_join_threshold:[39,65],dist_query_groupby_partition_volum:65,dist_query_groupby_task_volum:65,dist_query_join_partition_volum:65,dist_query_join_task_volum:65,dist_query_sort_task_volum:65,dist_query_table_partition_volum:65,distinct:[14,41],distribut:4,div:16,divid:[14,16,41],divis:16,dmy:9,doc:63,doe:[6,14,21,29,35,37,41,48,51,53,56],doesn:[21,22,35],doi:14,domain:[5,6,40,53],don:[1,7,20,21,25,29,44],done:[14,20],doubl:14,dow:14,down:[20,40],download:17,driver:[4,22,23],drivermanag:29,drwxr:60,dskiptest:[4,20,29],dst:[53,56],dtar:[4,20,29],due:11,durat:4,dure:30,dynam:28,each:[5,7],earli:[14,39],easi:[1,32],easier:56,easili:[5,6,29],ecosystem:48,editor:[5,6],effici:[25,27,48],either:[20,22,36,40,41,48],element:[6,7],elimin:[21,37,41],emb:43,em bed:4,emploi:28,employe:51,empsalari:41,empti:[41,49,53],enabl:[5,6,23],enclos:41,encod:48,end:[19,20,35,60],endpoint:44,engin:[26,27],english:14,enjoi:20,enough:4,ensur:[4,20],enter:[20,23],entiti:6,entri:[5,6,21,37],env:[4,6],environ:[7,10,11,20,21,22],epoch:14,equal:[21,39],equival:[14,21,38,41],era:14,error:[14,21,37,53],especi:[36,39,51,52],essenti:6,estim:24,etc:[44,57],euler:16,eval:18,evalu:18,even:[6,14,39],everi:[6,9,18,39,41],evn:44,exact:36,exactli:40,exampl:[1,4,5,6],exce:14,except:[14,29,41],exchang:39,exec:50,execut:[5,6,11],executequeri:29,executor_external_sort_buffer_s:65,executor_groupby_inmemory_hash_threshold:65,executor_hash_join_size_threshold:65,executor_inner_hash_join_size_threshold:65,executor_outer_hash_join_size_threshold:65,exercis:20,exist:[21,35,37,38,49,62],exit:59,exp:16,expect:[14,25],expens:39,experiment:23,explain:[5,20,29,41,45,49,53],explan:20,explicitli:[7,39,41],expon:16,expr:41,express:[11,14,19,23,34,37],extend:26,extens:13,extern:[1,20,21, 23,30,35,37,44,49],extlib:43,extract:[14,15,63],fail:53,failur:6,fall:[14,41],fals:[17,25,36,40,48],familiar:[48,49,53],fault:28,favorit:[5,6],featur:[21,22,23,24,25],feed:53,feel:20,few:7,field:[14,19,51,53,63],figur:18,file:[1,2],filenam:62,filesystem:20,fill:[14,29],filter:[40,41],find:[6,26,39],finish:6,first:[4,7,14,18,19],five:22,fix:14,flag:44,flat:[48,49,50],float4:[25,36,63],float8:[1,16,18,36,38,63],floor:16,fmdd:14,fmhh:14,fmmi:14,fmmm:14,fmmonth:14,fmss:14,fmyyyi:14,follow:[1,4,5,6,7,9,10,11,14,17,18,20,21,22,25,27,29,30,32,36,37,38,39,40,41,43,44,47,48,49,50,51,52,53,56,58,59,60,61,62,63,64,65],forc:[14,35,41],form:[10,39,41,49,53,56],format:6,formatha:6,fornam:29,found:60,four:[14,47],fraction:14,frame:41,framework:48,free:20,fridai:14,from:[1,6,14,15,16,18,19,20,21,23,26],fsshell:60,full:[14,39,41],func:41,function_nam:42,further:53,futur:23,fxyyyi:14,gener:6,geoip:17,geoip_country_cod:17,geoip_in_countri:17,get:[4,6,14,18],get_final_result:18,get_partial_result:18,ge tconnect:29,getstat:6,getstr:29,ghi:20,git:4,github:20,give:[11,37,41],given:[14,17,19,20,21,36,37,38,40,41,44,53,56,62,63],global:[14,39,56],gmt:[35,56],goal:28,good:[39,45],got:21,grant:4,greater:16,gregorian:14,group:[40,41,48],groupbi:23,grouping_column_refer:41,grtajo01:58,guarante:6,guid:63,gzip:48,gzipcodec:37,haadmin:6,hadmin:6,hadoop:[5,7,20,21,23,28,35,37,40],hadoop_hom:[5,20,44],handl:[29,39],handler:43,hash:23,have:[4,10,14,21,22,23,37,39],haven:30,hbase_hom:21,hbase_table_nam:21,hbasetablespac:43,hdf:[5,10,11,20,22,23,25,26,28,35,37,43,44,45,51,52,57],hdfs_locat:49,header:[49,53],headerlin:53,hello:[14,18],helloworld:18,help:63,here:[14,18,20,21,39,40,44,50],heterogen:[51,52],hh12:14,hh24:14,high:2,higher:20,highli:[20,56],histori:6,hive:4,hive_hom:[4,22],hive_jdbc_driver_dir:[4,22],hivemetastor:[4,22],hiveql:22,home:[1,4,20,21,22],host1:[5,6],host2:[5,6],host:[4,5,6,9,52,58,62],hostnam:[4,5,10,29,51,62],hour:14,how:5,howev:[39,48],html:63,http:[4,6,8,17,20,27,44,63],hu rt:28,hyunsik:[1,21,63],id1:39,id2:[35,39],id3:39,id4:39,iddd:14,ident:14,identifi:[4,14,41,43],ieee:36,ignor:[11,14,53],impl:44,implement:[13,14,20,23,43,44,63],implementaion:10,implicit:39,implicitli:41,improv:[39,48],includ:[4,13,14,41],incorrect:6,increas:5,independ:48,index:[23,24],index_en:25,index_support:27,indic:14,individu:41,inet4:[17,36],inexact:36,info:[6,8,21,58],inform:[4,6,9,14,25,37,39,41,44,51,52,63],inherit:[49,53],init:20,initi:6,inner:[39,41],input:[14,16,18,19,39],insensit:40,insert:6,insid:35,inspect:57,instal:[4,17,18,20],instanc:[5,10,20,43,51,52],instead:[4,14,20,40,53,56,62],instruct:[17,22],int1:36,int2:36,int32:44,int4:[18,19,36,38,63],int8:[1,16,25,36,38,63],integ:[11,14,16,36,53,63],integr:4,intend:14,interact:[20,28,62],interfac:[6,53,57],intermedi:[18,39],intern:[7,56],interpret:14,interv:[6,14],introduc:23,introduct:23,invers:63,invok:6,involv:39,ipv4:[17,36],iso:14,isodow:14,isoyear:14,issu:23,item:[14,18,40,60],item_nam:30,itself:[6,63],iyi:14,iyy i:14,jaehwa:21,jan:14,januari:14,jar:[4,22,29,43,44],java:[4,7,20,22,29,36,40,56],java_hom:20,jdbc4:4,jdbc:[4,22,23],jhkim:21,jinho:21,jkl:20,jline2:59,join:[23,34],join_condit:39,join_typ:39,joined_t:39,json:13,json_extract_path_text:15,julian:14,jun:14,jung:21,just:[1,4,6,40,41,60,65],jvm:[6,11],keep:14,kei:[14,15,21,26,30,32,35,37,39,49,50,61,65],key1:65,keyston:44,keyword:[41,50,51],kill:[6,58],kim:21,kind:[26,41,53],know:[5,14,20,41,51,52,56],knowledg:53,known:30,l_comment:[25,37],l_commitd:25,l_discount:[25,41],l_extendedpric:[25,41],l_linenumb:25,l_linestatu:25,l_orderkei:[21,25,37,38,41],l_orderkey_idx:25,l_partkei:[21,25,37,38,41],l_quantiti:[21,25,38,41],l_receiptd:25,l_returnflag:25,l_shipdat:[25,41],l_shipinstruct:25,l_shipmod:25,l_suppkei:25,l_tax:25,languag:[20,23,25,28],larger:[36,39,41,48],largest:16,last:[14,25,37,41],lastli:4,late:14,later:20,launch:4,layer:10,layout:[45,51],lazybinari:50,lazybinarycolumnarserd:49,lazybinaryserd:50,lc_time:14,lead:[14,19,30],leaf:2 6,learn:[20,51,56],least:[40,41],left:[39,41],legaci:17,length:[14,36],less:[14,16],let:[35,50,51],lib:[4,44],librari:21,licens:63,like:[10,14,20,29,30],limit:23,line:[5,6,44,53,56,57],lineitem:[21,25,37,38,41,58,63],lineitem_100_snappi:37,link:[20,25],linux:63,list:[5,6,18,20,22,30,40,41,56,58,63],list_endpoint:44,listen:[5,29],liter:[7,14,53],littl:5,load:[20,21,28,35],locaion:56,local:[4,11,14,17],localhost:[4,5,6,8,25,37,62],locat:[1,4,11,17,20,29,35,37,38,44,49,51,52,53,56],logic:[40,45],long_table_name_1234:41,lost:35,lot:[13,39],lower:[14,19],ltrim:19,lzo:48,machin:[6,51,62],mai:[4,6,7,14,20,39,41,64],main:[7,21,28,29,40],manag:[4,20,21,22,23,32,35],mandatori:44,mani:[11,49,56,63],manipul:65,manner:29,manual:[4,49],map:36,mapr:50,march:14,mariadbstor:4,master:[2,4,5],match:[14,19,23,36],math:13,maven:[20,22],max:53,max_output_file_s:65,maxmind:17,mdy:9,mean:[14,21,39,40],megabyt:11,memori:[4,6],memstor:4,mention:49,merg:18,meridiem:14,meta:[4,20,21,23,56,57],metacharact:40,me tadata:[35,49,53],metastor:22,method:[1,23],microsecond:14,midnight:14,millennium:14,millisecond:14,min:11,mind:14,minimum:11,minut:[14,20,22],mirror:20,mismatch:23,mix:14,mixtur:14,mkdir:[5,20,60],mmdd:14,mno:20,mod:16,mode:4,model:[18,23,34],modifi:[14,43],modul:[7,23],moment:[48,53],mon:14,mondai:14,monitor:6,month:14,more:[4,5,11,14,20,22,24,25,37,39,40,41,44,48,51,52,61,64],most:[4,39,51,53],mostli:49,move:20,msck:22,msk:22,multipl:[6,11,14,18,39,41,53,56],multipli:14,must:[4,6,9,10,14,18,21,22,25,27,35,36,41,48,51,61],mvn:[4,20,29],mysql_jdbc_driv:[4,22],mysqlstor:4,n_name:18,n_nationkei:18,n_regionkei:18,name1:65,name2:65,name3:65,name:[1,4,5,6,7,8,9,10,11,14,17,18,20,21,22,25,29,35,36,37,39,41,43,44,48,49,50,51,52,53,56,57,61,62,63,65],namenode_hostnam:10,namespac:29,nation:[18,63],nativ:39,natur:[39,41],nearest:[14,16,63],necessari:28,need:[1,4,6,14,20,21,22,29,44,45,48,49,50,53],neither:40,nest:48,network:[6,13],never:[6,21],new_column_nam:35,new_table_nam:35,newli:22,next :[14,22,29,43],node:[4,5,6,11,18,26],non:[14,39,41,48],nonsens:14,nor:40,notat:39,note:[4,14,18,40],novemb:14,now:[1,14,20,48,49,63,65],num1:16,num2:16,num:[11,41,53,62],number:5,numer:14,o_clerk:63,o_com:63,o_custkei:63,o_orderd:63,o_orderkei:63,o_orderprior:63,o_orderstatu:63,o_shipprior:63,o_totalpric:63,object:[44,51,52],occur:[14,21,37,41,49,53],off:14,offset:[53,56],often:53,ojdbc7:4,omit:[14,41,49,63],onc:[6,17,18,25,41,44,51,52],ongo:6,onli:[4,7,10,14,20,26,32,37,39,41,48,49,50,53],open:28,openstack:[23,43],oper:[4,6,13],optim:[23,24,28],option:[1,14,20,21,25,37,41,53,58,61,62],oraclestor:4,order:[4,5,9,11,20,21,22,27,28,29,30,36],order_d:30,orderbi:23,ordin:[14,16],ordinari:14,org:[4,20,22,27,29,35,37,43,44,49,50,51,53,63],origin:21,other:[6,7,11,14,18,21,28,38,41,44,49,53,56],otherwis:[14,17,40,41,62],our:53,out:[11,18],outer:[39,41],outfil:1,output:[14,18,21,38,41,50],output_typ:18,over:41,overview:23,overwrit:6,own:[51,53,56],p_id:61,pack:43,packag:29,pad:14,page:[5,23,4 8],pair:[7,49,50],parallel:5,param:[41,61,62],paramet:[14,15,16,17,19,23,37,48,49,51,53],paramt:61,parent:20,parenthes:[40,41],parquet:[23,47],pars:53,part:[14,63],particip:39,partit:[22,23,24],partsupp:63,pass:41,password:[4,44],past:14,path:[1,4,10,15,17,18,20,21,22,25,29,35,37,51,56,63],pattern:[14,19,23],pdist:[4,20,29],peer:8,pemiss:53,per:[5,6,11,23],percent:40,perform:[25,39,41,44],period:[6,14],perman:26,persist:[4,20],peter:14,phase:30,physic:[5,45],pictur:63,pid:6,place:63,plai:43,plain:[49,50,53],plan:[28,30,39,43,53],pleas:[1,5,11,14,17,18,20,25,27,29,37,39,41,43,44,48,49,51,52,53,56],plugin:23,point:[6,14,15,49],polar:16,pope:14,port:[4,5,6,10,21,29,44,52,58,62],posit:26,posix:40,possibl:[11,14,39,41],postgresqlstor:4,pow:16,power:[16,40],preced:[14,17],precis:[14,36],predic:[23,30,34,37,39],prefix:[14,44,56,61],preliminari:2,prepar:[4,20,22],present:[20,63],preserv:6,prevent:6,previou:[14,40],price:30,primari:[6,10],primarili:14,primit:36,print:14,println:29,problem:[6 ,39,59],procedur:20,process:[14,23,27,28,30,48,49,53,56,57],product:41,profil:22,program:[7,48],progress:[21,28,58,59,61,64],project:[28,48],prompt:[62,63,64],proper:[4,10,11,20],properli:18,properti:[4,5,6,7,8,9,10,11,17,18,21,22,23],protocol:20,provid:[4,6,13,17,18,20,22,23,24,28,29,32,39,40],proxi:44,prune:23,pst:[53,56],purg:[21,35,37],purpos:[7,22],put:[14,21,56,61],python:13,q_1363768615503_0001_000001:20,q_1411357607375_0006:58,q_1411357607375_0007:58,qualifier_nam:21,quantiti:41,quarter:14,queri:[4,6,11],query_run:58,query_succeed:20,queryid:58,querymast:[6,11],quit:63,quorum1:52,quorum2:52,quorum:21,quot:[14,62],radian:16,rais:16,ran:4,rang:[23,32],rcfile:[23,47],rdbm:[29,43,45],read:[5,20,26,48],real:16,recogn:[44,53,56],recommand:56,recommend:[14,20,44],record:[35,40,48,49,50,53],recordcompresswrit:50,rectangular:16,refer:[5,9,17,18,20,21,25,27,29,37,39,41,44,48,49,50,51,52,53,56,63],regardless:[25,39,48,49],regexp:40,regexp_replac:19,region:[44,63],regionon:44,regist:[18 ,23],register_d:21,regular:19,relat:[39,41,48],remaind:16,remot:5,remov:[4,19,20,21,35,37],renam:23,reoptim:28,repair:22,repeat:14,repetit:40,replac:[14,19],replic:39,repo:[4,20,27],repositori:20,repres:[14,39,44,51,52,53],represent:[14,48],request:11,requir:[6,14,20,41,51,64],reset:18,resid:[20,35],resourc:[5,6,8],resourceconfigur:11,respect:[36,40],respond:22,respons:[20,21,28,39,59,61,64],rest:41,restrict:14,result:[6,14,18,20,21,23,35,39,41,48,56,63],result_set_fetch_rownum:65,resultset:29,resut:16,retriev:[14,25,27,56],return_on:18,rewritten:39,right:[39,41],rlike:40,role:43,roma:14,roman:14,root:[5,16,26,51],rootdir:5,round:[16,63],row:[4,20,21,25,39,40,41,48,49,50,51,53,56,61,63,64],row_num:41,row_numb:41,rowkei:21,rpc:[5,6,8,29],rtrim:19,rule:39,run:[5,6],saint:14,salari:41,same:[6,14,16,17,18,21,22,39,40,41,44],saturdai:14,scalar:[41,48],scale:28,scan:[21,22,23],schema:[20,21,25,30,38,45,48,57,63],scheme:[10,20,43],score:[20,44,48,49,50,51,53,61,64],script1:18,script2:18,sc ript:[7,18,20],search:[23,26,27],search_condit:41,sec:[4,20,21,58,59,61,64],second:[4,6,14,19,21,39],section:[5,11,14,20,21,22,27,29,43,44,45,49,53],see:[4,5,11,14,20,21,25,43,44,52],select:[14,16,17,18,19,20,21,24,29,38,39,40,41,56,58,61,63,64],select_list:41,select_stat:37,self:18,semicolon:[60,64],seoul:[51,53,56],separ:[14,41,50,53,64],sequecnefil:50,sequenc:40,sequencefil:[23,47,49],serd:49,serde2:[49,50],serv:6,server:[4,6,7,20,23,44],servic:[2,4,5],servicenam:4,session:[23,39,56,57,63],set:4,setup:2,sever:[4,39],shape:39,share:[4,29,41,44,49],shell:[7,20,21,23],shift:14,ship_dat:30,shortcut:60,shorten:4,shortli:26,should:[1,4,5,9,10,11,14,17,18,20,21,22,25,29,30,37,43,48,49,51,52,53,56,62],show:[4,20,29,58,63,65],showmast:58,shown:14,shuffl:39,shut:20,shutdown:6,side:[19,56],sign:[16,40],significantli:39,simpl:20,simpli:[20,25],simul:6,simultan:11,sin:16,sinc:[4,14,49],sine:16,singl:[5,6,14,23,39,40,45,48,51,57],site:2,skip:[14,53],small:[25,36,39,48],smaller:[21,38],smallest :[16,48],smallint:36,snappi:48,snappycodec:[35,37,49,50,51,53],snapshot:[4,20],snativ:44,solut:39,some:[4,7,14,20,21,22,23,36,41,48,49,51,53,56,59],sort:[21,41],sort_expr:41,sourc:[4,14],space:[14,19,52],special:[51,53],specif:[6,10,14,36,38],specifi:[4,10,11,14,15,17,18,20,21,22,29,35,36,38,39,40,41,42,44,48,49,50,51,53,56,58,60,62],speed:39,spell:14,split:[19,44],split_part:19,sql_languag:63,sqrt:16,squar:16,src:[14,20,29],ssd:52,ssss:14,stage:[18,20,39],standalon:20,standard:[14,20,28,36,40],standbi:6,start:[5,6,14,18,19],starttim:58,startup:62,statement:[20,21,29,35,37,38,40,41,48,49,50,51,53,56,58,61,62,63],statist:6,statu:6,step:[20,25,44],still:[6,27],stmt:29,stop:[6,59],storag:[1,4,10,20,21,23],storage_typ:37,store:[4,6,11,20,21,22,25,26,28,44,49,50,51,52,53,61,63],str1:19,str2:19,str:18,string:[7,13,14,15,17],strong:1,strongli:44,struct:[43,52],structur:[27,37],style:40,subdir:38,subfield:14,subject:41,submit:[6,20,25],subqueri:41,subsequ:[14,26],substitut:43,substr:[14,19, 41],subtract:14,successfulli:[6,18,25,58],suffici:25,suffix:14,suggest:20,sum:[18,41,61,64],sum_pi:18,sundai:14,supergroup:60,suppli:14,supplier:63,support:[1,4,10,13,14],suppos:39,suppress:14,swift:[23,43],swift_tabl:44,swiftnativefilesystem:44,symbol:61,synopsi:[21,23,35,37,40,41],syntax:[41,42],system:[4,5,6,7],t_date:[51,56],t_timestamp:[51,56],tab:53,tabl:[1,4,20],table1:[20,29,35,40,41,48,49,50,51,53,56,61,64],table2:35,table_backup:1,table_nam:[1,21,22,35,37],table_refer:[39,41],table_space_nam:52,tablespac:[23,43,45],tabular:53,tajo:[1,2,4],tajo_classpath:[4,44],tajo_hom:[4,5,6,7,20,29,39,44,62],tajo_master_heaps:10,tajo_password:44,tajo_pid_dir:6,tajo_src:20,tajo_worker_heaps:11,tajocli:[6,56],tajodriv:29,tajojdbccli:29,tajomast:[2,4,5],tajoresourcemanag:6,tajowork:[6,7,11],tajoxx:19,take:[20,22,39,41],tan:16,tangent:16,tar:[4,20,29],tarbal:6,target:[4,6,16,20,21,29,38],tbl:44,tbname:63,tcp:62,techniqu:[28,39],temp:60,templat:[4,14,43],templet:7,ten:20,tenant:44,termin:53,t est:4,text:[1,5,6,14,15,17,18,19,20,21,23,25,30,35,36,37,40,44,47,48,49,50,51],text_nul:65,textserd:50,textserializerdeseri:[49,50],than:[14,16,20,21,22,38,39,40,41,61],thei:[6,14,39,40,49,51],them:[18,41,56],therebi:39,therefor:[6,14],theta:16,thi:[1,4,5,6,7,14,20,21,22,23,25,27,29,35,37,39,40,41,43,44,45,48,50,53,56,60,61],thin:4,think:20,third:[4,14],those:[18,48,49,51,53],though:39,three:[4,14,39,50],threshold:39,through:22,thu:[20,22,39,53],thursdai:14,time:6,timestamp:[14,21,36,51,53,56],timestamptz:36,timetz:36,timezon:[9,35,51,53,56,65],tini:36,tinyint:36,titl:21,tmmonth:14,tmp:[4,10,20,60],tmpdir:11,to_char:[14,56],to_dat:14,to_numb:14,to_timestamp:14,togeth:14,toggl:14,token:44,toler:[28,53],too:48,tool:[44,63],total2:41,total:[11,41],tpch:[1,25,63],tracker:[5,6,8],trail:[14,19],transit:6,transitiontoact:6,transitiontobackup:6,translat:[14,56],tree:[20,26,39],trigger:6,trim:19,truncat:16,tsql:[1,20,23,56],tuesdai:14,tupl:[18,25,26],turn:39,twenti:14,two:[1,7,14,20,26,32,39 ,40,42,49,50,52],two_level_bin_tre:[25,26,37],type:[1,7,11,14,15,16,17],typic:[18,41],u0001:[51,53],udaf1:18,udaf:18,udf1:18,udf:18,umbil:[5,6,8],uncompress:[48,50],underli:44,underscor:40,understand:[18,45],unequ:6,unhealthi:6,unicod:36,uniqu:65,unit:[4,11,48],unix:14,unix_timestamp:14,unknown:[21,25],unless:[14,22],unqualifi:[30,41],unquot:63,unset:[63,65],untar:20,until:65,updat:[6,22],upper:[14,19],uri:[4,6,43,44,51,52],url:[10,29,44,45],usag:[1,14],user:[4,6,10,11],usernam:[4,20,44],usr:4,usual:[7,53],utc:[14,53,56],utc_usec_to:[14,63],util:[25,57],val1:[40,65],val2:[40,65],val3:65,val:65,valid:14,valn:40,valu:[4,5,6,7,9,10,11,14,16,17,18,21,22,23,27,35],varbinari:36,varbit:36,varchar:36,vari:[14,36],variabl:[4,7,10,11,20,21,22,23,36,39,56,57,63],varieti:7,variou:[14,43,45,65],vatican:14,veri:[5,20,39,40,51,52],verifi:[6,21],versa:49,version:[4,20,63],vertic:53,via:[5,6],vice:49,view:45,volum:[20,21,25,63],wai:[1,6,14,21,53,56],wait:6,want:[1,4,5,6,7,10,11,14,20,21,22,25,29,30, 37,38,50,51,52,60,62,64],warehous:[21,28,35,37,51,52,60],web:[6,28],week:14,weekdai:14,well:[14,21,36,37,38,39],what:14,when:[4,6,14,18,20,21,25,26,37,38,39,41,48],where:[4,5,11,18,20,21,23,30,36,37,39,40],whether:[40,41,49],which:[4,6,13,14,20,21,26,28,29,35,37,39,41,49,50,51,53,56,62,65],who:[39,53],wide:39,width:14,wild:30,window:[18,23],wip:[4,20,27],wish:61,within:[6,14,39,41,60],without:[4,14,28,30,39,41,43,53,64],word:[11,14,49,53,56],work1:63,work:[14,23],worker:2,workload:11,world:[18,39],worst:28,would:[14,20,22],writ:53,write:[14,18,48,49,50,51,53,56],written:[49,50,53,56],x84:21,xa2:21,xe2:21,xii:14,xml:2,xpath:15,xtajoxx:19,xxtajo:19,xxx:[35,63],xxxxxx:4,xzvf:[20,29],year:[14,41],yet:[30,39],ymd:9,you:[1,4,5,6,7,9,10,11,14,17,18,20,21,22,25,27,29,30,35,37,38,39,40,41,43,44,48,49,50,51,52,53,56,59,60,61,62,63,64],your:[1,4,5,6,7,9,10,14,18,20,21,22,29,43,48,49,53],yyi:14,yyyi:14,yyyymmdd:14,yyyymondd:14,zero:[14,40],zone:[9,14,23,36],zong:56,zookeep:21,zookeeper_address: 21,zookeeper_client_port:21},titles:["Backup and Restore","Backup and Restore Catalog","Configuration","The catalog-site.xml File","Catalog Configuration","Cluster Setup","High Availability for TajoMaster","Preliminary","Cluster Service Configuration Defaults","The tajo-site.xml File","Tajo Master Configuration","Worker Configuration","FAQ","Functions","DateTime Functions and Operators","JSON Functions","Math Functions and Operators","Network Functions and Operators","Python Functions","String Functions and Operators","Getting Started","HBase Integration","Hive Integration","Apache Tajo\u2122 (dev) - User documentation","Future Works","How to use index?","Index Types","Index (Experimental Feature)","Introduction","Tajo JDBC Driver","Column Partitioning","Hash Partitioning","Introduction to Partitioning","Range Partitioning","SQL Language","ALTER TABLE","Data Model","Data Definition Language","INSERT (OVERWRITE) INTO","Joins","Predicates","Queries","SQL Expressions","Storage Plugin", "OpenStack Swift Integration","Table Management","Compression","File Formats","Parquet","RCFile","SequenceFile","Overview of Tajo Tables","Tablespaces","TEXT","Table Partitioning","Tajo Client API","Time Zone","Tajo Shell (TSQL)","Administration Commands","Executing as background process","Executing HDFS commands","Executing Queries from Files","Introducing to TSQL","Meta Commands","Executing a single command","Session Variables"],titleterms:{"default":8,"function":[13,14,15,16,17,18,19,41,42],"null":53,add:35,administr:[6,58],aggreg:18,alias:41,alter:35,apach:[23,30,48,49,53],api:55,arithmet:42,automat:6,avail:6,background:59,backup:[0,1,6],base:5,basic:[58,61,63],binari:29,broadcast:39,build:[20,29],built:13,call:42,cast:42,catalog:[1,3,4,7],check:20,classpath:29,claus:41,client:[29,55,56],cluster:[5,6,8,20,56],code:[20,29],column:[30,35],command:[58,60,63,64],common:[44,51],compat:[30,48,49,53],compress:[37,46,51],config:9,configur:[2,4,6,8,10,11,43,44,52],convers:14,creat:[21,25 ,30,37,48,49,53],cross:41,custom:[43,53],data:[11,36,37],databas:[1,37],date:[9,14],datetim:14,decor:18,defin:[13,18],definit:37,derbi:4,dev:23,direct:29,directori:[5,11],disabl:25,distribut:[5,29],document:23,doubl:36,dowload:20,download:[20,29],driver:29,drop:[21,35,37],dump:1,each:11,enabl:25,enter:62,env:7,exampl:[11,18,29,39,41,56],execut:[20,59,60,61,64],experiment:27,express:[40,42],extern:51,failov:6,faq:12,featur:27,file:[3,6,9,47,61],first:20,format:[14,47],from:[29,41,61],fulli:5,futur:24,gener:49,get:[20,29],git:20,groupbi:41,hadoop:44,handl:53,hash:31,have:41,hbase:21,hdf:60,heap:[10,11],high:6,hive:[22,30,48,49,53],hivecatalogstor:4,how:[6,25,29,30,48,49,53],ilik:40,index:[25,26,27,37],indic:23,insert:[21,38],integr:[21,22,44],introduc:[50,62],introduct:[28,32],issu:[30,48,49,53],jdbc:29,join:[39,41],json:15,languag:[34,37],latest:20,launch:[5,6],level:1,like:40,limit:41,local:20,make:5,manag:[45,51],mariadb:4,master:[6,8,10],match:40,math:16,maximum:11,memori:[10,11], meta:63,method:[32,37],mode:5,model:36,mysql:4,network:17,number:[11,36],openstack:44,oper:[14,16,17,19],optim:39,oracl:4,order:39,orderbi:41,out:20,overview:[39,41,43,51],overwrit:[21,38],parallel:11,paramet:61,parquet:48,partit:[30,31,32,33,35,54],pattern:40,per:44,permiss:5,physic:[48,49,53],plugin:43,postgresql:4,predic:40,preliminari:7,prerequisit:[17,20],process:59,properti:[35,48,49,51,53],provid:44,prune:30,python:18,qualifi:41,queri:[18,20,41,44,61],rang:33,rcfile:49,read:49,real:36,regist:43,registr:18,regular:40,releas:20,renam:35,resourc:11,restor:[0,1],rootdir:10,run:11,scan:25,sequencefil:50,serd:50,serial:[49,53],serializerdeseri:50,server:56,servic:8,session:65,set:[5,6,9,20,29,35,61],setup:5,shell:[57,62],similar:40,singl:64,site:[3,7,9],size:[10,11],sourc:[20,29],sql:[1,34,42,61],start:20,state:6,storag:43,string:[19,40,42],support:17,swift:44,synopsi:[58,62],system:9,tabl:[21,23,30,35,37,41,45,48,49,51,53,54,56],tablespac:[51,52],tajo:[5,6,7,8,9,10,20,23,29,44,49, 51,55,57],tajomast:[6,10],task:11,temporari:11,terminolog:6,test:6,text:53,time:[9,14,51,56],todo:[1,12,31,33,46,51,55],tsql:[57,62],type:[18,26,36,41,42],unpack:20,usag:[21,58,61,63],user:[13,18,23],valu:[36,53,61],variabl:65,via:20,when:49,where:41,window:41,work:24,worker:[5,8,11],writer:50,xml:[3,7,9],zone:[51,56]}}) \ No newline at end of file +Search.setIndex({envversion:42,terms:{c_name:67,four:[58,21],prefix:[13,47,56,21],deviat:50,locaion:56,newli:5,digit:[27,21],everi:[17,33,66,7,40],"void":54,affect:[56,62,12,21],println:54,tajo_src:49,direct:14,batch:59,enjoi:49,second:[18,40,9,21,33,62],even:[40,33,21],asin:31,neg:53,asia:[42,43,56],char_length:18,supplier:10,"new":[5,9,21,40,10,30],metadata:[22,30,43],ongo:40,elimin:[64,9,7],abov:[38,25,2,22,24,9,49],never:[9,40],o_totalpric:10,here:[17,9,21,33,24,47,49,8],path:[32,17,25,53,54,3,9,67,30,5,56,42,62,10,64,49],interpret:21,deterior:45,headerlin:43,anymor:25,precis:[27,21],datetim:[15,66],pack:36,sequencefil:[14,58,22],q_1363768615503_0001_000001:49,substr:[7,18,21],unix:21,total:[7,12],unit:[62,12,45],highli:[49,56],describ:[36,10,11,9,5],would:[5,49,18,21],call:[14,7,33],recommend:[47,49,21],type:[50,34,15,67,12],until:63,relat:[33,7,45],supergroup:28,hurt:59,rootdir:55,exce:21,recommand:56,getconnect:54,must:[13,32,17,18,40,25,42,9,21,5,7,62,45,27,11,66,30],join:[1 4,51],setup:16,work:[14,21],era:21,root:[31,65,42,55],dayofweek:21,give:[64,7,12],fmdd:21,indic:21,want:[5,12,38,46,21,23,24,9,49,28,32,62,25,40,64,44,67,57,54,55,34,42],rpad:18,end:[30,53,28,18,49],quot:[57,18,68,21],str2:18,ordinari:21,hdf:[14,32,19,59,36,55,65,30,5,42,44,25,64,47,48,49,12],how:55,conn:54,env:[40,62],verifi:[9,40],config:[40,34,55,6,62],lazybinaryserd:24,updat:[5,40],recogn:[47,43,56],after:[17,9,21,7,49,61],cli_error_stop:63,befor:[9,2,55,40,7,61],parallel:55,averag:50,attempt:21,third:[62,21],environ:[32,9,5,34,49,12],enter:[14,49],first:[17,18,21,34,62,61],order:[11,59,9,54,55,5,23,62,27,66,49,12],oper:[40,15,62],to_bin:29,over:7,failur:40,becaus:[33,9,2,56,21,40,42,43,7],veri:[55,33,42,8,44,49],vari:[27,21],digest:18,smallint:27,cli:48,fix:21,better:47,persist:[49,62],easier:56,descend:7,them:[17,7,56],thei:[33,21,22,42,8,40],binaryserializerdeseri:[22,24],choic:45,subqueri:7,regexp_replac:18,udaf1:17,each:[55,34],side:[18,56],mean:[9,33,8,21],saturdai:21,resu t:31,mdy:66,extract:[53,21,18,10],customserializerdeseri:43,network:[40,15],dst:[43,56],xxtajo:18,content:[14,64,49,62,9],millennium:21,got:9,free:49,standard:[50,59,21,8,27,49],md5:18,get_partial_result:17,angl:31,filter:[7,8],iso:21,fxyyyi:21,mvn:[54,49,62],rang:[31,14,39],independ:45,rank:61,system:[40,55,34,62],restrict:[31,21],instruct:[5,3],alreadi:[36,42,18,40,30],tpch:[25,67,10],primari:[40,32],cartesian:7,rewritten:33,xii:21,master:[16,55,62],too:45,json_arrai:53,listen:[54,55],namespac:54,tool:[47,10],inexact:27,target:[31,46,18,9,54,40,62,49],keyword:[42,7,24],provid:[14,15,54,17,40,59,52,3,39,5,8,62,33,49,68],expr:7,tree:[65,49,33],mmdd:21,project:[59,45],minut:[5,49,21],ran:62,mind:21,manner:54,script2:17,val2:[63,8],thoma:18,current_d:21,though:33,usernam:[47,49,62],object:[47,42,44],microsecond:21,letter:18,phase:23,doi:21,don:[25,54,67,34,9,47,49],doc:[68,10],binaryserd:24,doe:[9,54,56,21,40,7,43,45,64,42,30],declar:33,umbil:[40,55,6],dow:21,pope:21,random:31,syntax: [7,68],identifi:[36,7,18,62,21],involv:33,absolut:[31,49,62,10],row_num:7,submit:[25,49,40],layout:[42,19],explain:[54,55,22,7,43,19,49],apach:[5,9,3,62,49],geoip_country_cod:3,search_condit:7,fmmonth:21,stop:[40,2],ceil:31,amazon:[36,42],bar:[18,43],emb:36,method:[14,18,67],executor_hash_join_size_threshold:63,respond:5,l_receiptd:25,memstor:62,num:[57,7,43,12],mandatori:47,result:[14,17,33,9,45,56,21,30,40,7,10,49],respons:[13,38,59,9,2,33,49],extlib:36,best:[33,43],subject:7,awar:[5,47,12],heterogen:[42,44],figur:17,score:[13,38,22,42,24,45,47,49,43],approach:67,accord:[27,7,43,33],extend:65,extens:15,toler:[59,43],fault:59,howev:[33,45],against:49,logic:[8,19],countri:[3,21],com:[40,55,3,30],split_part:18,guid:10,assum:[38,23,49,12,21],nonsens:21,three:[33,24,62,21],been:10,trigger:40,datanod:12,basic:[14,59,33,43,67,24],c_mktsegment:67,tini:27,suppress:21,xxx:[30,10],worker:16,ani:[54,53,45,40,7,8,62,10,47,30,61,43],lpad:18,"catch":54,emploi:59,ident:21,geoip:3,servic:[16,55,62 ],properti:[14,32,17,34,40,9,55,3,5,62,66,6,12],cli_max_column:63,calcul:[7,18],alias_nam:7,udaf:17,conf:[34,32,44,40,36,55,3,57,56,5,62,9,33,47,49,12],march:21,sever:[33,68,62],pemiss:43,perform:[25,47,7,33],suggest:49,complex:[7,21],isodow:21,complet:[40,30],jkl:49,rais:31,dskiptest:[54,49,62],kim:9,squar:31,thu:[5,33,49,43],inherit:[22,43],to_numb:21,client:[14,9,55,40,62,25,6],shortli:65,thi:[5,7,8,9,13,14,11,18,21,24,25,28,30,49,34,36,40,64,43,19,45,47,67,33,53,54,55,56,62],roma:21,gzip:45,left:[33,7,18],protocol:49,just:[40,7,8,62,63,28,67],dist_query_groupby_task_volum:63,dtar:[54,49,62],yet:[33,23],languag:[59,14,49,25],jose:18,easi:[67,39],pdist:[54,49,62],backup_and_restor:10,expon:31,applic:7,preserv:40,bzip2codec:64,bushi:33,background:[14,48],database_nam:[57,64],u0001:[42,43],specif:[27,32,46,40,21],arbitrari:68,manual:[22,62],timetz:27,underli:47,right:[33,7,18],interv:[40,21],intern:[56,34],"52nd":21,cnt:[17,7],insensit:8,multipli:21,tracker:[40,55,6],condit:[33,7],f oo:18,localhost:[57,25,55,40,64,62,6],concat_pi:17,core:[47,66,12],who:[33,43],uncompress:[24,45],character_length:18,corr:50,peer:6,rcfile:[14,58],dist_query_join_partition_volum:63,total2:7,simul:40,"float":[31,50,17,42,22,23,24,45,27,47,49,43],encod:[18,45],bound:68,down:[8,49],storag:[14,32,9,67,62,49],jdbc:[5,62,14],wai:[9,56,21,40,43,67],support:[15,32,67,62,21],avail:16,width:21,editor:[40,55],fraction:21,o_custkei:10,creation:[25,62],form:[32,22,56,33,7,43],forc:[7,30,21],drwxr:28,compressiontyp:24,l_comment:[25,64],"true":[25,3,40,8,62,45,27,47,12,24],reset:17,l_discount:[25,7],vatican:21,trim:18,nnn:18,adopt:33,semicolon:[28,38],tajocli:[40,56],exist:[46,57,9,53,22,64,30],executor_inner_hash_join_size_threshold:63,successfulli:[20,25,17,40],floor:31,when:[17,33,25,9,21,40,7,62,45,64,46,65,49],getstr:54,role:36,hh12:21,test:62,node:[17,55,40,62,65,12],intend:21,consid:[40,56,33],longer:18,abscissa:31,carriag:43,jsonpath:53,ignor:[43,12,21],time:40,backward:12,ojdbc7:62,conc ept:[54,21],skip:[43,30,21],global:[33,56,21],stddev_pop:50,boolean_express:7,row:[13,50,38,33,25,45,9,56,22,7,24,62,10,42,43,49,61,8],millisecond:21,depend:[5,8,40],zone:[14,66,27,21],decim:[27,21],intermedi:[33,17],json_extract_path_text:53,hadmin:40,drivermanag:54,jvm:[40,12],sql_languag:10,sourc:[29,18,62,21],string:[15,53,3,21,34,29],word:[18,56,21,22,43,12],hdfs_locat:22,exact:27,did:21,"12th":21,item:[28,17,8,21],sine:31,div:31,tajo_hom:[34,57,54,55,40,62,33,47,49],dir:[46,17,55,12,42],prevent:40,templet:34,sign:[31,8],long_table_name_1234:7,cost:[59,33,52],port:[32,62,57,20,9,54,55,40,44,47],addr:[3,62],current:[32,54,17,61,40,25,45,65,39,21,57,5,7,8,62,10,64,33,58,12],deriv:7,gener:40,coeffici:50,stmt:54,tangent:31,address:[9,55,3,40,42,62,27,6],wait:40,shift:21,behav:7,commonli:43,regardless:[22,25,33,45],repositori:49,modul:[14,34],msck:5,output_typ:17,instal:[17,3,62,49],num1:31,memori:[40,62],connector:[5,62],handler:36,msk:5,tajo_pid_dir:40,capit:21,claus:[14,9,33,23,8 ,27,49],ojat:18,templat:[36,62,21],prepar:[5,49,62],timestamptz:27,cat:[13,40,55,49,67],countpi:17,"02b0e20540b89f0b735092bbac8093eb2e3804cf":18,purpos:[5,34],fmss:21,nearest:[31,21,10],l_orderkey_idx:25,l_shipinstruct:25,backslash:[21,18,10],occur:[9,21,22,64,43,7],alwai:[25,21],sundai:21,multipl:[17,33,56,21,40,7,43,12],haadmin:40,write:[17,56,21,22,42,24,45,43],purg:[9,64,30],c_address:67,ordin:[31,21],map:27,product:7,atan:31,max:[50,43],clone:[11,49,62],"4th":21,date:67,shuffl:33,underscor:8,data:[40,55,62],favorit:[40,55],predic:[64,14,51,23,33],inform:[44,33,25,21,40,7,62,10,64,42,47,66,68],preced:[3,21],combin:7,hh24:21,ghi:49,columnarserd:22,midnight:21,still:[40,11],ieee:27,dynam:59,entiti:40,mapr:24,disconnect:[63,40],monitor:40,new_table_nam:30,main:[59,9,54,8,34],non:[33,21,7,18,45],synopsi:[14,9,64,8,7,30],add_month:21,col2:[46,8,30],col3:[9,46,30],initi:40,nation:[17,10],therebi:33,now:[49,45,21,22,10,63,67],nor:8,introduct:14,hive_jdbc_driver_dir:[5,62],name:[3,5,7,1 0,25,12,13,17,21,22,24,9,27,33,30,32,34,36,6,49,42,43,44,45,47,48,67,40,54,55,56,57,62,63,64,66,68],reoptim:59,revers:18,separ:[43,38,7,24,21],januari:21,quarter:21,tajo_worker_heaps:12,compil:[49,62],domain:[40,55,8,43],replac:[18,21],individu:7,current_tim:21,significantli:33,year:[7,21],shown:21,space:[18,44,21],o_orderkei:10,profil:5,hivemetastor:[5,62],lag:61,partit:[5,52,61,14],git:62,org:[11,22,36,54,30,5,42,24,62,10,64,47,49,43],"byte":[18,45,33,10,27,49],card:23,care:[43,21],suffici:25,p_id:13,catalog:1,codegen:63,turn:33,place:10,standbi:40,think:49,str1:18,origin:9,directli:[11,54,5,23,43,65],onc:[17,25,3,40,7,44,42,47],arrai:[53,8],o_orderd:10,"long":[59,33,7,21],open:59,given:[46,18,9,53,3,21,57,56,7,8,10,64,27,47,49,43],stddev_samp:50,paramt:13,l_partkei:[64,46,7,9,25],especi:[27,42,44,33],copi:[36,34,62],specifi:[3,5,7,8,12,17,18,20,21,22,24,27,28,30,32,9,57,42,43,45,46,47,49,33,53,54,56,62,68],github:49,enclos:[7,68],tajo_password:47,mostli:22,than:[13,31,46,18,33,9, 21,5,7,8,49],serv:40,wide:33,serd:22,posix:8,balanc:59,posit:65,argument:[31,38,18,53,21,7,10,28,29,68],maxmind:3,engin:[65,11],techniqu:[59,33],partsupp:10,note:[17,8,62,21],take:[5,7,49,33],xxxxxx:62,begin:[21,10],c_nationkei:67,buffer:[49,45],price:23,compress:[14,30],deflatecodec:64,pair:[50,22,24,34],renam:14,later:49,quantiti:7,link:[25,49],axi:31,clientport:9,show:[20,54,62,10,63,49],threshold:33,ship_dat:23,xml:16,onli:[34,32,18,33,65,39,21,22,7,24,62,45,64,49,43],explicitli:[33,7,34],"500mb":12,activ:40,written:[22,56,24,43],l_suppkei:25,table_space_nam:44,"53rd":21,variou:[63,36,19,21],get:[40,17,62,21],client_session_expiry_tim:63,allocat:12,repo:[11,49,62],cannot:[33,17,43],java_hom:49,progress:[13,38,20,9,2,59],ssd:44,requir:[38,21,40,42,7,49],table_refer:[33,7],item_nam:23,borrow:8,c_custkei:67,list_endpoint:47,where:[14,17,18,9,55,33,23,8,62,64,27,49,12],calendar:21,concern:[67,34],detect:40,enough:62,ddsp:21,between:[50,8],"import":[33,54],across:[55,7],parent:49,exe cutor_groupby_inmemory_hash_threshold:63,hadoop_hom:[47,55,49],gregorian:21,decimaln:10,region:[47,10],gzipcodec:64,groupbi:14,compressioncodec:[22,43],improv:[33,45],among:33,acceler:33,jdbc4:62,pow:31,"4028235e":27,featur:[5,25,52,9,14],xzvf:[54,49],date_ord:63,invers:10,dist_query_broadcast_join_threshold:[63,33],derbystor:[40,62],those:[22,42,17,43,45],"case":[34,18,56,21,22,24,62,30,8],cast:[14,21],invok:40,new_column_nam:30,column_family_nam:9,advantag:45,ctrl:[40,55,49],cluster:[16,62],warehous:[59,9,42,44,64,28,30],abcdef:18,ascii:18,"__init__":17,develop:[14,49],regionon:47,alphabet:18,same:[31,50,17,40,9,3,21,5,7,8,33,47,61],binari:[14,18,62,65,29,49],epoch:21,html:10,pad:[18,21],week:21,finish:40,nest:45,driver:[5,62,14],decompress:[49,45],tajo_classpath:[47,62],mani:[22,56,12,10],extern:[14,9,49,22,23,64,67,47,30],appropri:[49,34],without:[38,59,36,21,33,23,43,62,7],fmmm:21,lc_time:21,fmmi:21,execut:[40,55,12],rest:[7,18],bitmap:52,kill:[20,40],speed:33,inet4:[27,3],stru ct:[36,44],except:[54,7,21],littl:55,desktop:9,blog:9,codec:[22,64,43,42,30,24],blob:[27,17],versa:22,overview:14,pgpgpgpg:18,disrupt:40,real:31,read:[65,55,49,45],period:[40,21],swiftnativefilesystem:47,mon:21,world:[33,17],pst:[43,56],mod:31,mysqlstor:62,integ:[31,21,61,43,10,27,29,12],server:[14,62,40,34,47,49],query_succeed:49,benefit:39,either:[53,5,7,8,45,27,49],last_valu:[50,61],output:[17,9,21,7,24,46],tajo:[16,67,62],result_set_fetch_rownum:63,yyyi:21,ascend:7,tajowork:[40,34,12],json_path:53,definit:[14,25,51,21],exit:2,ddl:[49,67],blocksiz:47,power:[31,8],inspect:48,broken:43,starttim:20,l_tax:25,regexp:8,"throw":54,comparison:[27,8],central:40,choi:9,aco:[31,10],degre:[31,55],yyyymondd:21,table_nam:[5,64,67,9,30],effici:[25,11,45],lastli:62,defaultport:62,yyi:21,your:[32,17,34,22,36,54,55,9,21,5,43,62,45,67,66,49,40],rowkei:9,hex:18,overwrit:40,start:[40,55,17,18,21],current_databas:63,interfac:[40,48,43],ipv4:[27,3],lot:[33,15],tupl:[25,17,65],untar:49,jun:21,tajoxx:18, index_en:25,max_output_file_s:63,notat:33,possibl:[33,7,12,21],ddth:21,bucket:42,day_of_week:21,embed:[18,62],expect:[25,21],creat:[55,49,62,67],multibyt:18,certain:[22,46,43,9,45],strongli:47,file:[16,67],oraclestor:62,fill:[54,18,21],incorrect:40,denot:8,sort_expr:7,tinyint:27,prepend:18,field:[43,21,42,18,10],valid:21,rdbm:[36,54,19],you:[33,2,3,5,7,8,9,10,11,12,13,38,17,21,22,23,24,36,28,30,49,32,34,25,40,42,43,44,45,46,47,67,57,54,55,56,62,64,66],polar:31,sequenc:[8,68,18],symbol:13,text_nul:63,briefli:7,tajomast:[16,55,62],hyunsik:[9,67,10],descript:[20,6,21,40,8,62,10,27,47,66,49,12],tajo_master_heaps:32,index_support:11,cpu:12,unset:[63,10],tajodriv:54,represent:[21,29,18,45],all:[3,5,7,8,10,17,20,21,9,30,49,36,40,42,43,19,67,50,54,55,56,62,63],dist:[33,54,49,62],month:21,correl:50,abil:40,mno:49,follow:[33,2,3,5,7,8,9,10,21,12,13,38,17,20,49,22,23,24,25,27,28,32,34,36,39,40,42,43,44,45,46,47,67,57,54,55,56,11,58,62,63,64,66],disk:[65,3,12],init:49,program:[34,45],thursdai:2 1,liter:[43,34,21],fals:[27,25,8,3,45],util:[25,48],worst:59,fall:[7,21],expression1:50,expression2:50,list:[17,40,20,55,56,5,7,8,10,23,49,68],helloworld:17,adjust:[32,56,21,22,42,43,45,12],cosin:[31,10],small:[33,27,25,45],tmmonth:21,ten:49,past:21,zero:[21,8,18],design:[59,23,34,45],pass:7,val3:63,further:43,val1:[63,8],what:21,abc:[49,8,18],clock:21,section:[11,22,36,54,55,21,5,43,19,9,47,49,12],abl:[5,9],abbrevi:[56,43,21],version:[49,62,10],consecut:33,to_dat:21,"public":54,zookeep:9,full:[33,7,21],hash:[14,18],valn:8,initcap:18,zong:56,strong:67,modifi:[36,21],valu:[31,14,32,61,17,18,34,40,9,53,55,3,21,5,66,50,62,11,29,30,12],search:[14,11,18,65],cli_print_error_trac:63,table_backup:67,amount:40,behavior_arithmetic_abort:63,codebas:49,via:[40,55],data_typ:[9,64,30],primit:27,transit:40,filenam:57,unbias:50,select:[13,31,38,17,18,52,20,9,53,54,3,21,33,56,7,8,10,46,29,49],hexadecim:29,l_extendedpric:[25,7],distinct:[7,21],etc:[47,48],regist:[14,17],two:[34,33,39,67,22,24,44,65,2 1,49,68,8],toggl:21,more:[13,38,44,52,25,55,21,5,68,7,8,62,45,64,42,33,47,49,12],flat:[22,24,45],discompress:49,function_nam:68,flag:47,known:23,endpoint:47,hour:21,formatha:40,dev:3,histori:40,orderbi:14,archiv:[49,62],learn:[42,49,56],def:[17,49],bewtween:27,prompt:[57,38,10],to_char:[29,56,21],num2:31,scan:[5,9,14],share:[54,22,47,7,62],accept:[43,56],tabular:43,minimum:[50,12],goal:59,divid:[31,7,21],anoth:[40,68],divis:31,n_name:17,csv:49,simpl:49,swift_tabl:47,blockcompresswrit:24,jline2:2,resourc:[40,55,6],seoul:[42,43,56],resultset:54,json_array_length:53,varianc:50,associ:33,"short":[22,7],author:9,caus:[40,21],atan2:31,help:10,pseudorandom:31,through:5,paramet:[31,14,18,53,3,21,22,42,43,45,64,50,29,61],style:8,late:21,alter:[5,51,14],good:[33,19],"return":[31,50,17,18,53,3,21,33,8,29,30,61,43],timestamp:[50,9,56,21,42,43,27],o_orderstatu:10,ssss:21,framework:45,mtizxdawmfwwmd:18,get_final_result:17,utc_usec_to:[21,10],serde2:[22,24],easili:[40,54,55],token:47,radian:31,fou nd:28,unicod:[27,18],truncat:[31,18],unequ:40,procedur:49,connect:[57,54,5,62,10,63],o_clerk:10,"try":[40,54,57],csvlineserd:43,print:21,proxi:47,advanc:[59,7],asc:[64,25,7],base:62,asf:[11,49,62],put:[13,9,56,21],fridai:21,refer:[3,7,10,17,22,24,9,25,33,64,43,44,45,11,47,49,54,55,56,42,66,68],thrown:30,launch:62,omit:[22,21,7,61,10],round:[31,10],perman:65,feed:43,meridiem:21,upper:[18,21],feel:49,exchang:33,applciat:54,number:55,done:[49,21],unhealthi:40,blank:21,differ:[9,56,21,33,7,8,44,42,30,43],script:[17,49,34],interact:[59,57,49],construct:[7,21],saint:21,twenti:21,scheme:[36,32,49],store:[13,44,22,59,25,9,5,42,24,62,10,65,43,47,49,12,40],schema:[46,19,25,45,23,9,10,48,49],option:[13,20,25,21,57,7,43,9,64,67,49],part:[21,10],pars:43,start_index:18,kind:[65,7,43],remot:55,remov:[18,9,49,64,62,30],l_orderkei:[64,46,7,9,25],str:17,comput:[33,47,7,21],packag:54,"null":[25,53,54,22,64,42,7,61],catalogstor:40,equival:[46,7,9,21],self:17,also:[44,33,36,56,21,40,7,8,62,10,63,23,43,4 7,49,24],tmpdir:12,brace:13,distribut:62,exec:24,previou:[8,21],mixtur:21,most:[33,42,43,62],plai:36,plan:[59,36,23,43,33],metacharact:8,model:[14,17,51],appear:7,quorum:9,filesystem:49,clear:10,salari:7,classnotfoundexcept:54,clean:[54,49,62],jaehwa:9,data_type_func_and_oper:68,session:[14,33,48,56,10],find:[40,33,65],access:[40,9,54,55,5,45,33,47],copyright:10,solut:33,fmhh:21,ymd:66,l_quantiti:[46,7,9,25],query_run:20,express:[50,14,18,21,64,51,12],nativ:33,strposb:18,hbase_table_nam:9,statist:40,sum_pi:17,bytea:27,set:62,startup:57,see:[44,36,55,9,21,62,25,47,49,12],arc:31,sec:[13,38,20,9,2,62,49],arg:[20,54],float4:[27,25,10],close:54,unqualifi:[23,7],particip:33,smallest:[31,45],subdir:46,"\u02c6ab":18,altern:[8,62],numer:21,fsshell:28,add_dai:21,outfil:67,popul:50,both:[18,40,59,22,7,24,61,43],last:[50,18,25,21,64,7,61],"85e7":21,c_comment:67,roman:21,snativ:47,context:21,load:[59,9,49,30],simpli:[25,49],point:[22,53,18,40,21],hbase_hom:9,header:[22,43],param:[13,57,7],shutdo wn:40,suppli:21,transitiontobackup:40,cathedr:21,becom:[40,56,21],java:[34,54,56,5,8,62,27,49],due:12,empti:[22,7,43],sinc:[22,62,21],l_linestatu:25,exercis:49,iddd:21,gap:61,tajojdbccli:54,coordin:31,understand:[17,19],func:7,repetit:[8,18],xa2:9,iyi:21,tajoresourcemanag:40,durat:62,n_regionkei:17,"while":[33,54,21],behavior:7,error:[9,43,64,30,21],script1:17,earli:[33,21],key1:63,tbname:10,itself:[40,10],centuri:21,grant:62,belong:7,shorten:62,hadoop:[14,59,9,55,49,64,8,34,30],decod:18,octal:18,conflict:40,higher:49,varbit:27,lineitem:[46,20,25,10,7,9,64],x84:9,optim:[59,14,52],fornam:54,moment:[43,45],user:[40,32,62,12],tsql:[14,56,49,67],chang:[54,55,49,33,62,10,30],lower:[18,21],sha1:18,lib:[47,62],entri:[9,64,55,40],parenthes:[7,8,68],udf1:17,expens:33,explan:49,shape:33,openstack:[36,14],snappi:45,all_backup:67,disk1:12,disk2:12,disk3:12,shortcut:28,appli:[40,33,21],input:[31,50,17,18,21,33,61],subsequ:[65,21],euler:31,bin:[13,38,40,2,55,57,67,5,62,49],complaint:21,varchar:27 ,format:[40,29],big:9,subfield:21,register_d:9,bit:[27,18],characterist:19,table2:30,table1:[13,38,54,56,30,22,7,24,45,42,43,49,8],collect:24,"boolean":[27,7,3,45],l_commitd:25,often:43,order_d:23,createstat:54,"1st":21,some:[14,34,22,9,2,42,56,21,5,7,43,62,45,27,49],back:40,sampl:50,mirror:49,tablespac:[36,19,14],scale:59,id4:33,id2:[33,30],id3:33,per:[14,55,12,40],id1:33,bst:[25,65],substitut:[36,18],machin:[40,42,57],o_shipprior:10,run:[40,55],dist_query_table_partition_volum:63,hive_hom:[5,62],step:[25,47,49],"15gb":12,subtract:21,varbinari:27,manag:[14,9,39,49,5,62,30],regular:18,"1gb":[32,12],block:[65,24,45],executor_outer_hash_join_size_threshold:63,repair:5,primarili:21,within:[40,21,33,7,28,61],ensur:[49,62],megabyt:12,textual:18,custom:[14,67,62],arithmet:[14,7],includ:[15,7,62,21],unix_timestamp:21,metastor:5,record:[8,22,24,45,30,43],properli:[17,18],int4:[31,46,18,53,10,27,17,29],int1:27,translat:[56,21],select_stat:64,int2:27,l_shipdat:[25,7],line:[55,56,40,43,47,48], int8:[31,50,46,25,53,10,27,29,67,61],info:[20,9,6,40],utc:[56,43,21],utf:18,consist:[34,21,22,7,43,19,65,68,24],blrunner:9,sum:[13,17,38,7,50],"export":[9,5,62,47,49,12],impl:47,constant:[31,14],doesn:[5,53,30,9],repres:[21,33,42,43,44,47],"char":[27,18,21],qualifier_nam:9,home:[5,9,49,62,67],titl:9,hiveql:5,debug_en:63,bracket:[33,8],servicenam:62,ecosystem:45,exp:31,jhkim:9,introduc:14,eval:17,join_typ:33,algorithm:[22,43,12,45],vice:22,first_valu:61,hixyx:18,json_array_contain:53,hello:[17,21],code:[17,3,62,18],"900150983cd24fb0d6963f7d28e17f72":18,queri:[40,62,12],dist_query_join_task_volum:63,base64:18,executor_external_sort_buffer_s:63,keyston:47,volum:[25,49,9,10],implicitli:7,dbname:10,recordcompresswrit:24,evn:47,hive:62,unquot:10,date_part:21,dealt:7,ddd:21,pleas:[3,7,12,17,21,22,25,49,36,33,64,43,44,45,11,47,67,54,55,56,42,68],smaller:[9,46],natur:[33,7],uniqu:63,fold:18,download:3,click:49,append:18,compat:[14,67,12],index:[14,53,18,52],compar:27,cell:9,c_phone:67,"19th" :21,experiment:14,can:[19,5,7,8,10,12,13,14,17,21,22,23,24,9,28,30,34,25,40,42,43,44,45,11,47,48,49,33,54,55,56,62,64],showmast:20,return_on:17,let:[42,24,30],authenticaiton:47,o_orderprior:10,vertic:43,implicit:33,convert:[31,18,3,21,40,29,68],aaabc:8,weekdai:21,larger:[27,33,7,45],typic:[17,7],control:40,cbrt:31,approxim:27,api:[5,25,14],namenode_hostnam:32,wip:[11,49,62],join_condit:33,from:[31,14,17,18,9,53,67,40,65,21,49,61],c_acctbal:67,doubl:[18,21],next:[36,21,54,5],few:34,chr:18,usr:62,remaind:31,sort:[9,7],src:[54,49,21],mismatch:14,trail:[18,21],name2:63,name3:63,name1:63,retriev:[25,56,11,18,21],alia:[31,27,7,18,10],annot:17,thin:62,parquet:[14,58],employe:42,tar:[54,49,62],process:[14,11,59,56,21,22,23,43,45,48],high:16,tab:43,tarbal:40,tan:31,concatnen:18,isoyear:21,instead:[56,21,57,43,62,49,61,8],sin:31,transitiontoact:40,ltrim:18,jinho:9,o_com:10,getstat:40,physic:[55,19],essenti:40,cli_print_paus:63,correspond:[22,7,65],element:[40,53,34],issu:14,column_refer:8,wri t:43,allow:[13,32,22,36,55,9,21,30,5,56,7,43,44,45,64,42,33,49,12],least:[7,8],move:49,comma:[7,43,21],outer:[33,7],chosen:33,decad:21,therefor:[40,21],crash:40,greater:31,handl:[33,54],spell:21,dai:21,auth:47,mention:22,lzo:45,quorum2:44,quorum1:44,mode:62,cluster1:44,consum:45,meta:[14,9,56,62,48,49],"static":54,our:43,special:[42,43],out:[17,12],variabl:[14,32,34,33,9,56,5,62,10,27,48,49,12],hbasetablespac:36,var_pop:50,suitabl:18,math:15,common:[14,7,33],shut:49,insid:30,manipul:63,standalon:49,dictionari:45,l_shipmod:25,tenant:47,joined_t:33,could:21,keep:21,length:[27,53,18,21],timezon:[56,42,43,63,66,30],suffix:21,resourceconfigur:12,mai:[38,34,33,21,40,7,62,49],quote_id:18,t_timestamp:[42,56],unknown:[25,9],licens:10,mkdir:[28,55,49],capac:[55,12],termin:43,bit_length:18,"final":[17,54,5,62,65,47,49],inner:[33,7],mysql_jdbc_driv:[5,62],shell:[14,49,34,9],grouping_column_refer:7,udf:17,rtrim:18,exactli:8,haven:23,prune:14,split:[47,18],structur:[11,64],charact:[18,42,21,22,23 ,8,27,68,43],float8:[31,50,46,10,21,27,17,67],textserd:24,julian:21,fail:43,have:[14,32,33,9,21,5,64,62],tabl:[49,62,67],need:[19,22,9,54,21,5,24,62,45,67,47,49,40,43],json_array_get:53,cli_null_char:63,min:[50,12],mix:21,builtin:36,which:[63,15,18,40,59,9,54,65,57,21,22,56,7,24,62,30,64,42,33,49,43],singl:[14,33,55,21,40,42,8,19,45,48,68],lineitem_100_snappi:64,unless:[5,21],preliminari:16,l_returnflag:25,deploi:40,"class":[17,5,36,54,22,8,62,43,24],url:[32,47,54,19],request:12,uri:[62,36,40,42,44,47],snapshot:[49,62],determin:[66,53,7,12],querymast:[40,12],text:[3,8,14,17,18,21,22,23,24,9,27,29,30,49,25,40,42,45,47,67,50,53,55,58,64],locat:[46,18,44,54,3,67,22,56,42,43,62,30,64,47,49,12],postgresqlstor:62,jar:[36,47,54,62,5],should:[3,5,25,12,17,21,22,23,9,49,32,36,57,64,43,44,45,67,54,55,56,62,42,66],jan:21,suppos:33,local:[62,3,12,21],cube:31,familiar:[22,43,45],disagre:21,tbl:47,increas:55,l_linenumb:25,enabl:[14,55,40],grtajo01:20,"default":[40,16,55,34,62],integr:62,dist_quer y_sort_task_volum:63,contain:[17,18,54,55,21,40,64,47],view:19,dhadoop:49,legaci:3,frame:7,knowledg:43,n_nationkei:17,rlike:8,statu:40,correctli:[27,49],t_date:[42,56],pattern:[14,18,21],to_timestamp:21,cli_print_pause_num_record:63,xyxhi:18,theta:31,neither:8,kei:[13,33,9,53,39,21,22,23,24,65,63,64,30],otherwis:[57,21,7,3,8],group:[7,8,45],swift:[36,14],addit:[46,56,33,7,8,44,68],plugin:14,admin:[20,10],equal:[9,33],april:56,instanc:[32,36,55,42,44,49],fmyyyi:21,english:21,arriv:9,chmod:55,rpc:[40,54,55,6],respect:[27,8,61],tuesdai:21,quit:10,compos:[23,45],compon:40,json:15,besid:43,sequecnefil:24,columnar:[22,45],cli_output_formatter_class:63,togeth:21,present:[49,10],delimit:[17,18,25,56,49,42,43,64,47,30],replic:33,bye:49,implementaion:32,plain:[22,24,43],octet_length:18,rectangular:31,wild:23,lazybinarycolumnarserd:22,textserializerdeseri:[22,24],layer:32,demo:47,site:16,bigint:[27,64],avgpi:17,avg:50,to_hex:29,"35b":49,classpath:[14,9],cross:33,sqrt:31,python:15,zookeeper_add ress:9,largest:31,http:[11,3,6,40,62,10,47,49],hostnam:[32,54,55,57,42,62],geoip_in_countri:3,column_nam:[9,64,30],col1:[9,46,8,30],off:21,well:[46,9,21,33,64,27],exampl:[40,55,67,62],command:[14,9,56,49,5,48,67],choos:49,usual:[43,34],less:[31,21],percent:8,tcp:57,current_timestamp:21,auth_:47,simultan:12,web:[59,40],add:[14,34,40,9,54,55,5,62,66,49,12],host2:[40,55],host1:[40,55],work1:10,match:[14,27,18,21],gmt:[30,56],int32:47,iyyi:21,workload:12,five:5,know:[55,56,21,42,44,7,49],xe2:9,createdatabaseifnotexist:62,password:[47,62],desc:[20,64,7],insert:40,storage_typ:64,resid:[49,30],like:[32,54,23,49,21],lost:30,necessari:[59,18],page:[14,55,45],another_long_table_name_5678:7,datetime_func_and_oper:68,linux:10,queryid:20,yyyymmdd:21,proper:[32,49,12,62],guarante:40,peter:21,librari:9,tmp:[28,32,49,62],leaf:65,lead:[23,18,61,21],avoid:[59,9,2,21,40,64],estim:52,zookeeper_client_port:9,blog_backup:9,xtajoxx:18,ab_bc_cd:18,usag:[67,21],maven:[5,49],host:[62,57,20,55,40,44,66],altho ugh:21,offset:[43,61,56],empsalari:7,stage:[33,17,49],about:[44,25,64,19,42,68],actual:[14,9],dist_query_groupby_partition_volum:63,column:[14,9],statement:[13,54,46,18,57,20,9,45,56,30,22,7,8,10,64,42,43,49,24],disabl:14,own:[42,43,56],lazybinari:24,merg:17,val:63,pictur:10,q_1411357607375_0007:20,q_1411357607375_0006:20,"var":62,snappycodec:[22,64,43,42,30,24],count:[13,50,38,18,20,21,7,61],temp:28,whether:[22,7,8],wish:13,directori:62,below:[49,36,21,22,43,45,67],limit:14,dmy:66,problem:[40,2,33],executequeri:54,evalu:[17,61],btrim:18,"int":[31,50,18,42,21,22,23,24,45,27,49,43],dure:23,pid:40,novemb:21,implement:[14,15,36,21,10,47,49],"20000nov31":21,var_samp:50,boot:[49,62],detail:[20,45,55,21,33,7,62,10,47,49],other:[17,18,40,59,9,56,21,22,7,43,34,46,47,12],bool:27,futur:14,branch:[14,11],varieti:34,repeat:[18,21],row_numb:[7,61],jung:9,mondai:21,escap:18,strpo:18,rule:33,mariadbstor:62,select_list:7,two_level_bin_tre:[25,64,65],decemb:21},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","hive_integration","configuration/service_config_defaults","sql_language/queries","sql_language/predicates","hbase_integration","tsql/meta_command","index_overview","configuration/worker_configuration","tsql/execute_file","index","functions","configuration","functions/python","functions/string_func_and_operators","table_management","tsql/admin_command","functions/datetime_func_and_operators","table_management/rcfile","partitioning/column_partitioning","table_management/sequencefile","index/how_to_use","configuration/catalog-site-xml","sql_language/data_model","tsql/dfs_command","functions/data_type_func_and_operators","sql_language/alter_table","functions/math_func_and_operators","configuration/tajo_master_configuration","sql_language/joins","configuration/preliminary","table_mana gement/compression","storage_plugin","faq","tsql/single_command","partitioning/intro_to_partitioning","configuration/ha_configuration","table_partitioning","table_management/table_overview","table_management/text","table_management/tablespaces","table_management/parquet","sql_language/insert","swift_integration","tsql","getting_started","functions/agg_func","sql_language","index/future_work","functions/json_func","jdbc_driver","configuration/cluster_setup","time_zone","tsql/intro","table_management/file_formats","introduction","tajo_client_api","functions/window_func","configuration/catalog_configuration","tsql/variables","sql_language/ddl","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","Hive Integration","Cluster Service Configuration Defaults","Queries","Predicates","HBase Integration","Me ta Commands","Index (Experimental Feature)","Worker Configuration","Executing Queries from Files","Apache Tajo\u2122 (dev) - User documentation","Functions","Configuration","Python Functions","String Functions and Operators","Table Management","Administration Commands","DateTime Functions and Operators","RCFile","Column Partitioning","SequenceFile","How to use index?","The catalog-site.xml File","Data Model","Executing HDFS commands","Data Type Functions and Operators","ALTER TABLE","Math Functions and Operators","Tajo Master Configuration","Joins","Preliminary","Compression","Storage Plugin","FAQ","Executing a single command","Introduction to Partitioning","High Availability for TajoMaster","Table Partitioning","Overview of Tajo Tables","TEXT","Tablespaces","Parquet","INSERT (OVERWRITE) INTO","OpenStack Swift Integration","Tajo Shell (TSQL)","Getting Started","Aggregation Functions","SQL Language","Future Works","JSON Functions","Tajo JDBC Driver","Cluster Setup","Time Zone","Intro ducing to TSQL","File Formats","Introduction","Tajo Client API","Window Functions","Catalog Configuration","Session Variables","Data Definition Language","Index Types","The tajo-site.xml File","Backup and Restore Catalog","SQL Expressions"],objects:{"":{trim:[18,0,1,""],upper:[18,0,1,""],now:[21,0,1,""],to_bin:[29,0,1,""],acos:[31,0,1,""],to_char:[21,0,1,""],btrim:[18,0,1,""],regexp_replace:[18,0,1,""],cbrt:[31,0,1,""],date_part:[21,0,1,""],random:[31,0,1,""],split_part:[18,0,1,""],sign:[31,0,1,""],substr:[18,0,1,""],stddev_pop:[50,0,1,""],add_months:[21,0,1,""],right:[18,0,1,""],to_date:[21,0,1,""],quote_ident:[18,0,1,""],rpad:[18,0,1,""],tan:[31,0,1,""],avg:[50,0,1,""],extract:[21,0,1,""],digest:[18,0,1,""],to_hex:[29,0,1,""],var_samp:[50,0,1,""],first_value:[61,0,1,""],lead:[61,0,1,""],min:[50,0,1,""],ascii:[18,0,1,""],sum:[50,0,1,""],current_date:[21,0,1,""],json_extract_path_text:[53,0,1,""],stddev_samp:[50,0,1,""],char_length:[18,0,1,""],chr:[18,0,1,""],abs:[31,0,1,""],var_pop :[50,0,1,""],pow:[31,0,1,""],encode:[18,0,1,""],degrees:[31,0,1,""],bit_length:[18,0,1,""],pi:[31,0,1,""],sin:[31,0,1,""],row_number:[61,0,1,""],locate:[18,0,1,""],sqrt:[31,0,1,""],ltrim:[18,0,1,""],atan:[31,0,1,""],current_time:[21,0,1,""],max:[50,0,1,""],lag:[61,0,1,""],cos:[31,0,1,""],rtrim:[18,0,1,""],initcap:[18,0,1,""],json_array_length:[53,0,1,""],rank:[61,0,1,""],corr:[50,0,1,""],lpad:[18,0,1,""],strposb:[18,0,1,""],json_array_contains:[53,0,1,""],utc_usec_to:[21,0,1,""],geoip_in_country:[3,0,1,""],repeat:[18,0,1,""],md5:[18,0,1,""],count:[50,0,1,""],lower:[18,0,1,""],reverse:[18,0,1,""],asin:[31,0,1,""],ceil:[31,0,1,""],floor:[31,0,1,""],octet_length:[18,0,1,""],radians:[31,0,1,""],json_array_get:[53,0,1,""],atan2:[31,0,1,""],to_timestamp:[21,0,1,""],geoip_country_code:[3,0,1,""],add_days:[21,0,1,""],mod:[31,0,1,""],decode:[18,0,1,""],exp:[31,0,1,""],div:[31,0,1,""],last_value:[61,0,1,""],round:[31,0,1,""],left:[18,0,1,""]}},titleterms:{code:[54,49],execut:[13,2,38,28,49],q ueri:[13,17,47,7,49],cross:7,scalar:15,session:63,permiss:55,mysql:62,openstack:47,hbase:9,classpath:54,languag:[51,64],paramet:13,xml:[26,66,34],oracl:62,zone:[42,56],how:[40,25,54,22,23,43,45],configur:[32,16,62,36,40,44,47,6,12],apach:[22,14,23,43,45],common:[47,42],window:[15,7,61],text:43,local:49,alter:30,match:8,build:[54,49],real:27,sourc:[54,49],synopsi:[20,57],string:[8,68,18],format:[58,21],python:17,faq:37,terminolog:40,background:2,introduct:[59,39],insert:[9,46],document:14,like:8,administr:[20,40],level:67,drop:[9,64,30],hive:[22,5,23,43,45],server:56,"default":6,mode:55,partit:[0,39,41,23,4,30],each:12,fulli:55,tajo:[14,32,40,66,54,55,6,22,42,34,60,47,48,49],manag:[42,19],failov:40,set:[13,54,55,30,40,66,49],dump:67,direct:54,dowload:49,meta:10,aggreg:[50,15,17],download:[54,49],hash:0,todo:[0,35,37,4,42,60,67],time:[66,42,56,21],out:49,compat:[22,23,43,45],index:[25,11,64,65],network:3,defin:[15,17],databas:[64,67],definit:64,per:47,launch:[40,55],state:40,experimen t:11,directori:[55,12],get:[54,49],method:[64,39],math:31,integr:[5,47,9],qualifi:7,run:12,compress:[64,35,42],hivecatalogstor:62,usag:[20,13,9,10],serializerdeseri:24,base:55,prerequisit:[3,49],releas:49,swift:47,rcfile:22,valu:[13,27,43],postgresql:62,convers:21,plugin:36,column:[23,30],where:7,groupbi:7,datetim:21,gener:22,backup:[40,1,67],disabl:25,first:49,oper:[31,21,29,3,18],rang:4,via:49,overview:[36,33,7,42],tajomast:[40,32],number:[27,12],automat:40,date:[66,21],api:60,storag:36,size:[32,12],git:49,from:[13,54,7],memori:[32,12],data:[64,27,29,12],support:3,doubl:27,regist:36,system:66,overwrit:[9,46],custom:[36,43],avail:40,start:49,json:53,call:68,basic:[20,13,10],master:[40,32,6],type:[17,7,27,65,29,68],"function":[31,50,15,17,18,53,3,21,7,61,29,68],setup:55,shell:[57,48],claus:7,worker:[55,6,12],broadcast:33,rootdir:32,heap:[32,12],jdbc:54,unpack:49,join:[33,7],prune:23,restor:[1,67],provid:47,servic:6,properti:[22,43,42,30,45],maximum:12,dev:14,orderbi:7,cast:68,serd:2 4,limit:7,introduc:[57,24],parquet:45,tablespac:[42,44],similar:8,featur:11,constant:68,file:[13,26,58,66,40],creat:[25,45,22,23,43,9,64],scan:25,process:2,registr:17,site:[26,66,34],indic:14,high:40,cluster:[40,56,55,49,6],have:7,tabl:[14,9,42,56,22,41,23,43,19,45,64,7,30],serial:[22,43],work:52,check:49,issu:[22,23,43,45],decor:17,"null":43,built:15,make:55,ilik:8,when:22,hadoop:47,hdf:28,binari:54,add:30,exampl:[17,54,56,33,7,12],futur:52,env:34,test:40,writer:24,config:66,singl:38,enabl:25,variabl:63,express:[8,68],resourc:12,distribut:[54,55],preliminari:34,optim:33,enter:57,driver:54,catalog:[26,34,67,62],regular:8,temporari:12,user:[14,15,17],sql:[13,51,67,68],extern:42,mariadb:62,tsql:[57,48],parallel:12,physic:[22,43,45],derbi:62,handl:43,task:12,renam:30,read:22,predic:8,arithmet:68,alias:7,client:[54,60,56],command:[20,28,38,10],pattern:8,model:27,sequencefil:24,order:33,latest:49}}) \ No newline at end of file Modified: tajo/site/docs/devel/sql_language.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/sql_language.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/sql_language.html (original) +++ tajo/site/docs/devel/sql_language.html Tue Sep 1 06:42:40 2015 @@ -110,7 +110,9 @@ </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.html#built-in-functions">Built-in Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-scalar-functions">Built-in Scalar Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a></li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-window-functions">Built-in Window Functions</a></li> <li class="toctree-l2"><a class="reference internal" href="functions.html#user-defined-functions">User-defined Functions</a></li> </ul> </li>
