🔗 SELECT
📄️ 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:
📄️ CREATE EXTERNAL STREAM
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.
📄️ DROP VIEW
Run the following SQL to drop a view or a materialized view.
📄️ CREATE EXTERNAL TABLE
Syntax
📄️ CREATE FUNCTION
At Timeplus, we leverage SQL to make powerful streaming analytics more accessible to a broad range of users. Without SQL, you have to learn and call low-level programming API, then compile/package/deploy them to get analytics results. This is a repetitive and tedious process, even for small changes.
📄️ SHOW FUNCTIONS
List available User-Defined Functions.
📄️ DROP FUNCTION
No matter UDF or UDAF, you can remove the function via DROP FUNCTION
📄️ CREATE REMOTE FUNCTION
At Timeplus, we leverage SQL to make powerful streaming analytics more accessible to a broad range of users. Without SQL, you have to learn and call low-level programming API, then compile/package/deploy them to get analytics results. This is a repetitive and tedious process, even for small changes.
📄️ SHOW CREATE
Show Details For A Stream
📄️ SYSTEM PAUSE
SYSTEM PAUSE MATERIALIZED VIEW
📄️ SYSTEM UNPAUSE
SYSTEM UNPAUSE MATERIALIZED VIEW