[FLINK-23193] Support to display Options when using desc table statement

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Implemented
• Component/s: Table SQL / Client
• Assignee: Unassigned
• Reporter: Fangliang Liu
• Created: 30/Jun/21 13:06
• Updated: 01/Jul/21 02:50
• Resolved: 01/Jul/21 02:50

Description

I use the following statement to create a table.

CREATE TABLE datagen (
  f_sequence INT,
  f_key1 INT,
  f_key2 INT,
  f_random_str STRING,
  log_ts  TIMESTAMP(3),
  WATERMARK FOR log_ts AS log_ts
) WITH (
  'connector' = 'datagen',
  'rows-per-second' = '10',
  'fields.f_sequence.kind' = 'sequence',
  'fields.f_sequence.start' = '1',
  'fields.f_sequence.end' = '10000',
  'fields.f_key1.min' = '1',
  'fields.f_key1.max' = '20',
  'fields.f_key2.min' = '1',
  'fields.f_key2.max' = '20',
  'fields.f_random_str.length' = '5'
);

When I use the `desc datagen` to view the table. Got the following result.

+--------------+------------------------+------+-----+--------+-----------+
|         name |                   type | null | key | extras | watermark |
+--------------+------------------------+------+-----+--------+-----------+
|   f_sequence |                    INT | true |     |        |           |
|       f_key1 |                    INT | true |     |        |           |
|       f_key2 |                    INT | true |     |        |           |
| f_random_str |                 STRING | true |     |        |           |
|       log_ts | TIMESTAMP(3) *ROWTIME* | true |     |        |  `log_ts` |
+--------------+------------------------+------+-----+--------+-----------+
5 rows in set

Cannot display the information in the with statement.

I think the following information is also necessary to show when the desc statement is executed.

 

'connector' = 'datagen', 
'rows-per-second' = '10', 
'fields.f_sequence.kind' = 'sequence', 
'fields.f_sequence.start' = '1', 
'fields.f_sequence.end' = '10000', 
'fields.f_key1.min' = '1', 
'fields.f_key1.max' = '20', 
'fields.f_key2.min' = '1', 
'fields.f_key2.max' = '20', 
'fields.f_random_str.length' = '5'

 

jark, what do you think？Looking forward to your reply.

.