Can not add comment on table via create table statement

Arinjay — Tue, 26 Mar 2024 22:30:36 GMT

I am not able to add comment using this create table statement with as (query)

Re: Can not add comment on table via create table statement

feiyun0112 — Wed, 27 Mar 2024 03:11:45 GMT

CREATE TABLE [ IF NOT EXISTS ] table_identifier [ ( col_name1 col_type1 [ COMMENT col_comment1 ], ... ) ] USING data_source [ OPTIONS ( key1=val1, key2=val2, ... ) ] [ PARTITIONED BY ( col_name1, col_name2, ... ) ] [ CLUSTERED BY ( col_name3, col_name4, ... ) [ SORTED BY ( col_name [ ASC | DESC ], ... ) ] INTO num_buckets BUCKETS ] [ LOCATION path ] [ COMMENT table_comment ] [ TBLPROPERTIES ( key1=val1, key2=val2, ... ) ] [ AS select_statement ]

`AS select_statement` is the last parameter

topic Re: Can not add comment on table via create table statement in Data Engineering

Can not add comment on table via create table statement

Re: Can not add comment on table via create table statement