Hive - Rename Table
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.
comment Comments
No comments yet.
Log in with external accounts
warning Please login first to view stats information.
article
HiveServer2 Cannot Connect to Hive Metastore Resolutions/Workarounds
article
Apache Hive 3.0.0 Installation on Windows 10 Step by Step Guide
article
Extract Values from XML Column in Hive Tables
article
Hive - Create External Table for Multiline CSV Files
article
Python: Load Data from Hive
Read more (51)