🔗 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
Regular streams in Timeplus are immutable, and stored in columnar format. Mutable streams are stored in row format (implemented via RocksDB), and can be updated or deleted. It is 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.
📄️ TRUNCATE STREAM
Run the following SQL to remove the historical data from a stream, keeping the schema and the stream itself.
📄️ 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
📄️ CREATE DATABASE
Starting from Timeplus Enterprise 2.6, you can create a database to organize your streams, materialized views and other resources. The database is a logical container to help you to manage and query the data more efficiently.
📄️ SHOW DATABASES
Starting from Timeplus Enterprise 2.6, you can create a database to organize your streams, materialized views and other resources. The database is a logical container to help you to manage and query the data more efficiently.
📄️ DROP DATABASE
Starting from Timeplus Enterprise 2.6, you can create a database to organize your streams, materialized views and other resources. The database is a logical container to help you to manage and query the data more efficiently.
📄️ SYSTEM PAUSE
SYSTEM PAUSE MATERIALIZED VIEW
📄️ SYSTEM UNPAUSE
SYSTEM UNPAUSE MATERIALIZED VIEW