Author: jihoonson
Date: Tue Sep 1 06:48:19 2015
New Revision: 1700402
URL: http://svn.apache.org/r1700402
Log:
add missing files
Added:
tajo/site/docs/devel/_sources/functions/agg_func.txt
tajo/site/docs/devel/_sources/functions/data_type_func_and_operators.txt
tajo/site/docs/devel/_sources/functions/window_func.txt
tajo/site/docs/devel/functions/agg_func.html
tajo/site/docs/devel/functions/data_type_func_and_operators.html
tajo/site/docs/devel/functions/window_func.html
Added: tajo/site/docs/devel/_sources/functions/agg_func.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_sources/functions/agg_func.txt?rev=1700402&view=auto
==============================================================================
--- tajo/site/docs/devel/_sources/functions/agg_func.txt (added)
+++ tajo/site/docs/devel/_sources/functions/agg_func.txt Tue Sep 1 06:48:19
2015
@@ -0,0 +1,91 @@
+************************************
+Aggregation Functions
+************************************
+
+.. function:: avg (expression)
+
+ Returns the average of all input values.
+
+ :param expression:
+ :type expression: int | float
+ :rtype: float8
+
+.. function:: corr (expression1, expression2)
+
+ Returns the coefficient of correlation between a set of number pairs.
+
+ :param expression1:
+ :param expression2:
+ :type expression1: int | float
+ :type expression2: int | float
+ :rtype: float8
+
+.. function:: count()
+
+ Returns the number of input rows.
+
+ :rtype: int8
+
+.. function:: last_value(expression)
+
+ Returns the last value of expression.
+
+ :param expression:
+ :type expression: int | float | date | time | timestamp | text
+ :rtype: same as parameter data type
+
+.. function:: max(expression)
+
+ Returns the maximum value of expression.
+
+ :param expression:
+ :type expression: int | float | date | time | timestamp | text
+ :rtype: same as parameter data type
+
+.. function:: min(expression)
+
+ Returns the minimum value of expression.
+
+ :param expression:
+ :type expression: int | float | date | time | timestamp | text
+ :rtype: same as parameter data type
+
+.. function:: stddev_pop(expression)
+
+ Returns the population standard deviation of a set of numbers.
+
+ :param expression:
+ :type expression: int | float
+ :rtype: float8
+
+.. function:: stddev_samp(expression)
+
+ Returns the sample standard deviation of a set of numbers.
+
+ :param expression:
+ :type expression: int | float
+ :rtype: float8
+
+.. function:: sum(expression)
+
+ Returns the sum of a set of numbers.
+
+ :param expression:
+ :type expression: int | float
+ :rtype: same as parameter data type
+
+.. function:: var_pop(expression)
+
+ Returns the variance of a set of numbers.
+
+ :param expression:
+ :type expression: int | float
+ :rtype: float8
+
+.. function:: var_samp(expression)
+
+ Returns the unbiased sample variance of a set of numbers.
+
+ :param expression:
+ :type expression: int | float
+ :rtype: float8
\ No newline at end of file
Added: tajo/site/docs/devel/_sources/functions/data_type_func_and_operators.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_sources/functions/data_type_func_and_operators.txt?rev=1700402&view=auto
==============================================================================
--- tajo/site/docs/devel/_sources/functions/data_type_func_and_operators.txt
(added)
+++ tajo/site/docs/devel/_sources/functions/data_type_func_and_operators.txt
Tue Sep 1 06:48:19 2015
@@ -0,0 +1,43 @@
+************************************
+Data Type Functions and Operators
+************************************
+
+.. function:: to_bin(source int4)
+
+ Returns the binary representation of integer.
+
+ :param source: source value
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select to_bin(22);
+ > 10110
+
+.. function:: to_char(source int8, format text)
+
+ Convert integer to string.
+
+ :param source: source value
+ :param format: format
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select to_char(125, '00999');
+ > 00125
+
+.. function:: to_hex(source int4)
+
+ Convert the argument to hexadecimal.
+
+ :param source: source value
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select to_hex(15);
+ > F
Added: tajo/site/docs/devel/_sources/functions/window_func.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_sources/functions/window_func.txt?rev=1700402&view=auto
==============================================================================
--- tajo/site/docs/devel/_sources/functions/window_func.txt (added)
+++ tajo/site/docs/devel/_sources/functions/window_func.txt Tue Sep 1 06:48:19
2015
@@ -0,0 +1,47 @@
+************************************
+Window Functions
+************************************
+
+.. function:: first_value (value any)
+
+ Returns the first value of input rows.
+
+ :param value: input value
+ :rtype: same as parameter data type
+
+.. function:: last_value (value any)
+
+ Returns the last value of input rows.
+
+ :param value: input value
+ :rtype: same as parameter data type
+
+.. function:: lag (value any [, offset integer [, default any ]])
+
+ 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.
+
+ :param value: input value
+ :param offset: offset
+ :param default: default value
+ :rtype: same as parameter data type
+
+.. function:: lead (value any [, offset integer [, default any ]])
+
+ 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.
+
+ :param value: input value
+ :param offset: offset
+ :param default: default value
+ :rtype: same as parameter data type
+
+.. function:: rank ()
+
+ Returns rank of the current row with gaps.
+
+ :rtype: int8
+
+.. function:: row_number ()
+
+ Returns the current row within its partition, counting from 1.
+
+ :rtype: int8
\ No newline at end of file
Added: tajo/site/docs/devel/functions/agg_func.html
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/functions/agg_func.html?rev=1700402&view=auto
==============================================================================
--- tajo/site/docs/devel/functions/agg_func.html (added)
+++ tajo/site/docs/devel/functions/agg_func.html Tue Sep 1 06:48:19 2015
@@ -0,0 +1,457 @@
+
+
+<!DOCTYPE html>
+<!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
+<!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
+<head>
+ <meta charset="utf-8">
+ <meta name="viewport" content="width=device-width, initial-scale=1.0">
+
+ <title>Aggregation Functions — Apache Tajo 0.11.0 documentation</title>
+
+
+
+
+
+
+ <link
href='https://fonts.googleapis.com/css?family=Lato:400,700|Roboto+Slab:400,700|Inconsolata:400,700'
rel='stylesheet' type='text/css'>
+
+
+
+
+
+
+
+
+
+ <link rel="stylesheet" href="../_static/css/theme.css" type="text/css" />
+
+
+
+ <link rel="top" title="Apache Tajo 0.11.0 documentation"
href="../index.html"/>
+ <link rel="up" title="Functions" href="../functions.html"/>
+ <link rel="next" title="Window Functions" href="window_func.html"/>
+ <link rel="prev" title="JSON Functions" href="json_func.html"/>
+
+
+ <script
src="https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js";></script>
+
+</head>
+
+<body class="wy-body-for-nav" role="document">
+
+ <div class="wy-grid-for-nav">
+
+
+ <nav data-toggle="wy-nav-shift" class="wy-nav-side">
+ <div class="wy-side-nav-search">
+ <a href="../index.html" class="fa fa-home"> Apache Tajo</a>
+ <div role="search">
+ <form id ="rtd-search-form" class="wy-form" action="../search.html"
method="get">
+ <input type="text" name="q" placeholder="Search docs" />
+ <input type="hidden" name="check_keywords" value="yes" />
+ <input type="hidden" name="area" value="default" />
+ </form>
+</div>
+ </div>
+
+ <div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation"
aria-label="main navigation">
+
+
+ <ul class="current">
+<li class="toctree-l1"><a class="reference internal"
href="../introduction.html">Introduction</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../getting_started.html">Getting Started</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a
local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../getting_started.html#first-query-execution">First query
execution</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../configuration.html">Configuration</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/preliminary.html">Preliminary</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/cluster_setup.html">Cluster Setup</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/tajo_master_configuration.html">Tajo Master
Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/worker_configuration.html">Worker Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/catalog_configuration.html">Catalog
Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/ha_configuration.html">High Availability for
TajoMaster</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/service_config_defaults.html">Cluster Service
Configuration Defaults</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/tajo-site-xml.html">The tajo-site.xml File</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/catalog-site-xml.html">The catalog-site.xml File</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../tsql.html">Tajo
Shell (TSQL)</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/meta_command.html">Meta Commands</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/dfs_command.html">Executing HDFS commands</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/variables.html">Session Variables</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/admin_command.html">Administration Commands</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/intro.html">Introducing to TSQL</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/single_command.html">Executing a single command</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/execute_file.html">Executing Queries from Files</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/background_command.html">Executing as background process</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../sql_language.html">SQL Language</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/data_model.html">Data Model</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/ddl.html">Data Definition Language</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/insert.html">INSERT (OVERWRITE) INTO</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/alter_table.html">ALTER TABLE</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/queries.html">Queries</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/joins.html">Joins</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/sql_expression.html">SQL Expressions</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/predicates.html">Predicates</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../time_zone.html">Time Zone</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../time_zone.html#server-cluster-time-zone">Server Cluster Time
Zone</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../time_zone.html#table-time-zone">Table Time Zone</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../time_zone.html#client-time-zone">Client Time Zone</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../time_zone.html#time-zone-id">Time Zone ID</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../time_zone.html#examples-of-time-zone">Examples of Time Zone</a></li>
+</ul>
+</li>
+<li class="toctree-l1 current"><a class="reference internal"
href="../functions.html">Functions</a><ul class="current">
+<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 current"><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>
+<li class="toctree-l1"><a class="reference internal"
href="../table_management.html">Table Management</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../table_management/table_overview.html">Overview of Tajo Tables</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../table_management/tablespaces.html">Tablespaces</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../table_management/file_formats.html">File Formats</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../table_management/compression.html">Compression</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../table_partitioning.html">Table Partitioning</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../partitioning/intro_to_partitioning.html">Introduction to
Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../partitioning/column_partitioning.html">Column Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../partitioning/range_partitioning.html">Range Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../partitioning/hash_partitioning.html">Hash Partitioning</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../storage_plugin.html">Storage Plugin</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../storage_plugin.html#overview">Overview</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../storage_plugin.html#register-custom-storage">Register custom
storage</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../storage_plugin.html#configuration">Configuration</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../index_overview.html">Index (Experimental Feature)</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../index/types.html">Index Types</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../index/how_to_use.html">How to use index?</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../index/future_work.html">Future Works</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../backup_and_restore.html">Backup and Restore</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../backup_and_restore/catalog.html">Backup and Restore Catalog</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../hive_integration.html">Hive Integration</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../hbase_integration.html">HBase Integration</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../hbase_integration.html#create-table">CREATE TABLE</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../hbase_integration.html#drop-table">DROP TABLE</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../hbase_integration.html#insert-overwrite-into">INSERT (OVERWRITE)
INTO</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../hbase_integration.html#usage">Usage</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../swift_integration.html">OpenStack Swift Integration</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../swift_integration.html#swift-configuration">Swift
configuration</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../swift_integration.html#hadoop-configurations">Hadoop
configurations</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../swift_integration.html#tajo-configuration">Tajo configuration</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../swift_integration.html#querying-on-swift">Querying on Swift</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../jdbc_driver.html">Tajo JDBC Driver</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC
driver</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC
Client</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../tajo_client_api.html">Tajo Client API</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../faq.html">FAQ</a></li>
+</ul>
+
+
+ </div>
+
+ </nav>
+
+ <section data-toggle="wy-nav-shift" class="wy-nav-content-wrap">
+
+
+ <nav class="wy-nav-top" role="navigation" aria-label="top navigation">
+ <i data-toggle="wy-nav-top" class="fa fa-bars"></i>
+ <a href="../index.html">Apache Tajo</a>
+ </nav>
+
+
+
+ <div class="wy-nav-content">
+ <div class="rst-content">
+ <div role="navigation" aria-label="breadcrumbs navigation">
+ <ul class="wy-breadcrumbs">
+ <li><a href="../index.html">Docs</a> »</li>
+
+ <li><a href="../functions.html">Functions</a> »</li>
+
+ <li>Aggregation Functions</li>
+ <li class="wy-breadcrumbs-aside">
+
+ <a href="../_sources/functions/agg_func.txt" rel="nofollow"> View
page source</a>
+
+ </li>
+ </ul>
+ <hr/>
+</div>
+ <div role="main">
+
+ <div class="section" id="aggregation-functions">
+<h1>Aggregation Functions<a class="headerlink" href="#aggregation-functions"
title="Permalink to this headline">¶</a></h1>
+<dl class="function">
+<dt id="avg">
+<tt class="descname">avg</tt><big>(</big><em>expression</em><big>)</big><a
class="headerlink" href="#avg" title="Permalink to this definition">¶</a></dt>
+<dd><p>Returns the average of all input values.</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>expression</strong> (<em>int | float</em>) –
</td>
+</tr>
+<tr class="field-even field"><th class="field-name">Return type:</th><td
class="field-body">float8</td>
+</tr>
+</tbody>
+</table>
+</dd></dl>
+
+<dl class="function">
+<dt id="corr">
+<tt class="descname">corr</tt><big>(</big><em>expression1</em>,
<em>expression2</em><big>)</big><a class="headerlink" href="#corr"
title="Permalink to this definition">¶</a></dt>
+<dd><p>Returns the coefficient of correlation between a set of number
pairs.</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>expression1</strong> (<em>int | float</em>) – </li>
+<li><strong>expression2</strong> (<em>int | float</em>) – </li>
+</ul>
+</td>
+</tr>
+<tr class="field-even field"><th class="field-name">Return type:</th><td
class="field-body"><p class="first last">float8</p>
+</td>
+</tr>
+</tbody>
+</table>
+</dd></dl>
+
+<dl class="function">
+<dt id="count">
+<tt class="descname">count</tt><big>(</big><big>)</big><a class="headerlink"
href="#count" title="Permalink to this definition">¶</a></dt>
+<dd><p>Returns the number of input rows.</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">Return type:</th><td
class="field-body">int8</td>
+</tr>
+</tbody>
+</table>
+</dd></dl>
+
+<dl class="function">
+<dt id="last_value">
+<tt
class="descname">last_value</tt><big>(</big><em>expression</em><big>)</big><a
class="headerlink" href="#last_value" title="Permalink to this
definition">¶</a></dt>
+<dd><p>Returns the last value of expression.</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>expression</strong> (<em>int | float | date | time |
timestamp | text</em>) – </td>
+</tr>
+<tr class="field-even field"><th class="field-name">Return type:</th><td
class="field-body">same as parameter data type</td>
+</tr>
+</tbody>
+</table>
+</dd></dl>
+
+<dl class="function">
+<dt id="max">
+<tt class="descname">max</tt><big>(</big><em>expression</em><big>)</big><a
class="headerlink" href="#max" title="Permalink to this definition">¶</a></dt>
+<dd><p>Returns the maximum value of expression.</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>expression</strong> (<em>int | float | date | time |
timestamp | text</em>) – </td>
+</tr>
+<tr class="field-even field"><th class="field-name">Return type:</th><td
class="field-body">same as parameter data type</td>
+</tr>
+</tbody>
+</table>
+</dd></dl>
+
+<dl class="function">
+<dt id="min">
+<tt class="descname">min</tt><big>(</big><em>expression</em><big>)</big><a
class="headerlink" href="#min" title="Permalink to this definition">¶</a></dt>
+<dd><p>Returns the minimum value of expression.</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>expression</strong> (<em>int | float | date | time |
timestamp | text</em>) – </td>
+</tr>
+<tr class="field-even field"><th class="field-name">Return type:</th><td
class="field-body">same as parameter data type</td>
+</tr>
+</tbody>
+</table>
+</dd></dl>
+
+<dl class="function">
+<dt id="stddev_pop">
+<tt
class="descname">stddev_pop</tt><big>(</big><em>expression</em><big>)</big><a
class="headerlink" href="#stddev_pop" title="Permalink to this
definition">¶</a></dt>
+<dd><p>Returns the population standard deviation of a set of numbers.</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>expression</strong> (<em>int | float</em>) –
</td>
+</tr>
+<tr class="field-even field"><th class="field-name">Return type:</th><td
class="field-body">float8</td>
+</tr>
+</tbody>
+</table>
+</dd></dl>
+
+<dl class="function">
+<dt id="stddev_samp">
+<tt
class="descname">stddev_samp</tt><big>(</big><em>expression</em><big>)</big><a
class="headerlink" href="#stddev_samp" title="Permalink to this
definition">¶</a></dt>
+<dd><p>Returns the sample standard deviation of a set of numbers.</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>expression</strong> (<em>int | float</em>) –
</td>
+</tr>
+<tr class="field-even field"><th class="field-name">Return type:</th><td
class="field-body">float8</td>
+</tr>
+</tbody>
+</table>
+</dd></dl>
+
+<dl class="function">
+<dt id="sum">
+<tt class="descname">sum</tt><big>(</big><em>expression</em><big>)</big><a
class="headerlink" href="#sum" title="Permalink to this definition">¶</a></dt>
+<dd><p>Returns the sum of a set of numbers.</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>expression</strong> (<em>int | float</em>) –
</td>
+</tr>
+<tr class="field-even field"><th class="field-name">Return type:</th><td
class="field-body">same as parameter data type</td>
+</tr>
+</tbody>
+</table>
+</dd></dl>
+
+<dl class="function">
+<dt id="var_pop">
+<tt class="descname">var_pop</tt><big>(</big><em>expression</em><big>)</big><a
class="headerlink" href="#var_pop" title="Permalink to this
definition">¶</a></dt>
+<dd><p>Returns the variance of a set of numbers.</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>expression</strong> (<em>int | float</em>) –
</td>
+</tr>
+<tr class="field-even field"><th class="field-name">Return type:</th><td
class="field-body">float8</td>
+</tr>
+</tbody>
+</table>
+</dd></dl>
+
+<dl class="function">
+<dt id="var_samp">
+<tt
class="descname">var_samp</tt><big>(</big><em>expression</em><big>)</big><a
class="headerlink" href="#var_samp" title="Permalink to this
definition">¶</a></dt>
+<dd><p>Returns the unbiased sample variance of a set of numbers.</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>expression</strong> (<em>int | float</em>) –
</td>
+</tr>
+<tr class="field-even field"><th class="field-name">Return type:</th><td
class="field-body">float8</td>
+</tr>
+</tbody>
+</table>
+</dd></dl>
+
+</div>
+
+
+ </div>
+ <footer>
+
+ <div class="rst-footer-buttons" role="navigation" aria-label="footer
navigation">
+
+ <a href="window_func.html" class="btn btn-neutral float-right"
title="Window Functions"/>Next <span class="fa
fa-arrow-circle-right"></span></a>
+
+
+ <a href="json_func.html" class="btn btn-neutral" title="JSON
Functions"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+
+ </div>
+
+
+ <hr/>
+
+ <div role="contentinfo">
+ <p>
+ © Copyright 2014, Apache Tajo Team.
+ </p>
+ </div>
+
+ <a href="https://github.com/snide/sphinx_rtd_theme";>Sphinx theme</a>
provided by <a href="https://readthedocs.org";>Read the Docs</a>
+</footer>
+ </div>
+ </div>
+
+ </section>
+
+ </div>
+
+
+
+
+
+ <script type="text/javascript">
+ var DOCUMENTATION_OPTIONS = {
+ URL_ROOT:'../',
+ VERSION:'0.11.0',
+ COLLAPSE_INDEX:false,
+ FILE_SUFFIX:'.html',
+ HAS_SOURCE: true
+ };
+ </script>
+ <script type="text/javascript" src="../_static/jquery.js"></script>
+ <script type="text/javascript" src="../_static/underscore.js"></script>
+ <script type="text/javascript" src="../_static/doctools.js"></script>
+
+
+
+
+
+ <script type="text/javascript" src="../_static/js/theme.js"></script>
+
+
+
+
+ <script type="text/javascript">
+ jQuery(function () {
+ SphinxRtdTheme.StickyNav.enable();
+ });
+ </script>
+
+
+</body>
+</html>
\ No newline at end of file
Added: tajo/site/docs/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=1700402&view=auto
==============================================================================
--- tajo/site/docs/devel/functions/data_type_func_and_operators.html (added)
+++ tajo/site/docs/devel/functions/data_type_func_and_operators.html Tue Sep 1
06:48:19 2015
@@ -0,0 +1,349 @@
+
+
+<!DOCTYPE html>
+<!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
+<!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
+<head>
+ <meta charset="utf-8">
+ <meta name="viewport" content="width=device-width, initial-scale=1.0">
+
+ <title>Data Type Functions and Operators — Apache Tajo 0.11.0
documentation</title>
+
+
+
+
+
+
+ <link
href='https://fonts.googleapis.com/css?family=Lato:400,700|Roboto+Slab:400,700|Inconsolata:400,700'
rel='stylesheet' type='text/css'>
+
+
+
+
+
+
+
+
+
+ <link rel="stylesheet" href="../_static/css/theme.css" type="text/css" />
+
+
+
+ <link rel="top" title="Apache Tajo 0.11.0 documentation"
href="../index.html"/>
+ <link rel="up" title="Functions" href="../functions.html"/>
+ <link rel="next" title="Math Functions and Operators"
href="math_func_and_operators.html"/>
+ <link rel="prev" title="Functions" href="../functions.html"/>
+
+
+ <script
src="https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js";></script>
+
+</head>
+
+<body class="wy-body-for-nav" role="document">
+
+ <div class="wy-grid-for-nav">
+
+
+ <nav data-toggle="wy-nav-shift" class="wy-nav-side">
+ <div class="wy-side-nav-search">
+ <a href="../index.html" class="fa fa-home"> Apache Tajo</a>
+ <div role="search">
+ <form id ="rtd-search-form" class="wy-form" action="../search.html"
method="get">
+ <input type="text" name="q" placeholder="Search docs" />
+ <input type="hidden" name="check_keywords" value="yes" />
+ <input type="hidden" name="area" value="default" />
+ </form>
+</div>
+ </div>
+
+ <div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation"
aria-label="main navigation">
+
+
+ <ul class="current">
+<li class="toctree-l1"><a class="reference internal"
href="../introduction.html">Introduction</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../getting_started.html">Getting Started</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a
local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../getting_started.html#first-query-execution">First query
execution</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../configuration.html">Configuration</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/preliminary.html">Preliminary</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/cluster_setup.html">Cluster Setup</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/tajo_master_configuration.html">Tajo Master
Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/worker_configuration.html">Worker Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/catalog_configuration.html">Catalog
Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/ha_configuration.html">High Availability for
TajoMaster</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/service_config_defaults.html">Cluster Service
Configuration Defaults</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/tajo-site-xml.html">The tajo-site.xml File</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/catalog-site-xml.html">The catalog-site.xml File</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../tsql.html">Tajo
Shell (TSQL)</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/meta_command.html">Meta Commands</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/dfs_command.html">Executing HDFS commands</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/variables.html">Session Variables</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/admin_command.html">Administration Commands</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/intro.html">Introducing to TSQL</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/single_command.html">Executing a single command</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/execute_file.html">Executing Queries from Files</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/background_command.html">Executing as background process</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../sql_language.html">SQL Language</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/data_model.html">Data Model</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/ddl.html">Data Definition Language</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/insert.html">INSERT (OVERWRITE) INTO</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/alter_table.html">ALTER TABLE</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/queries.html">Queries</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/joins.html">Joins</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/sql_expression.html">SQL Expressions</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/predicates.html">Predicates</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../time_zone.html">Time Zone</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../time_zone.html#server-cluster-time-zone">Server Cluster Time
Zone</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../time_zone.html#table-time-zone">Table Time Zone</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../time_zone.html#client-time-zone">Client Time Zone</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../time_zone.html#time-zone-id">Time Zone ID</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../time_zone.html#examples-of-time-zone">Examples of Time Zone</a></li>
+</ul>
+</li>
+<li class="toctree-l1 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-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>
+<li class="toctree-l1"><a class="reference internal"
href="../table_management.html">Table Management</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../table_management/table_overview.html">Overview of Tajo Tables</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../table_management/tablespaces.html">Tablespaces</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../table_management/file_formats.html">File Formats</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../table_management/compression.html">Compression</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../table_partitioning.html">Table Partitioning</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../partitioning/intro_to_partitioning.html">Introduction to
Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../partitioning/column_partitioning.html">Column Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../partitioning/range_partitioning.html">Range Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../partitioning/hash_partitioning.html">Hash Partitioning</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../storage_plugin.html">Storage Plugin</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../storage_plugin.html#overview">Overview</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../storage_plugin.html#register-custom-storage">Register custom
storage</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../storage_plugin.html#configuration">Configuration</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../index_overview.html">Index (Experimental Feature)</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../index/types.html">Index Types</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../index/how_to_use.html">How to use index?</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../index/future_work.html">Future Works</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../backup_and_restore.html">Backup and Restore</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../backup_and_restore/catalog.html">Backup and Restore Catalog</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../hive_integration.html">Hive Integration</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../hbase_integration.html">HBase Integration</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../hbase_integration.html#create-table">CREATE TABLE</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../hbase_integration.html#drop-table">DROP TABLE</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../hbase_integration.html#insert-overwrite-into">INSERT (OVERWRITE)
INTO</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../hbase_integration.html#usage">Usage</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../swift_integration.html">OpenStack Swift Integration</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../swift_integration.html#swift-configuration">Swift
configuration</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../swift_integration.html#hadoop-configurations">Hadoop
configurations</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../swift_integration.html#tajo-configuration">Tajo configuration</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../swift_integration.html#querying-on-swift">Querying on Swift</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../jdbc_driver.html">Tajo JDBC Driver</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC
driver</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC
Client</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../tajo_client_api.html">Tajo Client API</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../faq.html">FAQ</a></li>
+</ul>
+
+
+ </div>
+
+ </nav>
+
+ <section data-toggle="wy-nav-shift" class="wy-nav-content-wrap">
+
+
+ <nav class="wy-nav-top" role="navigation" aria-label="top navigation">
+ <i data-toggle="wy-nav-top" class="fa fa-bars"></i>
+ <a href="../index.html">Apache Tajo</a>
+ </nav>
+
+
+
+ <div class="wy-nav-content">
+ <div class="rst-content">
+ <div role="navigation" aria-label="breadcrumbs navigation">
+ <ul class="wy-breadcrumbs">
+ <li><a href="../index.html">Docs</a> »</li>
+
+ <li><a href="../functions.html">Functions</a> »</li>
+
+ <li>Data Type Functions and Operators</li>
+ <li class="wy-breadcrumbs-aside">
+
+ <a href="../_sources/functions/data_type_func_and_operators.txt"
rel="nofollow"> View page source</a>
+
+ </li>
+ </ul>
+ <hr/>
+</div>
+ <div role="main">
+
+ <div class="section" id="data-type-functions-and-operators">
+<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>
+<dd><p>Returns the binary representation of integer.</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>source</strong> – source value</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">to_bin</span><span
class="p">(</span><span class="mi">22</span><span class="p">);</span>
+<span class="o">></span> <span class="mi">10110</span>
+</pre></div>
+</div>
+</dd></dl>
+
+<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>
+<dd><p>Convert integer to 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>source</strong> – source value</li>
+<li><strong>format</strong> – format</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">to_char</span><span
class="p">(</span><span class="mi">125</span><span class="p">,</span> <span
class="s1">'00999'</span><span class="p">);</span>
+<span class="o">></span> <span class="mi">00125</span>
+</pre></div>
+</div>
+</dd></dl>
+
+<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>
+<dd><p>Convert the argument to hexadecimal.</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>source</strong> – source value</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">to_hex</span><span
class="p">(</span><span class="mi">15</span><span class="p">);</span>
+<span class="o">></span> <span class="n">F</span>
+</pre></div>
+</div>
+</dd></dl>
+
+</div>
+
+
+ </div>
+ <footer>
+
+ <div class="rst-footer-buttons" role="navigation" aria-label="footer
navigation">
+
+ <a href="math_func_and_operators.html" class="btn btn-neutral
float-right" title="Math Functions and Operators"/>Next <span class="fa
fa-arrow-circle-right"></span></a>
+
+
+ <a href="../functions.html" class="btn btn-neutral"
title="Functions"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+
+ </div>
+
+
+ <hr/>
+
+ <div role="contentinfo">
+ <p>
+ © Copyright 2014, Apache Tajo Team.
+ </p>
+ </div>
+
+ <a href="https://github.com/snide/sphinx_rtd_theme";>Sphinx theme</a>
provided by <a href="https://readthedocs.org";>Read the Docs</a>
+</footer>
+ </div>
+ </div>
+
+ </section>
+
+ </div>
+
+
+
+
+
+ <script type="text/javascript">
+ var DOCUMENTATION_OPTIONS = {
+ URL_ROOT:'../',
+ VERSION:'0.11.0',
+ COLLAPSE_INDEX:false,
+ FILE_SUFFIX:'.html',
+ HAS_SOURCE: true
+ };
+ </script>
+ <script type="text/javascript" src="../_static/jquery.js"></script>
+ <script type="text/javascript" src="../_static/underscore.js"></script>
+ <script type="text/javascript" src="../_static/doctools.js"></script>
+
+
+
+
+
+ <script type="text/javascript" src="../_static/js/theme.js"></script>
+
+
+
+
+ <script type="text/javascript">
+ jQuery(function () {
+ SphinxRtdTheme.StickyNav.enable();
+ });
+ </script>
+
+
+</body>
+</html>
\ No newline at end of file
Added: tajo/site/docs/devel/functions/window_func.html
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/functions/window_func.html?rev=1700402&view=auto
==============================================================================
--- tajo/site/docs/devel/functions/window_func.html (added)
+++ tajo/site/docs/devel/functions/window_func.html Tue Sep 1 06:48:19 2015
@@ -0,0 +1,382 @@
+
+
+<!DOCTYPE html>
+<!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
+<!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
+<head>
+ <meta charset="utf-8">
+ <meta name="viewport" content="width=device-width, initial-scale=1.0">
+
+ <title>Window Functions — Apache Tajo 0.11.0 documentation</title>
+
+
+
+
+
+
+ <link
href='https://fonts.googleapis.com/css?family=Lato:400,700|Roboto+Slab:400,700|Inconsolata:400,700'
rel='stylesheet' type='text/css'>
+
+
+
+
+
+
+
+
+
+ <link rel="stylesheet" href="../_static/css/theme.css" type="text/css" />
+
+
+
+ <link rel="top" title="Apache Tajo 0.11.0 documentation"
href="../index.html"/>
+ <link rel="up" title="Functions" href="../functions.html"/>
+ <link rel="next" title="Python Functions" href="python.html"/>
+ <link rel="prev" title="Aggregation Functions" href="agg_func.html"/>
+
+
+ <script
src="https://cdnjs.cloudflare.com/ajax/libs/modernizr/2.6.2/modernizr.min.js";></script>
+
+</head>
+
+<body class="wy-body-for-nav" role="document">
+
+ <div class="wy-grid-for-nav">
+
+
+ <nav data-toggle="wy-nav-shift" class="wy-nav-side">
+ <div class="wy-side-nav-search">
+ <a href="../index.html" class="fa fa-home"> Apache Tajo</a>
+ <div role="search">
+ <form id ="rtd-search-form" class="wy-form" action="../search.html"
method="get">
+ <input type="text" name="q" placeholder="Search docs" />
+ <input type="hidden" name="check_keywords" value="yes" />
+ <input type="hidden" name="area" value="default" />
+ </form>
+</div>
+ </div>
+
+ <div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation"
aria-label="main navigation">
+
+
+ <ul class="current">
+<li class="toctree-l1"><a class="reference internal"
href="../introduction.html">Introduction</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../getting_started.html">Getting Started</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../getting_started.html#prerequisites">Prerequisites</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../getting_started.html#dowload-and-unpack-the-source-code">Dowload and
unpack the source code</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../getting_started.html#build-source-code">Build source code</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../getting_started.html#setting-up-a-local-tajo-cluster">Setting up a
local Tajo cluster</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../getting_started.html#first-query-execution">First query
execution</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../configuration.html">Configuration</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/preliminary.html">Preliminary</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/cluster_setup.html">Cluster Setup</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/tajo_master_configuration.html">Tajo Master
Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/worker_configuration.html">Worker Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/catalog_configuration.html">Catalog
Configuration</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/ha_configuration.html">High Availability for
TajoMaster</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/service_config_defaults.html">Cluster Service
Configuration Defaults</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/tajo-site-xml.html">The tajo-site.xml File</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../configuration/catalog-site-xml.html">The catalog-site.xml File</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" href="../tsql.html">Tajo
Shell (TSQL)</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/meta_command.html">Meta Commands</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/dfs_command.html">Executing HDFS commands</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/variables.html">Session Variables</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/admin_command.html">Administration Commands</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/intro.html">Introducing to TSQL</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/single_command.html">Executing a single command</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/execute_file.html">Executing Queries from Files</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../tsql/background_command.html">Executing as background process</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../sql_language.html">SQL Language</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/data_model.html">Data Model</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/ddl.html">Data Definition Language</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/insert.html">INSERT (OVERWRITE) INTO</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/alter_table.html">ALTER TABLE</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/queries.html">Queries</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/joins.html">Joins</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/sql_expression.html">SQL Expressions</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../sql_language/predicates.html">Predicates</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../time_zone.html">Time Zone</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../time_zone.html#server-cluster-time-zone">Server Cluster Time
Zone</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../time_zone.html#table-time-zone">Table Time Zone</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../time_zone.html#client-time-zone">Client Time Zone</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../time_zone.html#time-zone-id">Time Zone ID</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../time_zone.html#examples-of-time-zone">Examples of Time Zone</a></li>
+</ul>
+</li>
+<li class="toctree-l1 current"><a class="reference internal"
href="../functions.html">Functions</a><ul class="current">
+<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 current"><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>
+<li class="toctree-l1"><a class="reference internal"
href="../table_management.html">Table Management</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../table_management/table_overview.html">Overview of Tajo Tables</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../table_management/tablespaces.html">Tablespaces</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../table_management/file_formats.html">File Formats</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../table_management/compression.html">Compression</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../table_partitioning.html">Table Partitioning</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../partitioning/intro_to_partitioning.html">Introduction to
Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../partitioning/column_partitioning.html">Column Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../partitioning/range_partitioning.html">Range Partitioning</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../partitioning/hash_partitioning.html">Hash Partitioning</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../storage_plugin.html">Storage Plugin</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../storage_plugin.html#overview">Overview</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../storage_plugin.html#register-custom-storage">Register custom
storage</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../storage_plugin.html#configuration">Configuration</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../index_overview.html">Index (Experimental Feature)</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../index/types.html">Index Types</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../index/how_to_use.html">How to use index?</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../index/future_work.html">Future Works</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../backup_and_restore.html">Backup and Restore</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../backup_and_restore/catalog.html">Backup and Restore Catalog</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../hive_integration.html">Hive Integration</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../hbase_integration.html">HBase Integration</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../hbase_integration.html#create-table">CREATE TABLE</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../hbase_integration.html#drop-table">DROP TABLE</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../hbase_integration.html#insert-overwrite-into">INSERT (OVERWRITE)
INTO</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../hbase_integration.html#usage">Usage</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../swift_integration.html">OpenStack Swift Integration</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../swift_integration.html#swift-configuration">Swift
configuration</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../swift_integration.html#hadoop-configurations">Hadoop
configurations</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../swift_integration.html#tajo-configuration">Tajo configuration</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../swift_integration.html#querying-on-swift">Querying on Swift</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../jdbc_driver.html">Tajo JDBC Driver</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="../jdbc_driver.html#how-to-get-jdbc-driver">How to get JDBC
driver</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../jdbc_driver.html#setting-the-classpath">Setting the CLASSPATH</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="../jdbc_driver.html#an-example-jdbc-client">An Example JDBC
Client</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal"
href="../tajo_client_api.html">Tajo Client API</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../faq.html">FAQ</a></li>
+</ul>
+
+
+ </div>
+
+ </nav>
+
+ <section data-toggle="wy-nav-shift" class="wy-nav-content-wrap">
+
+
+ <nav class="wy-nav-top" role="navigation" aria-label="top navigation">
+ <i data-toggle="wy-nav-top" class="fa fa-bars"></i>
+ <a href="../index.html">Apache Tajo</a>
+ </nav>
+
+
+
+ <div class="wy-nav-content">
+ <div class="rst-content">
+ <div role="navigation" aria-label="breadcrumbs navigation">
+ <ul class="wy-breadcrumbs">
+ <li><a href="../index.html">Docs</a> »</li>
+
+ <li><a href="../functions.html">Functions</a> »</li>
+
+ <li>Window Functions</li>
+ <li class="wy-breadcrumbs-aside">
+
+ <a href="../_sources/functions/window_func.txt" rel="nofollow"> View
page source</a>
+
+ </li>
+ </ul>
+ <hr/>
+</div>
+ <div role="main">
+
+ <div class="section" id="window-functions">
+<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>
+<dd><p>Returns the first value of input rows.</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>value</strong> – input value</td>
+</tr>
+<tr class="field-even field"><th class="field-name">Return type:</th><td
class="field-body">same as parameter data type</td>
+</tr>
+</tbody>
+</table>
+</dd></dl>
+
+<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>
+<dd><p>Returns the last value of input rows.</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>value</strong> – input value</td>
+</tr>
+<tr class="field-even field"><th class="field-name">Return type:</th><td
class="field-body">same as parameter data type</td>
+</tr>
+</tbody>
+</table>
+</dd></dl>
+
+<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>
+<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" />
+<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>value</strong> – input value</li>
+<li><strong>offset</strong> – offset</li>
+<li><strong>default</strong> – default value</li>
+</ul>
+</td>
+</tr>
+<tr class="field-even field"><th class="field-name">Return type:</th><td
class="field-body"><p class="first last">same as parameter data type</p>
+</td>
+</tr>
+</tbody>
+</table>
+</dd></dl>
+
+<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>
+<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" />
+<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>value</strong> – input value</li>
+<li><strong>offset</strong> – offset</li>
+<li><strong>default</strong> – default value</li>
+</ul>
+</td>
+</tr>
+<tr class="field-even field"><th class="field-name">Return type:</th><td
class="field-body"><p class="first last">same as parameter data type</p>
+</td>
+</tr>
+</tbody>
+</table>
+</dd></dl>
+
+<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>
+<dd><p>Returns rank of the current row with gaps.</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">Return type:</th><td
class="field-body">int8</td>
+</tr>
+</tbody>
+</table>
+</dd></dl>
+
+<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>
+<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" />
+<col class="field-body" />
+<tbody valign="top">
+<tr class="field-odd field"><th class="field-name">Return type:</th><td
class="field-body">int8</td>
+</tr>
+</tbody>
+</table>
+</dd></dl>
+
+</div>
+
+
+ </div>
+ <footer>
+
+ <div class="rst-footer-buttons" role="navigation" aria-label="footer
navigation">
+
+ <a href="python.html" class="btn btn-neutral float-right"
title="Python Functions"/>Next <span class="fa
fa-arrow-circle-right"></span></a>
+
+
+ <a href="agg_func.html" class="btn btn-neutral" title="Aggregation
Functions"><span class="fa fa-arrow-circle-left"></span> Previous</a>
+
+ </div>
+
+
+ <hr/>
+
+ <div role="contentinfo">
+ <p>
+ © Copyright 2014, Apache Tajo Team.
+ </p>
+ </div>
+
+ <a href="https://github.com/snide/sphinx_rtd_theme";>Sphinx theme</a>
provided by <a href="https://readthedocs.org";>Read the Docs</a>
+</footer>
+ </div>
+ </div>
+
+ </section>
+
+ </div>
+
+
+
+
+
+ <script type="text/javascript">
+ var DOCUMENTATION_OPTIONS = {
+ URL_ROOT:'../',
+ VERSION:'0.11.0',
+ COLLAPSE_INDEX:false,
+ FILE_SUFFIX:'.html',
+ HAS_SOURCE: true
+ };
+ </script>
+ <script type="text/javascript" src="../_static/jquery.js"></script>
+ <script type="text/javascript" src="../_static/underscore.js"></script>
+ <script type="text/javascript" src="../_static/doctools.js"></script>
+
+
+
+
+
+ <script type="text/javascript" src="../_static/js/theme.js"></script>
+
+
+
+
+ <script type="text/javascript">
+ jQuery(function () {
+ SphinxRtdTheme.StickyNav.enable();
+ });
+ </script>
+
+
+</body>
+</html>
\ No newline at end of file
