Apache Hive Cookbook

Renaming tables

In this recipe, you will learn how to rename a table in Hive.

Getting ready

The renaming command renames the old table name with a new table name. The general format of using the RENAME table command is as follows:

ALTER TABLE table_name RENAME TO new_table_name;

How to do it…

Use this command to rename a table in Hive:

Alter Table Hive_Test_table1 RENAME TO Hive_Test_table;