Reply
Explorer
Posts: 12
Registered: ‎03-16-2016

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

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!

 

 

New Contributor
Posts: 3
Registered: ‎04-29-2016

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

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)
Highlighted
Explorer
Posts: 12
Registered: ‎03-16-2016

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

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.