SHOW TABLE CREATION

Description

1. This statement is used to show the execution of the specified Iceberg Database table creation task
2. Syntax.
3. SHOW TABLE CREATION [FROM db_name] [LIKE table_name_wild];

5. Description.
6. 1. Usage Notes
7. 1) If db_name is not specified, the current default db is used.
8. 2) If you use LIKE, it will match the table creation task with table_name_wild in the table name
9. 2. The meaning of each column
10. 1) Database: the name of the database
11. 2) Table: the name of the table to be created
12. 3) Status: the creation status of the table, `success`/`fail`.
13. 4) CreateTime: the time to perform the task of creating the table
14. 5) Error Msg: Error message of the failed table creation, or empty if it succeeds.

example

1. 1. Show all the table creation tasks in the default 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. Show the table creation tasks in the specified 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. Show table creation tasks for the specified Iceberg db with the string "log" in the table name
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