Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to change a HIVE table schema using HUE? Is it supported?

How to change a HIVE table schema using HUE? Is it supported?

Explorer

Hi all, 

 

I find HUE is not available to change the schema of the HIVE table, is it ?

 

If I want to change the schema of a exist table, shall I delete the table and create again ?

 

Thanks you gus!

 

 

2 REPLIES 2

Re: How to change a HIVE table schema using HUE? Is it supported?

New Contributor

Alter Database

ALTER (DATABASE|SCHEMA) database_name SET DBPROPERTIES (property_name=property_value, ...);   -- (Note: SCHEMA added in Hive 0.14.0)
 
ALTER (DATABASE|SCHEMA) database_name SET OWNER [USER|ROLE] user_or_role;   -- (Note: Hive 0.13.0 and later; SCHEMA added in Hive 0.14.0)

Re: How to change a HIVE table schema using HUE? Is it supported?

Explorer

Yeh, you can do it like this. But it is still like work in the backend. Actually if I want to change some column data type, it should be click on the specific column on a drag down menu and choose the right data type, then submit.