DESCRIBE HISTORY
描述
DESCRIBE HISTORY 语句返回指定表的版本历史记录。
语法
{ DESC | DESCRIBE } HISTORY table_identifier [ LIMIT { ALL | limit_expression } ]参数
table_identifier
指定表名，可以选择性地用数据库名称限定。
语法:
[ database_name. ] table_nameLIMIT
指定返回的行数，使用
ALL时返回所有条目，也使用表达式limit_expression指定特定行数。
示例
-- 创建表 `student` 并插入三条数据。
CREATE TABLE student (id INT, name STRING)
INSERT INTO student VALUES (1, 'John')
INSERT INTO student VALUES (2, 'Jane')
INSERT INTO student VALUES (3, 'Doe')
-- 查看表 `student` 的历史记录。
DESCRIBE HISTORY student
+-------+------+---------------------------------------------------------------+----+----+-----------------------+----------+---------+------+
|version|action|description |size|rows|commitTime |timeTravel|worksheet|user |
+-------+------+---------------------------------------------------------------+----+----+-----------------------+----------+---------+------+
|2 |insert|运行sql: CREATE TABLE student (id INT, name STRING);\nINSERT...|551 |1 |2024-10-22 17:00:37.604|8小时前 |20045 | rain|
|1 |insert|运行sql: CREATE TABLE student (id INT, name STRING);\nINSERT...|560 |1 |2024-10-22 17:00:36.698|8小时前 |20045 | rain|
|0 |insert|运行sql: CREATE TABLE student (id INT, name STRING);\nINSERT...|560 |1 |2024-10-22 17:00:35.458|8小时前 |20045 | rain|
+-------+------+---------------------------------------------------------------+----+----+-----------------------+----------+---------+------+
-- 查看表 `student` 的历史记录，限制返回两条。
DESCRIBE HISTORY student LIMIT 2
+-------+------+---------------------------------------------------------------+----+----+-----------------------+----------+---------+------+
|version|action|description |size|rows|commitTime |timeTravel|worksheet|user |
+-------+------+---------------------------------------------------------------+----+----+-----------------------+----------+---------+------+
|2 |insert|运行sql: CREATE TABLE student (id INT, name STRING);\nINSERT...|551 |1 |2024-10-22 17:00:37.604|8小时前 |20045 | rain|
|1 |insert|运行sql: CREATE TABLE student (id INT, name STRING);\nINSERT...|560 |1 |2024-10-22 17:00:36.698|8小时前 |20045 | rain|
+-------+------+---------------------------------------------------------------+----+----+-----------------------+----------+---------+------+