Appendix : Legacy Presto components : MashZone NextGen Analytics : RAQL Queries : Over Techniques
Over Techniques
Column Expression
Example
over
()
To use the entire dataset as one partition, see the middle subquery in From Subqueries.
(partition column-name)
To group with a simple partition, see Group and Analyze Rows with Row Detail
(partition column-name between rows n preceding and n following )
To apply a window to each row within a partition, see Partitions and Windows
(partition column-name order by column-name)
To obtain running calculations in partitions, see Running Aggregates.
To provide an index of each row or ranking within each partition, see Number or Rank Rows.
any-partition-expression
For examples of statistical analysis, see Analytic Functions for Partitions and Windows.
Copyright © 2013-2017 Software AG, Darmstadt, Germany. (Innovation Release)

Product LogoContact Support   |   Community   |   Feedback