Skip to content

Issue on docs #2285

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
footmanai opened this issue Apr 11, 2025 · 2 comments
Open

Issue on docs #2285

footmanai opened this issue Apr 11, 2025 · 2 comments

Comments

@footmanai
Copy link

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 列为空白

  1. 方式2:

show table status from dit.base.t_yardage;

结果:
执行错误

  1. 方式3:

SELECT table_name, table_comment FROM dit.information_schema.TABLES WHERE table_schema = 'base' where table_name = 't_yardage'

结果:
comment 列为空白

通过 category 获取表 comment 都是空白。

@yuanyuan8983
Copy link
Contributor

这个问题是通过arrow flight sql 去连接Doris,通过 mysql catalog 查询mysql 下的表,comment 没数据?是这样吗

@footmanai
Copy link
Author

不止mysql,试过其他数据库也是comment没有数据(hana,oracle)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants