[FLINK-28750] Whether to add field comment for hive table

• Type: Improvement
• Status: Open
• Priority: Not a Priority
• Resolution: Unresolved
• Affects Version/s: 1.14.5
• Component/s: Connectors / Hive
• Labels: auto-deprioritized-minor pull-request-available
• Assignee: Unassigned
• Reporter: hehuiyuan
• Created: 30/Jul/22 07:23
• Updated: 18/Aug/23 22:35

Description

Currently,  I have a hive ddl，as follows

"set table.sql-dialect=hive;\n" +
"CREATE TABLE IF NOT EXISTS myhive.dev.shipu3_test_1125 (\n" +
"   `id` int COMMENT 'iadddd',\n" +
"   `cartdid` bigint COMMENT 'aaa',\n" +
"   `customer` string COMMENT 'vvvv',\n" +
"   `product` string COMMENT 'cccc',\n" +
"   `price` double COMMENT '',\n" +
"   `dt` STRING COMMENT ''\n" +
") PARTITIONED BY (dt STRING) STORED AS TEXTFILE TBLPROPERTIES (\n" +
"  'streaming-source.enable' = 'false',\n" +
"  'streaming-source.partition.include' = 'all',\n" +
"  'lookup.join.cache.ttl' = '12 h'\n" +
")"; 

It is parsed as SqlCreateHiveTable by hive dialect parser. But the field commet is lost.

 

 

 

 

 

 

 

 

 

 

 

Issue Links

• links to: GitHub Pull Request #20425
• links to: GitHub Pull Request #20548