Modified: tajo/site/docs/devel/functions/data_type_func_and_operators.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/functions/data_type_func_and_operators.html?rev=1706954&r1=1706953&r2=1706954&view=diff ============================================================================== --- tajo/site/docs/devel/functions/data_type_func_and_operators.html (original) +++ tajo/site/docs/devel/functions/data_type_func_and_operators.html Tue Oct 6 06:44:17 2015 @@ -164,6 +164,8 @@ <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -209,7 +211,7 @@ <h1>Data Type Functions and Operators<a class="headerlink" href="#data-type-functions-and-operators" title="Permalink to this headline">¶</a></h1> <dl class="function"> <dt id="to_bin"> -<tt class="descname">to_bin</tt><big>(</big><em>source int4</em><big>)</big><a class="headerlink" href="#to_bin" title="Permalink to this definition">¶</a></dt> +<code class="descname">to_bin</code><span class="sig-paren">(</span><em>source int4</em><span class="sig-paren">)</span><a class="headerlink" href="#to_bin" title="Permalink to this definition">¶</a></dt> <dd><p>Returns the binary representation of integer.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -231,7 +233,7 @@ <dl class="function"> <dt id="to_char"> -<tt class="descname">to_char</tt><big>(</big><em>source int8</em>, <em>format text</em><big>)</big><a class="headerlink" href="#to_char" title="Permalink to this definition">¶</a></dt> +<code class="descname">to_char</code><span class="sig-paren">(</span><em>source int8</em>, <em>format text</em><span class="sig-paren">)</span><a class="headerlink" href="#to_char" title="Permalink to this definition">¶</a></dt> <dd><p>Convert integer to string.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -258,7 +260,7 @@ <dl class="function"> <dt id="to_hex"> -<tt class="descname">to_hex</tt><big>(</big><em>source int4</em><big>)</big><a class="headerlink" href="#to_hex" title="Permalink to this definition">¶</a></dt> +<code class="descname">to_hex</code><span class="sig-paren">(</span><em>source int4</em><span class="sig-paren">)</span><a class="headerlink" href="#to_hex" title="Permalink to this definition">¶</a></dt> <dd><p>Convert the argument to hexadecimal.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" />
Modified: tajo/site/docs/devel/functions/datetime_func_and_operators.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/functions/datetime_func_and_operators.html?rev=1706954&r1=1706953&r2=1706954&view=diff ============================================================================== --- tajo/site/docs/devel/functions/datetime_func_and_operators.html (original) +++ tajo/site/docs/devel/functions/datetime_func_and_operators.html Tue Oct 6 06:44:17 2015 @@ -164,6 +164,8 @@ <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -214,7 +216,7 @@ </div></blockquote> <dl class="function"> <dt id="add_days"> -<tt class="descname">add_days</tt><big>(</big><em>date date|timestamp</em>, <em>day int</em><big>)</big><a class="headerlink" href="#add_days" title="Permalink to this definition">¶</a></dt> +<code class="descname">add_days</code><span class="sig-paren">(</span><em>date date|timestamp</em>, <em>day int</em><span class="sig-paren">)</span><a class="headerlink" href="#add_days" title="Permalink to this definition">¶</a></dt> <dd><p>Returns date value which is added with given day parameter.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -244,7 +246,7 @@ <dl class="function"> <dt id="add_months"> -<tt class="descname">add_months</tt><big>(</big><em>date date|timestamp</em>, <em>month int</em><big>)</big><a class="headerlink" href="#add_months" title="Permalink to this definition">¶</a></dt> +<code class="descname">add_months</code><span class="sig-paren">(</span><em>date date|timestamp</em>, <em>month int</em><span class="sig-paren">)</span><a class="headerlink" href="#add_months" title="Permalink to this definition">¶</a></dt> <dd><p>Returns date value which is added with given month parameter.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -271,7 +273,7 @@ <dl class="function"> <dt id="current_date"> -<tt class="descname">current_date</tt><big>(</big><big>)</big><a class="headerlink" href="#current_date" title="Permalink to this definition">¶</a></dt> +<code class="descname">current_date</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#current_date" title="Permalink to this definition">¶</a></dt> <dd><p>Returns current date.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -289,7 +291,7 @@ <dl class="function"> <dt id="current_time"> -<tt class="descname">current_time</tt><big>(</big><big>)</big><a class="headerlink" href="#current_time" title="Permalink to this definition">¶</a></dt> +<code class="descname">current_time</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#current_time" title="Permalink to this definition">¶</a></dt> <dd><p>Returns current time.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -307,7 +309,7 @@ <dl class="function"> <dt id="extract"> -<tt class="descname">extract</tt><big>(</big><em>field FROM source date|timestamp|time</em><big>)</big><a class="headerlink" href="#extract" title="Permalink to this definition">¶</a></dt> +<code class="descname">extract</code><span class="sig-paren">(</span><em>field FROM source date|timestamp|time</em><span class="sig-paren">)</span><a class="headerlink" href="#extract" title="Permalink to this definition">¶</a></dt> <dd><p>The extract function retrieves subfields such as year or hour from date/time values. <em>source</em> must be a value expression of type <em>timestamp</em>, or <em>time</em>. (Expressions of type <em>date</em> are cast to <em>timestamp</em> and can therefore be used as well.) <em>field</em> is an identifier that selects what field to extract from the source value. The extract function returns values of type double precision. The following are valid field names:</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -438,7 +440,7 @@ <dl class="function"> <dt id="date_part"> -<tt class="descname">date_part</tt><big>(</big><em>field text</em>, <em>source date|timestamp|time</em><big>)</big><a class="headerlink" href="#date_part" title="Permalink to this definition">¶</a></dt> +<code class="descname">date_part</code><span class="sig-paren">(</span><em>field text</em>, <em>source date|timestamp|time</em><span class="sig-paren">)</span><a class="headerlink" href="#date_part" title="Permalink to this definition">¶</a></dt> <dd><p>Note that here the field parameter needs to be a string value, not a name. The valid field names for date_part are the same as for extract.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -463,7 +465,7 @@ <dl class="function"> <dt id="now"> -<tt class="descname">now</tt><big>(</big><big>)</big><a class="headerlink" href="#now" title="Permalink to this definition">¶</a></dt> +<code class="descname">now</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#now" title="Permalink to this definition">¶</a></dt> <dd><p>Returns current timestamp</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -483,7 +485,7 @@ <dl class="function"> <dt id="to_char"> -<tt class="descname">to_char</tt><big>(</big><em>src timestamp</em>, <em>format text</em><big>)</big><a class="headerlink" href="#to_char" title="Permalink to this definition">¶</a></dt> +<code class="descname">to_char</code><span class="sig-paren">(</span><em>src timestamp</em>, <em>format text</em><span class="sig-paren">)</span><a class="headerlink" href="#to_char" title="Permalink to this definition">¶</a></dt> <dd><p>Converts timestamp to text. For more detailed, see ‘Date/Time Formatting and Conversion’ section below.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -508,7 +510,7 @@ <dl class="function"> <dt id="to_date"> -<tt class="descname">to_date</tt><big>(</big><em>src text</em>, <em>format text</em><big>)</big><a class="headerlink" href="#to_date" title="Permalink to this definition">¶</a></dt> +<code class="descname">to_date</code><span class="sig-paren">(</span><em>src text</em>, <em>format text</em><span class="sig-paren">)</span><a class="headerlink" href="#to_date" title="Permalink to this definition">¶</a></dt> <dd><p>Converts text to date. For more detailed, see ‘Date/Time Formatting and Conversion’ section below.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -533,7 +535,7 @@ <dl class="function"> <dt id="to_timestamp"> -<tt class="descname">to_timestamp</tt><big>(</big><em>epoch int</em><big>)</big><a class="headerlink" href="#to_timestamp" title="Permalink to this definition">¶</a></dt> +<code class="descname">to_timestamp</code><span class="sig-paren">(</span><em>epoch int</em><span class="sig-paren">)</span><a class="headerlink" href="#to_timestamp" title="Permalink to this definition">¶</a></dt> <dd><p>Converts int(UNIX epoch) to timestamp.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -553,7 +555,7 @@ <dl class="function"> <dt> -<tt class="descname">to_timestamp</tt><big>(</big><em>src text</em>, <em>format text</em><big>)</big></dt> +<code class="descname">to_timestamp</code><span class="sig-paren">(</span><em>src text</em>, <em>format text</em><span class="sig-paren">)</span></dt> <dd><p>Converts text timestamp. For more detailed, see ‘Date/Time Formatting and Conversion’ section below.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -578,7 +580,7 @@ <dl class="function"> <dt id="utc_usec_to"> -<tt class="descname">utc_usec_to</tt><big>(</big><em>string text</em>, <em>timestamp long</em>, <em>dayOfWeek int</em><big>)</big><a class="headerlink" href="#utc_usec_to" title="Permalink to this definition">¶</a></dt> +<code class="descname">utc_usec_to</code><span class="sig-paren">(</span><em>string text</em>, <em>timestamp long</em>, <em>dayOfWeek int</em><span class="sig-paren">)</span><a class="headerlink" href="#utc_usec_to" title="Permalink to this definition">¶</a></dt> <dd><ul> <li><p class="first">If the <strong>first parameter</strong> is ‘day’.</p> <p>Shifts and return a UNIX timestamp in microseconds to the beginning of the day it occurs in. Modified: tajo/site/docs/devel/functions/json_func.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/functions/json_func.html?rev=1706954&r1=1706953&r2=1706954&view=diff ============================================================================== --- tajo/site/docs/devel/functions/json_func.html (original) +++ tajo/site/docs/devel/functions/json_func.html Tue Oct 6 06:44:17 2015 @@ -164,6 +164,8 @@ <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -209,7 +211,7 @@ <h1>JSON Functions<a class="headerlink" href="#json-functions" title="Permalink to this headline">¶</a></h1> <dl class="function"> <dt id="json_extract_path_text"> -<tt class="descname">json_extract_path_text</tt><big>(</big><em>json text</em>, <em>json_path text</em><big>)</big><a class="headerlink" href="#json_extract_path_text" title="Permalink to this definition">¶</a></dt> +<code class="descname">json_extract_path_text</code><span class="sig-paren">(</span><em>json text</em>, <em>json_path text</em><span class="sig-paren">)</span><a class="headerlink" href="#json_extract_path_text" title="Permalink to this definition">¶</a></dt> <dd><p>Extracts JSON string from a JSON string based on json path specified and returns JSON string pointed to by JSONPath. Returns null if either argument is null.</p> <table class="docutils field-list" frame="void" rules="none"> @@ -237,7 +239,7 @@ Returns null if either argument is null. <dl class="function"> <dt id="json_array_get"> -<tt class="descname">json_array_get</tt><big>(</big><em>json_array text</em>, <em>index int4</em><big>)</big><a class="headerlink" href="#json_array_get" title="Permalink to this definition">¶</a></dt> +<code class="descname">json_array_get</code><span class="sig-paren">(</span><em>json_array text</em>, <em>index int4</em><span class="sig-paren">)</span><a class="headerlink" href="#json_array_get" title="Permalink to this definition">¶</a></dt> <dd><p>Returns the element at the specified index into the JSON array. This function returns an element indexed from the end of an array with a negative index, and null if the element at the specified index doesnât exist.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -267,7 +269,7 @@ Returns null if either argument is null. <dl class="function"> <dt id="json_array_contains"> -<tt class="descname">json_array_contains</tt><big>(</big><em>json_array text</em>, <em>value any</em><big>)</big><a class="headerlink" href="#json_array_contains" title="Permalink to this definition">¶</a></dt> +<code class="descname">json_array_contains</code><span class="sig-paren">(</span><em>json_array text</em>, <em>value any</em><span class="sig-paren">)</span><a class="headerlink" href="#json_array_contains" title="Permalink to this definition">¶</a></dt> <dd><p>Determine if the given value exists in the JSON array.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -294,7 +296,7 @@ Returns null if either argument is null. <dl class="function"> <dt id="json_array_length"> -<tt class="descname">json_array_length</tt><big>(</big><em>json_array text</em><big>)</big><a class="headerlink" href="#json_array_length" title="Permalink to this definition">¶</a></dt> +<code class="descname">json_array_length</code><span class="sig-paren">(</span><em>json_array text</em><span class="sig-paren">)</span><a class="headerlink" href="#json_array_length" title="Permalink to this definition">¶</a></dt> <dd><p>Returns the length of json array.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> Modified: tajo/site/docs/devel/functions/math_func_and_operators.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/functions/math_func_and_operators.html?rev=1706954&r1=1706953&r2=1706954&view=diff ============================================================================== --- tajo/site/docs/devel/functions/math_func_and_operators.html (original) +++ tajo/site/docs/devel/functions/math_func_and_operators.html Tue Oct 6 06:44:17 2015 @@ -164,6 +164,8 @@ <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -209,7 +211,7 @@ <h1>Math Functions and Operators<a class="headerlink" href="#math-functions-and-operators" title="Permalink to this headline">¶</a></h1> <dl class="function"> <dt id="abs"> -<tt class="descname">abs</tt><big>(</big><em>number int|float</em><big>)</big><a class="headerlink" href="#abs" title="Permalink to this definition">¶</a></dt> +<code class="descname">abs</code><span class="sig-paren">(</span><em>number int|float</em><span class="sig-paren">)</span><a class="headerlink" href="#abs" title="Permalink to this definition">¶</a></dt> <dd><p>Returns absolute value</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -231,7 +233,7 @@ <dl class="function"> <dt id="acos"> -<tt class="descname">acos</tt><big>(</big><em>number float</em><big>)</big><a class="headerlink" href="#acos" title="Permalink to this definition">¶</a></dt> +<code class="descname">acos</code><span class="sig-paren">(</span><em>number float</em><span class="sig-paren">)</span><a class="headerlink" href="#acos" title="Permalink to this definition">¶</a></dt> <dd><p>Returns the arc cosine of number value</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -253,7 +255,7 @@ <dl class="function"> <dt id="asin"> -<tt class="descname">asin</tt><big>(</big><em>number float</em><big>)</big><a class="headerlink" href="#asin" title="Permalink to this definition">¶</a></dt> +<code class="descname">asin</code><span class="sig-paren">(</span><em>number float</em><span class="sig-paren">)</span><a class="headerlink" href="#asin" title="Permalink to this definition">¶</a></dt> <dd><p>Returns the arc sine of number value</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -275,7 +277,7 @@ <dl class="function"> <dt id="atan"> -<tt class="descname">atan</tt><big>(</big><em>number float8</em><big>)</big><a class="headerlink" href="#atan" title="Permalink to this definition">¶</a></dt> +<code class="descname">atan</code><span class="sig-paren">(</span><em>number float8</em><span class="sig-paren">)</span><a class="headerlink" href="#atan" title="Permalink to this definition">¶</a></dt> <dd><p>Returns the arc tangent of number value</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -297,7 +299,7 @@ <dl class="function"> <dt id="atan2"> -<tt class="descname">atan2</tt><big>(</big><em>y float</em>, <em>x float</em><big>)</big><a class="headerlink" href="#atan2" title="Permalink to this definition">¶</a></dt> +<code class="descname">atan2</code><span class="sig-paren">(</span><em>y float</em>, <em>x float</em><span class="sig-paren">)</span><a class="headerlink" href="#atan2" title="Permalink to this definition">¶</a></dt> <dd><p>Returns the angle theta from the conversion of rectangular coordinates (x, y) to polar coordinates (r, theta)</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -324,7 +326,7 @@ <dl class="function"> <dt id="cbrt"> -<tt class="descname">cbrt</tt><big>(</big><em>number float</em><big>)</big><a class="headerlink" href="#cbrt" title="Permalink to this definition">¶</a></dt> +<code class="descname">cbrt</code><span class="sig-paren">(</span><em>number float</em><span class="sig-paren">)</span><a class="headerlink" href="#cbrt" title="Permalink to this definition">¶</a></dt> <dd><p>Returns the cube root of a number</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -346,7 +348,7 @@ <dl class="function"> <dt id="ceil"> -<tt class="descname">ceil</tt><big>(</big><em>number float</em><big>)</big><a class="headerlink" href="#ceil" title="Permalink to this definition">¶</a></dt> +<code class="descname">ceil</code><span class="sig-paren">(</span><em>number float</em><span class="sig-paren">)</span><a class="headerlink" href="#ceil" title="Permalink to this definition">¶</a></dt> <dd><p>Returns a smallest integer not less than argument</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -370,7 +372,7 @@ <dl class="function"> <dt id="cos"> -<tt class="descname">cos</tt><big>(</big><em>number float</em><big>)</big><a class="headerlink" href="#cos" title="Permalink to this definition">¶</a></dt> +<code class="descname">cos</code><span class="sig-paren">(</span><em>number float</em><span class="sig-paren">)</span><a class="headerlink" href="#cos" title="Permalink to this definition">¶</a></dt> <dd><p>Returns the cosine of a number</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -392,7 +394,7 @@ <dl class="function"> <dt id="degrees"> -<tt class="descname">degrees</tt><big>(</big><em>number float</em><big>)</big><a class="headerlink" href="#degrees" title="Permalink to this definition">¶</a></dt> +<code class="descname">degrees</code><span class="sig-paren">(</span><em>number float</em><span class="sig-paren">)</span><a class="headerlink" href="#degrees" title="Permalink to this definition">¶</a></dt> <dd><p>Converts radians to degrees</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -414,7 +416,7 @@ <dl class="function"> <dt id="div"> -<tt class="descname">div</tt><big>(</big><em>num1 int</em>, <em>num2 int</em><big>)</big><a class="headerlink" href="#div" title="Permalink to this definition">¶</a></dt> +<code class="descname">div</code><span class="sig-paren">(</span><em>num1 int</em>, <em>num2 int</em><span class="sig-paren">)</span><a class="headerlink" href="#div" title="Permalink to this definition">¶</a></dt> <dd><p>Integer division truncates resut</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -441,7 +443,7 @@ <dl class="function"> <dt id="exp"> -<tt class="descname">exp</tt><big>(</big><em>number float</em><big>)</big><a class="headerlink" href="#exp" title="Permalink to this definition">¶</a></dt> +<code class="descname">exp</code><span class="sig-paren">(</span><em>number float</em><span class="sig-paren">)</span><a class="headerlink" href="#exp" title="Permalink to this definition">¶</a></dt> <dd><p>Returns Euler’s number e raised to the power of a number</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -463,7 +465,7 @@ <dl class="function"> <dt id="floor"> -<tt class="descname">floor</tt><big>(</big><em>number float</em><big>)</big><a class="headerlink" href="#floor" title="Permalink to this definition">¶</a></dt> +<code class="descname">floor</code><span class="sig-paren">(</span><em>number float</em><span class="sig-paren">)</span><a class="headerlink" href="#floor" title="Permalink to this definition">¶</a></dt> <dd><p>Returns a largest integer not greater than argument</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -485,7 +487,7 @@ <dl class="function"> <dt id="mod"> -<tt class="descname">mod</tt><big>(</big><em>num1 int</em>, <em>num2 int</em><big>)</big><a class="headerlink" href="#mod" title="Permalink to this definition">¶</a></dt> +<code class="descname">mod</code><span class="sig-paren">(</span><em>num1 int</em>, <em>num2 int</em><span class="sig-paren">)</span><a class="headerlink" href="#mod" title="Permalink to this definition">¶</a></dt> <dd><p>Returns remainder of num1 / num2</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -512,7 +514,7 @@ <dl class="function"> <dt id="pi"> -<tt class="descname">pi</tt><big>(</big><big>)</big><a class="headerlink" href="#pi" title="Permalink to this definition">¶</a></dt> +<code class="descname">pi</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#pi" title="Permalink to this definition">¶</a></dt> <dd><p>Returns constant value of pi</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -532,7 +534,7 @@ <dl class="function"> <dt id="pow"> -<tt class="descname">pow</tt><big>(</big><em>x float</em>, <em>y float</em><big>)</big><a class="headerlink" href="#pow" title="Permalink to this definition">¶</a></dt> +<code class="descname">pow</code><span class="sig-paren">(</span><em>x float</em>, <em>y float</em><span class="sig-paren">)</span><a class="headerlink" href="#pow" title="Permalink to this definition">¶</a></dt> <dd><p>Returns value of x raised to the power of y</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -559,7 +561,7 @@ <dl class="function"> <dt id="radians"> -<tt class="descname">radians</tt><big>(</big><em>number float</em><big>)</big><a class="headerlink" href="#radians" title="Permalink to this definition">¶</a></dt> +<code class="descname">radians</code><span class="sig-paren">(</span><em>number float</em><span class="sig-paren">)</span><a class="headerlink" href="#radians" title="Permalink to this definition">¶</a></dt> <dd><p>Converts degrees to radians</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -581,7 +583,7 @@ <dl class="function"> <dt id="random"> -<tt class="descname">random</tt><big>(</big><em>number int4</em><big>)</big><a class="headerlink" href="#random" title="Permalink to this definition">¶</a></dt> +<code class="descname">random</code><span class="sig-paren">(</span><em>number int4</em><span class="sig-paren">)</span><a class="headerlink" href="#random" title="Permalink to this definition">¶</a></dt> <dd><p>Returns a pseudorandom number.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -603,7 +605,7 @@ <dl class="function"> <dt id="round"> -<tt class="descname">round</tt><big>(</big><em>number int|float</em><big>)</big><a class="headerlink" href="#round" title="Permalink to this definition">¶</a></dt> +<code class="descname">round</code><span class="sig-paren">(</span><em>number int|float</em><span class="sig-paren">)</span><a class="headerlink" href="#round" title="Permalink to this definition">¶</a></dt> <dd><p>Rounds to nearest integer</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -625,7 +627,7 @@ <dl class="function"> <dt id="sign"> -<tt class="descname">sign</tt><big>(</big><em>number int|float</em><big>)</big><a class="headerlink" href="#sign" title="Permalink to this definition">¶</a></dt> +<code class="descname">sign</code><span class="sig-paren">(</span><em>number int|float</em><span class="sig-paren">)</span><a class="headerlink" href="#sign" title="Permalink to this definition">¶</a></dt> <dd><p>Returns sign of argument as -1, 0, 1</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -647,7 +649,7 @@ <dl class="function"> <dt id="sin"> -<tt class="descname">sin</tt><big>(</big><em>number float</em><big>)</big><a class="headerlink" href="#sin" title="Permalink to this definition">¶</a></dt> +<code class="descname">sin</code><span class="sig-paren">(</span><em>number float</em><span class="sig-paren">)</span><a class="headerlink" href="#sin" title="Permalink to this definition">¶</a></dt> <dd><p>Returns the sine of number value</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -669,7 +671,7 @@ <dl class="function"> <dt id="sqrt"> -<tt class="descname">sqrt</tt><big>(</big><em>number float8</em><big>)</big><a class="headerlink" href="#sqrt" title="Permalink to this definition">¶</a></dt> +<code class="descname">sqrt</code><span class="sig-paren">(</span><em>number float8</em><span class="sig-paren">)</span><a class="headerlink" href="#sqrt" title="Permalink to this definition">¶</a></dt> <dd><p>Returns the square root of a number</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -691,7 +693,7 @@ <dl class="function"> <dt id="tan"> -<tt class="descname">tan</tt><big>(</big><em>number float</em><big>)</big><a class="headerlink" href="#tan" title="Permalink to this definition">¶</a></dt> +<code class="descname">tan</code><span class="sig-paren">(</span><em>number float</em><span class="sig-paren">)</span><a class="headerlink" href="#tan" title="Permalink to this definition">¶</a></dt> <dd><p>Returns the tangent of number value</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> Modified: tajo/site/docs/devel/functions/network_func_and_operators.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/functions/network_func_and_operators.html?rev=1706954&r1=1706953&r2=1706954&view=diff ============================================================================== --- tajo/site/docs/devel/functions/network_func_and_operators.html (original) +++ tajo/site/docs/devel/functions/network_func_and_operators.html Tue Oct 6 06:44:17 2015 @@ -164,6 +164,8 @@ <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -213,7 +215,7 @@ To use these functions and operations, the GeoIP database should be precedently installed in local disks of all the workers. (Please refer the install instruction in <a class="reference external" href="http://dev.maxmind.com/geoip/legacy/downloadable/";>http://dev.maxmind.com/geoip/legacy/downloadable/</a>)</p> -<p>Once the GeoIP database is installed, you should specify the install location in <tt class="docutils literal"><span class="pre">conf/tajo-site.xml</span></tt> +<p>Once the GeoIP database is installed, you should specify the install location in <code class="docutils literal"><span class="pre">conf/tajo-site.xml</span></code> as follows.</p> <div class="highlight-python"><div class="highlight"><pre><property> <name>tajo.function.geoip-database-location</name> @@ -226,7 +228,7 @@ as follows.</p> <h2>Supported Functions<a class="headerlink" href="#supported-functions" title="Permalink to this headline">¶</a></h2> <dl class="function"> <dt id="geoip_country_code"> -<tt class="descname">geoip_country_code</tt><big>(</big><em>addr text</em><big>)</big><a class="headerlink" href="#geoip_country_code" title="Permalink to this definition">¶</a></dt> +<code class="descname">geoip_country_code</code><span class="sig-paren">(</span><em>addr text</em><span class="sig-paren">)</span><a class="headerlink" href="#geoip_country_code" title="Permalink to this definition">¶</a></dt> <dd><p>Convert an ipv4 address string to a geoip country code.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -248,7 +250,7 @@ as follows.</p> <dl class="function"> <dt> -<tt class="descname">geoip_country_code</tt><big>(</big><em>addr inet4</em><big>)</big></dt> +<code class="descname">geoip_country_code</code><span class="sig-paren">(</span><em>addr inet4</em><span class="sig-paren">)</span></dt> <dd><p>Convert an ipv4 address to a geoip country code.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -270,7 +272,7 @@ as follows.</p> <dl class="function"> <dt id="geoip_in_country"> -<tt class="descname">geoip_in_country</tt><big>(</big><em>addr text</em>, <em>code text</em><big>)</big><a class="headerlink" href="#geoip_in_country" title="Permalink to this definition">¶</a></dt> +<code class="descname">geoip_in_country</code><span class="sig-paren">(</span><em>addr text</em>, <em>code text</em><span class="sig-paren">)</span><a class="headerlink" href="#geoip_in_country" title="Permalink to this definition">¶</a></dt> <dd><p>If the given country code is same with the country code of the given address, it returns true. Otherwise, returns false.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -297,7 +299,7 @@ as follows.</p> <dl class="function"> <dt> -<tt class="descname">geoip_in_country</tt><big>(</big><em>addr inet4</em>, <em>code text</em><big>)</big></dt> +<code class="descname">geoip_in_country</code><span class="sig-paren">(</span><em>addr inet4</em>, <em>code text</em><span class="sig-paren">)</span></dt> <dd><p>If the given country code is same with the country code of the given address, it returns true. Otherwise, returns false.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> Modified: tajo/site/docs/devel/functions/python.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/functions/python.html?rev=1706954&r1=1706953&r2=1706954&view=diff ============================================================================== --- tajo/site/docs/devel/functions/python.html (original) +++ tajo/site/docs/devel/functions/python.html Tue Oct 6 06:44:17 2015 @@ -164,6 +164,8 @@ <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -212,14 +214,14 @@ <div class="section" id="function-registration"> <h3>Function registration<a class="headerlink" href="#function-registration" title="Permalink to this headline">¶</a></h3> <p>To register Python UDFs, you must install script files in all cluster nodes. -After that, you can register your functions by specifying the paths to those script files in <tt class="docutils literal"><span class="pre">tajo-site.xml</span></tt>. Here is an example of the configuration.</p> +After that, you can register your functions by specifying the paths to those script files in <code class="docutils literal"><span class="pre">tajo-site.xml</span></code>. Here is an example of the configuration.</p> <div class="highlight-xml"><div class="highlight"><pre><span class="nt"><property></span> <span class="nt"><name></span>tajo.function.python.code-dir<span class="nt"></name></span> <span class="nt"><value></span>/path/to/script1.py,/path/to/script2.py<span class="nt"></value></span> <span class="nt"></property></span> </pre></div> </div> -<p>Please note that you can specify multiple paths with <tt class="docutils literal"><span class="pre">','</span></tt> as a delimiter. Each file can contain multiple functions. Here is a typical example of a script file.</p> +<p>Please note that you can specify multiple paths with <code class="docutils literal"><span class="pre">','</span></code> as a delimiter. Each file can contain multiple functions. Here is a typical example of a script file.</p> <div class="highlight-python"><div class="highlight"><pre><span class="c"># /path/to/udf1.py</span> <span class="nd">@output_type</span><span class="p">(</span><span class="s">'int4'</span><span class="p">)</span> @@ -243,10 +245,10 @@ After that, you can register your functi </div> <div class="section" id="decorators-and-types"> <h3>Decorators and types<a class="headerlink" href="#decorators-and-types" title="Permalink to this headline">¶</a></h3> -<p>By default, every function has a return type of <tt class="docutils literal"><span class="pre">BLOB</span></tt>. +<p>By default, every function has a return type of <code class="docutils literal"><span class="pre">BLOB</span></code>. You can use Python decorators to define output types for the script functions. Tajo can figure out return types from the annotations of the Python script.</p> <ul class="simple"> -<li><tt class="docutils literal"><span class="pre">output_type</span></tt>: Defines the return data type for a script UDF in a format that Tajo can understand. The defined type must be one of the types supported by Tajo. For supported types, please refer to <a class="reference internal" href="../sql_language/data_model.html"><em>Data Model</em></a>.</li> +<li><code class="docutils literal"><span class="pre">output_type</span></code>: Defines the return data type for a script UDF in a format that Tajo can understand. The defined type must be one of the types supported by Tajo. For supported types, please refer to <a class="reference internal" href="../sql_language/data_model.html"><em>Data Model</em></a>.</li> </ul> </div> <div class="section" id="query-example"> @@ -323,13 +325,13 @@ Followings are typical examples of Pytho <span class="k">return</span> <span class="bp">self</span><span class="o">.</span><span class="n">cnt</span> </pre></div> </div> -<p>These classes must provide <tt class="docutils literal"><span class="pre">reset()</span></tt>, <tt class="docutils literal"><span class="pre">eval()</span></tt>, <tt class="docutils literal"><span class="pre">merge()</span></tt>, <tt class="docutils literal"><span class="pre">get_partial_result()</span></tt>, and <tt class="docutils literal"><span class="pre">get_final_result()</span></tt> functions.</p> +<p>These classes must provide <code class="docutils literal"><span class="pre">reset()</span></code>, <code class="docutils literal"><span class="pre">eval()</span></code>, <code class="docutils literal"><span class="pre">merge()</span></code>, <code class="docutils literal"><span class="pre">get_partial_result()</span></code>, and <code class="docutils literal"><span class="pre">get_final_result()</span></code> functions.</p> <ul class="simple"> -<li><tt class="docutils literal"><span class="pre">reset()</span></tt> resets the aggregation state.</li> -<li><tt class="docutils literal"><span class="pre">eval()</span></tt> evaluates input tuples in the first stage.</li> -<li><tt class="docutils literal"><span class="pre">merge()</span></tt> merges intermediate results of the first stage.</li> -<li><tt class="docutils literal"><span class="pre">get_partial_result()</span></tt> returns intermediate results of the first stage. Output type must be same with the input type of <tt class="docutils literal"><span class="pre">merge()</span></tt>.</li> -<li><tt class="docutils literal"><span class="pre">get_final_result()</span></tt> returns the final aggregation result.</li> +<li><code class="docutils literal"><span class="pre">reset()</span></code> resets the aggregation state.</li> +<li><code class="docutils literal"><span class="pre">eval()</span></code> evaluates input tuples in the first stage.</li> +<li><code class="docutils literal"><span class="pre">merge()</span></code> merges intermediate results of the first stage.</li> +<li><code class="docutils literal"><span class="pre">get_partial_result()</span></code> returns intermediate results of the first stage. Output type must be same with the input type of <code class="docutils literal"><span class="pre">merge()</span></code>.</li> +<li><code class="docutils literal"><span class="pre">get_final_result()</span></code> returns the final aggregation result.</li> </ul> </div> <div class="section" id="id2"> 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=1706954&r1=1706953&r2=1706954&view=diff ============================================================================== --- tajo/site/docs/devel/functions/string_func_and_operators.html (original) +++ tajo/site/docs/devel/functions/string_func_and_operators.html Tue Oct 6 06:44:17 2015 @@ -164,6 +164,8 @@ <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -209,8 +211,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> -<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> +<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> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> <col class="field-body" /> @@ -236,7 +238,7 @@ <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> +<code class="descname">ascii</code><span class="sig-paren">(</span><em>string text</em><span class="sig-paren">)</span><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> @@ -260,7 +262,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">bit_length</code><span class="sig-paren">(</span><em>string text</em><span class="sig-paren">)</span><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" /> @@ -282,7 +284,7 @@ For other multibyte encodings, the argum <dl class="function"> <dt id="char_length"> -<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> +<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 the number of characters in string.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -306,7 +308,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">octet_length</code><span class="sig-paren">(</span><em>string text</em><span class="sig-paren">)</span><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" /> @@ -328,7 +330,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">chr</code><span class="sig-paren">(</span><em>code int4</em><span class="sig-paren">)</span><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" /> @@ -350,7 +352,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">decode</code><span class="sig-paren">(</span><em>binary text</em>, <em>format text</em><span class="sig-paren">)</span><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" /> @@ -377,7 +379,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">digest</code><span class="sig-paren">(</span><em>input text</em>, <em>method text</em><span class="sig-paren">)</span><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" /> @@ -404,7 +406,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">encode</code><span class="sig-paren">(</span><em>binary text</em>, <em>format text</em><span class="sig-paren">)</span><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" /> @@ -431,7 +433,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">initcap</code><span class="sig-paren">(</span><em>string text</em><span class="sig-paren">)</span><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" /> @@ -453,7 +455,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">md5</code><span class="sig-paren">(</span><em>string text</em><span class="sig-paren">)</span><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" /> @@ -475,7 +477,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">left</code><span class="sig-paren">(</span><em>string text</em>, <em>number int4</em><span class="sig-paren">)</span><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" /> @@ -502,7 +504,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">right</code><span class="sig-paren">(</span><em>string text</em>, <em>number int4</em><span class="sig-paren">)</span><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" /> @@ -529,7 +531,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">locate</code><span class="sig-paren">(</span><em>source text</em>, <em>target text</em><span class="optional">[</span>, <em>start_index int4</em><span class="optional">]</span><span class="sig-paren">)</span><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" /> @@ -560,7 +562,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">strposb</code><span class="sig-paren">(</span><em>source text</em>, <em>target text</em><span class="sig-paren">)</span><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" /> @@ -587,7 +589,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">substr</code><span class="sig-paren">(</span><em>source text</em>, <em>start int4</em>, <em>length int4</em><span class="sig-paren">)</span><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" /> @@ -615,7 +617,7 @@ For other multibyte encodings, the argum <dl class="function"> <dt id="trim"> -<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> +<code class="descname">trim</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="#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" /> @@ -642,7 +644,7 @@ For other multibyte encodings, the argum <dl class="function"> <dt> -<tt class="descname">trim</tt><big>(</big><em>[leading | trailing | both] [characters text] FROM string text</em><big>)</big></dt> +<code class="descname">trim</code><span class="sig-paren">(</span><em>[leading | trailing | both] [characters text] FROM string text</em><span class="sig-paren">)</span></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" /> @@ -669,7 +671,7 @@ For other multibyte encodings, the argum <dl class="function"> <dt id="btrim"> -<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> +<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> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -699,7 +701,7 @@ For other multibyte encodings, the argum <dl class="function"> <dt id="ltrim"> -<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> +<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> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -726,7 +728,7 @@ For other multibyte encodings, the argum <dl class="function"> <dt id="rtrim"> -<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> +<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> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -753,7 +755,7 @@ For other multibyte encodings, the argum <dl class="function"> <dt id="split_part"> -<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> +<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> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -781,7 +783,7 @@ For other multibyte encodings, the argum <dl class="function"> <dt id="regexp_replace"> -<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> +<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> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -809,7 +811,7 @@ For other multibyte encodings, the argum <dl class="function"> <dt id="upper"> -<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> +<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> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -831,7 +833,7 @@ For other multibyte encodings, the argum <dl class="function"> <dt id="lower"> -<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> +<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> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -853,7 +855,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">lpad</code><span class="sig-paren">(</span><em>source text</em>, <em>number int4</em>, <em>pad text</em><span class="sig-paren">)</span><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" /> @@ -881,7 +883,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">rpad</code><span class="sig-paren">(</span><em>source text</em>, <em>number int4</em>, <em>pad text</em><span class="sig-paren">)</span><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" /> @@ -909,7 +911,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">quote_ident</code><span class="sig-paren">(</span><em>string text</em><span class="sig-paren">)</span><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" /> @@ -931,7 +933,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">repeat</code><span class="sig-paren">(</span><em>string text</em>, <em>number int4</em><span class="sig-paren">)</span><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" /> @@ -958,7 +960,7 @@ For other multibyte encodings, the argum <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> +<code class="descname">reverse</code><span class="sig-paren">(</span><em>string text</em><span class="sig-paren">)</span><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" /> Modified: tajo/site/docs/devel/functions/window_func.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/functions/window_func.html?rev=1706954&r1=1706953&r2=1706954&view=diff ============================================================================== --- tajo/site/docs/devel/functions/window_func.html (original) +++ tajo/site/docs/devel/functions/window_func.html Tue Oct 6 06:44:17 2015 @@ -164,6 +164,8 @@ <li class="toctree-l1"><a class="reference internal" href="../jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -209,7 +211,7 @@ <h1>Window Functions<a class="headerlink" href="#window-functions" title="Permalink to this headline">¶</a></h1> <dl class="function"> <dt id="first_value"> -<tt class="descname">first_value</tt><big>(</big><em>value any</em><big>)</big><a class="headerlink" href="#first_value" title="Permalink to this definition">¶</a></dt> +<code class="descname">first_value</code><span class="sig-paren">(</span><em>value any</em><span class="sig-paren">)</span><a class="headerlink" href="#first_value" title="Permalink to this definition">¶</a></dt> <dd><p>Returns the first value of input rows.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -225,7 +227,7 @@ <dl class="function"> <dt id="last_value"> -<tt class="descname">last_value</tt><big>(</big><em>value any</em><big>)</big><a class="headerlink" href="#last_value" title="Permalink to this definition">¶</a></dt> +<code class="descname">last_value</code><span class="sig-paren">(</span><em>value any</em><span class="sig-paren">)</span><a class="headerlink" href="#last_value" title="Permalink to this definition">¶</a></dt> <dd><p>Returns the last value of input rows.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -241,7 +243,7 @@ <dl class="function"> <dt id="lag"> -<tt class="descname">lag</tt><big>(</big><em>value any</em><span class="optional">[</span>, <em>offset integer</em><span class="optional">[</span>, <em>default any</em><span class="optional">]</span><span class="optional">]</span><big>)</big><a class="headerlink" href="#lag" title="Permalink to this definition">¶</a></dt> +<code class="descname">lag</code><span class="sig-paren">(</span><em>value any</em><span class="optional">[</span>, <em>offset integer</em><span class="optional">[</span>, <em>default any</em><span class="optional">]</span><span class="optional">]</span><span class="sig-paren">)</span><a class="headerlink" href="#lag" title="Permalink to this definition">¶</a></dt> <dd><p>Returns value evaluated at the row that is offset rows before the current row within the partition. If there is no such row, instead return default. Both offset and default are evaluated with respect to the current row. If omitted, offset defaults to 1 and default to null.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -263,7 +265,7 @@ <dl class="function"> <dt id="lead"> -<tt class="descname">lead</tt><big>(</big><em>value any</em><span class="optional">[</span>, <em>offset integer</em><span class="optional">[</span>, <em>default any</em><span class="optional">]</span><span class="optional">]</span><big>)</big><a class="headerlink" href="#lead" title="Permalink to this definition">¶</a></dt> +<code class="descname">lead</code><span class="sig-paren">(</span><em>value any</em><span class="optional">[</span>, <em>offset integer</em><span class="optional">[</span>, <em>default any</em><span class="optional">]</span><span class="optional">]</span><span class="sig-paren">)</span><a class="headerlink" href="#lead" title="Permalink to this definition">¶</a></dt> <dd><p>Returns value evaluated at the row that is offset rows after the current row within the partition. If there is no such row, instead return default. Both offset and default are evaluated with respect to the current row. If omitted, offset defaults to 1 and default to null.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -285,7 +287,7 @@ <dl class="function"> <dt id="rank"> -<tt class="descname">rank</tt><big>(</big><big>)</big><a class="headerlink" href="#rank" title="Permalink to this definition">¶</a></dt> +<code class="descname">rank</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#rank" title="Permalink to this definition">¶</a></dt> <dd><p>Returns rank of the current row with gaps.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> @@ -299,7 +301,7 @@ <dl class="function"> <dt id="row_number"> -<tt class="descname">row_number</tt><big>(</big><big>)</big><a class="headerlink" href="#row_number" title="Permalink to this definition">¶</a></dt> +<code class="descname">row_number</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#row_number" title="Permalink to this definition">¶</a></dt> <dd><p>Returns the current row within its partition, counting from 1.</p> <table class="docutils field-list" frame="void" rules="none"> <col class="field-name" /> Modified: tajo/site/docs/devel/genindex.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/genindex.html?rev=1706954&r1=1706953&r2=1706954&view=diff ============================================================================== --- tajo/site/docs/devel/genindex.html (original) +++ tajo/site/docs/devel/genindex.html Tue Oct 6 06:44:17 2015 @@ -162,6 +162,8 @@ <li class="toctree-l1"><a class="reference internal" href="jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -661,7 +663,7 @@ </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><a href="functions/data_type_func_and_operators.html#to_char">to_char() (built-in function)</a>, <a href="functions/datetime_func_and_operators.html#to_char">[1]</a> </dt> Modified: tajo/site/docs/devel/getting_started.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/getting_started.html?rev=1706954&r1=1706953&r2=1706954&view=diff ============================================================================== --- tajo/site/docs/devel/getting_started.html (original) +++ tajo/site/docs/devel/getting_started.html Tue Oct 6 06:44:17 2015 @@ -163,6 +163,8 @@ <li class="toctree-l1"><a class="reference internal" href="jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -281,7 +283,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 <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> +<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> </div> </div> <div class="section" id="first-query-execution"> @@ -298,7 +300,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 <tt class="docutils literal"><span class="pre">bin/tsql</span></tt></p> +<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> <div class="highlight-python"><div class="highlight"><pre>$ $TAJO_HOME/bin/tsql tajo> </pre></div> @@ -337,7 +339,7 @@ If the table resides in HDFS, you should type TEXT </pre></div> </div> -<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><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>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=1706954&r1=1706953&r2=1706954&view=diff ============================================================================== --- tajo/site/docs/devel/hbase_integration.html (original) +++ tajo/site/docs/devel/hbase_integration.html Tue Oct 6 06:44:17 2015 @@ -163,6 +163,8 @@ <li class="toctree-l1"><a class="reference internal" href="jdbc_driver.html">Tajo JDBC Driver</a><ul> <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC driver</a></li> <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li> +<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connecting-to-the-tajo-cluster-instance">Connecting to the Tajo cluster instance</a></li> +<li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#connection-parameters">Connection Parameters</a></li> <li class="toctree-l2"><a class="reference internal" href="jdbc_driver.html#an-example-jdbc-client">An Example JDBC Client</a></li> </ul> </li> @@ -206,9 +208,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 <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>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>This section describes how to setup HBase integration.</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> +<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> <div class="highlight-python"><div class="highlight"><pre>export HBASE_HOME=/path/to/your/hbase/directory </pre></div> </div> @@ -227,12 +229,12 @@ This integration allows Tajo to access a </div> <p>Options</p> <ul class="simple"> -<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> +<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> </ul> -<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> +<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> </div> <div class="section" id="drop-table"> <h2>DROP TABLE<a class="headerlink" href="#drop-table" title="Permalink to this headline">¶</a></h2> @@ -240,11 +242,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><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> +<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> </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 <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> +<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> <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> @@ -285,7 +287,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 <tt class="docutils literal"><span class="pre">\d</span></tt> option:</p> +<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> <div class="highlight-sql"><div class="highlight"><pre>default> \d blog; table name: default.blog
