Support Questions

Find answers, ask questions, and share your expertise

Rename of the HADOOP/HUE table name

avatar
Contributor

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.

1 ACCEPTED SOLUTION

avatar
Master Collaborator

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

View solution in original post

3 REPLIES 3

avatar
Master Collaborator

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

avatar
Contributor

Thank you!

avatar
Community Manager

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



Regards,

Vidya Sargur,
Community Manager


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community: