footmanai opened a new issue, #2285:
URL: https://github.com/apache/doris-website/issues/2285

   
Path:/zh-CN/docs/3.0/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-STATUS
   
   环境情况:
    doris 3.0、mysql 8.0、
    创建与 mysql 关联的 category,category 名称为 dit;
    mysql 下有一个 schema 名为 base,还有一张表 t_yardage
    查询驱动使用 jdbc:arrow-flight-sql 版本 0.12.0
   
   2)在mysql下执行的SQL
   
   `SELECT
       table_name,
       table_comment
   FROM
   information_schema.TABLES
   WHERE
   table_schema = 'base' and table_name='t_yardage'`
   
   结果:
   table_name,table_comment
   t_yardage,全码谱明细值
   
   3)在 doris 下采用下面3种方式查询结果 
   
   1. 方式1:
   
   `use dit.base;
   show table status like 't_yardage';`
   
   结果:
   comment 列为空白
   
   2. 方式2:
   
   `show table status from dit.base.t_yardage;`
   
   结果:
   执行错误
   
   3. 方式3:
   
   `SELECT
       table_name,
       table_comment
   FROM
       dit.information_schema.TABLES
   WHERE
       table_schema = 'base' where table_name = 't_yardage'`
   
   结果:
   comment 列为空白
   
   通过 category 获取表 comment 都是空白。
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to