(v22) Multivalued Fields

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			If you need to access a BigQuery partition, explicitly include an alias for the built in partition column in your select clause, such as select *, _PARTITIONTIME as pt from projectId.datasetId.tableId.
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 7.0	Y
Elasticsearch 8.0	Y
File Upload	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
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
Trino	N/A
File Upload (Upload API)	N/A
Vertica	N/A