Group By Time

Many Composer connectors support grouping data by a real time field. This function is a prerequisite for all time-based visuals.

Most commonly, the data includes a date or time stamp field type that corresponds to Composer’s date field type. Here is a sample SQL query:

select timeField, max(otherField) from myCollection group by timeField

If grouping on time is not supported, some visuals will be unavailable for the 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?
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