How to rename the Hive table?

Big Data Hadoop

Hi Team,

I am new to Hive. I have created one table in Hive. Now I want to rename the table name. How can I do that?

1
Answers

Replies

It is possible to rename the Hive table. The alter command is used to change the table name. The syntax is represented below:


$ ALTER TABLE name RENAME TO new_name

 
 

If you want to unleash your potential in this competitive field, please visit the Big Data Hadoop course page for more information, where you can find the Big Data Hadoop tutorials and Big Data Hadoop frequently asked interview questions and answers as well.

 

This topic has been locked/unapproved. No replies allowed

Login to participate in this discussion.

Leave a reply

Before proceeding, please check your email for a verification link. If you did not receive the email, click here to request another.