Hive - Rename Table

Raymond Tang Raymond Tang 687 0.47 index 9/10/2021

Hive supports renaming tables with/without moving data folder. For a managed table that is created without LOCATIONclause, the command will also move the table's HDFS location.

Code snippet

You can use the following code snippet to rename tables.

ALTER TABLE table_name RENAME TO new_table_name;
hadoop hive