Modified: tajo/site/docs/devel/functions/string_func_and_operators.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/functions/string_func_and_operators.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/functions/string_func_and_operators.html (original) +++ tajo/site/docs/devel/functions/string_func_and_operators.html Tue Sep 1 06:42:40 2015 @@ -111,7 +111,9 @@ </ul> </li> <li class="toctree-l1 current"><a class="reference internal" href="../functions.html">Functions</a><ul class="current"> -<li class="toctree-l2 current"><a class="reference internal" href="../functions.html#built-in-functions">Built-in Functions</a></li> +<li class="toctree-l2 current"><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> @@ -208,8 +210,8 @@ <h1>String Functions and Operators<a class="headerlink" href="#string-functions-and-operators" title="Permalink to this headline">¶</a></h1> <dl class="function"> <dt> -<code class="descname">str1 || str2</code></dt> -<dd><p>Returns the concatnenated string of both side strings <code class="docutils literal"><span class="pre">str1</span></code> and <code class="docutils literal"><span class="pre">str2</span></code>.</p> +<tt class="descname">str1 || str2</tt></dt> +<dd><p>Returns the concatnenated string of both side strings <tt class="docutils literal"><span class="pre">str1</span></tt> and <tt class="docutils literal"><span class="pre">str2</span></tt>.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> <col class="field-body" /> @@ -227,16 +229,62 @@ </tr> </tbody> </table> -<div class="highlight-sql"><div class="highlight"><pre>select âTaâ || âjoâ; -> 'Tajo' +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="s1">'Ta'</span> <span class="o">||</span> <span class="s1">'jo'</span><span class="p">;</span> +<span class="o">></span> <span class="s1">'Tajo'</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="ascii"> +<tt class="descname">ascii</tt><big>(</big><em>string text</em><big>)</big><a class="headerlink" href="#ascii" title="Permalink to this definition">¶</a></dt> +<dd><p>Returns the ASCII code of the first character of the text. +For UTF-8, this function returns the Unicode code point of the character. +For other multibyte encodings, the argument must be an ASCII character.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><strong>string</strong> – input string</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body">int4</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">ascii</span><span class="p">(</span><span class="s1">'x'</span><span class="p">);</span> +<span class="o">></span> <span class="mi">120</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="bit_length"> +<tt class="descname">bit_length</tt><big>(</big><em>string text</em><big>)</big><a class="headerlink" href="#bit_length" title="Permalink to this definition">¶</a></dt> +<dd><p>Returns the number of bits in string.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><strong>string</strong> – input string</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body">int4</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="k">bit_length</span><span class="p">(</span><span class="s1">'jose'</span><span class="p">);</span> +<span class="o">></span> <span class="mi">32</span> </pre></div> </div> </dd></dl> <dl class="function"> <dt id="char_length"> -<code class="descname">char_length</code><span class="sig-paren">(</span><em>string text</em><span class="sig-paren">)</span><a class="headerlink" href="#char_length" title="Permalink to this definition">¶</a></dt> -<dd><p>Returns Number of characters in string</p> +<tt class="descname">char_length</tt><big>(</big><em>string text</em><big>)</big><a class="headerlink" href="#char_length" title="Permalink to this definition">¶</a></dt> +<dd><p>Returns the number of characters in string.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> <col class="field-body" /> @@ -245,29 +293,365 @@ </tr> <tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body">int4</td> </tr> -<tr class="field-odd field"><th class="field-name">Alias:</th><td class="field-body">character_length</td> +<tr class="field-odd field"><th class="field-name">Alias:</th><td class="field-body">character_length, length</td> +</tr> +<tr class="field-even field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="k">char_length</span><span class="p">(</span><span class="s1">'Tajo'</span><span class="p">);</span> +<span class="o">></span> <span class="mi">4</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="octet_length"> +<tt class="descname">octet_length</tt><big>(</big><em>string text</em><big>)</big><a class="headerlink" href="#octet_length" title="Permalink to this definition">¶</a></dt> +<dd><p>Returns the number of bytes in string.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><strong>string</strong> – input string</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body">int4</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="k">octet_length</span><span class="p">(</span><span class="s1">'jose'</span><span class="p">);</span> +<span class="o">></span> <span class="mi">4</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="chr"> +<tt class="descname">chr</tt><big>(</big><em>code int4</em><big>)</big><a class="headerlink" href="#chr" title="Permalink to this definition">¶</a></dt> +<dd><p>Returns a character with the given code.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><strong>code</strong> – input character code</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body">char</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">chr</span><span class="p">(</span><span class="mi">65</span><span class="p">);</span> +<span class="o">></span> <span class="n">A</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="decode"> +<tt class="descname">decode</tt><big>(</big><em>binary text</em>, <em>format text</em><big>)</big><a class="headerlink" href="#decode" title="Permalink to this definition">¶</a></dt> +<dd><p>Decode binary data from textual representation in string.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> +<li><strong>binary</strong> – encoded value</li> +<li><strong>format</strong> – decode format. base64, hex, escape. escape converts zero bytes and high-bit-set bytes to octal sequences (nnn) and doubles backslashes.</li> +</ul> +</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body"><p class="first">text</p> +</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre>select decode('MTIzXDAwMFwwMDE=', 'base64'); +> 123\\000\\001 +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="digest"> +<tt class="descname">digest</tt><big>(</big><em>input text</em>, <em>method text</em><big>)</big><a class="headerlink" href="#digest" title="Permalink to this definition">¶</a></dt> +<dd><p>Calculates the Digest hash of string.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> +<li><strong>input</strong> – input string</li> +<li><strong>method</strong> – hash method</li> +</ul> +</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body"><p class="first">text</p> +</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">digest</span><span class="p">(</span><span class="s1">'tajo'</span><span class="p">,</span> <span class="s1">'sha1'</span><span class="p">);</span> +<span class="o">></span> <span class="mi">02</span><span class="n">b0e20540b89f0b735092bbac8093eb2e3804cf</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="encode"> +<tt class="descname">encode</tt><big>(</big><em>binary text</em>, <em>format text</em><big>)</big><a class="headerlink" href="#encode" title="Permalink to this definition">¶</a></dt> +<dd><p>Encode binary data into a textual representation.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> +<li><strong>binary</strong> – decoded value</li> +<li><strong>format</strong> – encode format. base64, hex, escape. escape converts zero bytes and high-bit-set bytes to octal sequences (nnn) and doubles backslashes.</li> +</ul> +</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body"><p class="first">text</p> +</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">encode</span><span class="p">(</span><span class="s1">'123\\000\\001'</span><span class="p">,</span> <span class="s1">'base64'</span><span class="p">);</span> +<span class="o">></span> <span class="n">MTIzXDAwMFwwMDE</span><span class="o">=</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="initcap"> +<tt class="descname">initcap</tt><big>(</big><em>string text</em><big>)</big><a class="headerlink" href="#initcap" title="Permalink to this definition">¶</a></dt> +<dd><p>Convert the first letter of each word to upper case and the rest to lower case.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><strong>string</strong> – input string</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body">text</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">initcap</span><span class="p">(</span><span class="s1">'hi THOMAS'</span><span class="p">);</span> +<span class="o">></span> <span class="n">Hi</span> <span class="n">Thomas</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="md5"> +<tt class="descname">md5</tt><big>(</big><em>string text</em><big>)</big><a class="headerlink" href="#md5" title="Permalink to this definition">¶</a></dt> +<dd><p>Calculates the MD5 hash of string.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><strong>string</strong> – input string</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body">text</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">md5</span><span class="p">(</span><span class="s1">'abc'</span><span class="p">);</span> +<span class="o">></span> <span class="mi">900150983</span><span class="n">cd24fb0d6963f7d28e17f72</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="left"> +<tt class="descname">left</tt><big>(</big><em>string text</em>, <em>number int4</em><big>)</big><a class="headerlink" href="#left" title="Permalink to this definition">¶</a></dt> +<dd><p>Returns the first n characters in the string.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> +<li><strong>string</strong> – input string</li> +<li><strong>number</strong> – number of characters retrieved</li> +</ul> +</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body"><p class="first">text</p> +</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="k">left</span><span class="p">(</span><span class="s1">'ABC'</span><span class="p">,</span> <span class="mi">2</span><span class="p">);</span> +<span class="o">></span> <span class="n">AB</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="right"> +<tt class="descname">right</tt><big>(</big><em>string text</em>, <em>number int4</em><big>)</big><a class="headerlink" href="#right" title="Permalink to this definition">¶</a></dt> +<dd><p>Returns the last n characters in the string.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> +<li><strong>string</strong> – input string</li> +<li><strong>number</strong> – number of characters retrieved</li> +</ul> +</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body"><p class="first">text</p> +</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="k">right</span><span class="p">(</span><span class="s1">'ABC'</span><span class="p">,</span> <span class="mi">2</span><span class="p">);</span> +<span class="o">></span> <span class="n">BC</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="locate"> +<tt class="descname">locate</tt><big>(</big><em>source text</em>, <em>target text</em><span class="optional">[</span>, <em>start_index int4</em><span class="optional">]</span><big>)</big><a class="headerlink" href="#locate" title="Permalink to this definition">¶</a></dt> +<dd><p>Returns the location of specified substring.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> +<li><strong>source</strong> – source string</li> +<li><strong>target</strong> – target substring</li> +<li><strong>start_index</strong> – the index where the search is started</li> +</ul> +</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body"><p class="first">int4</p> +</td> +</tr> +<tr class="field-odd field"><th class="field-name">Alias:</th><td class="field-body"><p class="first">strpos</p> +</td> </tr> <tr class="field-even field"><th class="field-name">Example:</th><td class="field-body"></td> </tr> </tbody> </table> -<div class="highlight-sql"><div class="highlight"><pre>select char_length(âTajoâ); -> 4 +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">locate</span><span class="p">(</span><span class="s1">'high'</span><span class="p">,</span> <span class="s1">'ig'</span><span class="p">,</span> <span class="mi">1</span><span class="p">);</span> +<span class="o">></span> <span class="mi">2</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="strposb"> +<tt class="descname">strposb</tt><big>(</big><em>source text</em>, <em>target text</em><big>)</big><a class="headerlink" href="#strposb" title="Permalink to this definition">¶</a></dt> +<dd><p>Returns the binary location of specified substring.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> +<li><strong>source</strong> – source string</li> +<li><strong>target</strong> – target substring</li> +</ul> +</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body"><p class="first">int4</p> +</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">strpos</span><span class="p">(</span><span class="s1">'tajo'</span><span class="p">,</span> <span class="s1">'aj'</span><span class="p">);</span> +<span class="o">></span> <span class="mi">2</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="substr"> +<tt class="descname">substr</tt><big>(</big><em>source text</em>, <em>start int4</em>, <em>length int4</em><big>)</big><a class="headerlink" href="#substr" title="Permalink to this definition">¶</a></dt> +<dd><p>Extract substring.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> +<li><strong>source</strong> – source string</li> +<li><strong>start</strong> – start index</li> +<li><strong>length</strong> – length of substring</li> +</ul> +</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body"><p class="first">text</p> +</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">substr</span><span class="p">(</span><span class="s1">'alphabet'</span><span class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span class="mi">2</span><span class="p">);</span> +<span class="o">></span> <span class="n">ph</span> </pre></div> </div> </dd></dl> <dl class="function"> <dt id="trim"> -<code class="descname">trim</code><span class="sig-paren">(</span><em>[leading | trailing | both] [characters] from string</em><span class="sig-paren">)</span><a class="headerlink" href="#trim" title="Permalink to this definition">¶</a></dt> -<dd><p>Removes the characters (a space by default) from the start/end/both ends of the string</p> +<tt class="descname">trim</tt><big>(</big><em>string text</em><span class="optional">[</span>, <em>characters text</em><span class="optional">]</span><big>)</big><a class="headerlink" href="#trim" title="Permalink to this definition">¶</a></dt> +<dd><p>Removes the characters (a space by default) from the start/end/both ends of the string.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> +<li><strong>string</strong> – input string</li> +<li><strong>characters</strong> – characters which will be removed</li> +</ul> +</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body"><p class="first">text</p> +</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="k">trim</span><span class="p">(</span><span class="s1">'xTajoxx'</span><span class="p">,</span> <span class="s1">'x'</span><span class="p">);</span> +<span class="o">></span> <span class="n">Tajo</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt> +<tt class="descname">trim</tt><big>(</big><em>[leading | trailing | both] [characters text] FROM string text</em><big>)</big></dt> +<dd><p>Removes the characters (a space by default) from the start/end/both ends of the string.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> <col class="field-body" /> <tbody valign="top"> <tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> -<li><strong>string</strong> – </li> -<li><strong>characters</strong> – </li> +<li><strong>string</strong> – input string</li> +<li><strong>characters</strong> – characters which will be removed</li> </ul> </td> </tr> @@ -278,23 +662,23 @@ </tr> </tbody> </table> -<div class="highlight-sql"><div class="highlight"><pre>select trim(both âxâ from âxTajoxxâ); -> Tajo +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="k">trim</span><span class="p">(</span><span class="k">both</span> <span class="s1">'x'</span> <span class="k">from</span> <span class="s1">'xTajoxx'</span><span class="p">);</span> +<span class="o">></span> <span class="n">Tajo</span> </pre></div> </div> </dd></dl> <dl class="function"> <dt id="btrim"> -<code class="descname">btrim</code><span class="sig-paren">(</span><em>string text</em><span class="optional">[</span>, <em>characters text</em><span class="optional">]</span><span class="sig-paren">)</span><a class="headerlink" href="#btrim" title="Permalink to this definition">¶</a></dt> -<dd><p>Removes the characters (a space by default) from the both ends of the string</p> +<tt class="descname">btrim</tt><big>(</big><em>string text</em><span class="optional">[</span>, <em>characters text</em><span class="optional">]</span><big>)</big><a class="headerlink" href="#btrim" title="Permalink to this definition">¶</a></dt> +<dd><p>Removes the characters (a space by default) from the both ends of the string.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> <col class="field-body" /> <tbody valign="top"> <tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> -<li><strong>string</strong> – </li> -<li><strong>characters</strong> – </li> +<li><strong>string</strong> – input string</li> +<li><strong>characters</strong> – characters which will be removed</li> </ul> </td> </tr> @@ -308,23 +692,23 @@ </tr> </tbody> </table> -<div class="highlight-sql"><div class="highlight"><pre>select btrim(âxTajoxxâ, âxâ); -> Tajo +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">btrim</span><span class="p">(</span><span class="s1">'xTajoxx'</span><span class="p">,</span> <span class="s1">'x'</span><span class="p">);</span> +<span class="o">></span> <span class="n">Tajo</span> </pre></div> </div> </dd></dl> <dl class="function"> <dt id="ltrim"> -<code class="descname">ltrim</code><span class="sig-paren">(</span><em>string text</em><span class="optional">[</span>, <em>characters text</em><span class="optional">]</span><span class="sig-paren">)</span><a class="headerlink" href="#ltrim" title="Permalink to this definition">¶</a></dt> -<dd><p>Removes the characters (a space by default) from the start ends of the string</p> +<tt class="descname">ltrim</tt><big>(</big><em>string text</em><span class="optional">[</span>, <em>characters text</em><span class="optional">]</span><big>)</big><a class="headerlink" href="#ltrim" title="Permalink to this definition">¶</a></dt> +<dd><p>Removes the characters (a space by default) from the start ends of the string.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> <col class="field-body" /> <tbody valign="top"> <tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> -<li><strong>string</strong> – </li> -<li><strong>characters</strong> – </li> +<li><strong>string</strong> – input string</li> +<li><strong>characters</strong> – characters which will be removed</li> </ul> </td> </tr> @@ -335,23 +719,23 @@ </tr> </tbody> </table> -<div class="highlight-sql"><div class="highlight"><pre>select ltrim(âxxTajoâ, âxâ); -> Tajo +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">ltrim</span><span class="p">(</span><span class="s1">'xxTajo'</span><span class="p">,</span> <span class="s1">'x'</span><span class="p">);</span> +<span class="o">></span> <span class="n">Tajo</span> </pre></div> </div> </dd></dl> <dl class="function"> <dt id="rtrim"> -<code class="descname">rtrim</code><span class="sig-paren">(</span><em>string text</em><span class="optional">[</span>, <em>characters text</em><span class="optional">]</span><span class="sig-paren">)</span><a class="headerlink" href="#rtrim" title="Permalink to this definition">¶</a></dt> -<dd><p>Removes the characters (a space by default) from the end ends of the string</p> +<tt class="descname">rtrim</tt><big>(</big><em>string text</em><span class="optional">[</span>, <em>characters text</em><span class="optional">]</span><big>)</big><a class="headerlink" href="#rtrim" title="Permalink to this definition">¶</a></dt> +<dd><p>Removes the characters (a space by default) from the end ends of the string.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> <col class="field-body" /> <tbody valign="top"> <tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> -<li><strong>string</strong> – </li> -<li><strong>characters</strong> – </li> +<li><strong>string</strong> – input string</li> +<li><strong>characters</strong> – characters which will be removed</li> </ul> </td> </tr> @@ -370,16 +754,16 @@ <dl class="function"> <dt id="split_part"> -<code class="descname">split_part</code><span class="sig-paren">(</span><em>string text</em>, <em>delimiter text</em>, <em>field int</em><span class="sig-paren">)</span><a class="headerlink" href="#split_part" title="Permalink to this definition">¶</a></dt> -<dd><p>Splits a string on delimiter and return the given field (counting from one)</p> +<tt class="descname">split_part</tt><big>(</big><em>string text</em>, <em>delimiter text</em>, <em>field int</em><big>)</big><a class="headerlink" href="#split_part" title="Permalink to this definition">¶</a></dt> +<dd><p>Splits a string on delimiter and return the given field (counting from one).</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> <col class="field-body" /> <tbody valign="top"> <tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> -<li><strong>string</strong> – </li> -<li><strong>delimiter</strong> – </li> -<li><strong>field</strong> – </li> +<li><strong>string</strong> – input string</li> +<li><strong>delimiter</strong> – delimiter</li> +<li><strong>field</strong> – index to field</li> </ul> </td> </tr> @@ -390,24 +774,24 @@ </tr> </tbody> </table> -<div class="highlight-sql"><div class="highlight"><pre>select split_part(âab_bc_cdâ,â_â,2); -> bc +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">split_part</span><span class="p">(</span><span class="s1">'ab_bc_cd'</span><span class="p">,</span><span class="s1">'_'</span><span class="p">,</span><span class="mi">2</span><span class="p">);</span> +<span class="o">></span> <span class="n">bc</span> </pre></div> </div> </dd></dl> <dl class="function"> <dt id="regexp_replace"> -<code class="descname">regexp_replace</code><span class="sig-paren">(</span><em>string text</em>, <em>pattern text</em>, <em>replacement text</em><span class="sig-paren">)</span><a class="headerlink" href="#regexp_replace" title="Permalink to this definition">¶</a></dt> -<dd><p>Replaces substrings matched to a given regular expression pattern</p> +<tt class="descname">regexp_replace</tt><big>(</big><em>string text</em>, <em>pattern text</em>, <em>replacement text</em><big>)</big><a class="headerlink" href="#regexp_replace" title="Permalink to this definition">¶</a></dt> +<dd><p>Replaces substrings matched to a given regular expression pattern.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> <col class="field-body" /> <tbody valign="top"> <tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> -<li><strong>string</strong> – </li> -<li><strong>pattern</strong> – </li> -<li><strong>replacement</strong> – </li> +<li><strong>string</strong> – input string</li> +<li><strong>pattern</strong> – pattern</li> +<li><strong>replacement</strong> – string substituted for the matching substring</li> </ul> </td> </tr> @@ -418,7 +802,7 @@ </tr> </tbody> </table> -<div class="highlight-sql"><div class="highlight"><pre>select regexp_replace(âabcdefâ, â(Ëab|ef$)â, âââ); +<div class="highlight-sql"><div class="highlight"><pre>select regexp_replace('abcdef', '(Ëab|ef$)', 'â'); > âcdâ </pre></div> </div> @@ -426,13 +810,13 @@ <dl class="function"> <dt id="upper"> -<code class="descname">upper</code><span class="sig-paren">(</span><em>string text</em><span class="sig-paren">)</span><a class="headerlink" href="#upper" title="Permalink to this definition">¶</a></dt> -<dd><p>makes an input text to be upper case</p> +<tt class="descname">upper</tt><big>(</big><em>string text</em><big>)</big><a class="headerlink" href="#upper" title="Permalink to this definition">¶</a></dt> +<dd><p>Makes an input text to be upper case.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> <col class="field-body" /> <tbody valign="top"> -<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><strong>string</strong> – </td> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><strong>string</strong> – input string</td> </tr> <tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body">text</td> </tr> @@ -448,13 +832,13 @@ <dl class="function"> <dt id="lower"> -<code class="descname">lower</code><span class="sig-paren">(</span><em>string text</em><span class="sig-paren">)</span><a class="headerlink" href="#lower" title="Permalink to this definition">¶</a></dt> -<dd><p>makes an input text to be lower case</p> +<tt class="descname">lower</tt><big>(</big><em>string text</em><big>)</big><a class="headerlink" href="#lower" title="Permalink to this definition">¶</a></dt> +<dd><p>Makes an input text to be lower case.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> <col class="field-body" /> <tbody valign="top"> -<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><strong>string</strong> – </td> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><strong>string</strong> – input string</td> </tr> <tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body">text</td> </tr> @@ -467,6 +851,133 @@ </pre></div> </div> </dd></dl> + +<dl class="function"> +<dt id="lpad"> +<tt class="descname">lpad</tt><big>(</big><em>source text</em>, <em>number int4</em>, <em>pad text</em><big>)</big><a class="headerlink" href="#lpad" title="Permalink to this definition">¶</a></dt> +<dd><p>Fill up the string to length by prepending the characters fill (a space by default). If the string is already longer than length then it is truncated (on the right).</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> +<li><strong>source</strong> – source string</li> +<li><strong>number</strong> – padding length</li> +<li><strong>pad</strong> – padding string</li> +</ul> +</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body"><p class="first">text</p> +</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">lpad</span><span class="p">(</span><span class="s1">'hi'</span><span class="p">,</span> <span class="mi">5</span><span class="p">,</span> <span class="s1">'xy'</span><span class="p">);</span> +<span class="o">></span> <span class="n">xyxhi</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="rpad"> +<tt class="descname">rpad</tt><big>(</big><em>source text</em>, <em>number int4</em>, <em>pad text</em><big>)</big><a class="headerlink" href="#rpad" title="Permalink to this definition">¶</a></dt> +<dd><p>Fill up the string to length length by appending the characters fill (a space by default). If the string is already longer than length then it is truncated.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> +<li><strong>source</strong> – source string</li> +<li><strong>number</strong> – padding length</li> +<li><strong>pad</strong> – padding string</li> +</ul> +</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body"><p class="first">text</p> +</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">rpad</span><span class="p">(</span><span class="s1">'hi'</span><span class="p">,</span> <span class="mi">5</span><span class="p">,</span> <span class="s1">'xy'</span><span class="p">);</span> +<span class="o">></span> <span class="n">hixyx</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="quote_ident"> +<tt class="descname">quote_ident</tt><big>(</big><em>string text</em><big>)</big><a class="headerlink" href="#quote_ident" title="Permalink to this definition">¶</a></dt> +<dd><p>Return the given string suitably quoted to be used as an identifier in an SQL statement string. Quotes are added only if necessary (i.e., if the string contains non-identifier characters or would be case-folded). Embedded quotes are properly doubled.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><strong>string</strong> – input string</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body">text</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">quote_ident</span><span class="p">(</span><span class="s1">'Foo bar'</span><span class="p">);</span> +<span class="o">></span> <span class="ss">"Foo bar"</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="repeat"> +<tt class="descname">repeat</tt><big>(</big><em>string text</em>, <em>number int4</em><big>)</big><a class="headerlink" href="#repeat" title="Permalink to this definition">¶</a></dt> +<dd><p>Repeat string the specified number of times.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple"> +<li><strong>string</strong> – input string</li> +<li><strong>number</strong> – repetition number</li> +</ul> +</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body"><p class="first">text</p> +</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">repeat</span><span class="p">(</span><span class="s1">'Pg'</span><span class="p">,</span> <span class="mi">4</span><span class="p">);</span> +<span class="o">></span> <span class="n">PgPgPgPg</span> +</pre></div> +</div> +</dd></dl> + +<dl class="function"> +<dt id="reverse"> +<tt class="descname">reverse</tt><big>(</big><em>string text</em><big>)</big><a class="headerlink" href="#reverse" title="Permalink to this definition">¶</a></dt> +<dd><p>Reverse string.</p> +<table class="docutils field-list" frame="void" rules="none"> +<col class="field-name" /> +<col class="field-body" /> +<tbody valign="top"> +<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><strong>string</strong> – input string</td> +</tr> +<tr class="field-even field"><th class="field-name">Return type:</th><td class="field-body">text</td> +</tr> +<tr class="field-odd field"><th class="field-name">Example:</th><td class="field-body"></td> +</tr> +</tbody> +</table> +<div class="highlight-sql"><div class="highlight"><pre><span class="k">select</span> <span class="n">reverse</span><span class="p">(</span><span class="s1">'TAJO'</span><span class="p">);</span> +<span class="o">></span> <span class="n">OJAT</span> +</pre></div> +</div> +</dd></dl> </div>
Modified: tajo/site/docs/devel/genindex.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/genindex.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/genindex.html (original) +++ tajo/site/docs/devel/genindex.html Tue Sep 1 06:42:40 2015 @@ -109,7 +109,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,19 @@ | <a href="#E"><strong>E</strong></a> | <a href="#F"><strong>F</strong></a> | <a href="#G"><strong>G</strong></a> + | <a href="#I"><strong>I</strong></a> | <a href="#J"><strong>J</strong></a> | <a href="#L"><strong>L</strong></a> | <a href="#M"><strong>M</strong></a> | <a href="#N"><strong>N</strong></a> + | <a href="#O"><strong>O</strong></a> | <a href="#P"><strong>P</strong></a> + | <a href="#Q"><strong>Q</strong></a> | <a href="#R"><strong>R</strong></a> | <a href="#S"><strong>S</strong></a> | <a href="#T"><strong>T</strong></a> | <a href="#U"><strong>U</strong></a> + | <a href="#V"><strong>V</strong></a> </div> <h2 id="A">A</h2> @@ -239,6 +245,10 @@ <dt><a href="functions/datetime_func_and_operators.html#add_months">add_months() (built-in function)</a> </dt> + + <dt><a href="functions/string_func_and_operators.html#ascii">ascii() (built-in function)</a> + </dt> + </dl></td> <td style="width: 33%" valign="top"><dl> @@ -253,6 +263,10 @@ <dt><a href="functions/math_func_and_operators.html#atan2">atan2() (built-in function)</a> </dt> + + <dt><a href="functions/agg_func.html#avg">avg() (built-in function)</a> + </dt> + </dl></td> </tr></table> @@ -260,6 +274,12 @@ <table style="width: 100%" class="indextable genindextable"><tr> <td style="width: 33%" valign="top"><dl> + <dt><a href="functions/string_func_and_operators.html#bit_length">bit_length() (built-in function)</a> + </dt> + + </dl></td> + <td style="width: 33%" valign="top"><dl> + <dt><a href="functions/string_func_and_operators.html#btrim">btrim() (built-in function)</a> </dt> @@ -281,6 +301,14 @@ <dt><a href="functions/string_func_and_operators.html#char_length">char_length() (built-in function)</a> </dt> + + <dt><a href="functions/string_func_and_operators.html#chr">chr() (built-in function)</a> + </dt> + + + <dt><a href="functions/agg_func.html#corr">corr() (built-in function)</a> + </dt> + </dl></td> <td style="width: 33%" valign="top"><dl> @@ -288,6 +316,10 @@ </dt> + <dt><a href="functions/agg_func.html#count">count() (built-in function)</a> + </dt> + + <dt><a href="functions/datetime_func_and_operators.html#current_date">current_date() (built-in function)</a> </dt> @@ -306,12 +338,20 @@ </dt> + <dt><a href="functions/string_func_and_operators.html#decode">decode() (built-in function)</a> + </dt> + + <dt><a href="functions/math_func_and_operators.html#degrees">degrees() (built-in function)</a> </dt> </dl></td> <td style="width: 33%" valign="top"><dl> + <dt><a href="functions/string_func_and_operators.html#digest">digest() (built-in function)</a> + </dt> + + <dt><a href="functions/math_func_and_operators.html#div">div() (built-in function)</a> </dt> @@ -322,6 +362,10 @@ <table style="width: 100%" class="indextable genindextable"><tr> <td style="width: 33%" valign="top"><dl> + <dt><a href="functions/string_func_and_operators.html#encode">encode() (built-in function)</a> + </dt> + + <dt><a href="functions/math_func_and_operators.html#exp">exp() (built-in function)</a> </dt> @@ -338,6 +382,12 @@ <table style="width: 100%" class="indextable genindextable"><tr> <td style="width: 33%" valign="top"><dl> + <dt><a href="functions/window_func.html#first_value">first_value() (built-in function)</a> + </dt> + + </dl></td> + <td style="width: 33%" valign="top"><dl> + <dt><a href="functions/math_func_and_operators.html#floor">floor() (built-in function)</a> </dt> @@ -360,10 +410,34 @@ </dl></td> </tr></table> +<h2 id="I">I</h2> +<table style="width: 100%" class="indextable genindextable"><tr> + <td style="width: 33%" valign="top"><dl> + + <dt><a href="functions/string_func_and_operators.html#initcap">initcap() (built-in function)</a> + </dt> + + </dl></td> +</tr></table> + <h2 id="J">J</h2> <table style="width: 100%" class="indextable genindextable"><tr> <td style="width: 33%" valign="top"><dl> + <dt><a href="functions/json_func.html#json_array_contains">json_array_contains() (built-in function)</a> + </dt> + + + <dt><a href="functions/json_func.html#json_array_get">json_array_get() (built-in function)</a> + </dt> + + </dl></td> + <td style="width: 33%" valign="top"><dl> + + <dt><a href="functions/json_func.html#json_array_length">json_array_length() (built-in function)</a> + </dt> + + <dt><a href="functions/json_func.html#json_extract_path_text">json_extract_path_text() (built-in function)</a> </dt> @@ -374,12 +448,36 @@ <table style="width: 100%" class="indextable genindextable"><tr> <td style="width: 33%" valign="top"><dl> - <dt><a href="functions/string_func_and_operators.html#lower">lower() (built-in function)</a> + <dt><a href="functions/window_func.html#lag">lag() (built-in function)</a> + </dt> + + + <dt><a href="functions/agg_func.html#last_value">last_value() (built-in function)</a>, <a href="functions/window_func.html#last_value">[1]</a> + </dt> + + + <dt><a href="functions/window_func.html#lead">lead() (built-in function)</a> + </dt> + + + <dt><a href="functions/string_func_and_operators.html#left">left() (built-in function)</a> </dt> </dl></td> <td style="width: 33%" valign="top"><dl> + <dt><a href="functions/string_func_and_operators.html#locate">locate() (built-in function)</a> + </dt> + + + <dt><a href="functions/string_func_and_operators.html#lower">lower() (built-in function)</a> + </dt> + + + <dt><a href="functions/string_func_and_operators.html#lpad">lpad() (built-in function)</a> + </dt> + + <dt><a href="functions/string_func_and_operators.html#ltrim">ltrim() (built-in function)</a> </dt> @@ -390,6 +488,20 @@ <table style="width: 100%" class="indextable genindextable"><tr> <td style="width: 33%" valign="top"><dl> + <dt><a href="functions/agg_func.html#max">max() (built-in function)</a> + </dt> + + + <dt><a href="functions/string_func_and_operators.html#md5">md5() (built-in function)</a> + </dt> + + </dl></td> + <td style="width: 33%" valign="top"><dl> + + <dt><a href="functions/agg_func.html#min">min() (built-in function)</a> + </dt> + + <dt><a href="functions/math_func_and_operators.html#mod">mod() (built-in function)</a> </dt> @@ -406,6 +518,16 @@ </dl></td> </tr></table> +<h2 id="O">O</h2> +<table style="width: 100%" class="indextable genindextable"><tr> + <td style="width: 33%" valign="top"><dl> + + <dt><a href="functions/string_func_and_operators.html#octet_length">octet_length() (built-in function)</a> + </dt> + + </dl></td> +</tr></table> + <h2 id="P">P</h2> <table style="width: 100%" class="indextable genindextable"><tr> <td style="width: 33%" valign="top"><dl> @@ -422,6 +544,16 @@ </dl></td> </tr></table> +<h2 id="Q">Q</h2> +<table style="width: 100%" class="indextable genindextable"><tr> + <td style="width: 33%" valign="top"><dl> + + <dt><a href="functions/string_func_and_operators.html#quote_ident">quote_ident() (built-in function)</a> + </dt> + + </dl></td> +</tr></table> + <h2 id="R">R</h2> <table style="width: 100%" class="indextable genindextable"><tr> <td style="width: 33%" valign="top"><dl> @@ -430,16 +562,44 @@ </dt> + <dt><a href="functions/math_func_and_operators.html#random">random() (built-in function)</a> + </dt> + + + <dt><a href="functions/window_func.html#rank">rank() (built-in function)</a> + </dt> + + <dt><a href="functions/string_func_and_operators.html#regexp_replace">regexp_replace() (built-in function)</a> </dt> + + <dt><a href="functions/string_func_and_operators.html#repeat">repeat() (built-in function)</a> + </dt> + + + <dt><a href="functions/string_func_and_operators.html#reverse">reverse() (built-in function)</a> + </dt> + </dl></td> <td style="width: 33%" valign="top"><dl> + <dt><a href="functions/string_func_and_operators.html#right">right() (built-in function)</a> + </dt> + + <dt><a href="functions/math_func_and_operators.html#round">round() (built-in function)</a> </dt> + <dt><a href="functions/window_func.html#row_number">row_number() (built-in function)</a> + </dt> + + + <dt><a href="functions/string_func_and_operators.html#rpad">rpad() (built-in function)</a> + </dt> + + <dt><a href="functions/string_func_and_operators.html#rtrim">rtrim() (built-in function)</a> </dt> @@ -457,8 +617,6 @@ <dt><a href="functions/math_func_and_operators.html#sin">sin() (built-in function)</a> </dt> - </dl></td> - <td style="width: 33%" valign="top"><dl> <dt><a href="functions/string_func_and_operators.html#split_part">split_part() (built-in function)</a> </dt> @@ -467,6 +625,28 @@ <dt><a href="functions/math_func_and_operators.html#sqrt">sqrt() (built-in function)</a> </dt> + + <dt><a href="functions/agg_func.html#stddev_pop">stddev_pop() (built-in function)</a> + </dt> + + </dl></td> + <td style="width: 33%" valign="top"><dl> + + <dt><a href="functions/agg_func.html#stddev_samp">stddev_samp() (built-in function)</a> + </dt> + + + <dt><a href="functions/string_func_and_operators.html#strposb">strposb() (built-in function)</a> + </dt> + + + <dt><a href="functions/string_func_and_operators.html#substr">substr() (built-in function)</a> + </dt> + + + <dt><a href="functions/agg_func.html#sum">sum() (built-in function)</a> + </dt> + </dl></td> </tr></table> @@ -478,7 +658,11 @@ </dt> - <dt><a href="functions/datetime_func_and_operators.html#to_char">to_char() (built-in function)</a> + <dt><a href="functions/data_type_func_and_operators.html#to_bin">to_bin() (built-in function)</a> + </dt> + + + <dt><a href="functions/datetime_func_and_operators.html#to_char">to_char() (built-in function)</a>, <a href="functions/data_type_func_and_operators.html#to_char">[1]</a> </dt> @@ -488,11 +672,15 @@ </dl></td> <td style="width: 33%" valign="top"><dl> + <dt><a href="functions/data_type_func_and_operators.html#to_hex">to_hex() (built-in function)</a> + </dt> + + <dt><a href="functions/datetime_func_and_operators.html#to_timestamp">to_timestamp() (built-in function)</a>, <a href="functions/datetime_func_and_operators.html#to_timestamp">[1]</a> </dt> - <dt><a href="functions/string_func_and_operators.html#trim">trim() (built-in function)</a> + <dt><a href="functions/string_func_and_operators.html#trim">trim() (built-in function)</a>, <a href="functions/string_func_and_operators.html#trim">[1]</a> </dt> </dl></td> @@ -512,6 +700,22 @@ </dt> </dl></td> +</tr></table> + +<h2 id="V">V</h2> +<table style="width: 100%" class="indextable genindextable"><tr> + <td style="width: 33%" valign="top"><dl> + + <dt><a href="functions/agg_func.html#var_pop">var_pop() (built-in function)</a> + </dt> + + </dl></td> + <td style="width: 33%" valign="top"><dl> + + <dt><a href="functions/agg_func.html#var_samp">var_samp() (built-in function)</a> + </dt> + + </dl></td> </tr></table> Modified: tajo/site/docs/devel/getting_started.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/getting_started.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/getting_started.html (original) +++ tajo/site/docs/devel/getting_started.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> @@ -209,7 +211,7 @@ <blockquote> <div><ul class="simple"> <li>Hadoop 2.3.0 or higher (up to 2.6.0)</li> -<li>Java 1.6 or 1.7</li> +<li>Java 1.7 or higher</li> <li>Protocol buffer 2.5.0</li> </ul> </div></blockquote> @@ -280,7 +282,7 @@ Download the file that ends in .tar.gz t </div> <div class="admonition warning"> <p class="first admonition-title">Warning</p> -<p class="last">By default, <em>Catalog server</em> which manages table meta data uses <a class="reference external" href="http://db.apache.org/derby/";>Apache Derby</a> as a persistent storage, and Derby stores data into <code class="docutils literal"><span class="pre">/tmp/tajo-catalog-${username}</span></code> directory. But, some operating systems may remove all contents in <code class="docutils literal"><span class="pre">/tmp</span></code> when booting up. In order to ensure persistent store of your catalog data, you need to set a proper location of derby directory. To learn Catalog configuration, please refer to <a class="reference internal" href="configuration/catalog_configuration.html"><em>Catalog Configuration</em></a>.</p> +<p class="last">By default, <em>Catalog server</em> which manages table meta data uses <a class="reference external" href="http://db.apache.org/derby/";>Apache Derby</a> as a persistent storage, and Derby stores data into <tt class="docutils literal"><span class="pre">/tmp/tajo-catalog-${username}</span></tt> directory. But, some operating systems may remove all contents in <tt class="docutils literal"><span class="pre">/tmp</span></tt> when booting up. In order to ensure persistent store of your catalog data, you need to set a proper location of derby directory. To learn Catalog configuration, please refer to <a class="reference internal" href="configuration/catalog_configuration.html"><em>Catalog Configuration</em></a>.</p> </div> </div> <div class="section" id="first-query-execution"> @@ -297,7 +299,7 @@ Download the file that ends in .tar.gz t <CTRL + D> </pre></div> </div> -<p>Apache Tajo⢠provides a SQL shell which allows users to interactively submit SQL queries. In order to use this shell, please execute <code class="docutils literal"><span class="pre">bin/tsql</span></code></p> +<p>Apache Tajo⢠provides a SQL shell which allows users to interactively submit SQL queries. In order to use this shell, please execute <tt class="docutils literal"><span class="pre">bin/tsql</span></tt></p> <div class="highlight-python"><div class="highlight"><pre>$ $TAJO_HOME/bin/tsql tajo> </pre></div> @@ -336,7 +338,7 @@ If the table resides in HDFS, you should type TEXT </pre></div> </div> -<p><code class="docutils literal"><span class="pre">\d</span> <span class="pre">[table</span> <span class="pre">name]</span></code> command shows the description of a given table.</p> +<p><tt class="docutils literal"><span class="pre">\d</span> <span class="pre">[table</span> <span class="pre">name]</span></tt> command shows the description of a given table.</p> <p>Also, you can execute SQL queries as follows:</p> <div class="highlight-python"><div class="highlight"><pre>tajo> select * from table1 where id > 2; final state: QUERY_SUCCEEDED, init time: 0.069 sec, response time: 0.397 sec Modified: tajo/site/docs/devel/hbase_integration.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/hbase_integration.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/hbase_integration.html (original) +++ tajo/site/docs/devel/hbase_integration.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> @@ -205,9 +207,9 @@ <h1>HBase Integration<a class="headerlink" href="#hbase-integration" title="Permalink to this headline">¶</a></h1> <p>Apache Tajo⢠storage supports integration with Apache HBaseâ¢. This integration allows Tajo to access all tables used in Apache HBase.</p> -<p>In order to use this feature, you need to build add some configs into <code class="docutils literal"><span class="pre">conf/tajo-env.sh</span></code> and then add some properties into a table create statement.</p> +<p>In order to use this feature, you need to build add some configs into <tt class="docutils literal"><span class="pre">conf/tajo-env.sh</span></tt> and then add some properties into a table create statement.</p> <p>This section describes how to setup HBase integration.</p> -<p>First, you need to set your HBase home directory to the environment variable <code class="docutils literal"><span class="pre">HBASE_HOME</span></code> in conf/tajo-env.sh as follows:</p> +<p>First, you need to set your HBase home directory to the environment variable <tt class="docutils literal"><span class="pre">HBASE_HOME</span></tt> in conf/tajo-env.sh as follows:</p> <div class="highlight-python"><div class="highlight"><pre>export HBASE_HOME=/path/to/your/hbase/directory </pre></div> </div> @@ -226,12 +228,12 @@ This integration allows Tajo to access a </div> <p>Options</p> <ul class="simple"> -<li><code class="docutils literal"><span class="pre">table</span></code> : Set hbase origin table name. If you want to create an external table, the table must exists on HBase. The other way, if you want to create a managed table, the table must doesn’t exist on HBase.</li> -<li><code class="docutils literal"><span class="pre">columns</span></code> : :key means HBase row key. The number of columns entry need to equals to the number of Tajo table column</li> -<li><code class="docutils literal"><span class="pre">hbase.zookeeper.quorum</span></code> : Set zookeeper quorum address. You can use different zookeeper cluster on the same Tajo database. If you don’t set the zookeeper address, Tajo will refer the property of hbase-site.xml file.</li> -<li><code class="docutils literal"><span class="pre">hbase.zookeeper.property.clientPort</span></code> : Set zookeeper client port. If you don’t set the port, Tajo will refer the property of hbase-site.xml file.</li> +<li><tt class="docutils literal"><span class="pre">table</span></tt> : Set hbase origin table name. If you want to create an external table, the table must exists on HBase. The other way, if you want to create a managed table, the table must doesn’t exist on HBase.</li> +<li><tt class="docutils literal"><span class="pre">columns</span></tt> : :key means HBase row key. The number of columns entry need to equals to the number of Tajo table column</li> +<li><tt class="docutils literal"><span class="pre">hbase.zookeeper.quorum</span></tt> : Set zookeeper quorum address. You can use different zookeeper cluster on the same Tajo database. If you don’t set the zookeeper address, Tajo will refer the property of hbase-site.xml file.</li> +<li><tt class="docutils literal"><span class="pre">hbase.zookeeper.property.clientPort</span></tt> : Set zookeeper client port. If you don’t set the port, Tajo will refer the property of hbase-site.xml file.</li> </ul> -<p><code class="docutils literal"><span class="pre">IF</span> <span class="pre">NOT</span> <span class="pre">EXISTS</span></code> allows <code class="docutils literal"><span class="pre">CREATE</span> <span class="pre">[EXTERNAL]</span> <span class="pre">TABLE</span></code> statement to avoid an error which occurs when the table does not exist.</p> +<p><tt class="docutils literal"><span class="pre">IF</span> <span class="pre">NOT</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">CREATE</span> <span class="pre">[EXTERNAL]</span> <span class="pre">TABLE</span></tt> statement to avoid an error which occurs when the table does not exist.</p> </div> <div class="section" id="drop-table"> <h2>DROP TABLE<a class="headerlink" href="#drop-table" title="Permalink to this headline">¶</a></h2> @@ -239,11 +241,11 @@ This integration allows Tajo to access a <div class="highlight-sql"><div class="highlight"><pre><span class="k">DROP</span> <span class="k">TABLE</span> <span class="p">[</span><span class="n">IF</span> <span class="k">EXISTS</span><span class="p">]</span> <span class="o"><</span><span class="k">table_name</span><span class="o">></span> <span class="p">[</span><span class="n">PURGE</span><span class="p">]</span> </pre></div> </div> -<p><code class="docutils literal"><span class="pre">IF</span> <span class="pre">EXISTS</span></code> allows <code class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></code> statement to avoid an error which occurs when the table does not exist. <code class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></code> statement removes a table from Tajo catalog, but it does not remove the contents on HBase cluster. If <code class="docutils literal"><span class="pre">PURGE</span></code> option is given, <code class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></code> statement will eliminate the entry in the catalog as well as the contents on HBase cluster.</p> +<p><tt class="docutils literal"><span class="pre">IF</span> <span class="pre">EXISTS</span></tt> allows <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></tt> statement to avoid an error which occurs when the table does not exist. <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></tt> statement removes a table from Tajo catalog, but it does not remove the contents on HBase cluster. If <tt class="docutils literal"><span class="pre">PURGE</span></tt> option is given, <tt class="docutils literal"><span class="pre">DROP</span> <span class="pre">TABLE</span></tt> statement will eliminate the entry in the catalog as well as the contents on HBase cluster.</p> </div> <div class="section" id="insert-overwrite-into"> <h2>INSERT (OVERWRITE) INTO<a class="headerlink" href="#insert-overwrite-into" title="Permalink to this headline">¶</a></h2> -<p>INSERT OVERWRITE statement overwrites a table data of an existing table. Tajo’s INSERT OVERWRITE statement follows <code class="docutils literal"><span class="pre">INSERT</span> <span class="pre">INTO</span> <span class="pre">SELECT</span></code> statement of SQL. The examples are as follows:</p> +<p>INSERT OVERWRITE statement overwrites a table data of an existing table. Tajo’s INSERT OVERWRITE statement follows <tt class="docutils literal"><span class="pre">INSERT</span> <span class="pre">INTO</span> <span class="pre">SELECT</span></tt> statement of SQL. The examples are as follows:</p> <div class="highlight-sql"><div class="highlight"><pre><span class="c1">-- when a target table schema and output schema are equivalent to each other</span> <span class="k">INSERT</span> <span class="n">OVERWRITE</span> <span class="k">INTO</span> <span class="n">t1</span> <span class="k">SELECT</span> <span class="n">l_orderkey</span><span class="p">,</span> <span class="n">l_partkey</span><span class="p">,</span> <span class="n">l_quantity</span> <span class="k">FROM</span> <span class="n">lineitem</span><span class="p">;</span> <span class="c1">-- or</span> @@ -284,7 +286,7 @@ put 'blog', 'jhkim-01', put 'blog', 'jhkim-01', 'info:date', '2014-10-22' </pre></div> </div> -<p>And then create the table and query the table meta data with <code class="docutils literal"><span class="pre">\d</span></code> option:</p> +<p>And then create the table and query the table meta data with <tt class="docutils literal"><span class="pre">\d</span></tt> option:</p> <div class="highlight-sql"><div class="highlight"><pre>default> \d blog; table name: default.blog Modified: tajo/site/docs/devel/hive_integration.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/hive_integration.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/hive_integration.html (original) +++ tajo/site/docs/devel/hive_integration.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> @@ -208,10 +210,10 @@ This integration allows Tajo to access a Depending on your purpose, you can execute either SQL queries or HiveQL queries on the same tables managed in Apache Hive.</p> <p>In order to use this feature, you need to build Tajo with a specified maven profile -and then add some configs into <code class="docutils literal"><span class="pre">conf/tajo-env.sh</span></code> and <code class="docutils literal"><span class="pre">conf/catalog-site.xml</span></code>. +and then add some configs into <tt class="docutils literal"><span class="pre">conf/tajo-env.sh</span></tt> and <tt class="docutils literal"><span class="pre">conf/catalog-site.xml</span></tt>. This section describes how to setup HiveMetaStore integration. This instruction would take no more than five minutes.</p> -<p>You need to set your Hive home directory to the environment variable <code class="docutils literal"><span class="pre">HIVE_HOME</span></code> in conf/tajo-env.sh as follows:</p> +<p>You need to set your Hive home directory to the environment variable <tt class="docutils literal"><span class="pre">HIVE_HOME</span></tt> in conf/tajo-env.sh as follows:</p> <div class="highlight-python"><div class="highlight"><pre>export HIVE_HOME=/path/to/your/hive/directory </pre></div> </div> @@ -220,7 +222,7 @@ Next, you should set the path of MySQL J <div class="highlight-python"><div class="highlight"><pre>export HIVE_JDBC_DRIVER_DIR==/path/to/your/mysql_jdbc_driver/mysql-connector-java-x.x.x-bin.jar </pre></div> </div> -<p>Finally, you should specify HiveCatalogStore as Tajo catalog driver class in <code class="docutils literal"><span class="pre">conf/catalog-site.xml</span></code> as follows:</p> +<p>Finally, you should specify HiveCatalogStore as Tajo catalog driver class in <tt class="docutils literal"><span class="pre">conf/catalog-site.xml</span></tt> as follows:</p> <div class="highlight-python"><div class="highlight"><pre><property> <name>tajo.catalog.store.class</name> <value>org.apache.tajo.catalog.store.HiveCatalogStore</value> @@ -231,10 +233,10 @@ Next, you should set the path of MySQL J <p class="first admonition-title">Note</p> <p>Hive stores a list of partitions for each table in its metastore. If new partitions are directly added to HDFS, HiveMetastore will not able aware of these partitions unless the user -<code class="docutils literal"><span class="pre">ALTER</span> <span class="pre">TABLE</span> <span class="pre">table_name</span> <span class="pre">ADD</span> <span class="pre">PARTITION</span></code> commands on each of the newly added partitions or -<code class="docutils literal"><span class="pre">MSCK</span> <span class="pre">REPAIR</span> <span class="pre">TABLE</span> <span class="pre">table_name</span></code> command.</p> -<p>But current tajo doesn’t provide <code class="docutils literal"><span class="pre">ADD</span> <span class="pre">PARTITION</span></code> command and hive doesn’t provide an api for -responding to <code class="docutils literal"><span class="pre">MSK</span> <span class="pre">REPAIR</span> <span class="pre">TABLE</span></code> command. Thus, if you insert data to hive partitioned +<tt class="docutils literal"><span class="pre">ALTER</span> <span class="pre">TABLE</span> <span class="pre">table_name</span> <span class="pre">ADD</span> <span class="pre">PARTITION</span></tt> commands on each of the newly added partitions or +<tt class="docutils literal"><span class="pre">MSCK</span> <span class="pre">REPAIR</span> <span class="pre">TABLE</span> <span class="pre">table_name</span></tt> command.</p> +<p>But current tajo doesn’t provide <tt class="docutils literal"><span class="pre">ADD</span> <span class="pre">PARTITION</span></tt> command and hive doesn’t provide an api for +responding to <tt class="docutils literal"><span class="pre">MSK</span> <span class="pre">REPAIR</span> <span class="pre">TABLE</span></tt> command. Thus, if you insert data to hive partitioned table and you want to scan the updated partitions through Tajo, you must run following command on hive</p> <div class="last highlight-python"><div class="highlight"><pre>$ MSCK REPAIR TABLE [table_name]; </pre></div> Modified: tajo/site/docs/devel/index.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/index.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/index.html (original) +++ tajo/site/docs/devel/index.html Tue Sep 1 06:42:40 2015 @@ -109,7 +109,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> @@ -339,7 +341,7 @@ As a result, some contents can be mismat <li class="toctree-l2"><a class="reference internal" href="sql_language/sql_expression.html">SQL Expressions</a><ul> <li class="toctree-l3"><a class="reference internal" href="sql_language/sql_expression.html#arithmetic-expressions">Arithmetic Expressions</a></li> <li class="toctree-l3"><a class="reference internal" href="sql_language/sql_expression.html#type-casts">Type Casts</a></li> -<li class="toctree-l3"><a class="reference internal" href="sql_language/sql_expression.html#string-expressions">String Expressions</a></li> +<li class="toctree-l3"><a class="reference internal" href="sql_language/sql_expression.html#string-constants">String Constants</a></li> <li class="toctree-l3"><a class="reference internal" href="sql_language/sql_expression.html#function-call">Function Call</a></li> </ul> </li> @@ -359,7 +361,8 @@ As a result, some contents can be mismat </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><ul> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-scalar-functions">Built-in Scalar Functions</a><ul> +<li class="toctree-l3"><a class="reference internal" href="functions/data_type_func_and_operators.html">Data Type Functions and Operators</a></li> <li class="toctree-l3"><a class="reference internal" href="functions/math_func_and_operators.html">Math Functions and Operators</a></li> <li class="toctree-l3"><a class="reference internal" href="functions/string_func_and_operators.html">String Functions and Operators</a></li> <li class="toctree-l3"><a class="reference internal" href="functions/datetime_func_and_operators.html">DateTime Functions and Operators</a></li> @@ -367,6 +370,14 @@ As a result, some contents can be mismat <li class="toctree-l3"><a class="reference internal" href="functions/json_func.html">JSON Functions</a></li> </ul> </li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-aggregation-functions">Built-in Aggregation Functions</a><ul> +<li class="toctree-l3"><a class="reference internal" href="functions/agg_func.html">Aggregation Functions</a></li> +</ul> +</li> +<li class="toctree-l2"><a class="reference internal" href="functions.html#built-in-window-functions">Built-in Window Functions</a><ul> +<li class="toctree-l3"><a class="reference internal" href="functions/window_func.html">Window Functions</a></li> +</ul> +</li> <li class="toctree-l2"><a class="reference internal" href="functions.html#user-defined-functions">User-defined Functions</a><ul> <li class="toctree-l3"><a class="reference internal" href="functions/python.html">Python Functions</a></li> </ul> @@ -474,9 +485,9 @@ As a result, some contents can be mismat <div class="section" id="indices-and-tables"> <h1>Indices and tables<a class="headerlink" href="#indices-and-tables" title="Permalink to this headline">¶</a></h1> <ul class="simple"> -<li><a class="reference internal" href="genindex.html"><span>Index</span></a></li> -<li><a class="reference internal" href="py-modindex.html"><span>Module Index</span></a></li> -<li><a class="reference internal" href="search.html"><span>Search Page</span></a></li> +<li><a class="reference internal" href="genindex.html"><em>Index</em></a></li> +<li><a class="reference internal" href="py-modindex.html"><em>Module Index</em></a></li> +<li><a class="reference internal" href="search.html"><em>Search Page</em></a></li> </ul> </div> Modified: tajo/site/docs/devel/index/future_work.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/index/future_work.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/index/future_work.html (original) +++ tajo/site/docs/devel/index/future_work.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/index/how_to_use.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/index/how_to_use.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/index/how_to_use.html (original) +++ tajo/site/docs/devel/index/how_to_use.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/index/types.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/index/types.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/index/types.html (original) +++ tajo/site/docs/devel/index/types.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> @@ -206,7 +208,7 @@ <div class="section" id="index-types"> <h1>Index Types<a class="headerlink" href="#index-types" title="Permalink to this headline">¶</a></h1> -<p>Currently, Tajo supports only one type of index, <code class="docutils literal"><span class="pre">TWO_LEVEL_BIN_TREE</span></code>, shortly <code class="docutils literal"><span class="pre">BST</span></code>. The BST index is a kind of binary search tree which is extended to be permanently stored on disk. It consists of two levels of nodes; a leaf node indexes the keys with the positions of data in an HDFS block and a root node indexes the keys with the leaf node indices.</p> +<p>Currently, Tajo supports only one type of index, <tt class="docutils literal"><span class="pre">TWO_LEVEL_BIN_TREE</span></tt>, shortly <tt class="docutils literal"><span class="pre">BST</span></tt>. The BST index is a kind of binary search tree which is extended to be permanently stored on disk. It consists of two levels of nodes; a leaf node indexes the keys with the positions of data in an HDFS block and a root node indexes the keys with the leaf node indices.</p> <p>When an index scan is started, the query engine first reads the root node and finds the search key. If it finds a leaf node corresponding to the search key, it subsequently finds the search key in that leaf node. Finally, it directly reads a tuple corresponding to the search key from HDFS.</p> </div> Modified: tajo/site/docs/devel/index_overview.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/index_overview.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/index_overview.html (original) +++ tajo/site/docs/devel/index_overview.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> @@ -204,7 +206,7 @@ <div class="section" id="index-experimental-feature"> <h1>Index (Experimental Feature)<a class="headerlink" href="#index-experimental-feature" title="Permalink to this headline">¶</a></h1> <p>An index is a data structure that is used for efficient query processing. Using an index, the Tajo query engine can directly retrieve search values.</p> -<p>This is still an experimental feature. In order to use indexes, you must check out the source code of the <code class="docutils literal"><span class="pre">index_support</span></code> branch:</p> +<p>This is still an experimental feature. In order to use indexes, you must check out the source code of the <tt class="docutils literal"><span class="pre">index_support</span></tt> branch:</p> <div class="highlight-python"><div class="highlight"><pre>git clone -b index_support https://git-wip-us.apache.org/repos/asf/tajo.git tajo-index </pre></div> </div> Modified: tajo/site/docs/devel/introduction.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/introduction.html?rev=1700399&r1=1700398&r2=1700399&view=diff ============================================================================== --- tajo/site/docs/devel/introduction.html (original) +++ tajo/site/docs/devel/introduction.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>
