Group By Time
This applies to: Visual Data Discovery
Many 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 Symphony data discovery’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 connector 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 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 |