Live Mode and Historical Playback

Live mode and historical playback (also known as Data DVR) allow you to get the most from data stores that support playback. The only difference between live mode and historical playback is the time range that is selected.

  • Live mode refreshes field data on your visuals for fields that are indexed as playable. In live mode, your data plays forever without an end date.
  • Historical playback (Data DVR) shows the historical record of field data for fields that are indexed as playable. Playback can show up to the last moment before the current period in your data.

Live mode and historical playback require an index or partition field. The data store should be capable of receiving new or updated data, that is, data that is not static like flat files. If the data store does not support indexing or partitioning, then live mode and historical playback are not available. For most data stores, indexing is the default.

Live mode and historical playback are supported for even time intervals. See Even Time Intervals. Live mode an historical playback are not supported for fused data sources. See Data Fusion Limitations.

Playback mode (Data DVR) is available if the Time field in your data set has the playable parameter set to True and the granularity of the field is not greater than day. When is the "playable" property in the data source set to true?

  1. If the field in the data source is indexed or partitioned. For Impala data sources, this option can also be enabled if the selected field has a connection to the partitioned field.

  2. If the data source is Spark (for example, SparkSQL)

  3. In Amazon Redshift, data sources for the first sort key.

Support for this feature by Composer connectors is shown in the following table.

Key: P - Supported; O - Not Supported; N/A - not applicable

Connector Supported?
Amazon Redshift P
Amazon S3 P
Apache Drill P
Apache Phoenix P
Apache Phoenix Query Server (QS) P
Apache Solr P
BigQuery P
Cloudera Impala P
Cloudera Search P
Couchbase P
Dremio P
Elasticsearch 6.0 P
Elasticsearch 7.0 P
Flat File P
HDFS P
Hive P
MemSQL P
Microsoft SQL Server P
MongoDB P
MySQL P
Oracle P
PostgreSQL P
Presto P
Real Time Sales P
SAP Hana P
SAP IQ P
Snowflake P
Spark SQL P
Teradata P
TIBCO DV P
Upload API P
Vertica P

See also Configuring Time Bar Defaults.