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;

Get Apache Hive Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.