How to change the Hive table comment

Question

Hi. I had added a comment while creating a Hive table. I want to change the comment that I added before. Is there a way I can do this?

Answer 1

Yes, it is possible to change the comment. The table comment is a table property and Hive allows you to change the table properties using the ALTER command. Refer to the below command:

ALTER TABLE table_name SET TBLPROPERTIES ('comment' = new_comment);