You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Yubin Li (Jira)" <ji...@apache.org> on 2022/10/19 02:04:00 UTC

[jira] [Commented] (FLINK-29679) DESCRIBE statement shows column comment

    [ https://issues.apache.org/jira/browse/FLINK-29679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17619932#comment-17619932 ] 

Yubin Li commented on FLINK-29679:
----------------------------------

[~luoyuxia] table's comment is a table level prop, we could use `show create table <table_name>` to display table's comment, eg:

```

CREATE TABLE `default_catalog`.`default_database`.`t2` (
  `id` INT
) COMMENT 'hello2'
WITH (
  'connector' = 'print'
)

```

`DESCRIBE` statement shows column level props, such as column's comment.

> DESCRIBE statement shows column comment
> ---------------------------------------
>
>                 Key: FLINK-29679
>                 URL: https://issues.apache.org/jira/browse/FLINK-29679
>             Project: Flink
>          Issue Type: New Feature
>          Components: Table SQL / API
>    Affects Versions: 1.17.0
>            Reporter: Yubin Li
>            Assignee: Yubin Li
>            Priority: Major
>
> comment is very helpful to make table schema user-friendly, many data analysers rely on such message to write sql adaptive to corresponding business logics.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)