SHOW TABLE CREATION

Description

1. 该语句用于展示指定的 Iceberg Database 建表任务的执行情况
2. 语法：
3. SHOW TABLE CREATION [FROM db_name] [LIKE table_name_wild];

5. 说明：
6. 1. 使用说明
7. 1) 如果不指定 db_name，使用当前默认 db
8. 2) 如果使用 LIKE，则会匹配表名中包含 table_name_wild 的建表任务
9. 2. 各列含义说明
10. 1) Database: 数据库名称
11. 2) Table：要创建表的名称
12. 3) Status：表的创建状态，`success`/`fail`
13. 4) CreateTime：执行创建该表任务的时间
14. 5) Error Msg：创建表失败的错误信息，如果成功，则为空。

example

1. 1. 展示默认 Iceberg db 中所有的建表任务
2. SHOW TABLE CREATION;

4. mysql> show table creation ;
5. +----------------------------+--------+---------+---------------------+----------------------------------------------------------+
6. | Database                   | Table  | Status  | Create Time         | Error Msg                                                |
7. +----------------------------+--------+---------+---------------------+----------------------------------------------------------+
8. | default_cluster:iceberg_db | logs_1 | success | 2022-01-24 19:42:45 |                                                          |
9. | default_cluster:iceberg_db | logs   | fail    | 2022-01-24 19:42:45 | Cannot convert Iceberg type[list<string>] to Doris type. |
10. +----------------------------+--------+---------+---------------------+----------------------------------------------------------+

12. 2. 展示指定 Iceberg db 中的建表任务
13. SHOW TABLE CREATION FROM example_db;

15. mysql> show table creation from iceberg_db;
16. +----------------------------+--------+---------+---------------------+----------------------------------------------------------+
17. | Database                   | Table  | Status  | Create Time         | Error Msg                                                |
18. +----------------------------+--------+---------+---------------------+----------------------------------------------------------+
19. | default_cluster:iceberg_db | logs_1 | success | 2022-01-24 19:42:45 |                                                          |
20. | default_cluster:iceberg_db | logs   | fail    | 2022-01-24 19:42:45 | Cannot convert Iceberg type[list<string>] to Doris type. |
21. +----------------------------+--------+---------+---------------------+----------------------------------------------------------+

23. 3. 展示指定 Iceberg db 中的建表任务，表名中包含字符串 "log" 的任务
24. SHOW TABLE CREATION FROM example_db LIKE '%log%';

26. mysql> show table creation from iceberg_db like "%1";
27. +----------------------------+--------+---------+---------------------+-----------+
28. | Database                   | Table  | Status  | Create Time         | Error Msg |
29. +----------------------------+--------+---------+---------------------+-----------+
30. | default_cluster:iceberg_db | logs_1 | success | 2022-01-24 19:42:45 |           |
31. +----------------------------+--------+---------+---------------------+-----------+

keyword

1. SHOW,TABLE CREATION