Rename of the HADOOP/HUE table name

[#1]

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.

[#2 · Accepted solution]

@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/Par...

> 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.

[#3]

Thank you!

[#4]

@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.