Github user liuyu000 commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/990#discussion_r104583550
--- Diff: docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc ---
@@ -26,8 +26,20 @@
[[olap_functions]]
= OLAP Functions
-This section describes the syntax and semantics of the On Line
-Analytical Process (OLAP) window functions. The OLAP window functions
+On-line Analytical Process (OLAP) functions provide the capability to
partition source data into groups of rows, order the rows in each group,
compute aggregates within a window frame for a row. Typically, an OLAP function
in SQL is expressed in two components <FUNCTION> and <OVER>: <FUNCTION>
specifies the function and the arguments, and <OVER> specifies the
partitioning, the ordering and the window frames. <OVER> is sometimes called
the window. OLAP functions are used to perform analytic tasks against data sets
stored in or computed from a set of tables, such as moving average and ranks.
+
+Trafodion also supports a set of sequence functions which are SQL
extensions and have to be used together with a SEQUENCE BY clause. These
sequence functions can be used to compute a running quantity of a column up to
and include the current row as follows.
--- End diff --
Thanks Hans & Ming.
I've updated this part based on your advice to improve the readability. :)
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
