Cloudera Data Visualization supports several analytic functions that examine
overlapping groupings of data.
Analytic functions are similar to aggregate functions because both use the contents of multiple
data input rows to calculate the result. Analytic functions use flexible conditions that are
specified by the OVER(...) clause to order and group input so that specific rows
may be part of the calculation for several output values.
Syntax for analytic functions is slightly different depending on the type of data connection
used.
Supported Data Connections include the following:
Impala
Hive
PostgreSQL
SparkSQL
RedShift
The Analytic Functions field properties are not available on MariaDB, MySQL, non-Oracle SQLite,
Apache Drill, and Apache Solr connections.