Group By UNIX Time

Many Composer connectors support grouping data by an integer field that contains times in Unix (epoch) time.

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 N
Elasticsearch 7.0 N
Flat File Y
HDFS Y
Hive Y
MemSQL Y
Microsoft SQL Server Y
MongoDB N
MySQL Y
Oracle Y
PostgreSQL Y
Presto Y
Real Time Sales N
SAP Hana Y
SAP IQ Y
Snowflake Y
Spark SQL Y
Teradata Y
TIBCO DV Y
Upload API Y
Vertica Y