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