Group By Multiple Fields
This applies to: Visual Data Discovery
Many connectors can group by more than one field in a query. Here is a sample SQL query:
select firstField, secondField, count(distinct otherField) from myCollection group by firstField, secondField
If multi-group querying is not supported, some visuals will be unavailable for a data source.
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 | Y | |
| Amazon S3 | Y | |
| Apache Drill | Y | |
| Apache Phoenix | Y | |
| Apache Phoenix Query Server (QS) | Y | |
| Apache Solr | Y | |
| BigQuery | Y | 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 | Y | |
| Cloudera Search | N | |
| Couchbase | Y | |
| Dremio | Y | |
| Elasticsearch 7.0 | Y | |
| Elasticsearch 8.0 | Y | |
| File Upload | Y | |
| HDFS | Y | |
| Hive | Y | |
| Jira | Y | |
| MemSQL | Y | |
| Microsoft SQL Server | Y | |
| MongoDB | Y | |
| MySQL | Y | |
| Oracle | Y | |
| PostgreSQL | Y | |
| Python | Y | |
| Real Time Sales | Y | |
| Salesforce | Y | |
| SAP Hana | Y | |
| SAP IQ | Y | |
| Spark SQL | Y | |
| Snowflake | Y | |
| Teradata | Y | |
| TIBCO DV | Y | |
| Trino | Y | |
| File Upload (Upload API) | Y | |
| Vertica | Y |