question Re: Rename of the HADOOP/HUE table name in Support Questions

Rename of the HADOOP/HUE table name

Choolake — Tue, 21 Apr 2026 06:41:42 GMT

Rename of the HADOOP/HUE table name

Hi everyone,

I need to rename the table name in HUE. i used following command.

ALTER TABLE db.table1 RENAME TO db.table2;

Please let me know the correct way to rename the table without any issue.

Thank you.

Re: Rename of the HADOOP/HUE table name

vaishaakb — Fri, 15 Mar 2024 10:36:32 GMT

@Choolake Thank you for bringing this to our Community.

The shared ALTER command should work as expected.

Ref:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterTable/Partition/Column:~:text=the%20named%20table.-,Alter%20Table,-Rename%20Table

> Please let me know the correct way to rename the table without any issue.

What is your concern here? Can you also try renaming a test table in a test database and see how it goes?

HTH.

Re: Rename of the HADOOP/HUE table name

Choolake — Mon, 18 Mar 2024 10:47:47 GMT

Thank you!

Re: Rename of the HADOOP/HUE table name

VidyaSargur — Mon, 18 Mar 2024 15:50:29 GMT

@Choolake, Did the response assist in resolving your query? If it did, kindly mark the relevant reply as the solution, as it will aid others in locating the answer more easily in the future.