Hive - Rename Table

Raymond Tang Raymond Tang 0 672 0.48 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

Join the Discussion

View or add your thoughts below

Comments