Fast Distinct Values

Composer connectors that support fast distinct values can efficiently return distinct values for a field. This functionality optimizes the retrieval of distinct (unique) values in large numbers of records. If a connector supports this feature, the Filter dialog is populated with distinct values for an attribute directly from the data source, without the need to refresh the data and without retrieving or storing the distinct values in Composer's metadata. For example, Elasticsearch keeps lists of distinct values at the ready. Features such as these make fast distinct values possible for your connector.

There is no metric that defines “fast”. This value is based on the judgment of the developer.

When custom ranges or list values are requested for a field, full data scans are not performed.

For most connectors, this feature can be safely left disabled without impact.

Support for this feature by Composer connectors is shown in the following table.

Key: Y - Supported; N - Not Supported; N/A - not applicable

Connector Supported?
Amazon Redshift N/A
Amazon S3 N/A
Apache Drill N/A
Apache Phoenix N/A
Apache Phoenix Query Server (QS) N/A
Apache Solr Y
BigQuery N/A
Cloudera Impala N/A
Cloudera Search Y
Couchbase N/A
Dremio N/A
Elasticsearch 6.0 Y
Elasticsearch 7.0 Y
Flat File N/A
HDFS N/A
Hive N/A
MemSQL N/A
Microsoft SQL Server N/A
MongoDB N/A
MySQL N/A
Oracle N/A
PostgreSQL N/A
Presto N/A
Real Time Sales N/A
SAP Hana N/A
SAP IQ N/A
Snowflake N/A
Spark SQL N/A
Teradata N/A
TIBCO DV N/A
Upload API N/A
Vertica N/A