SQL Commands | Timeplus

📄️ CREATE STREAM

Stream is a key concept in Timeplus. All data lives in streams, no matter static data or data in motion. We don't recommend you to create or manage TABLE in Timeplus.

📄️ CREATE RANDOM STREAM

You may use this special stream to generate random data for tests. For example:

External stream for Kafka is official supported. The external stream for local log files is at technical preview. In Timeplus Enterprise, it also supports another type of External Stream to read/write data for a remote Timeplus Enterprise.

📄️ CREATE MUTABLE STREAM

Mutable streams are only available in Timeplus Enterprise. Please check this page for details.

📄️ ALTER STREAM

Currently we don't recommend to alter the schema of streams in Timeplus. You can modify the retention policy for historical store via MODIFY TTL and modify the retention policy for streaming storage via MODIFY SETTING.

📄️ SHOW STREAMS

List Streams

📄️ DROP STREAM

Run the following SQL to drop a stream or an external stream, with all data in streaming storage and historical storage.

📄️ CREATE FORMAT

Timeplus supports reading or writing messages in Protobuf or Avro format. This document covers how to process data without a Schema Registry. Check this page if your Kafka topics are associated with a Schema Registry.

📄️ SHOW FORMAT SCHEMAS

List schemas in the current Timeplus deployment:

📄️ DROP FORMAT SCHEMA

📄️ CREATE VIEW

There are two types of views in Timeplus: logical view (or just view ) and materialized view.

📄️ CREATE MATERIALIZED VIEW

The difference between a materialized view and a regular view is that the materialized view is running in background after creation and the resulting stream is physically written to internal storage (hence it's called materialized).

📄️ ALTER VIEW

You can use this SQL to change a view or a materialized view. Today only the settings can be changed. To change the SQL query behinds the view, you have to drop and re-create it.