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  
Cloudera Impala Y
Cloudera Search N
Couchbase Y
Dremio Y  
Elasticsearch 6.0 Y
Elasticsearch 7.0 Y
Flat File Y  
HDFS Y  
Hive Y  
MemSQL Y  
Microsoft SQL Server Y  
MongoDB Y



MySQL Y  
Oracle Y
PostgreSQL Y  
Presto Y  
Real Time Sales Y  
SAP Hana Y  
SAP IQ Y  
Snowflake Y  
Spark SQL Y
Teradata Y  
TIBCO DV Y  
Upload API Y  
Vertica Y