🔗 SELECT
📄️ 创建流
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 来删除流或外部流，并将所有数据存储在流存储和历史存储中。
📄️ TRUNCATE STREAM
Run the following SQL to remove the historical data from a stream, keeping the schema and the stream itself.
📄️ 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.
📄️ 拖放视图
运行以下 SQL 来删除视图或物化视图。
📄️ 创建外部表
语法
📄️ CREATE FUNCTION
在 Timeplus 中，我们通过 SQL 让广大用户更容易获取强大的流式分析功能。 如果不用 SQL ，您必须学习并调用比较底层的编程API，然后编译/打包/部署它们以获得分析结果。 这是一个重复性和棘手的过程，即使对小的变化来说也是如此。
📄️ SHOW FUNCTIONS
List available User-Defined Functions.
📄️ 删除函数
No matter UDF or UDAF, you can remove the function via DROP FUNCTION
📄️ CREATE REMOTE FUNCTION
在 Timeplus 中，我们通过 SQL 让广大用户更容易获取强大的流式分析功能。 如果不用 SQL ，您必须学习并调用比较底层的编程API，然后编译/打包/部署它们以获得分析结果。 这是一个重复性和棘手的过程，即使对小的变化来说也是如此。
📄️ 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