We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
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种方式查询结果
use dit.base; show table status like 't_yardage';
结果: comment 列为空白
show table status from dit.base.t_yardage;
结果: 执行错误
SELECT table_name, table_comment FROM dit.information_schema.TABLES WHERE table_schema = 'base' where table_name = 't_yardage'
通过 category 获取表 comment 都是空白。
The text was updated successfully, but these errors were encountered:
这个问题是通过arrow flight sql 去连接Doris,通过 mysql catalog 查询mysql 下的表,comment 没数据?是这样吗
Sorry, something went wrong.
不止mysql,试过其他数据库也是comment没有数据(hana,oracle)
No branches or pull requests
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种方式查询结果
use dit.base; show table status like 't_yardage';
结果:
comment 列为空白
show table status from dit.base.t_yardage;
结果:
执行错误
SELECT table_name, table_comment FROM dit.information_schema.TABLES WHERE table_schema = 'base' where table_name = 't_yardage'
结果:
comment 列为空白
通过 category 获取表 comment 都是空白。
The text was updated successfully, but these errors were encountered: