Hive - Rename Table

Raymond Raymond
Raymond
Stats
articleArticles 555
codeCode 5
imageDiagrams 54
descriptionNotebooks 0
chat_bubble_outlineThreads 8
commentComments 296
loyaltyKontext Points 6181
account_circle Profile
visibility 330 event 2021-09-10 access_time 3 years ago language English
share
Twitter Facebook LinkedIn
more_vert
arrow_upward arrow_downward

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;
More from Kontext
copyright This page is subject to Site terms.
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts