Apache Hive Cookbook

Altering table properties

In this recipe, you will learn how to alter table properties in Hive.

Getting ready

The ALTER TABLE properties command alters the table properties. The general format of using the ALTER TABLE command is as follows:

ALTER TABLE table_name SET TBLPROPERTIES table_properties;

How to do it…

Follow these steps to alter a table in Hive. The following statement changes the old comment to a new one:

Alter Table Hive_Test_table SET TBLPROPERTIES ('comment' = 'This is a new comment');