How to rename the Hive table

Question

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?

Answer 1

Hi@akhtar,

You can rename the table name in the hive. You need to use the alter command. This command allows you to change the table name as shown below.

$ ALTER TABLE name RENAME TO new_name