SQL Commands

📄️ 创建流

Stream is a key concept in Timeplus. 所有数据都存在于流中，无论是静态数据还是动态数据。 We don't recommend you to create or manage TABLE in Timeplus.

📄️ 创建随机流

You may use this special stream to generate random data for tests. 例如：例如：

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.

📄️ 改变流

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.

📄️ sql-show-streams

列出流

📄️ 下拉流

运行以下 SQL 来删除流或外部流，并将所有数据存储在流存储和历史存储中。

📄️ CREATE FORMAT

Timeplus 支持以 Protobuf 或 Avro 格式读取或写入消息。本文档介绍如何在没有架构注册表的情况下处理数据。 Check this page if your Kafka topics are associated with a Schema Registry.

📄️ 显示格式架构

List schemas in the current Timeplus deployment:

📄️ DROP FORMAT SCHEMA

📄️ 创建视图

Timeplus 有两种类型的视图：逻辑视图（或普通View）和物化视图（Materialized View）。

📄️ CREATE MATERIALIZED VIEW

物化视图与常规视图之间的区别在于，物化视图在创建后一直在后台运行，由此产生的数据将写入内部存储(即所谓的物化)。

📄️ 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.