Hive - Rename Table

visibility 59 access_time 9 months ago languageEnglish

Hive supports renaming tables with/without moving data folder. For a managed table that is created without LOCATION clause, 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;
copyright This page is subject to Site terms.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

timeline Stats
Page index 0.24
More from Kontext
Python: Load Data from Hive
visibility 1,094
thumb_up 2
access_time 2 years ago
Use Hadoop File System Task in SSIS to Write File into HDFS
visibility 4,808
thumb_up 1
access_time 5 years ago