[
https://issues.apache.org/jira/browse/FLINK-28750?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
hehuiyuan updated FLINK-28750:
------------------------------
Description:
Currently, I have a hive ddl，as follows
{code:java}
"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" +
")"; {code}
It is parsed as SqlCreateHiveTable by hive dialect parser. But the field commet
is lost.
!image-2022-07-30-15-52-31-326.png|width=661,height=550!
was:
Currently, I have a hive ddl，as follows
{code:java}
"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" +
")"; {code}
It is parsed as SqlCreateHiveTable by hive dialect parser. But the field commet
is lost.
!image-2022-07-30-15-23-53-383.png|width=818,height=408!
> Whether to add comment for hive table
> -------------------------------------
>
> Key: FLINK-28750
> URL: https://issues.apache.org/jira/browse/FLINK-28750
> Project: Flink
> Issue Type: Improvement
> Reporter: hehuiyuan
> Priority: Major
>
> Currently, I have a hive ddl，as follows
> {code:java}
> "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" +
> ")"; {code}
> It is parsed as SqlCreateHiveTable by hive dialect parser. But the field
> commet is lost.
>
> !image-2022-07-30-15-52-31-326.png|width=661,height=550!
>
>
>
>
>
>
>
>
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
