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