Multivalued Fields

This applies to: Visual Data Discovery

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

Support for this feature by connector 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
Jira	N
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
Python	N
Real Time Sales	N/A
Salesforce	N
SAP Hana	N/A
SAP IQ	N/A
Spark SQL	N/A
Snowflake	N/A
Teradata	N/A
TIBCO DV	N/A
Trino	N/A
File Upload (Upload API)	N/A
Vertica	N/A