Github user zellerh commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/990#discussion_r104524268
--- 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 --
Would it make sense to list those functions under a separate heading, so it
is clear that they are not confused with the ANSI SQL OLAP functions? Maybe
also give an example?
---
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.
---
