Multivalued Fields

Some Composer connectors support aggregation by multivalued fields, such as arrays.

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?	Notes
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	The Apache Solr JSON API does not support metrics by multivalued fields.
BigQuery	N/A
Cloudera Impala	N/A
Cloudera Search	Y
Couchbase	N/A	The Couchbase connector supports multivalued fields with some limitations. See the detailed description in Manage the Couchbase Connector.
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	Y	Mongo DB unwinds multivalued fields which may result in incorrect metrics' results.
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

Related articles