Supported connections

CDP 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.