Group By Multiple Fields
Many Composer 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 Composer connectors 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 | ||
| MemSQL | Y | ||
| Microsoft SQL Server | Y | ||
| MongoDB | Y | ||
| MySQL | Y | ||
| Oracle | Y | ||
| PostgreSQL | Y | ||
| Real Time Sales | Y | ||
| SAP Hana | Y | ||
| SAP IQ | Y | ||
| Snowflake | Y | ||
| Spark SQL | Y | ||
| Teradata | Y | ||
| TIBCO DV | Y | ||
| Trino | Y | ||
| File Upload (Upload API) | Y | ||
| Vertica | Y | ||
Comments
0 comments
Please sign in to leave a comment.